Hi,
Postgres is not officially supported yet and still under development. We implemented the PEAR::DB class in order to have the basics done for multiple database support but have not tested all SQL queries.
I have installed pgsql on my machine and will test it all over. Thanks for reporting!
Thomas
2005/11/3, Longinos Ferrando lofesa@gmail.com:
Hi all. I tried the RC from the latest CVS (3/11/2005 7:00am) with postgresql as backend database and I get some errors. If I use Firefox 1.0.7 I get the message : "Your browser does not accept cookies" and , off course, the browser has the cookies enabled. In MS Iexplorer: With $rcmail_config['enable_caching']='TRUE'; blank screen and in error log I get "/var/www/html/horde/program/include/rcube_db.inc on line 148", then I configure it to FALSE.
I tried with $rcmail_config['db_backend'] set to db When I try to send a mail w/o identities, I get a error message that says the message have not sender. Then I insert 1 contact, I get the error: DB Error in /var/www/html/horde/program/include/rcube_db.inc (189): DB Error: unknown error SERVICE CURRENTLY NOT AVAILABLE!
DB Error: unknown errorand get 2 contacts inserted, I eliminate 1 and then I can send the message. If I try to insert a new identity I get the same message but the record is inserted. If I try to insert a contact, I get the error: [03-Nov-2005 11:57:07 +0100] DB Error: DB Error: unknown error; QUERY: INSERT INTO contacts (user_id, name, firstname, surname, email) VALUES (?, 'aa', 'aa', 'aa', 'aa') in /var/www/html/horde/program/include/rcube_db.inc on line 148 [03-Nov-2005 11:57:07 +0100] DB Error: DB Error: unknown error in /var/www/html/horde/program/include/rcube_db.inc on line 189 and no contact are inserted.
With the MDB2: If I try ti delete a identity I get the message Fatal error: Call to undefined function: affectedrows() in /var/www/html/horde/program/include/rcube_mdb2.inc on line 189 and the identity is deleted. I I try to insert a contact I get the mesage: [03-Nov-2005 11:57:07 +0100] DB Error: DB Error: unknown error; QUERY: INSERT INTO contacts (user_id, name, firstname, surname, email) VALUES (?, 'aa', 'aa', 'aa', 'aa') in /var/www/html/horde/program/include/rcube_db.inc on line 148 [03-Nov-2005 11:57:07 +0100] DB Error: DB Error: unknown error in /var/www/html/horde/program/include/rcube_db.inc on line 189 and no contacs are added.
For other hand, I hope this project have exit. I don´t know well php , so I don´t create patches, but have the possibility of do some test with postgresql and oracle as databse and Courierr as imap server. Feel free to send patches, demand logs, the environ is for test purposing and have not problem to do or change server config, php config, etc... ... The system is RedHat 4 AS with php 4.3.9-38 from the redhat rpm´s.