Announcement: New Knowledge Base

4 June 2020: We are pleased to announce the launch of a new Knowledge Base, Changelogs for Business Security Products, where you can find more details, such as bugfixes or new features, about the most recent releases of our business-related products.

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.

 

Best Answer

  • fsuhadifsuhadi Posts: 8
    Accepted Answer

    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.

Answers

  • 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

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

     

    fsuhadi
  • Thanks. 

  • 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

This discussion has been closed.