[sork] DB Error: no darabse selected

Thomas Wagner t.wagner at icie.jku.at
Wed Jul 23 10:06:30 UTC 2008


Hi

I've installed horde-grouware-1.1.1 and added vacation-h3-3.0.1 and  
forwards-h3-3.0.1 successfully.
I've added databases for vacation and forwards, but when I try using one  
of these I get an error message and this entry in my logfile:

Jul 23 11:42:54 HORDE [error] [forwards] DB Error: no database selected:  
SELECT alarm_id, alarm_uid, alarm_start, alarm_end, alarm_methods,  
alarm_params, alarm_title, alarm_text, alarm_snooze, alarm_internal FROM  
horde_alarms WHERE alarm_dismissed = 0 AND ((alarm_snooze IS NULL AND  
alarm_start <= '') OR alarm_snooze <= '') AND (alarm_end IS NULL OR  
alarm_end >= '') AND (alarm_uid = '' OR alarm_uid = '') ORDER BY  
alarm_start, alarm_end [nativecode=**] [pid 4972 on line 303 of  
"/srv/www/htdocs/horde/lib/Horde/Alarm.php"]

Now I am not sure, if it is a problem with forwards (same with vacation)  
or with the Alarm.php

Here is my .horde/forwards/config/conf.php
---SNIP---
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: forwards/config/conf.xml,v 1.7 2005/04/13 18:06:16 chuck Exp $
$conf['server']['params']['default']['table'] = 'users';
$conf['server']['params']['default']['user_col'] = 'user';
$conf['server']['params']['default']['pass_col'] = 'password';
$conf['server']['params']['default']['altemail'] = 'altemail';
$conf['server']['params']['default']['forward'] = 'forward';
$conf['server']['params']['default']['driverconfig'] = 'horde';
$conf['server']['driver'] = 'sql';
$conf['enabled']['keeplocal'] = true;
$conf['enabled']['authenticate'] = true;
$conf['user']['refused'] = array('root', 'bin', 'daemon', 'adm', 'lp',  
'shutdown', 'halt', 'uucp', 'ftp', 'anonymous', 'nobody', 'httpd',  
'operator', 'guest', 'diginext', 'bind', 'cyrus', 'courier', 'games',  
'kmem', 'mailnull', 'man', 'mysql', 'news', 'postfix', 'sshd', 'tty',  
'www');
$conf['menu']['apps'] = array();
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
$conf['server']['params']['table'] = 'users';
$conf['server']['params']['default']['database'] = 'horde';
$conf['server']['params']['database'] = 'horde';
---SNAP---

I've added the last three lines by myself, but with or without these lines  
I recieve the error message listet above.
The table "user" exists within the database "horde" and is accessible.

Can anyone help me to get rid of the error message an make forwards an  
vacation work.

Regards

Thomas

-- 
Thomas Wagner
Institute for Communications and Information Engineering
University of Linz, 4040 Linz, Austria
mailto:t.wagner at icie.jku.at
http://www.icie.jku.at


More information about the sork mailing list