On 07/01/2010 07:17 AM, Jason Oster wrote:
My pg_hba.conf is attached.# dpkg-query -f '${Version}\n' -W postgresql 8.4.4-0ubuntu10.04 Same version.
Here's some news, attempting to debug this:I found a "solution" to the Postgresql connection problem. I had to change my SOGoProfileURL to drop the table name (?!):
# defaults write sogod SOGoProfileURL 'postgresql://sogo:s...@localhost:5432/sogo' # defaults write sogod OCSFolderInfoURL 'postgresql://sogo:s...@localhost:5432/sogo/sogo_folder_info'
The old value for SOGoProfileURL was: 'postgresql://sogo:s...@localhost:5432/sogo/sogo_user_profile'
After making this change, restarting SOGo, it dumps the following into sogo.log:
2010-07-01 09:25:38.838 sogod[3860] <0x0x21854f0[PostgreSQL72Channel]: connection=<0x0x2132010[PGConnection]: connection=0x0x2133500>>: message: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sogo_pkey" for table "sogo"
Jul 01 09:25:38 sogod: SOGo watchdog [3860]: |SOGo| table 'sogo' successfully created! 2010-07-01 09:25:38.932 sogod[3860] <0x0x21854f0[PostgreSQL72Channel]: connection=<0x0x2132010[PGConnection]: connection=0x0x2133500>>: message: NOTICE: CREATE TABLE will create implicit sequence "sogo_folder_info_c_folder_id_seq" for serial column "sogo_folder_info.c_folder_id"
2010-07-01 09:25:38.983 sogod[3860] <0x0x21854f0[PostgreSQL72Channel]: connection=<0x0x2132010[PGConnection]: connection=0x0x2133500>>: message: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "sogo_folder_info_pkey" for table "sogo_folder_info"
Jul 01 09:25:39 sogod: SOGo watchdog [3860]: |SOGo| table 'sogo_folder_info' successfully created!
?! Checking the tables in my 'sogo' database: # psql -d sogo -U sogo Password for user sogo: psql (8.4.4) Type "help" for help. sogo=> \dt List of relations Schema | Name | Type | Owner --------+------------------+-------+------- public | sogo | table | sogo public | sogo_folder_info | table | sogo (2 rows) Wow, it really did create a table named 'sogo' in the database named 'sogo'.So I attempt to access http://localhost/SOGo and I still get the same message in the browser:
the called object returned no result And sogo.log has some new information:Jul 01 09:25:58 sogod: SOGo watchdog [3860]: <0x0x19aa810[SOGoCache]> Cache cleanup interval set every 300.000000 seconds Jul 01 09:25:58 sogod: SOGo watchdog [3860]: <0x0x19aa810[SOGoCache]> Using host(s) 'localhost' as server(s) 2010-07-01 09:25:58.118 sogod[3860] Note(SoObject): SoDebugKeyLookup is enabled! 2010-07-01 09:25:58.118 sogod[3860] Note(SoObject): SoDebugBaseURL is enabled! 2010-07-01 09:25:58.118 sogod[3860] Note(SoObject): relative base URLs are enabled. Jul 01 09:25:58 sogod: SOGo watchdog [3860]: [ERROR] [object-handler] did not find dispatcher class ''SoObjectMethodDispatcher'; fallback' localhost - - [01/Jul/2010:09:25:58 GMT] "GET /SOGo/ HTTP/1.1" 500 36/0 0.007 - - 304K
Well, not "new" information, really. This is the same error message I've been getting since the upgrade to Ubuntu 10.04. I've hit another dead end.
<<attachment: jason_oster.vcf>>
-- users@sogo.nu https://inverse.ca/sogo/lists