First time user of this software and it has been driving me insane.

[Ofloo]

Started out with php8 but that i think has it's own problems, so changed to php7.4. When I run phppsinfo.php all is green except the first 2 those are blue, seems normal to me though.

 
webserver:

nginx -V
nginx version: nginx/1.20.1
built with OpenSSL 1.1.1k-freebsd  25 Mar 2021
TLS SNI support enabled

php version

PHP 7.4.22 (cli) (built: Aug  3 2021 01:11:05) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.22, Copyright (c), by Zend Technologies

Prestashop version 1.7.7.6

mysql version:

mysql -V
mysql  Ver 8.0.25 for FreeBSD13.0 on amd64 (Source distribution)

I can login with the created user on mysql database from console, the entered database information is correct. Tried both firefox and chromium-browser

 

Error translated says database server not found, check login and password fields. I can see an active connection on the database server, although not sure if it authenticated properly. Not sure where to check for authentication errors in mysql, however when I check err log can't see any issues.

Complete new installed server/services.

[Nickz]

Hi don't worry too much.

A domain name (or a subdomain/subfolder)

Quote

 

Recommended web server: Apache 2.2+, Nginx

PHP 7.1+

MySQL 5.6+ installed with a database created

FTP access (ask your hosting service for your credentials)

Configuration

In the PHP configuration (php.ini file) set memory_limit to "256M" and upload_max_filesize to "16M" (or more if available). If you do not have direct access to the php.ini file, ask your provider to change the settings for you.

SSL certificate if you plan to process payments internally (not using PayPal for instance)

Must have PHP extensions: CURL, DOM, Fileinfo, GD, Intl, Mbstring, Zip, Json, iconv

To improve performances: MemCached, Apcu, OpCache

 

I would try to put php to 7.3 and have you opened a Datenbank?

[Ofloo]

Yes I've created a database. But if it's such an issue to go beyond php version 7.3 then maybe this should be a disclaimer, 7.1+ <=7.3 because 7.1+ is everything above.

 

however !!

 

 

And still the same problem. And yes the mysql db just works. There's no doubt I can login on the console using the same credentials ! The database server is installed locally so nginx is connecting from localhost. There's no authentication issue. I created both user shop@localhost and [email protected].

 

# mysql -u shop -p db_shop_0
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 227
Server version: 8.0.25 Source distribution

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

shop@localhost [db_shop_0]> 

 

[Nickz]

What is the path to the DB? Change the parameter if you copy them for publishing purposes.

Do not openly publish here the real data. If unsure PM me.

[Ofloo]

Path? the files are handled by mysql, .. why would you want to know the path of the database? Or did you mean path to mysql.sock. For the sake of simplicity I've chosen to use port 3306, .. about that real data there isn't anything critical or problematic up there.