SOLVED Nextcloud Plugin 12.2-RELEASE-p6

S

shadow010

Dabbler
Joined
May 3, 2020
Messages
12
Hallo zusammen

Seit ich letzte Woche mein TrueNAS Code upgedatet habe war danach Nextcloud nicht mehr erreichbar. Da ich meine Nextcloud eh neu aufsetzen wollte habe ich die Installation deinstalliert und wollte sie neu installieren. Das Plugin meldet zwar erfolgreich installiert, wenn ich aber den nachstehenden Log ansehe sehe ich dass SQL ein Problem hat. Leider bin ich mit SQL nicht seht bewandert. Habe dann aber per Shell eine neue Tabelle Benutzer und Passwort anglegt da der dbadmin wie im Post Install Message nicht existiert/erstellt wurde. Wenn ich nun in der Webinstallation von Nextcloud den neu angelegten Benutzer und DB anstelle des von der Post Install Message verwendete Daten eingebe erhalte ich ebenfalls:
SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
Ich habe dann in der MySQL.php auch versucht den IDENTIFIED WITH mysql_native_password BY ‘$password’”; für den localhost und '%' in IDENTIFIED BY ‘$password’”; zu ändern leider ohne erfolg.

vielleicht könnt Ihr mit weiterhelfen.

vielen Danke dafür im voraus

Code:
Plugin erfolgreich installiert
Install Notes:
nginx_enable: -> YES
mysql_enable: -> YES
php_fpm_enable: -> YES
Performing sanity check on nginx configuration:
Starting nginx.
Performing sanity check on php-fpm configuration:
Starting php_fpm.
Starting mysql.
Starting mysql.
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('cLXNpGVQMtrkN2QI') WHERE User='root'' at line 1
Using NAT Address: 192.168.1.2
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('cLXNpGVQMtrkN2QI') WHERE User='root'' at line 1
Error while trying to create admin user: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
Trace: #0 /usr/local/www/nextcloud/lib/private/DB/ConnectionAdapter.php(69): OC\DB\Exceptions\DbalException::wrap()
#1 /usr/local/www/nextcloud/lib/private/DB/MySqlTools.php(60): OC\DB\ConnectionAdapter->executeQuery()
#2 /usr/local/www/nextcloud/lib/private/DB/MySqlTools.php(40): OC\DB\MySqlTools->isMariaDBWithLargePrefix()
#3 /usr/local/www/nextcloud/lib/private/Setup/MySQL.php(50): OC\DB\MySqlTools->supports4ByteCharset()
#4 /usr/local/www/nextcloud/lib/private/Setup.php(360): OC\Setup\MySQL->setupDatabase()
#5 /usr/local/www/nextcloud/core/Command/Maintenance/Install.php(108): OC\Setup->install()
#6 /usr/local/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Maintenance\Install->execute()
#7 /usr/local/www/nextcloud/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run()
#8 /usr/local/www/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
#9 /usr/local/www/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
#10 /usr/local/www/nextcloud/lib/private/Console/Application.php(215): Symfony\Component\Console\Application->run()
#11 /usr/local/www/nextcloud/console.php(100): OC\Console\Application->run()
#12 /usr/local/www/nextcloud/occ(11): require_once('/usr/local/www/...')
#13 {main}
Previous: Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
Trace: #0 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1486): OC\DB\Connection->connect()
#1 /usr/local/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1014): Doctrine\DBAL\Connection->getWrappedConnection()
#2 /usr/local/www/nextcloud/lib/private/DB/Connection.php(226): Doctrine\DBAL\Connection->executeQuery()
#3 /usr/local/www/nextcloud/lib/private/DB/ConnectionAdapter.php(66): OC\DB\Connection->executeQuery()
#4 /usr/local/www/nextcloud/lib/private/DB/MySqlTools.php(60): OC\DB\ConnectionAdapter->executeQuery()
#5 /usr/local/www/nextcloud/lib/private/DB/MySqlTools.php(40): OC\DB\MySqlTools->isMariaDBWithLargePrefix()
#6 /usr/local/www/nextcloud/lib/private/Setup/MySQL.php(50): OC\DB\MySqlTools->supports4ByteCharset()
#7 /usr/local/www/nextcloud/lib/private/Setup.php(360): OC\Setup\MySQL->setupDatabase()
#8 /usr/local/www/nextcloud/core/Command/Maintenance/Install.php(108): OC\Setup->install()
#9 /usr/local/www/nextcloud/3rdparty/symfony/console/Command/Command.php(255): OC\Core\Command\Maintenance\Install->execute()
#10 /usr/local/www/nextcloud/3rdparty/symfony/console/Application.php(1009): Symfony\Component\Console\Command\Command->run()
#11 /usr/local/www/nextcloud/3rdparty/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand()
#12 /usr/local/www/nextcloud/3rdparty/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun()
#13 /usr/local/www/nextcloud/lib/private/Console/Application.php(215): Symfony\Component\Console\Application->run()
#14 /usr/local/www/nextcloud/console.php(100): OC\Console\Application->run()
#15 /usr/local/www/nextcloud/occ(11): require_once('/usr/local/www/...')
#16 {main}
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('cLXNpGVQMtrkN2QI') WHERE User='root'' at line 1
Nextcloud is not installed - only a limited number of commands are available
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('cLXNpGVQMtrkN2QI') WHERE User='root'' at line 1
Nextcloud is not installed - only a limited number of commands are available
Nextcloud is not installed - only a limited number of commands are available
There are no commands defined in the "config:system" namespace.
Nextcloud is not installed - only a limited number of commands are available
There are no commands defined in the "config:system" namespace.
Nextcloud is not installed - only a limited number of commands are available
Nextcloud is not installed - only a limited number of commands are available
There are no commands defined in the "db" namespace.
Performing sanity check on php-fpm configuration:
There are no commands defined in the "db" namespace.
Stopping php_fpm.
There are no commands defined in the "db" namespace.
There are no commands defined in the "db" namespace.
Waiting for PIDS: 8323.
There are no commands defined in the "db" namespace.
Performing sanity check on php-fpm configuration:
There are no commands defined in the "db" namespace.
Starting php_fpm.
There are no commands defined in the "db" namespace.
Performing sanity check on nginx configuration:
There are no commands defined in the "db" namespace.
Stopping nginx.
There are no commands defined in the "db" namespace.
There are no commands defined in the "db" namespace.
Waiting for PIDS: 8304.
There are no commands defined in the "db" namespace.
Performing sanity check on nginx configuration:
There are no commands defined in the "db" namespace.
Starting nginx.
There are no commands defined in the "db" namespace.
There are no commands defined in the "db" namespace.
Admin Portal:
http://192.168.101.3
 
