Hi guys, im trying to install elgg on XAMPP for local elgg manipulation
Im basing myself on this tutorial http://learn.elgg.org/en/v2.3.2/intro/install/xampp.html but when i go to http://localhost/sites/elgg and actually start installing elgg, after i fill my information on database installation and click "next" this error appears to me:
An unrecoverable error has occurred and has been logged. If you are the site administrator check your settings file, otherwise contact the site administrator with the following information:
Exception at time 1492840736.
And when i go to my error log and type that number this is what appears:
[Sat Apr 22 01:58:56.057672 2017] [:error] [pid 9780:tid 1876] [client 127.0.0.1:53377] Exception at time 1492840736: exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOConnection.php:43\nStack trace:\n#0 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOConnection.php(43): PDO->__construct('mysql:host=loca...', 'root', 'root', Array)\n#1 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOMySql\\Driver.php(45): Doctrine\\DBAL\\Driver\\PDOConnection->__construct('mysql:host=loca...', 'root', 'root', Array)\n#2 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'root', 'root', Array)\n#3 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Connection.php(1036): Doctrine\\DBAL\\Connection->connect()\n#4 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(176): Doctrine\\DBAL\\Connection->exec('SET SESSION sql...')\n#5 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(143): Elgg\\Database->connect('readwrite')\n#6 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(123): Elgg\\Database->setupConnections()\n#7 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(386): Elgg\\Database->getConnection('read')\n#8 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(226): Elgg\\Database->getResults('SELECT 1', NULL, true, Array)\n#9 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(1254): Elgg\\Database->getDataRow('SELECT 1')\n#10 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(1231): ElggInstaller->checkDatabaseSettings('root', 'root', 'elgg12', 'localhost')\n#11 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(380): ElggInstaller->validateDatabaseVars(Array, Array)\n#12 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(132): ElggInstaller->database(Array)\n#13 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Application.php(485): ElggInstaller->run('database')\n#14 C:\\xampp\\htdocs\\sites\\elgg\\install.php(11): Elgg\\Application::install()\n#15 {main}\n\nNext exception 'Doctrine\\DBAL\\Driver\\PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOConnection.php:47\nStack trace:\n#0 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOMySql\\Driver.php(45): Doctrine\\DBAL\\Driver\\PDOConnection::__construct('mysql:host=loca...', 'root', 'root', Array)\n#1 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'root', 'root', Array)\n#2 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Connection.php(1036): Doctrine\\DBAL\\Connection->connect()\n#3 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(176): Doctrine\\DBAL\\Connection->exec('SET SESSION sql...')\n#4 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(143): Elgg\\Database->connect('readwrite')\n#5 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(123): Elgg\\Database->setupConnections()\n#6 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(386): Elgg\\Database->getConnection('read')\n#7 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(226): Elgg\\Database->getResults('SELECT 1', NULL, true, Array)\n#8 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(1254): Elgg\\Database->getDataRow('SELECT 1')\n#9 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(1231): ElggInstaller->checkDatabaseSettings('root', 'root', 'elgg12', 'localhost')\n#10 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(380): ElggInstaller->validateDatabaseVars(Array, Array)\n#11 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(132): ElggInstaller->database(Array)\n#12 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Application.php(485): ElggInstaller->run('database')\n#13 C:\\xampp\\htdocs\\sites\\elgg\\install.php(11): Elgg\\Application::install()\n#14 {main}\n\nNext exception 'Doctrine\\DBAL\\Exception\\ConnectionException' with message 'An exception occured in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)' in C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\AbstractMySQLDriver.php:103\nStack trace:\n#0 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\DBALException.php(145): Doctrine\\DBAL\\Driver\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\DBAL\\Driver\\PDOException))\n#1 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Driver\\PDOMySql\\Driver.php(47): Doctrine\\DBAL\\DBALException::driverException(Object(Doctrine\\DBAL\\Driver\\PDOMySql\\Driver), Object(Doctrine\\DBAL\\Driver\\PDOException))\n#2 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Connection.php(360): Doctrine\\DBAL\\Driver\\PDOMySql\\Driver->connect(Array, 'root', 'root', Array)\n#3 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\doctrine\\dbal\\lib\\Doctrine\\DBAL\\Connection.php(1036): Doctrine\\DBAL\\Connection->connect()\n#4 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(176): Doctrine\\DBAL\\Connection->exec('SET SESSION sql...')\n#5 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(143): Elgg\\Database->connect('readwrite')\n#6 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(123): Elgg\\Database->setupConnections()\n#7 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(386): Elgg\\Database->getConnection('read')\n#8 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Database.php(226): Elgg\\Database->getResults('SELECT 1', NULL, true, Array)\n#9 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(1254): Elgg\\Database->getDataRow('SELECT 1')\n#10 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(1231): ElggInstaller->checkDatabaseSettings('root', 'root', 'elgg12', 'localhost')\n#11 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(380): ElggInstaller->validateDatabaseVars(Array, Array)\n#12 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\ElggInstaller.php(132): ElggInstaller->database(Array)\n#13 C:\\xampp\\htdocs\\sites\\elgg\\vendor\\elgg\\elgg\\engine\\classes\\Elgg\\Application.php(485): ElggInstaller->run('database')\n#14 C:\\xampp\\htdocs\\sites\\elgg\\install.php(11): Elgg\\Application::install()\n#15 {main}, referer: http://localhost/sites/elgg/install.php?step=database
Pretty long but i dont knows what any of that means. Can you guys help me please
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by RaĆ¼l Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- iionly@iionly
iionly - 0 likes
- vyas@saurabhvyas
vyas - 0 likes
- Nikolai Shcherbin@rivervanrain
Nikolai Shcherbin - 0 likes
- Check your server logs
- Try to edit this:
You must log in to post replies.Have you created the database to be used for Elgg? You need to do that on your own. And if the database exists, are you sure that the database name, database user and password you have entered are correct? These must match with the database name and the database user must have the permission to access the database. The error message indicates that there's a problem with connecting to the database. But which of the possible reasons I listed for the connection problem I can't tell from the error message as it could be either of them.
I am facing the same issue while installing :
"An unrecoverable error has occurred and has been logged. If you are the site administrator check your settings file, otherwise contact the site administrator with the following information: "
I am using ELGG 2.3.5, with MySQL installed in my Windows 10 system & rest software in WSL (apache, php)
I could access db from WSL bash.
root@SAVYAS-LAP:/var/www# mysql -u root -p --host=127.0.0.1 --port=3306 --protocol=TCP
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37
Server version: 5.7.21-log MySQL Community Server (GPL)
..
..
mysql>
I checked that I have settings.py correct
root@SAVYAS-LAP:/var/www# grep db elgg-config/settings.php
* @global string $CONFIG->dbuser
$CONFIG->dbuser = 'admin';
* @global string $CONFIG->dbpass
$CONFIG->dbpass = <<passwd>>
* @global string $CONFIG->dbname
$CONFIG->dbname = <<db-name>>
* @global string $CONFIG->dbhost
$CONFIG->dbhost = '127.0.0.1';
* @global string $CONFIG->dbprefix
$CONFIG->dbprefix = '';
//$CONFIG->db['split'] = true;
//$CONFIG->db['write']['dbuser'] = "";
//$CONFIG->db['write']['dbpass'] = "";
//$CONFIG->db['write']['dbname'] = "";
//$CONFIG->db['write']['dbhost'] = "";
//$CONFIG->db['read'][0]['dbuser'] = "";
//$CONFIG->db['read'][0]['dbpass'] = "";
//$CONFIG->db['read'][0]['dbname'] = "";
//$CONFIG->db['read'][0]['dbhost'] = "";
//$CONFIG->db['read'][1]['dbuser'] = "";
//$CONFIG->db['read'][1]['dbpass'] = "";
//$CONFIG->db['read'][1]['dbname'] = "";
//$CONFIG->db['read'][1]['dbhost'] = "";
* @global bool $CONFIG->db_disable_query_cache
$CONFIG->db_disable_query_cache = false;
(sanitizing passwd & dbname )
Any help / pointers ... please ??