Forums / Upgrading to 1.5.x / Upgrading MariaDB 5 to 10

Upgrading MariaDB 5 to 10

Views: 1,528

Results 1 to 3 of 3
12 May 2024, 8:49 AM
#1
siliconbug avatar

siliconbug

Zen Follower

Join Date:
Apr 2009
Posts:
125
Plugin Contributions:
0

Upgrading MariaDB 5 to 10

ZC v1.5.8a
php 7.4
phpMyAdmin v4.9.7
MariaDB v5.5.68 / v10.3.29

After upgrading ZC from 1.3.9h to v1.5.8a, everything works fine, and the next thing to do is switch from MariaDB v5 to v10.

I use phpMyAdmin to export the database from MariaDB v5, and import to v10. No error message here, and DB name, username, password are all the same.
Stop v5 and run v10. The website says "There seems to be a problem connecting to our database." Error log shows:

Request URI: /index.php?main_page=product_reviews_info&products_id=2&reviews_id=10&zenid=1k4o01rd1saah9js23cvlhnj30, IP address: 124.243.150.207, Language id
#1 mysqli_connect() called at [/web/includes/classes/db/mysql/query_factory.php:76]
#2 queryFactory->connect() called at [/web/includes/init_includes/init_database.php:22]
#3 require(/web/includes/init_includes/init_database.php) called at [/volume1/web/kendo158/includes/application_top.php:199]
#4 require(/web/includes/application_top.php) called at [/volume1/web/kendo158/index.php:25]
--> PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /web/includes/classes/db/mysql/query_factory.php on line 76.

Stop v10 and run v5, and everything is back to normal. It looks like phpMyAdmin can see MariaDB v10 on my server, but ZC can't. Do I miss any step?

13 May 2024, 5:02 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: Upgrading MariaDB 5 to 10

siliconbug:

mysqli_connect(): (HY000/2002): No such file or directory

That message typically means that the database is not responding to PHP's connection attempt when using the credentials specified in your /includes/configure.php file, namely:
DB_SERVER
DB_SERVER_USERNAME
DB_SERVER_PASSWORD
DB_DATABASE
DB_PREFIX

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

13 May 2024, 10:25 PM
#3
siliconbug avatar

siliconbug

Zen Follower

Join Date:
Apr 2009
Posts:
125
Plugin Contributions:
0

Re: Upgrading MariaDB 5 to 10

All configuration looks correct, and to stop/restart Apache/php/MariaDB 10 doesn't make any difference (in a Linux server).
Finally, I reboot the whole server..., and it works.

Come on, you're a Linux, not Windows!