cancel
Showing results for 
Search instead for 
Did you mean: 

Migrating to MYSQL failed

SOLVED
Highlighted
Aspirant

Migrating to MYSQL failed

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Aspirant

Re: Migrating to MYSQL failed

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.

6 REPLIES
F-Secure

Re: Migrating to MYSQL failed

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();

 

 

 

 

Aspirant

Re: Migrating to MYSQL failed

mysql version is

5.1.73

F-Secure

Re: Migrating to MYSQL failed

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

 

Aspirant

Re: Migrating to MYSQL failed

Thanks. 

Aspirant

Re: Migrating to MYSQL failed

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

Aspirant

Re: Migrating to MYSQL failed

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.