API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
125
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.65 KB | None | 0 0
raw download clone embed print report
  1. GRANT ALL PRIVILEGES ON bd_billings.* to root@localhost;FLUSH PRIVILEGES;
  2.  
  3. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'; flush privileges;
  4.  
  5. mysql -u root -h localhost -P 3306 -p nomeDaBase
  6.  
  7. <subsystem xmlns="urn:jboss:domain:datasources:4.0">
  8. <datasources>
  9. <drivers>
  10. <driver name="mysql" module="com.mysql">
  11. <driver-class>com.mysql.cj.jdbc.Driver</driver-class>
  12. <xa-datasource-class>com.mysql.cj.jdbc.MysqlXADataSource</xa-datasource-class>
  13. </driver>
  14. </drivers>
  15. </datasources>
  16. </subsystem>
  17.  
  18. <module xmlns="urn:jboss:module:1.5" name="com.mysql">
  19. <resources>
  20. <resource-root path="mysql-connector-java-8.0.15.jar" />
  21. </resources>
  22. <dependencies>
  23. <module name="javax.api"/>
  24. <module name="javax.transaction.api"/>
  25. </dependencies>
  26. </module>
  27.  
  28. <property name = "hibernate.connection.url" value="jdbc:mysql://localhost:3306/nomeDaBase?serverTimezone=UTC"/>
  29.  
  30.  
  31. <property name = "hibernate.connection.username" value="root"/>
  32. <property name = "hibernate.connection.verifyServerCertificate" value="false"/>
  33. <property name = "hibernate.connection.useSSL" value="false"/>
  34. <property name= "hibernate.connection.requireSSL" value="false"/>
  35. <property name = "hibernate.jdbc.time_zone" value="UTC"/>
  36.  
  37. <property name = "hibernate.show_sql" value="true" />
  38.  
  39. <property name = "hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />
  40. <property name = "hibernate.connection.driver_class" value="com.mysql.cj.jdbc.Driver" />
  41. <property name = "hibernate.hbm2ddl.auto" value="validate"/>
  42.  
  43. <!-- Configuring Connection Pool -->
  44. <property name="hibernate.c3p0.min_size" value="5" />
  45. <property name="hibernate.c3p0.max_size" value="20" />
  46. <property name="hibernate.c3p0.timeout" value="500" />
  47. <property name="hibernate.c3p0.max_statements" value="50" />
  48. <property name="hibernate.c3p0.idle_test_period" value="2000" />
  49. <property name="hibernate.transaction.factory_class" value="org.hibernate.transaction.JDBCTransactionFactory"/>
  50. <property name="hibernate.current_session_context_class"
  51. value="thread"/>
  52.  
  53. 2019-02-19 12:23:17,913 ERROR [org.jboss.msc.service.fail]
  54. > (ServerService Thread Pool -- 71) MSC000001: Failed to start service
  55. > jboss.persistenceunit."NomeApp.war#NomeAppApp":
  56. > org.jboss.msc.service.StartException in service
  57. > jboss.persistenceunit."NomeApp.war#NomeAppApp":
  58. > org.hibernate.service.spi.ServiceException: Unable to create requested
  59. > service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] at
  60. > org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:179)
  61. > at
  62. > org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:121)
  63. > at
  64. > org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:667)
  65. > at
  66. > org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:193)
  67. > at
  68. > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  69. > at
  70. > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  71. > at java.lang.Thread.run(Thread.java:748) at
  72. > org.jboss.threads.JBossThread.run(JBossThread.java:320) Caused by:
  73. > org.hibernate.service.spi.ServiceException: Unable to create requested
  74. > service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] at
  75. > org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:244)
  76. > at
  77. > org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:208)
  78. > at
  79. > org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
  80. > at
  81. > org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:51)
  82. > at
  83. > org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
  84. > at
  85. > org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
  86. > at
  87. > org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
  88. > at
  89. > org.hibernate.boot.model.process.spi.MetadataBuildingProcess.handleTypes(MetadataBuildingProcess.java:352)
  90. > at
  91. > org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:111)
  92. > at
  93. > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:847)
  94. > at
  95. > org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:874)
  96. > at
  97. > org.jboss.as.jpa.hibernate5.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44)
  98. > at
  99. > org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:161)
  100. > ... 7 more Caused by:
  101. > org.hibernate.exception.JDBCConnectionException: Error calling
  102. > Driver#connect at
  103. > org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator$1$1.convert(BasicConnectionCreator.java:105)
  104. > at
  105. > org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.convertSqlException(BasicConnectionCreator.java:123)
  106. > at
  107. > org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:41)
  108. > at
  109. > org.hibernate.engine.jdbc.connections.internal.BasicConnectionCreator.createConnection(BasicConnectionCreator.java:58)
  110. > at
  111. > org.hibernate.engine.jdbc.connections.internal.PooledConnections.addConnections(PooledConnections.java:106)
  112. > at
  113. > org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:40)
  114. > at
  115. > org.hibernate.engine.jdbc.connections.internal.PooledConnections.<init>(PooledConnections.java:19)
  116. > at
  117. > org.hibernate.engine.jdbc.connections.internal.PooledConnections$Builder.build(PooledConnections.java:138)
  118. > at
  119. > org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.buildPool(DriverManagerConnectionProviderImpl.java:110)
  120. > at
  121. > org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl.configure(DriverManagerConnectionProviderImpl.java:74)
  122. > at
  123. > org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:94)
  124. > at
  125. > org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:217)
  126. > at
  127. > org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:189)
  128. > at
  129. > org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:145)
  130. > at
  131. > org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:66)
  132. > at
  133. > org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35)
  134. > at
  135. > org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:88)
  136. > at
  137. > org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:234)
  138. > ... 19 more Caused by: java.sql.SQLException: Access denied for user
  139. > 'root'@'localhost' at
  140. > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  141. > at
  142. > com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  143. > at
  144. > com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  145. > at
  146. > com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
  147. > at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
  148. > at
  149. > com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
  150. > at
  151. > com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
  152. > at
  153. > org.hibernate.engine.jdbc.connections.internal.DriverConnectionCreator.makeConnection(DriverConnectionCreator.java:38)
  154. > ... 34 more
  155. >
  156. > 2019-02-19 12:23:17,917 ERROR
  157. > [org.jboss.as.controller.management-operation] (External Management
  158. > Request Threads -- 7) WFLYCTL0013: Operation ("add") failed - address:
  159. > ([("deployment" => "NomeApp.war")]) - failure description: {
  160. > "WFLYCTL0080: Failed services" => {"jboss.persistenceunit."NomeApp.war#NomeAppApp"" =>
  161. > "org.jboss.msc.service.StartException in service
  162. > jboss.persistenceunit."NomeApp.war#NomeAppApp":
  163. > org.hibernate.service.spi.ServiceException: Unable to create requested
  164. > service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  165. > Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service
  166. > [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  167. > Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
  168. > Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost'"},
  169. > "WFLYCTL0412: Required services that are not installed:" => ["jboss.persistenceunit."NomeApp.war#NomeAppApp""],
  170. > "WFLYCTL0180: Services with missing/unavailable dependencies" => undefined } 2019-02-19 12:23:17,919 ERROR [org.jboss.as.server]
  171. > (External Management Request Threads -- 7) WFLYSRV0021: Deploy of
  172. > deployment "NomeApp.war" was rolled back with the following failure
  173. > message: {
  174. > "WFLYCTL0080: Failed services" => {"jboss.persistenceunit."NomeApp.war#NomeAppApp"" =>
  175. > "org.jboss.msc.service.StartException in service
  176. > jboss.persistenceunit."NomeApp.war#NomeAppApp":
  177. > org.hibernate.service.spi.ServiceException: Unable to create requested
  178. > service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  179. > Caused by: org.hibernate.service.spi.ServiceException: Unable to create requested service
  180. > [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  181. > Caused by: org.hibernate.exception.JDBCConnectionException: Error calling Driver#connect
  182. > Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost'"},
  183. > "WFLYCTL0412: Required services that are not installed:" => ["jboss.persistenceunit."NomeApp.war#NomeAppApp""],
  184. > "WFLYCTL0180: Services with missing/unavailable dependencies" => undefined
  185.  
  186. UPDATE mysql.user SET plugin = 'auth_socket' WHERE User = 'root';
  187. UPDATE mysql.user SET host = '%' WHERE User = 'root';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!