Re: [SOGo] sogo fails to start

[Nigel Pegram]

I remembered I had changed one item in the setup file, so upon reverting 
that, and enabling more debugging options the logs display:


version 2.3.2 (build @shiva.inverse 201509161658) -- starting
vmem size check enabled: shutting down app when vmem > 384 MB
<0x0x7f3e9ebac288[SOGoProductLoader]> SOGo products loaded from 
'/usr/lib/GNUstep/SOGo':
<0x0x7f3e9ebac288[SOGoProductLoader]>   Appointments.SOGo, 
CommonUI.SOGo, MailPartViewers.SOGo, MailerUI.SOGo, ContactsUI.SOGo, 
PreferencesUI.SOGo, Contacts.S

OGo, MainUI.SOGo, SchedulerUI.SOGo, AdministrationUI.SOGo, Mailer.SOGo
2015-11-09 12:25:29.916 sogod[3115] WOContext.m:85  Assertion failed in 
WOContext(instance), method initialize.  Couldn't instantiate 
WOContextClass ((null))!
/usr/sbin/sogod: Uncaught exception NSInternalInconsistencyException, 
reason: WOContext.m:85  Assertion failed in WOContext(instance), method 
initialize.  Cou

ldn't instantiate WOContextClass ((null))!

TIA
Nigel

On 09/11/15 10:37, Nigel Pegram wrote:

Hi,

I have a previously working sogo install which following an upgrade 
now fails to start.


It displays the error message: sogod[26952] File NSData.m: 163. In 
readContentsOfFile Open ((null)) attempt failed - bad path


I'm unsure how to debug this. Any pointers appreciated.

TIA
Nigel


--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo fails to start

[Nigel Pegram]

Removal and reinstallation of sogo fixed problem.

Thanks anyway.

On 09/11/15 10:37, Nigel Pegram wrote:

Hi,

I have a previously working sogo install which following an upgrade 
now fails to start.


It displays the error message: sogod[26952] File NSData.m: 163. In 
readContentsOfFile Open ((null)) attempt failed - bad path


I'm unsure how to debug this. Any pointers appreciated.

TIA
Nigel


--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] sogo fails to start

[Nigel Pegram]

Hi,

I have a previously working sogo install which following an upgrade now 
fails to start.


It displays the error message: sogod[26952] File NSData.m: 163. In 
readContentsOfFile Open ((null)) attempt failed - bad path


I'm unsure how to debug this. Any pointers appreciated.

TIA
Nigel
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Some contacts not synched with Thunderbird

[Nigel Pegram]

Hi,

SOGo is working fine, web interface perfect. Thunderbird integration
working, apart from one error.

Some contacts are not being synced to the Thunderbird address book. It
looks like the cause is contact records which have a Display Name, but
no first or last names.

I don't know how the user has created these records, but they obviously
have been able to.

So, if SOGo allows records like this to be entered, why can't it
synchronise them? If there is a good reason, then why doesn't SOGo block
entry of such records (validate the data)? If validation like this is
not able to be enforced then perhaps we need a work around in the back
end to avoid these records "disappearing", e.g. a work around which
enters something in the required fields so they sync.

Also, is there an easy way to find these records and update them? If
nothing else we could do a quick correction by copying the display name
to the first or last name field as-is. How, though? The data is in a
mySQL database. I can program an SQL query, but I'd need to know how to
find the records (in which tables they are). Is there a better way?
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] broken subscription to icalendar

[Nigel Pegram]

bump

On 02/03/15 09:44, Nigel Pegram wrote:
> Hello,
>
> Recently a subscription to an icalendar account has stopped working,
> both in the web interface and in Thunderbird.
>
> When copying the URL into a web browser the calendar file seems to
> download correctly.
>
> The Thunderbird error console shows:
>
> [JavaScript Warning: "There has been an error reading data for calendar:
> xxx.  However, this error is believed to be minor, so the
> program will attempt to continue. Error code: READ_FAILED. Description: "]
>
> When I have tried to recreate the calendar in the web interface I
> receive a message saying "An error occurred which importing calendar"
> and the operation fails.
>
> The server log has:
>
> Mar 02 09:42:11 sogod [2068]: 124.148.76.77 "POST
> /SOGo/so/bruce/Calendar/addWebCalendar HTTP/1.1" 400 190/126 0.004 - - 12K
>
> The URL is being copied and pasted directly from the iCloud sharing
> information dialog.
>
> Any suggestions for debugging this?
>
> TIA
> Nigel

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] broken subscription to icalendar

