Service Virtualization

  • 1.  Authorization failure with mysql database

    Posted Mar 09, 2016 03:15 AM

    . Hi,

     

    i'm using devtest 9.1 in a docker compose file. There is started in a compose file a mysql separate database, then there will be started the enterprise dashboard server and after that a registry. When the registry is up and running it will start the vse. 

    There is a problem with authentication when I try to login into server console with admin rights. I checked from the mysql database, that the admin user credentials are created into the database. The admin console days 'Bad credentials' and also the VSEManager command line tool cannot login into the VSE.

    I had the same problem with 9.0 version, and hoped that this would work in the newest version. Any ideas how to solve this issue?

     

    Best Regards,

     

    Ilpo Paju



  • 2.  Re: Authorization failure with mysql database

    Broadcom Employee
    Posted Mar 09, 2016 04:43 AM

    These symptoms have happened to me for two reasons:

     

    1. I didn't create the database with UTF8

     

    2. I didn't take into account case sensitivity in table names on Linux.

     

    To fix the first one, drop your database and recreate it according to MySQL cookbook for DevTest 8

     

    To fix the second one, set lower_case_table_names=1 in the my.ini (or my.cnf, or server.cnf, whichever your mysql installation is using) file and restart the mysqld process.



  • 3.  Re: Authorization failure with mysql database

    Posted Mar 09, 2016 05:21 AM

    Hi Rick,

    thanks for your answer, it was a correct one! :-)

    Now the devtest is able to use mysql database within docker containers.