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

Popular posts from this blog

c# - How Configure Devart dotConnect for SQLite Code First? -

java - Copying object fields -

c++ - Clear the memory after returning a vector in a function -