[Nigel Pegram]

Hello,

Recently a subscription to an icalendar account has stopped working,
both in the web interface and in Thunderbird.

When copying the URL into a web browser the calendar file seems to
download correctly.

The Thunderbird error console shows:

[JavaScript Warning: "There has been an error reading data for calendar:
xxx.  However, this error is believed to be minor, so the
program will attempt to continue. Error code: READ_FAILED. Description: "]

When I have tried to recreate the calendar in the web interface I
receive a message saying "An error occurred which importing calendar"
and the operation fails.

The server log has:

Mar 02 09:42:11 sogod [2068]: 124.148.76.77 "POST
/SOGo/so/bruce/Calendar/addWebCalendar HTTP/1.1" 400 190/126 0.004 - - 12K

The URL is being copied and pasted directly from the iCloud sharing
information dialog.

Any suggestions for debugging this?

TIA
Nigel
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Direct Login by transmitting credentials

[Nigel Pegram]

Hi,

A quick look at the HTML shows it to be a form which posts to /SOGo/connect

I'd be looking at AJAX/javascript on an intranet page to post
"userName", "password" and "language"to that URL and then load the
input. (I haven't tried it, just a thought.)

Nigel

On 20/03/14 16:13, u...@rumlikon.ch wrote:
> Hi everybody
>
> I was wondering if it is possible to login to sogo directly by transfering the
> credentials via URL (or any other way).
>
> We use sogo as part of our intranet and the intranet knows the credentials of
> the logged in user and could transfert it.
> This would be more convenient for our users.
>
> Exmaple: user1:passwo...@sogo.meidomain.com
>
> Any idea?
>
> Thanks
> Ueli

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Best Mobile/Tablet OS for SOGo

[Nigel Pegram]

Hi,

I use both iOS and Android.

While both work well, I've found the native support in iOS causes fewer
challenges.

I personally use Android since the document handling in iOS did not fit
well with my work practices. If you can live with that, I'd happy
suggest iOS.

Nigel

On 11/03/14 23:24, Sven Schwedas wrote:
> Hi,
>
> On 2014-03-11 15:45, ianjamesv...@icefire.eu wrote:
>> The options appear to be:
>>
>> iOS (Apple)
>> Android (Google)
>> Windows Phone 8 (Microsoft)
>> BlackBerry 10 (BlackBerry)
> Fwiw, FirefoxOS doesn't currently support CardDAV, but might in the
> reasonable future.
>
>> My gut feeling is that Android is likely to be the most straightforward to
>> adapt if changes are needed, as the other three are more locked down. 
>> However,
>> I want to get feedback from users of SOGo and mobile devices (mainly phones,
>> but also tablets) before I make a decision.
> We've been using both Android and iOS for months. While OSX is a royal
> pain and essentially broken, iOS (6 and 7) seem to work fine and didn't
> cause more problems than Android.
>
> iOS supports Cal/CardDAV natively, Android needs external Cal/CardDAV
> providers that cost around $7 per user, if that's an issue for you.
> Also, said providers are somewhat broken on HTC phones, thanks to HTC
> breaking core Android libraries [1], so you might want to stay away from
> them (we're using Google Nexus devices ever since).
>
> [1] http://dmfs.org/wiki/index.php?title=HTC_Sense_issue
>
>> Thanks,
>>
>> Ian
>>

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Search entire mailstore from the GUI?

[Nigel Pegram]

Is the web GUI a must? Thunderbird has this capability.

Nigel

On 11/03/14 22:33, Charles Marcus wrote:
> Hi all,
>
> I don't think SOGo has this capability, but hopefully I'm wrong.
>
> Is there a way to search, or even browse, the entire mailstore backend
> using the SOGo web GUI?
>
> My boss has asked me to look into a way for him, or someone he
> designates, to be able to search for keywords across the entire
> mailstore. I've explained about archiving tools, but he would prefer
> something that I can install myself and doesn't cost an arm and a leg...
>

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] mail aliases for calendar

[Nigel Pegram]

Excellent, thanks for the detailed explanation.

Nigel

On 24/02/14 22:13, Christian Mack wrote:
> Hello Nigel Pegram
>
>
> ABBAS Alain is right, if your user bob has an email address of
> b...@somewhere.com AND an alias of i...@somewhere.com, then they should
> both be in the LDAP for user bob.
>
>
> But if you forward i...@somewhere.com to bob (and some other users) you
> can delegate use of i...@somewhere.com to bob (and the other users).
> In the SOGo Webfrontend you can do that by logging in as user "it".
> Then in "Mail" right click on "i...@somewhere.com" in the folder tree.
> Choose "Delegation...".
> It will open a window, where you can press the "Add" button.
> Another window opens, where you can search for bob.
> Select bob and press "Add" button on the bottom.
> Now close both windows again.
>
> When bob now logs in to SOGo, he can use "i...@somewhere.com" as sender in
> any email, and he can accept invitations for "i...@somewhere.com".
>
>
> Kind regards,
> Christian Mack
>
> Am 2014-02-24 09:56, schrieb Nigel Pegram:
>> Thanks for the response, but I don't think were talking about the same
>> thing. As I understand your reply, you're referring to referencing a
>> different data field for email address information.
>>
>> My issue revolves around the person having more than one external email
>> address: e.g. you can contact them on b...@somewhere.com and on
>> i...@somewhere.com. An email to either address ends up in bob's inbox. The
>> challenge is that if sogo is set up so that the calendar is for
>> b...@somewhere.com, then meeting invitations sent to i...@somewhere.com do
>> not work.
>>
>>
>> On 23/02/14 01:18, ABBAS Alain wrote:
>>> you must have in your sogo configuration file :
>>> MailFieldNames =(mail,alias);
>>> with all fields who could contain an email adress of the user
>>>
>>>
>>>
>>> Le Samedi 22 Février 2014 03:35 CET, Nigel Pegram 
>>> a écrit:
>>>  
>>>> Hello,
>>>>
>>>> At one of the sites where I have installed SOGo, I encountered a
>>>> hiccough when one team member created an appointment inviting others.
>>>>
>>>> The recipient team member has multiple email addresses, so they received
>>>> on a different account than the one which is connected to their
>>>> calendar. Yet, since their mail is received/collected by a central
>>>> server, it all ends up at the one account.
>>>>
>>>> The recipient was unable to accept the appointment. The error message
>>>> was not helpful.
>>>>
>>>> It occurred to me that a solution may be a setting which allows ema il
>>>> aliases to be recorded so that events processed using any of the listed
>>>> email accounts are placed in the primary email address's calendar.
>>>>
>>>> Is this possible?
>>>>
>>>> It seems a useful addition. I can't be the only person who is dealing
>>>> with clients who have multiple email addresses.
>>>>
>>>> Your thoughts?
>>>>
>>>> Nigel
>>>> --
>>>> users@sogo.nu
>>>> https://inverse.ca/sogo/lists
>>> --
>>> *Alain Abbas*
>>> 11 rue Robert Schumann
>>> 54500 Vandoeuvre
>>> Tel : +333 83 18 02 70
>>> skype: alain.abbas 
>

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] mail aliases for calendar

[Nigel Pegram]

Hello,

Thanks for the response, but I don't think were talking about the same
thing. As I understand your reply, you're referring to referencing a
different data field for email address information.

My issue revolves around the person having more than one external email
address: e.g. you can contact them on b...@somewhere.com and on
i...@somewhere.com. An email to either address ends up in bob's inbox. The
challenge is that if sogo is set up so that the calendar is for
b...@somewhere.com, then meeting invitations sent to i...@somewhere.com do
not work.

HTH
Nigel

On 23/02/14 01:18, ABBAS Alain wrote:
> HEllo
> you must have in your sogo configuration file :
> MailFieldNames =(mail,alias);
> with all fields who could contain an email adress of the user
>
> Regards
>
>
>
> Le Samedi 22 Février 2014 03:35 CET, Nigel Pegram 
> a écrit:
>  
>> Hello,
>>
>> At one of the sites where I have installed SOGo, I encountered a
>> hiccough when one team member created an appointment inviting others.
>>
>> The recipient team member has multiple email addresses, so they received
>> on a different account than the one which is connected to their
>> calendar. Yet, since their mail is received/collected by a central
>> server, it all ends up at the one account.
>>
>> The recipient was unable to accept the appointment. The error message
>> was not helpful.
>>
>> It occurred to me that a solution may be a setting which allows ema il
>> aliases to be recorded so that events processed using any of the listed
>> email accounts are placed in the primary email address's calendar.
>>
>> Is this possible?
>>
>> It seems a useful addition. I can't be the only person who is dealing
>> with clients who have multiple email addresses.
>>
>> Your thoughts?
>>
>> Nigel
>> --
>> users@sogo.nu
>> https://inverse.ca/sogo/lists
>
> --
> *Alain Abbas*
> 11 rue Robert Schumann
> 54500 Vandoeuvre
> Tel : +333 83 18 02 70
> skype: alain.abbas 

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] mail aliases for calendar

