Upgrade mysql to postgresql

General support regarding TimeTrex, such as
configuring policies/taxes or processing payroll.
Post Reply
dougi
Posts: 3
Joined: Mon Apr 15, 2019 3:28 am

Upgrade mysql to postgresql

Post by dougi »

Hello,

everything from this guide:
viewtopic.php?f=6&t=7519

is fine till step 8. The upgrade-prozess wont start as you can see in the appending picture.

The source DB is 5.5.59-MariaDB running on PHP-Version: 5.6.39.
Target DB is PostgreSQL 9.5.12 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.0
4.9) 5.4.0 20160609, 64-bit on PHP-Version 7.0.28

The last log is
---------------[ 15-Apr-2019 10:42:46 +0000 [1555324966.6157] (PID: 11816) ]---------------
DEBUG [L2981] [00061ms]: Misc::getCurrentOSUser(): Running as OS User: www-data
DEBUG [L0923] [00061ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L0548] [00066ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0187] [00066ms]: TTDate::setTimeZone(): TimeZone already set to: GMT
DEBUG [L0145] [00066ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo Mode: 0
DEBUG [L0165] [00067ms]: [Function](): Lock File: /tmp/timetrex/UnAttended_Upgrade_2737064364.lock
DEBUG [L0084] [00067ms]: LockFile::getCurrentPID(): Current PID: 11816
DEBUG [L0261] [00067ms]: [Function](): Checking requirements only...
DEBUG [L0264] [00067ms]: [Function](): Launched from web installer...
DEBUG [L2521] [00067ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00068ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1493] [00068ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
---------------[ 15-Apr-2019 10:42:46 +0000 [1555324966.6832] (PID: 11816) ]---------------
Someone any idea what to do now?

Thanks,
Dougi
Attachments
db upgrade.PNG
db upgrade.PNG (24.53 KiB) Viewed 4473 times
mikeb
Posts: 710
Joined: Thu Jul 27, 2006 11:58 am

Re: Upgrade mysql to postgresql

Post by mikeb »

There should be more information in your TimeTrex log file, can you try to re-run the last step that failed and attach the entire log file here please?
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
dougi
Posts: 3
Joined: Mon Apr 15, 2019 3:28 am

Re: Upgrade mysql to postgresql

Post by dougi »

Yes, here it is
---------------[ 18-Apr-2019 12:13:34 +0000 [1555589614.3374] (PID: 14267) ]---------------
DEBUG [L0402] [00028ms]: [Function](): URI: /var/www/html/timetrex/tools/unattended_upgrade.php IP Address:
DEBUG [L0404] [00028ms]: [Function](): USER-AGENT: N/A
DEBUG [L0405] [00028ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Dem
DEBUG [L0405] [00028ms]: [Function](): o Mode: 0
DEBUG [L0192] [00050ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L2981] [00058ms]: Misc::getCurrentOSUser(): Running as OS User: www-data
DEBUG [L0923] [00059ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L0548] [00063ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0187] [00063ms]: TTDate::setTimeZone(): TimeZone already set to: GMT
DEBUG [L0145] [00063ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo Mode: 0
DEBUG [L0165] [00064ms]: [Function](): Lock File: /tmp/timetrex/UnAttended_Upgrade_2737064364.lock
DEBUG [L0084] [00064ms]: LockFile::getCurrentPID(): Current PID: 14267
DEBUG [L0261] [00064ms]: [Function](): Checking requirements only...
DEBUG [L0264] [00064ms]: [Function](): Launched from web installer...
DEBUG [L2521] [00064ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00064ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1493] [00064ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
---------------[ 18-Apr-2019 12:13:34 +0000 [1555589614.4017] (PID: 14267) ]---------------

---------------[ 18-Apr-2019 12:13:34 +0000 [1555589611.965] (PID: 12422) ]---------------
DEBUG [L0402] [00006ms]: [Function](): URI: /timetrex/api/json/api.php?Class=APIInstall&Method=getRequirements&v=2&MessageID=ed3b5c9f-968e-f79b-ed09-5584a79263f1&disable_db=1 IP Address: 172.17.0.1
DEBUG [L0404] [00006ms]: [Function](): USER-AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:66.0) Gecko/20100101 Firefox/66.0
DEBUG [L0405] [00006ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: 172.17.0.3 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.
DEBUG [L0405] [00006ms]: [Function](): php Demo Mode: 0
DEBUG [L0192] [00007ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L0197] [00008ms]: [Function](): Handling JSON Call To API Factory: APIInstall Method: getRequirements Message ID: ed3b5c9f-968e-f79b-ed09-5584a79263f1
DEBUG [L0240] [00008ms] Array: [Function](): Arguments: (Size: 28)
array(1) {
[0]=>
string(1) "0"
}


DEBUG [L0262] [00009ms]: [Function](): No SessionID or calling non-authenticated function...
DEBUG [L0429] [00010ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0546] [00010ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L0050] [00010ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIInstall Method: getRequirements Message ID: ed3b5c9f-968e-f79b-ed09-5584a79263f1
DEBUG [L0141] [00010ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L2521] [00010ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L2521] [00011ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex/cache_b Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L2521] [00012ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex/cache_f Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00013ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1550] [00013ms]: Install::checkDiskSpace(): Free Space: 1401627705344 Free Percent: 88.419630767644
DEBUG [L1464] [00013ms] Array: Install::checkBaseURL(): Checking Base URL: http://localhost:8083/timetrex/interfac ... nstall.php
bool(false)

DEBUG [L1493] [00714ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
DEBUG [L1574] [00844ms] Array: Install::checkPHPCLIRequirements(): PHP CLI Requirements Command: "/usr/bin/php" "/var/www/html/timetrex/tools/unattended_upgrade.php" --config "/var/www/html/timetrex/includes/../timetrex.ini.php" --requirements_only --web_installer Exit Code: 0 Output:
array(1) {
[0]=>
string(35) "Requirements all pass successfully!"
}


DEBUG [L0124] [00845ms]: Install::setAMFMessageID(): AMF Message ID: ed3b5c9f-968e-f79b-ed09-5584a79263f1
DEBUG [L0923] [02316ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1550] [02316ms]: Install::checkDiskSpace(): Free Space: 1401627701248 Free Percent: 88.419630509254
DEBUG [L1464] [02316ms] Array: Install::checkBaseURL(): Checking Base URL: http://localhost:8083/timetrex/interfac ... nstall.php
bool(false)


DEBUG [L1493] [02316ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
DEBUG [L1574] [02447ms] Array: Install::checkPHPCLIRequirements(): PHP CLI Requirements Command: "/usr/bin/php" "/var/www/html/timetrex/tools/unattended_upgrade.php" --config "/var/www/html/timetrex/includes/../timetrex.ini.php" --requirements_only --web_installer Exit Code: 0 Output:
array(1) {
[0]=>
string(35) "Requirements all pass successfully!"
}


---------------[ 18-Apr-2019 12:15:03 +0000 [1555589702.889] (PID: 12421) ]---------------
DEBUG [L0402] [00003ms]: [Function](): URI: /timetrex/api/json/api.php?Class=APIInstall&Method=getDatabaseSchema&v=2&MessageID=649ab51f-c946-1005-f0f7-9fab6601f0c1 IP Address: 172.17.0.1
DEBUG [L0404] [00003ms]: [Function](): USER-AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:66.0) Gecko/20100101 Firefox/66.0
DEBUG [L0405] [00003ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: 172.17.0.3 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.
DEBUG [L0405] [00003ms]: [Function](): php Demo Mode: 0
DEBUG [L0460] [00018ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0470] [00021ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L0510] [00021ms]: Install::checkTableExists(): Table Name: company
DEBUG [L0520] [00039ms]: Install::checkTableExists(): Exists - Table Name: company
DEBUG [L0192] [00041ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L0197] [00042ms]: [Function](): Handling JSON Call To API Factory: APIInstall Method: getDatabaseSchema Message ID: 649ab51f-c946-1005-f0f7-9fab6601f0c1
DEBUG [L0240] [00042ms] Array: [Function](): Arguments: (Size: 11)
array(0) {
}


DEBUG [L0262] [00043ms]: [Function](): No SessionID or calling non-authenticated function...
DEBUG [L0429] [00043ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0546] [00043ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L0050] [00043ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIInstall Method: getDatabaseSchema Message ID: 649ab51f-c946-1005-f0f7-9fab6601f0c1
DEBUG [L0141] [00043ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L0460] [00043ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0470] [00044ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L0510] [00044ms]: Install::checkTableExists(): Table Name: company
DEBUG [L0520] [00051ms]: Install::checkTableExists(): Exists - Table Name: company
DEBUG [L0269] [00630ms]: [Function](): Server Response Time: 0.62990498542786
---------------[ 18-Apr-2019 12:15:03 +0000 [1555589703.519] (PID: 12421) ]---------------
And this one from postgresql log:
2019-04-18 12:15:02 UTC [14295-1] timetrex@timetrex ERROR: invalid input syntax for uuid: "-1" at character 34
2019-04-18 12:15:02 UTC [14295-2] timetrex@timetrex STATEMENT: SELECT * FROM company WHERE id = '-1'
2019-04-18 12:15:03 UTC [14296-1] timetrex@timetrex ERROR: invalid input syntax for uuid: "-1" at character 34
2019-04-18 12:15:03 UTC [14296-2] timetrex@timetrex STATEMENT: SELECT * FROM company WHERE id = '-1'
2019-04-18 12:15:03 UTC [14296-3] timetrex@timetrex ERROR: function max(uuid) does not exist at character 8
2019-04-18 12:15:03 UTC [14296-4] timetrex@timetrex HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2019-04-18 12:15:03 UTC [14296-5] timetrex@timetrex STATEMENT: select max(id) from accrual
mikeb
Posts: 710
Joined: Thu Jul 27, 2006 11:58 am

Re: Upgrade mysql to postgresql

Post by mikeb »

The PostgreSQL log doesn't seem to match the TimeTrex log, are you sure thats the entire timetrex log file?

If so please do the following:

In your TimeTrex.ini.php file, set the following under the [debug] section:
enable = TRUE
enable_display = FALSE
buffer_output = TRUE
enable_log = TRUE
verbosity = 10
Reproduce the issue and upload the TimeTrex log file here again as an attachment to your post.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
dougi
Posts: 3
Joined: Mon Apr 15, 2019 3:28 am

Re: Upgrade mysql to postgresql

Post by dougi »

Sorry my delayed response, i were on vacation last week.

So here is the complete new logfile with

enable = TRUE
enable_display = FALSE
buffer_output = TRUE
enable_log = TRUE
verbosity = 10

in debugpart of timetrex.ini file.
---------------[ 28-Apr-2019 14:06:21 +0000 [1556460381.3195] (PID: 31624) ]---------------
DEBUG [L0402] [00032ms]: [Function](): URI: /var/www/html/timetrex/tools/unattended_upgrade.php IP Address:
DEBUG [L0404] [00032ms]: [Function](): USER-AGENT: N/A
DEBUG [L0405] [00032ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Dem
DEBUG [L0405] [00032ms]: [Function](): o Mode: 0
DEBUG [L0192] [00056ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L2981] [00065ms]: Misc::getCurrentOSUser(): Running as OS User: www-data
DEBUG [L0923] [00065ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L0548] [00070ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0187] [00070ms]: TTDate::setTimeZone(): TimeZone already set to: GMT
DEBUG [L0145] [00070ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo Mode: 0
DEBUG [L0165] [00071ms]: [Function](): Lock File: /tmp/timetrex/UnAttended_Upgrade_2737064364.lock
DEBUG [L0084] [00071ms]: LockFile::getCurrentPID(): Current PID: 31624
DEBUG [L0261] [00071ms]: [Function](): Checking requirements only...
DEBUG [L0264] [00071ms]: [Function](): Launched from web installer...
DEBUG [L2521] [00071ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00071ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1493] [00071ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
---------------[ 28-Apr-2019 14:06:21 +0000 [1556460381.3907] (PID: 31624) ]---------------

---------------[ 28-Apr-2019 14:06:22 +0000 [1556460382.0214] (PID: 31626) ]---------------
DEBUG [L0402] [00027ms]: [Function](): URI: /var/www/html/timetrex/tools/unattended_upgrade.php IP Address:
DEBUG [L0404] [00028ms]: [Function](): USER-AGENT: N/A
DEBUG [L0405] [00028ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Dem
DEBUG [L0405] [00028ms]: [Function](): o Mode: 0
DEBUG [L0192] [00050ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L2981] [00059ms]: Misc::getCurrentOSUser(): Running as OS User: www-data
DEBUG [L0923] [00059ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L0548] [00063ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0187] [00063ms]: TTDate::setTimeZone(): TimeZone already set to: GMT
DEBUG [L0145] [00063ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo Mode: 0
DEBUG [L0165] [00064ms]: [Function](): Lock File: /tmp/timetrex/UnAttended_Upgrade_2737064364.lock
DEBUG [L0084] [00064ms]: LockFile::getCurrentPID(): Current PID: 31626
DEBUG [L0261] [00064ms]: [Function](): Checking requirements only...
DEBUG [L0264] [00064ms]: [Function](): Launched from web installer...
DEBUG [L2521] [00064ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00064ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1493] [00065ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
---------------[ 28-Apr-2019 14:06:22 +0000 [1556460382.0858] (PID: 31626) ]---------------

---------------[ 28-Apr-2019 14:06:23 +0000 [1556460383.6269] (PID: 31628) ]---------------
DEBUG [L0402] [00029ms]: [Function](): URI: /var/www/html/timetrex/tools/unattended_upgrade.php IP Address:
DEBUG [L0404] [00029ms]: [Function](): USER-AGENT: N/A
DEBUG [L0405] [00029ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Dem
DEBUG [L0405] [00029ms]: [Function](): o Mode: 0
DEBUG [L0192] [00051ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L2981] [00060ms]: Misc::getCurrentOSUser(): Running as OS User: www-data
DEBUG [L0923] [00060ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L0548] [00064ms]: TTi18n::chooseBestLocale(): Unable to find and set a locale.
DEBUG [L0187] [00064ms]: TTDate::setTimeZone(): TimeZone already set to: GMT
DEBUG [L0145] [00064ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: N/A Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.php Demo Mode: 0
DEBUG [L0165] [00065ms]: [Function](): Lock File: /tmp/timetrex/UnAttended_Upgrade_2737064364.lock
DEBUG [L0084] [00065ms]: LockFile::getCurrentPID(): Current PID: 31628
DEBUG [L0261] [00122ms]: [Function](): Checking requirements only...
DEBUG [L0264] [00122ms]: [Function](): Launched from web installer...
DEBUG [L2521] [00122ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00122ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1493] [00123ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
---------------[ 28-Apr-2019 14:06:23 +0000 [1556460383.7494] (PID: 31628) ]---------------

---------------[ 28-Apr-2019 14:06:23 +0000 [1556460381.258] (PID: 31277) ]---------------
DEBUG [L0402] [00002ms]: [Function](): URI: /timetrex/api/json/api.php?Class=APIInstall&Method=getRequirements&v=2&MessageID=e8d9f62d-1fb4-e1a3-ff5e-468b1ae8ddd2&disable_db=1 IP Address: 172.17.0.1
DEBUG [L0404] [00002ms]: [Function](): USER-AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:66.0) Gecko/20100101 Firefox/66.0
DEBUG [L0405] [00002ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: 172.17.0.3 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.
DEBUG [L0405] [00002ms]: [Function](): php Demo Mode: 0
DEBUG [L0192] [00002ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L0197] [00003ms]: [Function](): Handling JSON Call To API Factory: APIInstall Method: getRequirements Message ID: e8d9f62d-1fb4-e1a3-ff5e-468b1ae8ddd2
DEBUG [L0240] [00003ms] Array: [Function](): Arguments: (Size: 28)
array(1) {
[0]=>
string(1) "0"
}


DEBUG [L0262] [00003ms]: [Function](): No SessionID or calling non-authenticated function...
DEBUG [L0429] [00004ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0546] [00004ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L0050] [00004ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIInstall Method: getRequirements Message ID: e8d9f62d-1fb4-e1a3-ff5e-468b1ae8ddd2
DEBUG [L0141] [00004ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L2521] [00004ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L2521] [00005ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex/cache_b Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L2521] [00005ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex/cache_f Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L2521] [00005ms]: Misc::cleanDir(): Cleaning: /tmp/timetrex/6e Exclude Regex: \.ZIP|\.lock|.state|upgrade_staging
DEBUG [L0923] [00006ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1550] [00006ms]: Install::checkDiskSpace(): Free Space: 1401392570368 Free Percent: 88.404797622095
DEBUG [L1464] [00006ms] Array: Install::checkBaseURL(): Checking Base URL: http://localhost:8083/timetrex/interfac ... nstall.php
bool(false)


DEBUG [L1493] [00006ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
DEBUG [L1574] [00143ms] Array: Install::checkPHPCLIRequirements(): PHP CLI Requirements Command: "/usr/bin/php" "/var/www/html/timetrex/tools/unattended_upgrade.php" --config "/var/www/html/timetrex/includes/../timetrex.ini.php" --requirements_only --web_installer Exit Code: 0 Output:
array(1) {
[0]=>
string(35) "Requirements all pass successfully!"
}


DEBUG [L0923] [00708ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1550] [00708ms]: Install::checkDiskSpace(): Free Space: 1401392566272 Free Percent: 88.404797363705
DEBUG [L1464] [00709ms] Array: Install::checkBaseURL(): Checking Base URL: http://localhost:8083/timetrex/interfac ... nstall.php
bool(false)


DEBUG [L1493] [00709ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
DEBUG [L1574] [00838ms] Array: Install::checkPHPCLIRequirements(): PHP CLI Requirements Command: "/usr/bin/php" "/var/www/html/timetrex/tools/unattended_upgrade.php" --config "/var/www/html/timetrex/includes/../timetrex.ini.php" --requirements_only --web_installer Exit Code: 0 Output:
array(1) {
[0]=>
string(35) "Requirements all pass successfully!"
}


DEBUG [L0124] [00839ms]: Install::setAMFMessageID(): AMF Message ID: e8d9f62d-1fb4-e1a3-ff5e-468b1ae8ddd2
DEBUG [L0923] [02314ms]: Install::checkPHPVersion(): Comparing with Version: 7.0.28-0ubuntu0.16.04.1
DEBUG [L1550] [02314ms]: Install::checkDiskSpace(): Free Space: 1401392566272 Free Percent: 88.404797363705
DEBUG [L1464] [02315ms] Array: Install::checkBaseURL(): Checking Base URL: http://localhost:8083/timetrex/interfac ... nstall.php
bool(false)


DEBUG [L1493] [02315ms]: Install::checkPHPOpenBaseDir(): Open BaseDir:
DEBUG [L1574] [02502ms] Array: Install::checkPHPCLIRequirements(): PHP CLI Requirements Command: "/usr/bin/php" "/var/www/html/timetrex/tools/unattended_upgrade.php" --config "/var/www/html/timetrex/includes/../timetrex.ini.php" --requirements_only --web_installer Exit Code: 0 Output:
array(1) {
[0]=>
string(35) "Requirements all pass successfully!"
}


DEBUG [L0212] [02503ms] Array: APIInstall::getRequirements(): Retval:
array(45) {
["check_all_requirements"]=>
int(0)
["tt_product_edition"]=>
int(10)
["php_os"]=>
string(5) "Linux"
["application_name"]=>
string(14) "TimeTrex-Debug"
["config_file_loc"]=>
string(51) "/var/www/html/timetrex/includes/../timetrex.ini.php"
["php_config_file"]=>
string(28) "/etc/php/7.0/apache2/php.ini"
["php_include_path"]=>
bool(false)
["timetrex_version"]=>
array(3) {
["check_timetrex_version"]=>
int(2)
["current_timetrex_version"]=>
string(6) "11.0.2"
["latest_timetrex_version"]=>
string(6) "11.5.1"
}
["php_version"]=>
array(2) {
["php_version"]=>
string(23) "7.0.28-0ubuntu0.16.04.1"
["check_php_version"]=>
int(0)
}
["database_engine"]=>
int(0)
["bcmath"]=>
int(0)
["mbstring"]=>
int(0)
["gettext"]=>
int(0)
["intl"]=>
int(0)
["soap"]=>
int(0)
["gd"]=>
int(0)
["json"]=>
int(0)
["mcrypt"]=>
int(0)
["simplexml"]=>
int(0)
["curl"]=>
int(0)
["zip"]=>
int(0)
["openssl"]=>
int(0)
["mail"]=>
int(0)
["pear"]=>
int(0)
["safe_mode"]=>
int(0)
["disabled_functions"]=>
array(2) {
["check_disabled_functions"]=>
int(0)
["disabled_function_list"]=>
string(0) ""
}
["allow_fopen_url"]=>
int(0)
["magic_quotes"]=>
int(0)
["disk_space"]=>
int(0)
["memory_limit"]=>
array(2) {
["check_php_memory_limit"]=>
int(0)
["memory_limit"]=>
string(9) "512000000"
}
["base_url"]=>
array(2) {
["check_base_url"]=>
int(0)
["recommended_base_url"]=>
string(18) "/timetrex/api/json"
}
["base_dir"]=>
array(3) {
["check_php_open_base_dir"]=>
int(0)
["php_open_base_dir"]=>
string(0) ""
["php_cli_directory"]=>
string(8) "/usr/bin"
}
["cli_executable"]=>
array(2) {
["check_php_cli_binary"]=>
int(0)
["php_cli"]=>
string(12) "/usr/bin/php"
}
["cli_requirements"]=>
array(2) {
["check_php_cli_requirements"]=>
int(0)
["php_cli_requirements_command"]=>
string(167) ""/usr/bin/php" "/var/www/html/timetrex/tools/unattended_upgrade.php" --config "/var/www/html/timetrex/includes/../timetrex.ini.php" --requirements_only --web_installer"
}
["config_file"]=>
int(0)
["cache_dir"]=>
array(2) {
["check_writable_cache_directory"]=>
int(0)
["cache_dir"]=>
string(13) "/tmp/timetrex"
}
["safe_cache_dir"]=>
array(3) {
["check_safe_cache_directory"]=>
int(0)
["cache_dir"]=>
string(13) "/tmp/timetrex"
["base_path"]=>
string(23) "/var/www/html/timetrex/"
}
["storage_dir"]=>
array(2) {
["check_writable_storage_directory"]=>
int(0)
["storage_path"]=>
string(8) "/storage"
}
["safe_storage_dir"]=>
array(3) {
["check_safe_storage_directory"]=>
int(0)
["storage_path"]=>
string(8) "/storage"
["base_path"]=>
string(23) "/var/www/html/timetrex/"
}
["log_dir"]=>
array(2) {
["check_writable_log_directory"]=>
int(0)
["log_path"]=>
string(5) "/logs"
}
["safe_log_dir"]=>
array(3) {
["check_safe_log_directory"]=>
int(0)
["log_path"]=>
string(5) "/logs"
["base_path"]=>
string(23) "/var/www/html/timetrex/"
}
["empty_cache_dir"]=>
array(2) {
["check_clean_cache_directory"]=>
int(0)
["cache_dir"]=>
string(13) "/tmp/timetrex"
}
["file_permission"]=>
int(0)
["file_checksums"]=>
int(0)
["extended_error_messages"]=>
array(0) {
}
}


DEBUG [L0269] [02503ms]: [Function](): Server Response Time: 2.5027000904083
---------------[ 28-Apr-2019 14:06:23 +0000 [1556460383.7609] (PID: 31277) ]---------------

---------------[ 28-Apr-2019 14:06:27 +0000 [1556460386.723] (PID: 31277) ]---------------
DEBUG [L0402] [00002ms]: [Function](): URI: /timetrex/api/json/api.php?Class=APIInstall&Method=getDatabaseConfig&v=2&MessageID=c01a0b45-fb81-34fe-de69-6dfffad80d14&disable_db=1 IP Address: 172.17.0.1
DEBUG [L0404] [00002ms]: [Function](): USER-AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:66.0) Gecko/20100101 Firefox/66.0
DEBUG [L0405] [00002ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: 172.17.0.3 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.
DEBUG [L0405] [00002ms]: [Function](): php Demo Mode: 0
DEBUG [L0192] [00003ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L0197] [00003ms]: [Function](): Handling JSON Call To API Factory: APIInstall Method: getDatabaseConfig Message ID: c01a0b45-fb81-34fe-de69-6dfffad80d14
DEBUG [L0240] [00003ms] Array: [Function](): Arguments: (Size: 11)
array(0) {
}


DEBUG [L0262] [00004ms]: [Function](): No SessionID or calling non-authenticated function...
DEBUG [L0429] [00005ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0546] [00005ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L0050] [00005ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIInstall Method: getDatabaseConfig Message ID: c01a0b45-fb81-34fe-de69-6dfffad80d14
DEBUG [L0141] [00005ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L0269] [00560ms]: [Function](): Server Response Time: 0.5593249797821
---------------[ 28-Apr-2019 14:06:27 +0000 [1556460387.2824] (PID: 31277) ]---------------

---------------[ 28-Apr-2019 14:06:32 +0000 [1556460392.238] (PID: 31277) ]---------------
DEBUG [L0402] [00002ms]: [Function](): URI: /timetrex/api/json/api.php?Class=APIInstall&Method=testConnection&v=2&MessageID=629d193c-60d6-e1f7-d183-5e1e14ceba31&disable_db=1 IP Address: 172.17.0.1
DEBUG [L0404] [00002ms]: [Function](): USER-AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:66.0) Gecko/20100101 Firefox/66.0
DEBUG [L0405] [00002ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: 172.17.0.3 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.
DEBUG [L0405] [00002ms]: [Function](): php Demo Mode: 0
DEBUG [L0192] [00002ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L0197] [00003ms]: [Function](): Handling JSON Call To API Factory: APIInstall Method: testConnection Message ID: 629d193c-60d6-e1f7-d183-5e1e14ceba31
DEBUG [L0240] [00003ms] Array: [Function](): Arguments: (Size: 247)
array(1) {
[0]=>
array(7) {
["type"]=>
string(9) "postgres8"
["host"]=>
string(9) "127.0.0.1"
["database_name"]=>
string(8) "timetrex"
["user"]=>
string(8) "timetrex"
["password"]=>
string(8) "timetrex"
["priv_user"]=>
string(0) ""
["priv_password"]=>
string(0) ""
}
}


DEBUG [L0262] [00003ms]: [Function](): No SessionID or calling non-authenticated function...
DEBUG [L0429] [00004ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0546] [00004ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L0050] [00004ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIInstall Method: testConnection Message ID: 629d193c-60d6-e1f7-d183-5e1e14ceba31
DEBUG [L0141] [00004ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L0460] [00018ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0470] [00023ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L1046] [00023ms] Array: Install::getDatabaseVersion(): PostgreSQL Version:
array(13) {
["client"]=>
string(6) "9.5.12"
["protocol"]=>
int(3)
["server"]=>
string(6) "9.5.12"
["server_encoding"]=>
string(9) "SQL_ASCII"
["client_encoding"]=>
string(9) "SQL_ASCII"
["is_superuser"]=>
string(3) "off"
["session_authorization"]=>
string(8) "timetrex"
["DateStyle"]=>
string(8) "ISO, MDY"
["IntervalStyle"]=>
string(8) "postgres"
["TimeZone"]=>
string(3) "UTC"
["integer_datetimes"]=>
string(2) "on"
["standard_conforming_strings"]=>
string(2) "on"
["application_name"]=>
string(0) ""
}


DEBUG [L0269] [00547ms]: [Function](): Server Response Time: 0.54621410369873
---------------[ 28-Apr-2019 14:06:32 +0000 [1556460392.7843] (PID: 31277) ]---------------

---------------[ 28-Apr-2019 14:06:34 +0000 [1556460393.989] (PID: 31277) ]---------------
DEBUG [L0402] [00002ms]: [Function](): URI: /timetrex/api/json/api.php?Class=APIInstall&Method=createDatabase&v=2&MessageID=13ca1105-1f73-9589-d352-ab73772f26ac&disable_db=1 IP Address: 172.17.0.1
DEBUG [L0404] [00002ms]: [Function](): USER-AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:66.0) Gecko/20100101 Firefox/66.0
DEBUG [L0405] [00002ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: 172.17.0.3 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.
DEBUG [L0405] [00002ms]: [Function](): php Demo Mode: 0
DEBUG [L0192] [00002ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L0197] [00003ms]: [Function](): Handling JSON Call To API Factory: APIInstall Method: createDatabase Message ID: 13ca1105-1f73-9589-d352-ab73772f26ac
DEBUG [L0240] [00003ms] Array: [Function](): Arguments: (Size: 247)
array(1) {
[0]=>
array(7) {
["type"]=>
string(9) "postgres8"
["host"]=>
string(9) "127.0.0.1"
["database_name"]=>
string(8) "timetrex"
["user"]=>
string(8) "timetrex"
["password"]=>
string(8) "timetrex"
["priv_user"]=>
string(0) ""
["priv_password"]=>
string(0) ""
}
}


DEBUG [L0262] [00003ms]: [Function](): No SessionID or calling non-authenticated function...
DEBUG [L0429] [00004ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0546] [00004ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L0050] [00004ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIInstall Method: createDatabase Message ID: 13ca1105-1f73-9589-d352-ab73772f26ac
DEBUG [L0141] [00004ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L0372] [00004ms]: APIInstall::createDatabase(): Next
DEBUG [L0460] [00017ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0470] [00021ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L0460] [00035ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0470] [00037ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L0397] [00037ms]: APIInstall::createDatabase(): yDatabase does exist...
DEBUG [L0351] [00040ms]: Install::writeConfigFile(): Found php_cli path without backslash, trying to correct...
DEBUG [L0355] [00040ms]: Install::writeConfigFile(): Found storage path without backslash, trying to correct...
DEBUG [L0359] [00040ms]: Install::writeConfigFile(): Found log path without backslash, trying to correct...
DEBUG [L0363] [00040ms]: Install::writeConfigFile(): Found cache path without backslash, trying to correct...
DEBUG [L0404] [00042ms]: Install::writeConfigFile(): Modified Config File! writeConfig Result: 1
DEBUG [L0269] [00042ms]: [Function](): Server Response Time: 0.041781902313232
---------------[ 28-Apr-2019 14:06:34 +0000 [1556460394.0309] (PID: 31277) ]---------------

---------------[ 28-Apr-2019 14:06:34 +0000 [1556460394.056] (PID: 31277) ]---------------
DEBUG [L0402] [00002ms]: [Function](): URI: /timetrex/api/json/api.php?Class=APIInstall&Method=getDatabaseSchema&v=2&MessageID=21f6ba62-5c46-b20f-3426-2ae53a62f949 IP Address: 172.17.0.1
DEBUG [L0404] [00002ms]: [Function](): USER-AGENT: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:66.0) Gecko/20100101 Firefox/66.0
DEBUG [L0405] [00002ms]: [Function](): Version: 11.0.2 (PHP: v7.0.28-0ubuntu0.16.04.1) Edition: 10 Production: 0 Server: 172.17.0.3 OS: LINUX Database: Type: postgres8 Name: timetrex Config: /var/www/html/timetrex/includes/../timetrex.ini.
DEBUG [L0405] [00002ms]: [Function](): php Demo Mode: 0
DEBUG [L0460] [00016ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0470] [00019ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L0510] [00019ms]: Install::checkTableExists(): Table Name: company
DEBUG [L0520] [00036ms]: Install::checkTableExists(): Exists - Table Name: company
DEBUG [L0192] [00038ms]: TTDate::setTimeZone(): Setting TimeZone: GMT
DEBUG [L0197] [00039ms]: [Function](): Handling JSON Call To API Factory: APIInstall Method: getDatabaseSchema Message ID: 21f6ba62-5c46-b20f-3426-2ae53a62f949
DEBUG [L0240] [00039ms] Array: [Function](): Arguments: (Size: 11)
array(0) {
}


DEBUG [L0262] [00039ms]: [Function](): No SessionID or calling non-authenticated function...
DEBUG [L0429] [00040ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0546] [00040ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L0050] [00040ms]: unauthenticatedInvokeService(): Handling UNAUTHENTICATED JSON Call To API Factory: APIInstall Method: getDatabaseSchema Message ID: 21f6ba62-5c46-b20f-3426-2ae53a62f949
DEBUG [L0141] [00040ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L0460] [00040ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0470] [00040ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L0510] [00040ms]: Install::checkTableExists(): Table Name: company
DEBUG [L0520] [00047ms]: Install::checkTableExists(): Exists - Table Name: company
DEBUG [L0269] [00576ms]: [Function](): Server Response Time: 0.57595205307007
---------------[ 28-Apr-2019 14:06:34 +0000 [1556460394.632] (PID: 31277) ]---------------
mikeb
Posts: 710
Joined: Thu Jul 27, 2006 11:58 am

Re: Upgrade mysql to postgresql

Post by mikeb »

I'm not seeing any errors in your log file, please check your Apache or PHP error logs, its possible Apache or PHP may be crashing or timing out.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Post Reply