Dear,

Along with greeting, the need was born to have the mysql in azure, which was easily done with export of the information, now the problem we have that in Azure we have to disable SSL security so that the database can connect to the OSticket client remote server, so far I have been able to define the certificate paths but still changing it to the new certificates does not work .. Someone who has the same scenario.

Version OSticket: v1.12.5-6
Version Mysql: 8.0.18
Version PHP: 7.2.26
Servidor WEB: Apache 2.4.6

greetings and thanks

JM

@jmora03

As you can see from the code below, once you set those global variables they will be set in an array called $options as key ssl:

Once we set $options we pass it to db_connect. In this method if $options['ssl'] exists, we will run $__db->ssl_set($options) where $__db is the initialization of a mysql connection and ssl_set sets the SSL credentials for the connection:

So if the connection is failing it's most likely the setup you have and you should see specific errors being thrown that will guide you towards the issue.

Cheers.

    KevinTheJedi Thanks for the prompt response, check the files and they are well configured, where can I see the log of this ssl security error to the database?

    The database in Azure has the certificate .PEM and not crt, also make the change but still does not take the declared certificates.

    I need to connect to an Azure Database for MySQL using that certificate, which would be done:

    https://docs.microsoft.com/en-us/azure/mysql/howto-configure-ssl

    someone with the same problem?

    Thanks.

    JM

      @jmora03

      You should see any related errors in the MySQL error logs or the Apache error logs.

      Cheers.

      Write a Reply...