[Nigel Pegram]

Hello,

At one of the sites where I have installed SOGo, I encountered a
hiccough when one team member created an appointment inviting others.

The recipient team member has multiple email addresses, so they received
on a different account than the one which is connected to their
calendar. Yet, since their mail is received/collected by a central
server, it all ends up at the one account.

The recipient was unable to accept the appointment. The error message
was not helpful.

It occurred to me that a solution may be a setting which allows email
aliases to be recorded so that events processed using any of the listed
email accounts are placed in the primary email address's calendar.

Is this possible?

It seems a useful addition. I can't be the only person who is dealing
with clients who have multiple email addresses.

Your thoughts?

Nigel
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] create task not in my own calendar

[Nigel Pegram]

Hello,

Yes, you do need to grant permissions for other to view or alter others'
calendars.

Try right clicking on the calendar, then select sharing from the menu.

Regards,
Nigel

On 11/02/14 20:46, Systeembeheer wrote:
>
> Hello,
>
> As we are in the process of migrating from Exchange to SOGo I want to
> know the following:
>
> The receptionist must be able to plan a task for the technical department.
>
> I am now using the latest ZEG version of SOGo. We use the webinterface
> with firefox on Debian 7.3.
>
> I got as far as being able to see the tasklist from sogo2 user in the
> window from sogo1 user.
>
> But when I create a task I am only able to select the personal
> calender from the user himself not from the other.
>
> I know in Exchange you have to give permission to be able to do this
> but I do not know if this is nessesary in SOGo and
>
> cannot find where and how in SOGo.
>
>  
>
> Can anyone shed some light on this?
>
>  
>
>  
>
> Kind regards,
>
>  
>
> Systemmanagement
>
> W. Krelekamp
>
>  
>
> systeembeh...@obg.nu 
>
>  
>
>  
>
>  
>

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] SOGo Integrator and New Calendar in Thunderbird

