We have setup a new MySQL connection and when we test the connection get the following error. The time zone noted in the error is the setting for both adobe campaign and the target mysql db. I noted one other thread regarding this issue but couldn't determine what the solution was.
The connection is as follows (sensitive data removed).
We did eventually resolve the issue. Here is what was required from start to finish. For the time zone error it was step 4 that fixed the problem.
1) Marketing server hosts, Install MYSQL Client on adobe campaign marketing servers. The new MYSQL client is required for a new adobe campaign connection.
2) Marketing server hosts, Create a link between libmysqlclient_r.so.18 and libmysqlclient.so.18 so that libmysqlclient_r.so.18 is recognized but redirects to libmysqlclient.so.18
3) Network, Enable network connection between adobe campaign instance and the MYSQL DB host
4) MYSQL DB, Populate DB time zone table ‘mysql.time_zone_name’ using script mysql_tzinfo_to_sql
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.