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 '('JOS5jkuil2CHIvfT') WHERE User='root'' at line 1
Using NAT Address: 192.168.1.24
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 '('JOS5jkuil2CHIvfT') 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
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
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 '('JOS5jkuil2CHIvfT') WHERE User='root'' at line 1
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 '('JOS5jkuil2CHIvfT') 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 '('JOS5jkuil2CHIvfT') 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: 7539.
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.
There are no commands defined in the "db" namespace.
Waiting for PIDS: 7528, 7528.
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.
Do I need to do anything to get my truenas to use 12.1 version? It seems to still be using 12.2.
Waqar May 11, 2021 at 4:57 PM
we are reverting back to using 12.1-RELEASE for now until other bits are in place for nextcloud to consume 12.2-RELEASE. This change will revert nextcloud back to 12.1 ( https://github.com/freenas/iocage-ix-plugins/pull/287 ).
Bonnie Follweiler May 7, 2021 at 7:05 PM
Yes, thank you
James Davison May 7, 2021 at 6:16 PM
I attached the debug file. Does that look correct?
The NextCloud plugin installer seems to not support MySQL 8.0.
After the plugin json was updated to use MySQL 8.0 the install has these issues.
https://github.com/freenas/iocage-ix-plugins/blob/12.2-RELEASE/nextcloud.json
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 '('JOS5jkuil2CHIvfT') WHERE User='root'' at line 1
Using NAT Address: 192.168.1.24
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 '('JOS5jkuil2CHIvfT') 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
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 '('JOS5jkuil2CHIvfT') WHERE User='root'' at line 1
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 '('JOS5jkuil2CHIvfT') 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 '('JOS5jkuil2CHIvfT') 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: 7539.
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.
There are no commands defined in the "db" namespace.
Waiting for PIDS: 7528, 7528.
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.
Admin Portal:
http://192.168.1.24:8282