micneu

micneu

Patron
Joined
Mar 23, 2019
Messages
474
frag doch mal im nextcloud forum, die kenne sich ja damit besser aus denke ich (ich hatte nur mal nextcloud zum testen auf einem raspi)
 
Ray_Lion

Ray_Lion

Cadet
Joined
May 13, 2021
Messages
1
Hey shadow, konntest du den Fehler beheben? Verzweifle gerade am gleichen Problem..

LG!
 
Patrick M. Hausen

Patrick M. Hausen

Hall of Famer
Joined
Nov 25, 2013
Messages
7,776
Was sagt denn pkg info | grep mysql innerhalb des Jails?
 
S

shadow010

Dabbler
Joined
May 3, 2020
Messages
12
Hallo zusammen
ja das Problem konte ich beheden dafür habe ich das echte Problem gefunden: 12.1/12.2 Releads

@Ray_Lion
Du musst die Datenbank selber bauen dazu:
log dich auf der nextcloud-jail shell ein
mysql -u root
CREATE DATABASE nextcloud;
CREATE USER 'dbadmin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORT_DAS_BEI_POST_INSTALL_MESSAGE_ANGEZEIGT_WIRD';
GRANT ALL PRIVILEGES ON nextcloud.* TO 'dbadmin'@'localhost';
FLUSH PRIVILEGES;
SELECT User,Host FROM mysql.user; <---Nun solltest du den dbadmin sehen!!!
und kannst weiter machen und dich einlogen
Gruss hoffe es hilft dir noch
 
You must log in or register to reply here.

Similar threads

K
Nextcloud can't see database, unlike all guides
Replies
2
Views
3K
pc-magic
pc-magic
V
nextcloud installing Problem
2
Replies
22
Views
8K
venco
venco
T
Nextcloud iocage upgrade fail: Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002]
Replies
1
Views
315
subnetspider
subnetspider
B
WEBDav access in Windows 10 (Nextcloud)
Replies
1
Views
2K
boniek
B
Janus Ng
  • Locked
FreeNAS 9.10-U6 migration from ownCloud plugin to Nextcloud plugin
Replies
3
Views
2K
Janus Ng
Janus Ng
Top