Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

QuestionAnswer
[sudo] password for jtel:The jtel user password
mysql host address:

acd-dbm

For redundant installations only: acd-dbm1 or acd-dbm2, depending on which is active

mysql user name:root
mysql password:The MySQL root password
customer directory:The customer directory from above, or just ENTER if none is present.

Check the Output

This is an example of a successful update:

Code Block
--------------------------------------
JTELCarrierPortal - full update script
--------------------------------------
mysql host address: acd-dbm
mysql user name: root
mysql password: Fe1er3B0rl
customer directory: 

Settings
--------
MYSQLHOST:   acd-dbm
MYSQLUSER:   root
MYSQLPASS:   Fe1er3B0rl
CUSTOMERDIR: 

-----------------------------------------
Phase 1 - files, directories, permissions
-----------------------------------------
Copying Data/system/help from JTELCarrierPortal ... done!
Copying Data/system/gui from JTEL ... done!
Removing no longer needed .xls.jrxml files ... done!
Copying Data/system/jasper from JTELCarrierPortal ... done!
Ensure correct file permissions in JTELCarrierPortal ... done!
Ensure correct file permissions in Data ... done!
Ensure correct file permissions in JTEL ... done!
Phase 1 - files, directories, permissions - DONE.

--------------------
Phase 2 - DB Updates
--------------------
Call update_all.sh in JTELCarrierPortal ...
Updating database ...
mysql_execute: portal Update_JTELDatabases.sql ... done!
mysql_execute: portal Update_JTELWeb_Utils.sql ... done!
mysql_execute: delete Delete_JTELLog.sql ... done!
mysql_execute: delete Delete_JTELWeb.sql ... done!
mysql_execute: delete Delete_JTELStats.sql ... done!
mysql_execute: delete Delete_ResourcesParams.sql ... done!
mysql_execute: fixes CSTUTT-278_JTELStats.FixStatistics_UsersLogin.sql ... done!
mysql_execute: fixes CSTUTT-278_JTELStats.FixStatistics_UsersGroupsLogin.sql ... done!
mysql_execute: fixes JTELWeb.RemoveTranslators.sql ... done!
mysql_execute: init AreaCodes_AT.sql ... done!
mysql_execute: cleaners Cleaners.sql ... done!
mysql_execute: portal Update_JTELLog.sql ... done!
mysql_execute: portal Update_JTELWeb.sql ... done!
mysql_execute: portal Update_JTELStats.sql ... edone!
mysql_execute: importexport2 Update_JTELWeb_ImportExport2.sql ... done!
mysql_execute: hardstyle Update_JTELWeb_Hardstyle.sql ... done!
mysql_execute: acd Update_JTELWeb_Acd.sql ... done!
mysql_execute: acd Update_JTELStats_Acd.sql ... done!
mysql_execute: cache Update_JTELWeb_Cache.sql ... done!
mysql_execute: cache Update_JTELStats_Cache.sql ... done!
mysql_execute: conf Update_JTELWeb_Conf.sql ... done!
mysql_execute: conf Update_JTELStats_Conf.sql ... done!
mysql_execute: dialler Update_JTELWeb_Dialler.sql ... done!
mysql_execute: dialler Update_JTELStats_Dialler.sql ... done!
mysql_execute: jts_service JTS_Service.sql ... done!
mysql_execute: presence Update_Presence.sql ... done!
mysql_execute: salesforce Update_SalesForce.sql ... done!
mysql_execute: sap Update_SAP.sql ... done!
mysql_execute: cockpit cockpit.sql ... done!
mysql_execute: jtelstats2 Update_JTELWeb.sql ... done!
mysql_execute: jtelstats2 Update_JTELStats2.sql ... done!
mysql_execute: jrest jrest_ResourcesParams.sql ... done!
mysql_execute: jrest Update_jrest.sql ... done!

Database update done!

Search for errors ...

CONGRATULATIONS: no errors during update.
Call update_all.sh in JTEL ...
Updating database..........
CONGRATULATIONS: no errors during update.
Call update_translations.sh in JTELCarrierPortal ...
Updating translations ...
mysql_execute: translations Update_JTELWeb_Translations.sql ... done!

Database update done!

Search for errors ...

CONGRATULATIONS: no errors during update.
Phase 2 - DB Updates - DONE.

-------------------------------------------------------------------------------------------
All done. REMEMBER: the error checking in this script is not perfect - SO TEST, TEST, TEST!
-------------------------------------------------------------------------------------------