ADOConnection problem

Asked by Nicolas Truchaud on 2017-09-20

Hello,

I've just installed queXS on a CentOS server and I get an error when trying to add operators :
ADOConnection._Execute(INSERT INTO operator (`operator_id` ,`username` ,`firstName` ,`lastName`, `Time_zone_name`,`voip`,`chat_enable`,`chat_user`,..., false) % line 1229, file: adodb.inc.php
ADOConnection.Execute(INSERT INTO operator (`operator_id` ,`username` ,`firstName` ,`lastName`, `Time_zone_name`,`voip`,`chat_enable`,`chat_user`,...) % line 114, file: operators.php

The displayed error is : Could not add operator. There may already be an operator of this name: 'jdoe' whatever the operator's login is...

I also have a time zone problem : Your database does not have timezones installed, please see here for details ...
or
Check that you have granted relevant permissions on 'time_zone_...' tables in database named 'mysql'.

Is there a link ?

Question information

Language:
English Edit question
Status:
Solved
For:
queXS Edit question
Assignee:
No assignee Edit question
Solved by:
Adam Zammit
Solved:
2017-09-27
Last query:
2017-09-27
Last reply:
2017-09-25
Adam Zammit (adamzammit) said : #1

Hi Nicolas,

These problems sound related.

Make sure you have the timezone database in mysql installed. See: https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

You may also need to grant permission to the database user. See: https://quexs.acspri.org.au/installation-manual

Adam

Nicolas Truchaud (nicktruch) said : #2

Hello,

Thank you for the information provided.

When we check the database timezone configuration, we notice that the database gets timezone information from the operating system :

SELECT @@global.time_zone, @@session.time_zone;
+-------------------------------+-------------------------------+
| @@global.time_zone | @@session.time_zone |
+-----------------------------+-------------------------------+
| SYSTEM | SYSTEM |
+---------------------------+--------------------------------+
and the timezone was already configured like below :

# timedatectl |grep "Time zone"
       Time zone: Europe/Paris (CEST, +0200)
Apparently, db configuration is OK.

However, when we have been getting some errors in timezone page on the site and the combobox does not function in the page:

(screenshot below)
https://www.evernote.com/l/AAVZaDT9uEFBT5ibrREYvLl3WJ59jHj4uB4

Could you provide us a solution for that issue ?

Thank you in advance,
Best regards,
Nicolas

Best Adam Zammit (adamzammit) said : #3

Please follow the instructions here:

https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html

under "Populating the mysql timezone tables".

The operating system may have timezone tables installed, but mySql needs them loaded.

Kind Regards,
Adam Zammit

Nicolas Truchaud (nicktruch) said : #4

Ok thanks, everything seems to work now.

Kind regards,
Nicolas Truchaud