Network Connection Lost MYSQL 9.0.9 and 9.0.11

[gregory]

Started getting login screen, but upon logging in with correct credentials get a pop up reading:

"The network connection was lost. Please check your network connection then try again.
ADOConnection.Execute(UPDATE authentication SET updated_date = ? WHERE session_id = ?, Array[2]) % line 439, file:
Authentication.Update() % line 743, file:
Authentication.Check(xxx) % line 271, file:
TimeTrex-Debug is unable to connect to its database, please make sure that the database service on your own local TimeTrex-Debug server has been started and is running. If you are unsure, try rebooting your server.","record_details":{"total":0,"valid":0,"invalid":0},"user_generic_status_batch_id":false,"request":false,"pager":false,"details":false}}

Was able to run install script for both 9.0.9 (existing version) and for 9.0.11 (updated in case it fixed). So it appears database access parameters in timetrex.ini.php are correct

There is nothing in timetrex log files except for the update/install transactions. When it fails with above message nothing is recorded to logs.

MYSQL 5.5.47
PHP 5.3.17

ini file below
[path]
storage_dir = "/var/xxtimetrex/storage"
log_dir = "/var/log/xxxtimetrex"
;URL to TimeTrex web root directory. ie: http://your.domain.com/<*BASE_URL*>
;DO NOT INCLUDE http://your.domain.com, just the directory AFTER your domain
base_url = "/xxxTimeTrex/interface"

;
;log directory
;
;Linux
log = "/var/log/xxxtimetrex"

;
;Misc storage, for attachments/images
;
;Linux
storage = "/var/xxxtimetrex/storage"

;
;Full path and name to the PHP CLI Binary
;
;Linux
php_cli = "/usr/bin/php"

;
; Database connection settings. These can be set from the installer.
;
[database]
type = mysqli
;type = postgres8

host = 192.168.2.7
database_name = xxxtimetrex
user = timetrex_user
password = ********

;
; Email delivery settings.
;
[mail]
;Least setup, deliver email through TimeTrex's email relay via SOAP (HTTP port 80)
;delivery_method = soap

;Deliver email through local sendmail command specified in php.ini
;delivery_method = mail

;Deliver email through remote SMTP server with the following settings.
delivery_method = smtp
smtp_host = 192.168.2.247
smtp_port = 25
smtp_username = timetrex@xxx.com
;smtp_password=testpass123

;
; Cache settings
;
[cache]
enable = TRUE
;Linux
dir = "/tmp/xxxtimetrex"

[debug]
;Set to false if you're debugging
production = FALSE

enable = FALSE
enable_display = FALSE
buffer_output = TRUE
;was FALSE AND VERBOSITY = 10
enable_log = TRUE
verbosity = 10

[other]
default_interface = html5
; Force all clients to use SSL.
force_ssl = TRUE
installer_enabled = FALSE
primary_company_id = 1
hostname = localhost

THANKS

[shaunw]

Please see this FAQ: http://forums.timetrex.com/viewtopic.php?f=6&t=89

[gregory]

Changed to full debug, saw message about binary log issue. Changed MYSQL binary log to ROW. Restarted MySQL and all appears OK.

Upgraded to 9.0.12 and could not get past login screen (conection lost errors), also could not install blank screens. Rolled back to 9.0.11 and running.

Gregory

[shaunw]

There is likely an issue with the way you upgraded to v9.0.12, or something else specific to your installation.

My understanding is that v9.0.12 is literally about 2 lines of code different from v9.0.11, so if that isn't working for you, we would need to see the TimeTrex log file with the error messages to diagnose it further.