Elgg Installation Error

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:

exception:title

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

  • 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 ??

    1. Check your server logs
    2. Try to edit this:
    //$CONFIG->dbhost = '127.0.0.1';
    
    $CONFIG->dbhost = 'localhost';