Cannot connect to 3.10.12 database

[kkurtz]

I have been trying to migrate a J3.10.12 site to J4.4.9. However, during the process I get an Ajax load error message. I have a post under the category "Migrating and Upgrading to Joomla! 4.x" My post is titled "Migrating from J3.10.12 to J4.4.9" I have gotten some responses and have followed the advice but the situation seems to get worse.
So I decided to try something else. I had copied the content to another J3.10.12. So I backed that up with Akeeba and restored to the original subdomain. The restore was successful. However, I don't want to use the database that comes with it. I copied the database and changed the name. Then I entered the nre db name, username and psw in the Joomla Global configuration screen and hit save. I get a message "Could not connect to database." The database is there. Here is the FPA:

[28-Nov-2024 20:03:41 UTC] PHP Warning: session_start(): Failed to read session data: files (path: /var/cpanel/php/sessions/ea-php56) in /home/cssdar/public_html/vtnapa/fpa-en.php on line 647

Joomla! Instance :: Joomla! 3.10.12-Stable (Daraja) 8-July-2023
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: true | SEF: true | SEF Suffix: false | SEF ReWrite: false | .htaccess/web.config: Yes | GZip: false | Cache: false | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 60 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: Public | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.10.12: Yes | Database Supports J! 3.10.12: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.10.0-1160.31.1.el7.x86_64 | Technology: x86_64 | Web Server: Apache | Encoding: gzip, deflate, br, zstd | System TMP Writable: Yes | Free Disk Space : 831.36 GiB |

PHP Configuration :: Version: 7.4.33 | PHP API: cgi-fcgi | Session Path Writable: No | Display Errors: 0 | Error Reporting: 32759 | Log Errors To: error_log | Last Known Error: 28th November 2024 20:04:49. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 1G | Max. POST Size: 1G | Max. Input Time: 300 | Max. Execution Time: 300 | Memory Limit: 8G

Database Configuration :: Version: 5.7.44 (Client:mysqlnd 7.4.33) | Database Size: 4.76 MiB | #of Tables with config prefix:  84 | #of other Tables:  0 | User Privileges : GRANT ALL

PHP Extensions :: Core (7.4.33) | date (7.4.33) | libxml (7.4.33) | openssl (7.4.33) | pcre (7.4.33) | zlib (7.4.33) | filter (7.4.33) | hash (7.4.33) | pcntl (7.4.33) | readline (7.4.33) | Reflection (7.4.33) | SPL (7.4.33) | session (7.4.33) | standard (7.4.33) | cgi-fcgi (7.4.33) | bcmath (7.4.33) | calendar (7.4.33) | ctype (7.4.33) | curl (7.4.33) | dom (20031129) | fileinfo (7.4.33) | ftp (7.4.33) | gd (7.4.33) | iconv (7.4.33) | imap (7.4.33) | json (7.4.33) | mbstring (7.4.33) | mysqlnd (mysqlnd 7.4.33) | PDO (7.4.33) | Phar (7.4.33) | posix (7.4.33) | SimpleXML (7.4.33) | sockets (7.4.33) | sodium (7.4.33) | sqlite3 (7.4.33) | tokenizer (7.4.33) | xml (7.4.33) | xmlwriter (7.4.33) | xsl (7.4.33) | zip (1.15.6) | mysqli (7.4.33) | pdo_mysql (7.4.33) | pdo_sqlite (7.4.33) | xmlreader (7.4.33) | ionCube Loader (12.0.5) | Zend OPcache (7.4.33) | Zend Engine (3.4.0) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: Yes | Server SU: Yes | PHP SU: Yes | Potential Ownership Issues: No

Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |

Elevated Permissions (First 10) ::

