I was playing around with the view I created to for addressbook. If I
create the view such that there are no records:
inventory=> select * from sogoaddress;
c_cn | c_name | c_uid | cn | givenname | sn | title | department |
homephone | mobile | telephonenumber | fax | streetaddress | locality |
st | zip | countryname | birthdate | mail
------+--------+-------+----+-----------+----+-------+------------+-----------+--------+-----------------+-----+---------------+----------+----+-----+-------------+-----------+------
(0 rows)
Then I don't see any errors in SOGO, but when I try to access the
addressbook, sogo locks up using 100% CPU. This is on 1.3.4. I'm
guessing I'm doing something dumb. Is anyone else using sql as an
addressbook (not authentication and addressbook)? Could you send me that
part of the .GNUStepDefaults file? Any place else to look -- seems like
a simple sql query returning zero rows shouldn't thrash SOGo.
Thanks,
Ben
On 1/4/2011 9:33 PM, Ben wrote:
I'm trying to create an sql addressbook. I think I did everything right, but I
can't see anything in the web interface when I search, and in the sogo logs I
get:
EXCEPTION:<NSException: 0xf95040> NAME:NSInvalidArgumentException
REASON:Number of objects does not match the number of keys. INFO:(nil)
And then sogo restarts.
I think I've got the view set up right. Here's the column names:
c_cn | cn | givenname | sn | title | department | homephone | mobile |
telephonenumber | fax | streetaddress | locality | st | zip | countryname |
birthdate | mail |
The relevant section in .GNUStepDaults / SOGoUserSources is:
{
type=sql;
id="SQL DIR";
viewURL =
"postgresql://sogo:passw...@localhost:5432/sogo/sogoaddress";
canAuthenticate = NO;
isAddressBook = YES;
}
I'm using the same postgres username / password to login to postgres for sogo's
contacts, calendars, etc. It is a different table, but same username/password,
etc.
As a simple test, I created this view with only one record that uses no weird
characters or anything like that.
Any ideas what is wrong? (Debian Lenny with Postgres 8.4 (backports)
Thanks,
Ben
--
[email protected]
https://inverse.ca/sogo/lists
