Chocobozzz / OpenVPN-Admin

Install and administrate OpenVPN with a web interface (logs visualisations, users managing...)
GNU Affero General Public License v3.0
947 stars 368 forks source link

Error creating tables DB (good login credentials) #99

Open berekese opened 6 years ago

berekese commented 6 years ago

[Wed Apr 11 13:32:53.339213 2018] [php7:error] [pid 18051] [client 192.168.100.73:44228] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'openvpn-admin.admin' doesn't exist in /var/www/html/openvpn-admin/index.php:76\nStack trace:\n#0 /var/www/html/openvpn-admin/index.php(76): PDOStatement->execute(Array)\n#1 {main}\n thrown in /var/www/html/openvpn-admin/index.php on line 76, referer: http://192.168.100.144/openvpn-admin/index.php?admin

However in ./include/config.php details are right and I can connect. Database openvpn-admin is empty.

# mysql -uroot -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 53
Server version: 10.1.29-MariaDB-6 Debian buildd-unstable
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| openvpn-admin      |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> use openvpn-admin;
Database changed
MariaDB [openvpn-admin]> show tables;
Empty set (0.00 sec)

MariaDB [openvpn-admin]> quit
Bye

I haven't root password Mysql, is the cause?

Thanks.

Chocobozzz commented 6 years ago

Maybe similar to https://github.com/Chocobozzz/OpenVPN-Admin/issues/60?