[Nigel Pegram]

Hello everyone,

I have TB 17.0.4 (Ubuntu) and SOGo working together, using Lightning,
Connector and Integrator.

If I create calendars via the web interface, they automatically appear
in TB—all very good :-)

However, the reverse doesn't seem to work. Creating a calendar in TB "On
My Computer" results in a local file store, not a SOGo calendar.

It may be my expectations, but if SOGo is /integrated/ with TB, then
when I create a calendar in TB, I had expected it to be created in SOGo.

Is this a current limitation?

I can ask my users to create using the web interface, but it's a missing
feature, then, IMHO. It would be very user friendly to create calendars
in TB directly into SOGo, either by default or as an additional option.

Cheers
Nigel
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Outlook calendar and contacts work, mail fails

[Nigel Pegram]

Hello again,

I've tried sorting this out, but when I've added the suggested settings
to dovecot it causes IMAP logins to fail.

My guess is the passing comment about limiting the changed permissions
to the sogo process, but I've no idea how to do that. I tried adding
user=sogo and uid= but it didn't seem to work.

Could someone provide an example of how they've done that in dovecot please?

TIA
Nigel

On 11/03/13 00:40, Jean Raby wrote:
> On 13-03-10 9:02 AM, Nigel Pegram wrote:
>> Hello everyone,
>>
>> I have a working sogo installation. Everything seems to work as expected
>> from the web interface, including mail.
>>
>> However, when connecting using outlook, I am able to read and write to
>> the calendar and contacts, but nothing happens with the mail. The
>> folders and messages are not loaded from the server, nor is a created
>> folder replicated to the server.
>>
>> System is a clean install of Ubuntu 12.04. Imap is provided by dovecot.
>> Sogo 2.0.4b
>>
>> The following from the logs seems to be where the problem is, but I
>> don't know how to solve it.
>>
>> Mar 10 20:43:33 sogod [1491]: [ERROR]
>> <0x0xb94a3f78[NGImap4ConnectionManager]> IMAP4 login failed:
>>host=mailserver, user=nigel, pwd=no
>>url=imap://nigel@mailserver/
>>base=(null)
>>base-class=(null))
> Exactly, please see the documentation regarding the trust between the
> imap server and sogo. (or the password files)
> http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf
> (p7 and p14)
>>
>>
>> TIA
>> Nigel
>>
>
>

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Outlook calendar and contacts work, mail fails

[Nigel Pegram]

Thanks for your reply Jean,

