java - access mysql with kubernetes : access denied for user root -
i have 2 pod
- mysql
- .jar file(microservice server java)
this mysql .yaml file
apiversion: v1 kind: pod metadata: name: mysql labels: name: mysql spec: containers: - resources: limits : cpu: 0.5 image: mysql name: mysql env: - name: mysql_root_password # change value: pass ports: - containerport: 3306 name: mysql volumemounts: - name: mysqlkuber mountpath: /var/lib/mysql readonly: false volumes: - name: mysqlkuber hostpath: path: /home/adicipta/mysqlkuber
i expose pod mysql service ip 10.0.0.67:3306
the .jar file pod run commend
sudo ./kubectl run lingga --image=msf4j
and error
2016-02-29 03:11:08 info classpathxmlapplicationcontext:512 - refreshing org.springframework.context.support.classpathxmlapplicationcontext@2401f4c3: startup date [mon feb 29 03:11:08 gmt 2016]; root of context hierarchy 2016-02-29 03:11:09 info xmlbeandefinitionreader:315 - loading xml bean definitions class path resource [beans.xml] 2016-02-29 03:11:10 info defaultlistablebeanfactory:603 - pre-instantiating singletons in org.springframework.beans.factory.support.defaultlistablebeanfactory@1753acfe: defining beans [datasource,hibernatesessionfactorybean,globalmanagerdao,baselogicbean,interfaceaccount]; root of factory hierarchy 2016-02-29 03:11:10 info drivermanagerdatasource:153 - loaded jdbc driver: com.mysql.jdbc.driver 2016-02-29 03:11:10 info version:37 - hibernate commons annotations 3.2.0.final 2016-02-29 03:11:10 info environment:603 - hibernate 3.6.10.final 2016-02-29 03:11:10 info environment:636 - hibernate.properties not found 2016-02-29 03:11:10 info environment:814 - bytecode provider name : javassist 2016-02-29 03:11:10 info environment:695 - using jdk 1.4 java.sql.timestamp handling 2016-02-29 03:11:10 info annotationbinder:532 - binding entity annotated class: com.adins.model.msuser 2016-02-29 03:11:10 info entitybinder:530 - bind entity com.adins.model.msuser on table msuser 2016-02-29 03:11:10 info configuration:1676 - hibernate validator not found: ignoring 2016-02-29 03:11:10 info annotationsessionfactorybean:780 - building new hibernate sessionfactory 2016-02-29 03:11:10 info hibernatesearcheventlistenerregister:75 - unable find org.hibernate.search.event.fulltextindexeventlistener on classpath. hibernate search not enabled. 2016-02-29 03:11:10 info connectionproviderfactory:173 - initializing connection provider: org.springframework.orm.hibernate3.transactionawaredatasourceconnectionprovider 2016-02-29 03:11:11 warn settingsfactory:140 - not obtain connection metadata java.sql.sqlexception: access denied user 'root'@'172.17.0.1' (using password: no) @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:957) @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3878) @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3814) @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:871)
inside .jar file have bean.xml set ip (10.0.0.67:3306)
i dont why doesnt works
maybe can me sort out
and use kubernetes docker container
just set password @ datasource code
this datasource code inside .jar file
<property name="username" value="root" /> <property name="password" value="pass" />
it depend on how datasource looks like.
Comments
Post a Comment