Migrating to MYSQL failed

fsuhadi

i have follow this instruction

https://community.f-secure.com/t5/Business/Policy-Manager-on-MySQL/ta-p/88662

to migrate from h2db to mysql but error:

 

could not connect to [ipaddress]:3306: unexpected end of stream, read 0 bytes from 4

 

server is  Centos 6.8

mysql ver 14.14 distrib 5.1.7.3

Firewall off

 

Please help.

Thanks.

 

dandelion

Hello, 

 

please clarify the version of MySQL Server you are using. 

 

The version you provided most likley corresponds to the version of 'mysql' utility, but not the version of the server.

The server version can be obtained by executing the following SQL query:

     SELECT VERSION();

 

 

 

 

fsuhadi

mysql version is

5.1.73

dandelion

Hi! Policy Manager only supports versions 5.5 through 5.7 of MySQL Server. 

 

fsuhadi

Thanks. 

fsuhadi

Hi,

 

i have upgrade mysql to the latest version but still having the same problem.

 

# mysql --version
mysql Ver 14.14 Distrib 5.7.17, for Linux (x86_64) using EditLine wrapper

 

Please help. Thanks

fsuhadi

I have solved the problem.

 

the problem lies with the connector.

 

i have replaced mariadb-java-client-1.5.3. jar with mariadb-java-client-1.5.7.jar located at /opt/f-secure/fspms/lib/

 

hope this can help others.

 

Thanks.