I did include the dovecot settings as suggested on page 7. It may be
complicated by the fact that the SOGO server is on one machine and
dovecot on another.

I'll revise the dovecot docs and get back to you.

Regards,
Nigel

On 11/03/13 00:40, Jean Raby wrote:
> On 13-03-10 9:02 AM, Nigel Pegram wrote:
>> Hello everyone,
>>
>> I have a working sogo installation. Everything seems to work as expected
>> from the web interface, including mail.
>>
>> However, when connecting using outlook, I am able to read and write to
>> the calendar and contacts, but nothing happens with the mail. The
>> folders and messages are not loaded from the server, nor is a created
>> folder replicated to the server.
>>
>> System is a clean install of Ubuntu 12.04. Imap is provided by dovecot.
>> Sogo 2.0.4b
>>
>> The following from the logs seems to be where the problem is, but I
>> don't know how to solve it.
>>
>> Mar 10 20:43:33 sogod [1491]: [ERROR]
>> <0x0xb94a3f78[NGImap4ConnectionManager]> IMAP4 login failed:
>>host=mailserver, user=nigel, pwd=no
>>url=imap://nigel@mailserver/
>>base=(null)
>>base-class=(null))
> Exactly, please see the documentation regarding the trust between the
> imap server and sogo. (or the password files)
> http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf
> (p7 and p14)
>>
>>
>> TIA
>> Nigel
>>
>
>

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Outlook calendar and contacts work, mail fails

[Nigel Pegram]

Hello everyone,

I have a working sogo installation. Everything seems to work as expected
from the web interface, including mail.

However, when connecting using outlook, I am able to read and write to
the calendar and contacts, but nothing happens with the mail. The
folders and messages are not loaded from the server, nor is a created
folder replicated to the server.

System is a clean install of Ubuntu 12.04. Imap is provided by dovecot.
Sogo 2.0.4b

The following from the logs seems to be where the problem is, but I
don't know how to solve it.

Mar 10 20:43:33 sogod [1491]: [ERROR]
<0x0xb94a3f78[NGImap4ConnectionManager]> IMAP4 login failed:
  host=mailserver, user=nigel, pwd=no
  url=imap://nigel@mailserver/
  base=(null)
  base-class=(null))


TIA
Nigel
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo Domain for Microsoft Setup

[Nigel Pegram]

See p. 15 of the manual. You need both sogo. and
autodiscover.
set in your DNS/hosts file.

HTH
Nigel

Sent from my iPad

Intelligent Organisations
Building leaders, teams and organisations.

Nigel Pegram
Phone +61 4 3170 3410
90 Weston St, Maddington WA 6109, Australia
ABN 78975593881

On 29/09/2012, at 12:29 AM, Devinder Singh  wrote:

 Any feedback for me ?  Any idea where I might be going wrong ?

Thanks & Regards,
Devinder Singh Birdi

On 9/28/2012 6:28 PM, Devinder Singh wrote:

 Hi ,

I get the error as attached when I enter the MS Exchange Server as
sogo.qlc.net and user -  devinder

I can access the SOG0 domain via  http://sogo.qlc.net/SOGo .

Any idea what could be the value to be passed to Microsoft Exchange Server
and where can I find it ?

Thanks & Regards,
Devinder Singh Birdi

On 9/28/2012 1:29 AM, John Russell wrote:

Just curious, what linux distro/version are you using?

On Thu, Sep 27, 2012 at 10:59 AM, Devinder Singh wrote:

>  Hi All,
>
> I have been able to configure the entire SOGo setup for Microsoft Native
> Compatibility.
>
> I am stuck at the last step .* "Enter the DNS name or the IP address of
> your SOGo server in the Microsoft Exchange Server field** "*
>
> On my system right now, with any can run the SOGo due to the conf
> configuration as below.
>
> ProxyPass /SOGo http://127.0.0.1:2/SOGo retry=0
>
> by giving my IP no. as 192.168.1.185 does not work.
>
> Any idea what value can I add in that field ?
>
> Additionally,  what does autodiscover.example.com does ?  how would I
> configure it . Already ocsmanager.conf has the ProxyPass for the
> /autodiscovery.
>
> Kindly guide.
>
> --
> Thanks & Regards,
> Devinder Singh Birdi
>
>


-- 
"It's better to be boldly decisive and risk being wrong than to agonize at
length and be right too late."
Marilyn Moats Kennedy
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Cannot login following new install

[Nigel Pegram]

Thanks to Peter and Paul,

