Failed to connect to database problem

MyOOS [Dumper]ist ein Sicherungsprogramm für MySQL-Datenbanken. Damit können Sicherungskopien der Daten (Forum, Shop, Blog, usw.) erstellt und bei Bedarf auch wieder hergestellt werden. Besonders bei Web-Space ohne Shell-Zugang bietet sich MyOOS [Dumper] als sinnvolle Alternative an.
Antworten
skeith
Beiträge: 2
Registriert: 02.09.2019, 22:16

Failed to connect to database problem

Beitrag von skeith »

Hi, afraid I don't know German so hopefully everything typed can be understood.

Trying to install this on my server but its giving me an error upon hitting the admin install button at the end of the process which throws this error: mysqli://*username*:@localhost/*db name* failed to connectAccess denied for user '*username'@'localhost' (using password: YES)

I changed the names between the ** to not let out my database information.


Everything looks green up to that point but one thing, which is: Session save path Not set, Unwriteable.

Not sure if that would cause any issues. My hosting says the database is actually MariaDB and not mysqli. Not sure if that would also cause a problem?

Thanks for any help on this.
r23
Beiträge: 2624
Registriert: 18.09.2008, 05:56
Wohnort: Hagen
Kontaktdaten:

Re: Failed to connect to database problem

Beitrag von r23 »

Hello and welcome,

I'm guessing you want to install the shop system?

PHP Diagnosis
Here we examine the configuration attitudes of its PHP installation. PHP Info
PHP version >= 7.2.0 Yes

Please click on the PHP diagnosis page (the page after the license agreement) on PHP Info

mysqli must be active: Example on the screenshot
03-09-_2019_1-38-39.jpg
03-09-_2019_1-38-39.jpg (227.3 KiB) 9252 mal betrachtet


If the user rights are not sufficient, create a new empty database with another tool (provider interface).


Enter the access data into the form and click on Start without creating a new database (leave checkbox empty).
03-09-_2019_1-45-51.jpg
03-09-_2019_1-45-51.jpg (172.53 KiB) 9252 mal betrachtet
Hope the answer will help.

Ralf
skeith
Beiträge: 2
Registriert: 02.09.2019, 22:16

Re: Failed to connect to database problem

Beitrag von skeith »

Looks like mine is off, any way of turning it on?
mysqli.png
mysqli.png (23.07 KiB) 9244 mal betrachtet
r23
Beiträge: 2624
Registriert: 18.09.2008, 05:56
Wohnort: Hagen
Kontaktdaten:

Re: Failed to connect to database problem

Beitrag von r23 »

Hello,

I don't see any mistakes

The project uses the database abstraction layer Adodb for the database.

The error message is generated in the file install/newinstall.php in line 54

Code: Alles auswählen

       $db = NewADOConnection($dbtype);
       $dbh = $db->Connect($dbhost, $dbuname, $dbpass);
       if (!$dbh) {
        $dbpass = "";
        die("$dbtype://$dbuname:$dbpass@$dbhost failed to connect" . $db->ErrorMsg());
       }

The connection is established with NewADOConnection. What I only notice is the upper/lower case.

Adodb Doc
https://adodb.org/dokuwiki/doku.php?id= ... connection

Code: Alles auswählen

       $db     = adoNewConnection($driver);
newAdoConnection() Is a pseudonym for adoNewConnection()
https://adodb.org/dokuwiki/doku.php?id= ... ence_index

Sorry - but I have no idea for a solution

Ralf
zonebattler
Beiträge: 3
Registriert: 01.04.2021, 18:44

Re: Failed to connect to database problem

Beitrag von zonebattler »

I encountered the same problem today. Upon starting the Dumper (which has been working flawlessly for years until today), I'm getting the error message:

MySQL-ERROR
MySQL meldet:
Access denied for user 'xxxxxxxxx'@'yyyyyyyy.zzzzzzz.com' (using password: YES)


Fehler bei der Anfrage:
Error establishing a database connection!


The only thing that has changed since the last working backup: My hoster (all-inkl.com) has switched my databases from MySQL to MariaDB!

I maintain the website of a friend on another server of the same hoster which has not been migrated from MySQL to MariaDB yet. In this installation, the Dumper is still working flawlessly. So it seems that the Dumper (even in the newest version v5.0.3-dev) doesn't like MariaDB databases.

Can anybody confirm this or - even better - fix it? I'd really, really like to stay with the Dumper instead of using any WordPress plugins...

Thanks,
Ralph
Antworten