Sqlstate[hy000] [2054]

Server
1

Ciao to all!!

Today i have installed apache, mysql and php on my new proliant.
after that i install owncloud.
all works fine but can not start configuration because in the access page of owncloud after i put correct information and click on end conbfiguration the owncloude page answer me:

Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

i have try a lot of thing see in google… but i do not able to solve this…

can you help me?

thanks in advance!!
stefano

Error while trying to create admin user: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Steps to reproduce

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Server configuration

Operating system:

Web server:

Database:

PHP version:

ownCloud version: (see ownCloud admin page)

Updated from an older ownCloud or fresh install:

Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.

or 

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder

*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.

Are you using external storage, if yes which one: local/smb/sftp/…

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…

LDAP configuration (delete this part if not used)

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:

Operating system:

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

Insert your ownCloud log here

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...
2

Hello,

how about filling the template so we might narrow down ?
Did you try setting 127.0.0.1 or localhost ?
Cheers.

2 Likes
3

localhost
then:
Operating system : ubuntu desktop 20.04

**Web server:**Apache

Database: mysql 8.0.20

PHP version: 7.2.31

ownCloud version: (see ownCloud admin page) latest 10

Updated from an older ownCloud or fresh install: fresh

Where did you install ownCloud from:

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.

The content of config/config.php:

Log in to the web-UI with an administrator account and click on
'admin' -> 'Generate Config Report' -> 'Download ownCloud config report'
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.

or 

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your ownCloud installation folder

*ATTENTION:* Do not post your config.php file in public as is. Please use one of the above
methods whenever possible. Both, the generated reports from the web-ui and from occ config:list
consistently remove sensitive data. You still may want to review the report before sending.
If done manually then it is critical for your own privacy to dilligently
remove *all* host names, passwords, usernames, salts and other credentials before posting.
You should assume that attackers find such information and will use them against your systems.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.

Are you using external storage, if yes which one: local/smb/sftp/…

Are you using encryption: yes/no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…

LDAP configuration (delete this part if not used)

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your ownCloud installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';


Eventually replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser: chrome

Operating system: unbuntu 20.04

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

Insert your ownCloud log here

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...
4

Could you try with 127.0.0.1 to check ?
Do you have PDO installed, I suggest you check the required modules.

1 Like
5

already check with 127.0.0.1 and with the ip address of machine
port 3306 correct?

6

Default is port 3306 but it depends on your configuration.
Can you login with a simple mysql in the console ?

mysql -u user ...
1 Like
7

yes
i will do
now like root or like user?

8

Well the one you use to create your ownCloud account.

9

ok i am logged on with workbench

10

It doesn’t proved the point unless you are using workbench on localhost ?
Check the requirements too as I stated before.

11

yes i am log in with localhost
if is needed that i log in with shell of php pèls tell me how.

stefanbo

12

Reporting same problem.
My setup - Ubuntu 20.04 - OwnCloud 10.2.
Command for creating user and granting privileges on owncloud DB had to be separated not as found in instructions).
`mysql> CREATE USER ‘admin’@‘localhost’ IDENTIFIED BY ‘MyPassword1’;
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL ON owncloud.* to ‘admin’@‘localhost’;
Query OK, 0 rows affected (0.00 sec)`

And it is reporting same Sqlstate[hy000][2054] error on database user/password. I am entering -
user: admin,
password: password as above,
database: owncloud and
localhost.
Any news when will OwnCloud support Ubuntu20.04 and php7.4?

13

This is a mysql configuration issue. You need to allow standard login authentication. A quick internet search with your error message shows the following my.cnf line:

[mysqld]
default_authentication_plugin= mysql_native_password

Just install PHP7.3 via Ondrej PPA until PHP7.4 is supported:


PHP7.4 will be supported with the next release (ownCloud 10.5) which is supposed to be release pretty soon (tm)

2 Likes
14

Great ! It worked!

Only I did it with:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Good for 10.5 - I will wait this version for full deployment.

1 Like
15

I’m pretty sure it is not advisable to run a web application with a db root user. I would recommend to create another user with just access to the ownCloud database.

1 Like
16

Of course it is not root…Just used this as example:)
Thanx though.

1 Like