Post by MMinieri » Sun Dec 27, 2020 10:09 am

I'm sure it's something simple (Newbie here) but nothing I try resolves it. Doing a fresh install of OC3. The full error message (it's LONG), my step 3 config form, and screenshots of current DB and User are posted here [b]https://www.ceperianas.com/TECH_ISS ... e.jpg [/b] . Pretty annoying since I removed (via CPanel) the previous copy of OC to minimize have to fix my own errors. Any help will be appreciated. Thanks in advance.

Newbie

Posts

Joined
Mon Nov 04, 2019 8:22 am

Post by sw!tch » Sun Dec 27, 2020 11:32 am

try localhost for hostname. Ensure your DB credentials are correct per your cpanel.

Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!


Active Member

Posts

Joined
Sat Apr 28, 2012 2:32 pm

Post by MMinieri » Sun Dec 27, 2020 2:11 pm

Thanks. Tried with LOCALHOST ... no joy. Can anyone confirm WHICH USERNAMES to insert in Part 1 and 2? I assume Part 1 is a user created when the DB was created. Part 2 says "for administration" ..... of WHAT? OC itself or the DB? Also, EMAIL is my ACTUAL email? The error massage starts with a reference to xxxx@(some IP address?).

Newbie

Posts

Joined
Mon Nov 04, 2019 8:22 am

Post by sw!tch » Sun Dec 27, 2020 2:36 pm

On the installer.

Config Section 1 is your database setup.

Config Section 2 is your Opencart Store Administration panel setup.

Maybe watch the video in the documentation here - http://docs.opencart.com/en-gb/installation/

Full Stack Web Developer :: Send a PM for Custom Work.
Backup and learn how to recover before you make any changes!


Active Member

Posts

Joined
Sat Apr 28, 2012 2:32 pm

Post by MMinieri » Sun Dec 27, 2020 4:26 pm

Thanks for the reply and link. That is the link I was following when I got hung up at STEP 3. I will keep at it.

Newbie

Posts

Joined
Mon Nov 04, 2019 8:22 am

Post by pprmkr » Sun Dec 27, 2020 5:21 pm

Error message with wrong credentials for database access.
Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'ceperianascom'@'localhost' (using password: YES) in /home4/riannace/public_html/ceperianas.com/system/library/db/mysqli.php on line 7Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home4/riannace/public_html/ceperianas.com/system/library/db/mysqli.php on line 10Warning: DB\MySQLi::__construct(): Couldn't fetch mysqli in /home4/riannace/public_html/ceperianas.com/system/library/db/mysqli.php on line 10Notice: Undefined variable: mysql in /home4/riannace/public_html/ceperianas.com/install/controller/install/step_3.php on line 280Notice: Trying to get property 'connect_error' of non-object in /home4/riannace/public_html/ceperianas.com/install/controller/install/step_3.php on line 280

Log in CPanel and find database settings. Server address ( hostname ), database user ( username ) and database name. When you cannot recall password, change it . And then enter that credentials in setup step 3.

User avatar
Active Member

Posts

Joined
Sat Jan 08, 2011 11:05 pm
Location - Netherlands

Post by MMinieri » Mon Dec 28, 2020 8:09 am

Thanks all. I missed some facts that were not clear in any of the OC docs I searched. Most importantly;

* DB name cannot have any UPPER CASE letters ..... such as oc vs OC
* The DB password in Part 1 is - apparently - something created by the HOST

Starting over again

Newbie

Posts

Joined
Mon Nov 04, 2019 8:22 am
Who is online

Users browsing this forum: No registered users and 17 guests