Database statistics :: Uptime: 11440986 | Threads: 1 | Questions: 94416805 | Slow queries: 0 | Opens: 35738172 | Flush tables: 1 | Open tables: 2000 | Queries per second avg: 8.252 |

Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party:: WF_SPELLCHECKER_TITLE (2.6.11) ? | WF_CONTEXTMENU_TITLE (2.6.11) ? | WF_VISUALBLOCKS_TITLE (2.6.11) ? | WF_IMGMANAGER_TITLE (2.6.11) ? | WF_MEDIA_TITLE (2.6.11) ? | WF_HR_TITLE (2.6.11) ? | WF_SOURCE_TITLE (2.6.11) ? | WF_FONTSELECT_TITLE (2.6.11) ? | WF_BROWSER_TITLE (2.6.11) ? | WF_STYLESELECT_TITLE (2.6.11) ? | WF_FONTSIZESELECT_TITLE (2.6.11) ? | WF_EMOTIONS_TITLE (2.6.11) ? | WF_SEARCHREPLACE_TITLE (2.6.11) ? | WF_ANCHOR_TITLE (2.6.11) ? | WF_FULLSCREEN_TITLE (2.6.11) ? | WF_CLEANUP_TITLE (2.6.11) ? | WF_INLINEPOPUPS_TITLE (2.6.11) ? | WF_TABLE_TITLE (2.6.11) ? | WF_PREVIEW_TITLE (2.6.11) ? | WF_KITCHENSINK_TITLE (2.6.11) ? | WF_LISTS_TITLE (2.6.11) ? | WF_CLIPBOARD_TITLE (2.6.11) ? | WF_FONTCOLOR_TITLE (2.6.11) ? | WF_TEXTCASE_TITLE (2.6.11) ? | WF_NONBREAKING_TITLE (2.6.11) ? | WF_CHARMAP_TITLE (2.6.11) ? | WF_LINK_TITLE (2.6.11) ? | WF_FORMATSELECT_TITLE (2.6.11) ? | WF_XHTMLXTRAS_TITLE (2.6.11) ? | WF_AUTOSAVE_TITLE (2.6.11) ? | WF_ARTICLE_TITLE (2.6.11) ? | WF_STYLE_TITLE (2.6.11) ? | WF_LAYER_TITLE (2.6.11) ? | WF_VISUALCHARS_TITLE (2.6.11) ? | WF_PRINT_TITLE (2.6.11) ? | WF_DIRECTIONALITY_TITLE (2.6.11) ? | WF_LINK_SEARCH_TITLE (2.6.11) ? | WF_AGGREGATOR_VIMEO_TITLE (2.6.11) ? | WF_AGGREGATOR_DAILYMOTION_TITLE (2.6.11) ? | WF_AGGREGATOR_[youtube]_TITLE (2.6.11) ? | WF_AGGREGATOR_VINE_TITLE (2.6.11) ? | WF_FILESYSTEM_JOOMLA_TITLE (2.6.11) ? | WF_POPUPS_WINDOW_TITLE (2.6.11) ? | WF_POPUPS_JCEMEDIABOX_TITLE (2.6.11) ? | WF_LINKS_JOOMLALINKS_TITLE (2.6.11) ? |