Installation of memcached and rpl packages fixed it.

Nigel
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Cannot login following new install

[Nigel Pegram]

Ok. I've made a little progress, starting again using the LJ article
settings, including reinstalling SOGo.

Now the DB log shows:

120210 10:26:0133608 Connectsogo@localhost on sogo
33608 QuerySET CHARACTER SET utf8
33608 QuerySELECT c_password FROM sogo_users WHERE c_uid =
'chris'
33608 QuerySELECT * FROM sogo_users WHERE (c_uid = 'chris')
OR (mail = 'chris')
33608 QuerySELECT c_settings FROM sogo_user_profile WHERE
c_uid = 'chris'

So we have things happening beyond the initial password lookup.

Now in the browser the URL changes from localhost/SOGo to
localhost/SOGo/

However, nothing new is displayed, the login page still appears. If the
wrong password is used, an error message appears, as expected.

There are no errors in the apache logs, just:

127.0.0.1 - - [10/Feb/2012:10:32:27 +0800] "GET /SOGo/chris HTTP/1.1"
200 4036 "http://localhost/SOGo/"; "Mozilla/5.0 (X11; Ubuntu; Linux
x86_64; rv:10.0) Gecko/20100101 Firefox/10.0"

TIA
Nigel
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Cannot login following new install

[Nigel Pegram]

Thank you Peter and Paul, I will look at them both.

Cheers
Nigel

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Cannot login following new install

[Nigel Pegram]

Hello everyone,

I have installed a new installation of sogo on Ubuntu 10.10. I have used
mysql as the data store.

I have the daemons running and am able to display the web page 
http://localhost/SOGo

My problem is that I cannot login. 

I have tried creating a couple of users in the sogo_view table and have tried
passwords in clear text, and md5. All the other tables are empty since
ths is my first login attempt.

It seems that the communication is happening between sogo and the database, but
something fails after the query. I don't know how to debug this any further.

Every time the logs give the same result: 

31415 Query SELECT c_password FROM sogo_view WHERE c_uid = 
'nigel'
120209 10:47:01 31417 Connect   sogo@localhost on sogo
31417 Query SET CHARACTER SET utf8
31417 Query BEGIN
31417 Query SELECT t1.c_alarm_number, t1.c_name, t1.c_path, 
t1.c_recurrence_id, t1.c_uid FROM  sogo_alarms_folder t1 WHERE t1.c_alarm_date
>= 1328755320 AND t1.c_alarm_date <= 1328755620
31417 Query ROLLBACK
31417 Query BEGIN
31417 Query DELETE FROM sogo_alarms_folder WHERE 
c_alarm_date <= 1328755620
31417 Query COMMIT

My configuration is below (with passwords changed).


http://www.gnustep.org/plist-0_9.xml";>


NSGlobalDomain


sogod

MySQL4DebugEnabled
yes
OCSEMailAlarmsFolderURL
   
mysql://sogo:password@localhost:3306/sogo/sogo_alarms_folder
OCSFolderInfoURL
   
mysql://sogo:password@localhost:3306/sogo/sogo_folder_info
OCSSessionsFolderURL
   
mysql://sogo:password@localhost:3306/sogo/sogo_sessions_folder
SOGoACLsSendEMailNotifications
YES
SOGoAppointmentSendEMailNotifications
YES
SOGoAppointmentSendEMailReceipts
YES
SOGoDraftsFolderName
Drafts
SOGoEnableEMailAlarms
YES
SOGoFoldersSendEMailNotifications
YES
SOGoIMAPServer
localhost:993
SOGoLanguage
English
SOGoMailComposeMessageType
html
SOGoMailDomain
pegram.homelinux.net
SOGoMailMessageCheck
every_10_minutes
SOGoMailReplyPlacement
above
SOGoMailSignaturePlacement
above
SOGoMailingMechanism
smtp
SOGoProfileURL
   
mysql://sogo:password@localhost:3306/sogo/sogo_user_profile
SOGoSMTPServer
localhost
SOGoSentFolderName
Sent
SOGoTimeZone
Australia/Perth
SOGoTrashFolderName
Trash
SOGoUserSources


canAuthenticate
YES
displayName
Pegram Address Book
id
directory
isAddressBook
YES
type
sql
userPasswordAlgorithm
md5
viewURL
   
mysql://sogo:password@localhost:3306/sogo/sogo_view


SoSecurityManagerDebugEnabled
yes




TIA
Nigel

-- 
users@sogo.nu
https://inverse.ca/sogo/lists