CMSMS\Database\DatabaseConnectionException

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
montedavis
Forum Members
Forum Members
Posts: 64
Joined: Wed Jul 03, 2013 7:44 pm

CMSMS\Database\DatabaseConnectionException

Post by montedavis »

Hello,

I updated a version of CMSMS from 1.11.x to 2.2.15 on a siteground server, everything is working fine in this instance. I then had to move the site to an Omnis web hosting environment and now receive CMSMS\Database\DatabaseConnectionException.

My config file has "mysqli"

There are no other php errors displayed. There is no php error log.

I don't know what else to do to fix this issue? Any thoughts?

The Siteground system info is below as I cannot enter the Omnis version of CMSMS.


Thank you,

Monte




"CMSMS Version 2.2.15

Installed Modules
AdminSearch 1.0.5
CMSContentManager 1.1.9
CMSMailer 6.2.14
CmsJobManager 0.1.3
DesignManager 1.1.9
FileManager 1.6.12
FilePicker 1.0.5
FormBuilder 1.1.1
MenuManager 1.50.3
MicroTiny 2.2.5
ModuleManager 2.1.8
Navigator 1.0.9
News 2.51.11
Search 1.52
ThemeManager 1.1.8
TinyMCE 2.9.12

CMS Made Simple Config Settings
php_memory_limit
max_upload_size 256000000
url_rewriting none
page_extension
query_var page
auto_alias_content true
locale
set_names true
timezone America/New_York
permissive_smarty false
debug false
root_url https://www.gilliganoilcompany.com
ssl_url https://www.gilliganoilcompany.com
root_path Success /home/customer/www/gilliganoilcompany.com/public_html (0755)
uploads_path Success /home/customer/www/gilliganoilcompany.com/public_html/uploads (0755)
uploads_url https://www.gilliganoilcompany.com/uploads
image_uploads_path Success /home/customer/www/gilliganoilcompany.com/public_html/uploads/images (0755)
image_uploads_url https://www.gilliganoilcompany.com/uploads/images
ssl_uploads_url https://www.gilliganoilcompany.com/uploads

Performance and Tuning Information (recommended settings, but not required)
Allow Browser to Cache Pages Caution Off (False)
Allowing browsers to cache pages will improve performance by not requiring your system to serve the page on repeated visits to a page.
Browser Cache Expiry Period (minutes) Success 60
PHP 5.5+ Opcode Cache Success On (True)
Enable Smarty Caching Caution Off (False)
Enabling Smarty caching can have serious performance benefits for most websites.
Do a Compilation Check Success Off (False)
Remove cache files that are older than the specified number of days Caution Off (False)
The system should be configured to destroy old temporary files after a reasonable time to improve performance and minimize disk space requirements

PHP Information
Current PHP Version (phpversion) Success 7.4.26
md5 function (md5_function) Success On (True)
JSON functions (json_function) Success On (True)
GD version (gd_version) Success 2
tempnam function (tempnam_function) Success On (True)
Magic quotes in runtime (magic_quotes_runtime) Success Off (False)
Is E_ALL enabled in error_reporting (E_ALL) Success
Is E_STRICT disabled in error_reporting (E_STRICT) Success
Is E_DEPRECATED disabled in error_reporting (E_DEPRECATED) Caution E_DEPRECATED is enabled
Testing for time difference in the file system (test_file_timedifference) Success No time difference found
Testing for time difference in the database (test_db_timedifference) Success No time difference found
Checking if the HTTPD process can create a file inside of a directory it created (create_dir_and_file) Success 1
PHP Effective Memory Limit (memory_limit) Success 768M
Maximum Execution Time (max_execution_time) Success 120
PHP register_globals (register_globals) Success Off (False)
PHP output_buffering (output_buffering) Caution 0 ?
disable_functions in PHP (disable_functions) Success
PHP Open Basedir (open_basedir) Success
Test for remote URL (test_remote_url) Success Success
fsockopen: Connection ok! Success
fopen: Connection ok! Success
File uploads (file_uploads) Success On (True)
Maximum Post Size (post_max_size) Success 256M
Maximum Upload Size (upload_max_filesize) Success 256M
Session Save Path (session_save_path) Success /tmp (1777)
Sessions are allowed to use Cookies (session_use_cookies) Success On (True)
Basic XML (expat) support (xml_function) Success On (True)
Checking for the XMLReader class (xmlreader_class) Success On (True)
Test ini_set (check_ini_set) Success On (True)
Test for the curl library (curl) Success On
Test curl version (curlversion) Success version 7.66.0, minimum recommended version is 7.19.7

Server Information
Server Software (server_software) apache
Server API (server_api) apache2handler
Server Operating System (server_os) linux 3.12.18-clouder0 on x86_64
Server Database (server_db_type) mysql (mysqli)
Server Database Version (server_db_version) Success 5.7.32
Check database access levels (server_db_grants) Success found a "grant all" statement that appears to be suitable

Permission Information
tmp Success /home/customer/www/gilliganoilcompany.com/public_html/tmp (0755)
tmp_cache Success /home/customer/www/gilliganoilcompany.com/public_html/tmp/cache (0755)
templates_c Success /home/customer/www/gilliganoilcompany.com/public_html/tmp/templates_c (0755)
modules Success /home/customer/www/gilliganoilcompany.com/public_html/modules (0755)
uploads Success /home/customer/www/gilliganoilcompany.com/public_html/uploads (0755)
File Creation Mask (umask) Success /home/customer/www/gilliganoilcompany.com/public_html/tmp/cache (0755)
config_file Success 0444
User avatar
DIGI3
Dev Team Member
Dev Team Member
Posts: 1609
Joined: Wed Feb 25, 2009 4:25 am
Location: Victoria, BC

Re: CMSMS\Database\DatabaseConnectionException

Post by DIGI3 »

I'm pretty sure the only things it could be is incorrect settings in the config.php file or the user not having access to the database. Some hosts put the database on a different server so the defaults aren't always appropriate.

Often clearing the cache (manually, if necessary) will fix issues after a host move, but I don't think that will be the case this time.
Not getting the answer you need? CMSMS support options
montedavis
Forum Members
Forum Members
Posts: 64
Joined: Wed Jul 03, 2013 7:44 pm

Re: CMSMS\Database\DatabaseConnectionException

Post by montedavis »

Thanks DIGI3, The new host does use a specific host name, not "localhost" I believe I have the credentials correct as was tested by host admin. I manually cleared the cache but no luck. I'll double check the user permissions.
montedavis
Forum Members
Forum Members
Posts: 64
Joined: Wed Jul 03, 2013 7:44 pm

SOLVED Re: CMSMS\Database\DatabaseConnectionException

Post by montedavis »

permission were correct, but I had a TYPO in db name! Thank you!
Post Reply

Return to “CMSMS Core”