Components :: Admin ::
Core :: com_languages (3.0.0) 1 | com_redirect (3.0.0) 1 | com_cache (3.0.0) 1 | com_messages (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_menus (3.0.0) 1 | com_categories (3.0.0) 1 | com_login (3.0.0) 1 | com_installer (3.0.0) 1 | com_templates (3.0.0) 1 | com_newsfeeds (3.0.0) 1 | com_contenthistory (3.2.0) 1 | com_plugins (3.0.0) 1 | com_privacy (3.9.0) 1 | com_content (3.0.0) 1 | com_joomlaupdate (3.10.1) 1 | com_fields (3.7.0) 1 | com_modules (3.0.0) 1 | com_admin (3.0.0) 1 | com_ajax (3.2.0) 1 | com_checkin (3.0.0) 1 | com_banners (3.0.0) 1 | com_tags (3.1.0) 1 | com_users (3.0.0) 1 | com_finder (3.0.0) 1 | com_search (3.0.0) 1 | com_config (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_weblinks (3.9.0) 1 | com_postinstall (3.2.0) 1 | com_associations (3.7.0) 1 | com_media (3.0.0) 1 |
3rd Party:: Akeeba (8.3.2) 1 | COM_JCE (2.6.11) 1 |

Modules :: Site ::
Core :: mod_login (3.0.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_search (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_stats (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_random_image (3.0.0) 1 | mod_weblinks (3.9.0) 1 | mod_whosonline (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_users_latest (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_wrapper (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_languages (3.5.0) 1 |
3rd Party:: Simple File Upload v1.3 (for Joomla (1.3) ? | Blank Module (6.0.14) 1 |

Modules :: Admin ::
Core :: mod_quickicon (3.0.0) 1 | mod_status (3.0.0) 1 | mod_login (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_version (3.0.0) 1 | mod_stats_admin (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_sampledata (3.8.0) 1 | mod_title (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_latestactions (3.9.0) 1 | mod_logged (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party:: file_fof30 (3.6.2) ? | file_fof40 (4.1.3) ? |

Plugins ::
Core :: plg_system_fields (3.7.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_languagefilter (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_p3p (3.0.0) 1 | plg_system_debug (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_weblinks (3.9.0) 0 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_log (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_stats (3.5.0) 0 | plg_system_highlight (3.0.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_captcha_recaptcha (3.4.0) 1 | plg_search_newsfeeds (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_weblinks (3.9.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_content (3.0.0) 1 | plg_search_tags (3.0.0) 0 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_privacy_message (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_user (3.9.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_weblinks (3.9.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_content (3.0.0) 1 | plg_finder_tags (3.0.0) 1 | plg_installer_webinstaller (2.1.2) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_cookie (3.0.0) 1 | plg_authentication_joomla (3.0.0) 1 | plg_extension_joomla (3.0.0) 1 | plg_content_fields (3.7.0) 1 | plg_content_geshi (2.5.0) 0 | plg_content_confirmconsent (3.9.0) 0 | plg_content_loadmodule (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_emailcloak (3.0.0) 0 | plg_content_finder (3.0.0) 0 | plg_content_vote (3.0.0) 1 | plg_content_pagenavigation (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_weblink (3.9.0) 0 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_article (3.0.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_eos310 (3.10.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | plg_user_terms (3.9.0) 0 | plg_user_contactcreator (3.0.0) 0 | plg_user_profile (3.0.0) 0 | plg_user_joomla (3.0.0) 1 |
3rd Party:: PLG_SYSTEM_BACKUPONUPDATE (8.3.2) 0 | PLG_SYSTEM_AKVERSIONCHECK (8.3.2) 1 | plg_system_jce (2.6.11) 1 | PLG_JMONITORING_AKEEBABACKUP_TITLE (1.0) 1 | PLG_INSTALLER_AKEEBABACKUP (8.3.2) 1 | plg_installer_jce (2.6.11) 1 | plg_extension_jce (2.6.11) 1 | plg_editors_tinymce (4.5.12) 1 | plg_editors_codemirror (5.60.0) 1 | plg_editors_jce (2.6.11) 0 | plg_content_jce (2.6.11) 1 | plg_quickicon_akeebabackup (8.3.2) 0 | plg_quickicon_jce (2.6.0-pro-bet) 1 | PLG_ACTIONLOG_AKEEBABACKUP (8.3.2) 0 |

Templates :: Site :: Chapters1Template (1.6.0) 1 | Chapters2-Template (1.6.0) 1 | Chapters2-Template (1.6.0) 1 | beez3 (3.1.0) 1 | protostar (1.0) 1 | Chapters3-Template (1.6.0) 1 | Chapters5Template (1.6.0) 1 |
Templates :: Admin :: hathor (3.0.0) 1 | isis (1.0) 1 |

[toivo]

Session Path Writable: No

The folder specified in the php.ini directive sessionsave_path needs to be writable.

Did you set up a separate new username and password combination to the new database through phpMyAdmin or a similar MySQL client application? Unless the MySQL user has wildcard access to all the databases, the old password is not valid.

[AMurray]

I don't see any indicators that the database connection is a problem in the FPA.

[kkurtz]

I don't see a php.ini file in the root directory.

I set up a new database name and username but used the same psw. How can I setup a new password?

[kkurtz]

How can I change the sessionsave_path to writable?

[toivo]

I set up a new database name and username but used the same psw. How can I setup a new password?

Go to phpMyAdmin, select the database from the left pane and click the tab Privileges in the list of tabs at the top. Is the username listed and does it have privileges granted to the database?

If the username does not have the privileges to the database, click 'Edit privileges' and grant them to the user. If the password is not working and you are unable to access the backend of Joomla, write-enable and edit the file file configuration.php in the main Joomla folder. Use a proper text editor like vi or the one in the File Manager - Edit in cPanel and set the desired password in this line:

Code: Select all

	public $password = 'my-password';

It looks like the only option in phpMyAdmin to change the password manually is to create a new user and set the password there. The username and the password from phpMyAdmin have to match the username and password in the Global Configuration, the file configuration.php in the main Joomla folder.

[Per Yngve Berg]

How can I change the sessionsave_path to writable?

Contact your host.

[toivo]

How can I change the sessionsave_path to writable?

As you can see from the Changeable column of the list of runtime directives at https://www.php.net/manual/en/session.configuration.php, the directive session.save_path can be stored anywhere, for example in a php.ini file in the main Joomla folder. Point the path to a writable folder, for example the Joomla tmp folder, from the variable $tmp_path in the file configuration.php, for example:

Code: Select all

session.save_path ="/home/abcdefgh/public_html/mywebsite/tmp"

[kkurtz]

This is to Toivo regarding his instructions for changing the db password.
There is no Privileges tab on my phpmyadmin. My tabs are Structure, SQL, Search, Query, Export, Import, Operations, Routines, Events, Triggers, Designer.
About creating a new user. I am guessing you mean a database user and password, not a Joomla user. I don't see a place to do that.
Regarding the sessionsave_path...In the MultiPHP INI Editor there is a session.save_path with the entry /var/cpanel/php/sessions/ea-php74. It looks like most of our sites ave a similar entry - different file names - and they are all not writeable.

[toivo]

There is no Privileges tab on my phpmyadmin.

Sorry, my mistake. I got the Privileges tab from the root user of the localhost version of phpMyAdmin.

In your cPanel go to the section Databases and select 'Manage My Databases' - 'Database Users' where it is possible to add a new database user and assign the user to a particular database, or simply change the password of a current user.

It looks like most of our sites ave a similar entry - different file names - and they are all not writeable.

Then change the path to the Joomla tmp folder that is writable by Joomla.