Hello,

I'm in the process of moving our OS Ticket database to Azure's MySQL managed service. For other PHP apps, I was able to insert this following snippet into the config file. e.g., Nextcloud, Drupal, etc.
'pdo' => array(
PDO::MYSQL_ATTR_SSL_CA => ['/cert/BaltimoreCyberTrustRoot.crt.pem'],
PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => [false],
);

The error I'm getting is:
mod_fcgid: stderr: PHP Parse error: syntax error, unexpected '=>' (T_DOUBLE_ARROW)

However, for OS Ticket this doesn't seem to work. And while I know OS Ticket has a recommended way to do this, I would rather not generate another cert and would prefer to standardize on the PHP PDO module. I've tried adding the php short tag option to the php.ini file, but that didn't work.

Any pointers are greatly appreciated!

Thank you,

Ryan

    4 months later

    A bit old reply but I encountered similar problem. What i did is to limit the range of IP from Azure to the webprovider....no ssl but at least some "control" in the middle...

    2 years later

    ryannix123 did you ever figure out a solution to this problem. I am in the same exact boat as you. Trying to get this to work with Azure MySQL.

    Write a Reply...