Hi,
Windows 2003 Server, MySQL 5.0, PHP 5.0, just downloaded timetrex yesterday, getting the following when testing my connection (even though I KNOW the users are ok, both accounts have full permissions on all catalogs, I can connect via admin locally and across my network...
-------
Connection test to your database as a non-privileged user has FAILED! Please correct them and try again.
Connection test to your database as a privileged user has FAILED! Please correct the user name/password and try again.
-------
Now, I mysql is running, I can connect to the db on my own without timetrex...???!?!?
I do have this in the drop down for database though:
Database Type: MySQLi (v4.1.3+ w/InnoDB)
And no other options available.
Please help?
Install Step 3 - Connections failed, can connect w/o install
Root used.
By the way, Im connecting with my root account too and at localhost... still cant connect. I turned on errors and debugging, no errors at top, debugging output is this:
Debug Buffer
============================================================================
Memory Usage: 3297032
----------------------------------------------------------------------------
DEBUG [155]: [Function](): URI: /sites/timetracking/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqli&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=MYDATABASENAME&data%5Buser%5D=MYROOTACCOUNT&data%5Bpassword%5D=MYPASSWORD%24&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action=Test+Connection
DEBUG [157]: [Function](): Production: 0
DEBUG [50]: [Function](): Bypassing Authentication
DEBUG [263]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [305]: TTi18n::chooseBestLocale(): cSetting Locale: en_us
DEBUG [191]: TTi18n::setLocale(): Attempting to set Locale to: en_us Category: 0
DEBUG [194]: TTi18n::setLocale(): bAttempting to set Locale to: en_us
DEBUG [196]: TTi18n::setLocale(): Failed setting i18n locale: en_us
DEBUG [316]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [73]: Install::isInstallMode(): Install Mode is ON
============================================================================
============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 0.0000 ms (0.00 %) unprofiled
656.0230 ms (100.00 %) Missed
============================================================================
656.0230 ms (100.00 %) OVERALL TIME
============================================================================
Debug Buffer
============================================================================
Memory Usage: 3297032
----------------------------------------------------------------------------
DEBUG [155]: [Function](): URI: /sites/timetracking/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqli&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=MYDATABASENAME&data%5Buser%5D=MYROOTACCOUNT&data%5Bpassword%5D=MYPASSWORD%24&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action=Test+Connection
DEBUG [157]: [Function](): Production: 0
DEBUG [50]: [Function](): Bypassing Authentication
DEBUG [263]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [305]: TTi18n::chooseBestLocale(): cSetting Locale: en_us
DEBUG [191]: TTi18n::setLocale(): Attempting to set Locale to: en_us Category: 0
DEBUG [194]: TTi18n::setLocale(): bAttempting to set Locale to: en_us
DEBUG [196]: TTi18n::setLocale(): Failed setting i18n locale: en_us
DEBUG [316]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [73]: Install::isInstallMode(): Install Mode is ON
============================================================================
============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 0.0000 ms (0.00 %) unprofiled
656.0230 ms (100.00 %) Missed
============================================================================
656.0230 ms (100.00 %) OVERALL TIME
============================================================================
How did you install PHP? The MySQLi extension is a newer not as well tested MySQL extension for PHP. You might want to try installing the original (and usually the default) MySQL extension and try that instead.
Here is some more information regarding the extension:
http://ca.php.net/manual/en/ref.mysql.php
Here is some more information regarding the extension:
http://ca.php.net/manual/en/ref.mysql.php