Unable to connect to your database server using the provided settings.

A Database Error Occurred

Unable to connect to your database server using the provided settings.
Filename: core/Loader.php
Line Number: 346

mysql> use openaudit;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A


Database changed

mysql> show grants;

+---------------------------------------------------------------------+

 Grants for root@localhost                                           |

+---------------------------------------------------------------------+

| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |

| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION        |

+---------------------------------------------------------------------+

2 rows in set (0.00 sec)


mysql> show grants for 'opexport'@'localhost';

ERROR 1141 (42000): There is no such grant defined for user 'opexport' on host 'localh
ost'

mysql> show grants for 'openaudit'@'localhost';
ERROR 1141 (42000): There is no such grant defined for user 'openaudit' on host 'localhost'
mysql> select host, user, authentication_string from mysql.user;
+-----------+-----------+-------------------------------------------+
| host      | user      | authentication_string                     |
+-----------+-----------+-------------------------------------------+
| localhost | root      | *XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX |
| localhost | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
+-----------+-----------+-------------------------------------------+
2 rows in set (0.00 sec)
mysql> 

rm -rf /usr/local/open-audit
rm -rf /var/www/html/open-audit
rm -rf /var/www/open-audit
rm -rf /var/lib/mysql

2 answers

1.  

   2

   1

   0

   • Mark Unwin
   • Mar 10, 2016

   Hi,

   The install script should create the database and user for you. The commands it runs are:

   mysql -u root -e "CREATE DATABASE openaudit;"
    
   mysql -u root -e "CREATE USER openaudit@localhost IDENTIFIED BY 'openauditpassword';"
   
   mysql -u root -e "GRANT ALL PRIVILEGES ON openaudit.* TO openaudit@localhost IDENTIFIED BY 'openauditpassword'; FLUSH PRIVILEGES;"
    
   mysql -u root openaudit -e "source /usr/local/open-audit/other/openaudit_mysql.sql"

   You can run the manually if need be.

   •  Comment

   1. andguent

      • Mar 10, 2016

      Well, this might explain it. Thanks for your help, but I think Mysql 5.7.10 may have changed too much for your installer. {code} Server version: 5.7.10 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE USER openaudit@localhost IDENTIFIED BY 'openauditpassword'; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements mysql> {code} I had to change 'openauditpassword' to something more complicated before mysql would allow it.

   2. andguent

      • Mar 10, 2016

      Also, for completeness sake, your commands above need a "use openaudit;" prior to the source line.

   3. andguent

      • Mar 10, 2016

      Wait wait wait, nevermind. I was copy-pasting between the quotes so I only had to login once. I bet if I wasn't too lazy to type my root sql password four times the source line would have worked.

   4. Mark Unwin

      • Mar 10, 2016

      Thanks for the response. We'll investigate MySQL 5.7 on RHEL 6.7 ASAP.

   CommentAdd your comment...
2.  

   1

   0

   -1

   • grossman
   • Apr 01, 2016

   Hi.

   I have the same problem.

   I tryed to log as openaudit with mysql console, and it work. But if I echoed the $params variable in Loader.php script, the var is empty. So I think there is the problem.

   •  Comment

   1. Mark Unwin

      • Apr 04, 2016

      This issue is related to MySQL on RedHat not accepting our password. Your database credentials are set in /usr/local/open-audit/code_igniter/application/config/database.php If these are the same that you're using on the console - and the console works (as you said it does), please open a new Question instead of adding to this one. If they're not the same, feel free to change them.

   CommentAdd your comment...