[horde] Database does not exist error - mysql

MJ Barber mbarber at barbersweb.net
Tue May 20 18:51:00 PDT 2003


I can connect to database from the command line.......
But, all else is futile it would seem....

Any help is greatly appreciated.


Config:
$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = 'mypasswordhere';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';



>From the webpage:
A fatal error has occurred:

DB Error: no such database

[line 108 of /var/www/html/horde/lib/Prefs/sql.php]

Details have been logged for the administrator.


Database access:
[root at boston config]# mysql -u horde -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 3.23.56

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
ERROR 1046: No Database Selected
mysql> use horde;
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 tables;
+------------------+
| Tables_in_horde  |
+------------------+
| horde_categories |
| horde_prefs      |
| horde_users      |
+------------------+
3 rows in set (0.01 sec)

mysql> 

Thanks,
Mike




More information about the horde mailing list