[SOGo] Can't login with sql authenciation using mysql, no errors in log file

2011-07-24 Thread Helge Kraak 
  

Hi all, 

after two days of unsuccessful attempts to get the SOGo
login to work I'd like to ask you for help. 

My OS is: CentOS 5.6. I
installed SOGo successfully so far. In the log file there are no errors
left from what I understand. Nevertheless I can't login using a user
name and password - stored in the sogo_view table - which are identical
to the imap mail account I want to access.  

My sogo_view table in my
mysql database has these columns: 

c_uid c_name c_password c_cn mail


I deactivated the firewall in case this could have any impact on the
database port. 

mysqld and of course sogod and httpd are running.


This is the log file consisting of 3 steps I executed: sogod start,
sogo website access in browser, one attempt to login 

Jul 25 02:26:03
sogod [10472]:  Terminating with signal 15
Jul 25 02:26:03 sogod
[10472]:  sending terminate signal to pid 10477
MySQL4 connection
dropped 0x0xa65e30 (channel=0x0xb0f2b0)
Jul 25 02:26:03 sogod [10472]: 
child 10477 exited
Jul 25 02:26:03 sogod [10472]:  all children exited.
We now terminate.
Jul 25 02:26:04 sogod [10614]: version 1.3.8 (build
r...@vizzini.inverse.ca 201107141607) -- starting
Jul 25 02:26:04 sogod
[10614]: vmem size check enabled: shutting down app when vmem > 384
MB
Jul 25 02:26:04 sogod [10614]:  SOGo products loaded from
'/usr/GNUstep/System/Library/SOGo':
Jul 25 02:26:04 sogod [10614]: 
Mailer.SOGo, Appointments.SOGo, MailPartViewers.SOGo,
AdministrationUI.SOGo, MailerUI.SOGo, SchedulerUI.SOGo, CommonUI.SOGo,
PreferencesUI.SOGo, Contacts.SOGo, MainUI.SOGo, ContactsUI.SOGo
Jul 25
02:26:04 sogod [10614]:  listening on *:2
Jul 25 02:26:04 sogod
[10614]:  watchdog process pid: 10614
Jul 25 02:26:04 sogod [10614]: 
watchdog request timeout set to 10 minutes
Jul 25 02:26:04 sogod
[10614]:  preparing 1 children
Jul 25 02:26:04 sogod [10614]:  child
spawned with pid 10619
2011-07-25 02:26:04.612 sogod[10619] MySQL4
connection established 0x0xa65e30
2011-07-25 02:26:04.612 sogod[10619]
MySQL4 channel 0x0xb0f2b0 opened (connection=0x0xa65e30,sogo)
2011-07-25
02:26:04.612 sogod[10619]  SQL: SELECT count(*) FROM
sogo_user_profile;
2011-07-25 02:26:04.613 sogod[10619]  query has
results, entering fetch-mode.
2011-07-25 02:26:04.613 sogod[10619]  SQL:
SELECT count(*) FROM sogo_folder_info;
2011-07-25 02:26:04.613
sogod[10619]  query has results, entering fetch-mode.
2011-07-25
02:26:04.614 sogod[10619]  SQL: SELECT count(*) FROM
sogo_sessions_folder;
2011-07-25 02:26:04.615 sogod[10619]  query has
results, entering fetch-mode.

Jul 25 02:26:27 sogod [10619]: |SOGo|
starting method 'GET' on uri '/SOGo/'
Jul 25 02:26:27 sogod [10619]: 
Cache cleanup interval set every 300.00 seconds
Jul 25 02:26:27
sogod [10619]:  Using host(s) 'localhost' as server(s)
Jul 25 02:26:27
sogod [10619]: |SOGo| traverse(acquire): SOGo
Jul 25 02:26:27 sogod
[10619]: |SOGo| do traverse name: 'SOGo'
2011-07-25 02:26:27.698
sogod[10619] Note(SoObject): SoDebugKeyLookup is enabled!
2011-07-25
02:26:27.698 sogod[10619] Note(SoObject): SoDebugBaseURL is
enabled!
2011-07-25 02:26:27.698 sogod[10619] Note(SoObject): relative
base URLs are enabled.
Jul 25 02:26:27 sogod [10619]: D validate object:

Jul 25 02:26:27 sogod [10619]: D object is public.
Jul 25 02:26:27
sogod [10619]: D validate key SOGo of object: 
Jul 25 02:26:27 sogod
[10619]: D found no security info for key (class SOGo): SOGo
Jul 25
02:26:27 sogod [10619]: D default is allow ...
Jul 25 02:26:27 sogod
[10619]: |SOGo| set clientObject: 
2011-07-25 02:26:27.699 sogod[10619] 
SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid =
'anonymous';
2011-07-25 02:26:27.699 sogod[10619]  query has results,
entering fetch-mode.
2011-07-25 02:26:27.713 sogod[10619]
WOCompoundElement: pool embedding is on.
2011-07-25 02:26:27.713
sogod[10619] WOCompoundElement: id logging is on.
2011-07-25
02:26:27.728 sogod[10619] WARNING(-[NSNull(misc) count]): called NSNull
-count (returns 0) !!!
Jul 25 02:26:27 sogod [10619]: |SOGo| request
took 0.045303 seconds to execute

Jul 25 02:26:27 sogod [10619]: 
Zipping of response disabled
92.193.5.230 - - [25/Jul/2011:02:26:27 GMT]
"GET /SOGo/ HTTP/1.1" 200 10719/0 0.047 - - 3M
Jul 25 02:29:48 sogod
[10619]: |SOGo| starting method 'POST' on uri '/SOGo/connect'
Jul 25
02:29:48 sogod [10619]: |SOGo| traverse(acquire): SOGo => connect
Jul 25
02:29:48 sogod [10619]: |SOGo| do traverse name: 'SOGo'
Jul 25 02:29:48
sogod [10619]: D validate object: 
Jul 25 02:29:48 sogod [10619]: D
object is public.
Jul 25 02:29:48 sogod [10619]: D validate key SOGo of
object: 
Jul 25 02:29:48 sogod [10619]: D found no security info for key
(class SOGo): SOGo
Jul 25 02:29:48 sogod [10619]: D default is allow
...
Jul 25 02:29:48 sogod [10619]: |SOGo| do traverse name:
'connect'
Jul 25 02:29:48 sogod [10619]: D validate key connect of
object: 
Jul 25 02:29:48 sogod [10619]: D validate permission '' on
object: 
Jul 25 02:29:48 sogod [10619]: D successfully validated
permission ''.
Jul 25 02:29:48 sogod [1

Re: [SOGo] Proxy Error when opening Preferences under 1.3.7

2011-07-24 Thread Jean-Michel OLTRA 

Bonjour,


Le samedi 23 juillet 2011, Sven Slezák a écrit...


> sunny@forte:~$ telnet localhost 2000
> Trying 127.0.0.1...
> Connected to localhost.
> Escape character is '^]'.
> "IMPLEMENTATION" "Cyrus timsieved v2.2.13"
> "SIEVE" "fileinto reject envelope encoded-character vacation subaddress 
> comparator-i;ascii-numeric relational regex imap4flags copy include body 
> variables enotify environment mailbox date"
> "SASL" "PLAIN"
> "STARTTLS"
> "NOTIFY" "mailto"
> "VERSION" "1.0"
> OK "Dovecot ready."

The last time I have seen this error, it was something relative to imap acl's.

It was solved when I added "acl imap_acl" to the "mail_plugins" line of
the "protocol imap" part in the dovecot.conf file.

-- 
jm

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

[SOGo] Funambol 8.0.7 - Connector 1.0.8 - Sogo 1.3.8a

2011-07-24 Thread Christian Holzberger 

Hello,

since i upgraded sogo to 1.3.8a i cant login to my funambol server, i 
only get back "invalid credentials". i'm using a multi-domain 
configuration on sogo side.


The funambol ds-server log says: 

[2011-07-24 16:15:10,241] [funambol.transport.http] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [] [] [] Handling 
incoming request
[2011-07-24 16:15:10,241] [funambol.transport.http] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [] [] [] Request URL: 
http://sogo.xxx.de/funambol/ds
[2011-07-24 16:15:10,241] [funambol.transport.http] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [] [] [] Requested 
sessionId: null
[2011-07-24 16:15:10,514] [funambol.handler] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [fac-354692047212549] 
[] [] User not authenticated
[2011-07-24 16:15:10,514] [funambol.handler] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [fac-354692047212549] 
[] [] Authentication failed for device fac-354692047212549. Make sure 
that the client used correct username and password and that there is a 
principal associating the user  to the device.
[2011-07-24 16:15:10,514] [funambol.handler] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [fac-354692047212549] 
[] [] moving to state: STATE_PKG1_RECEIVING
[2011-07-24 16:15:10,572] [funambol.handler] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [fac-354692047212549] 
[] [] moving to state: STATE_START
[2011-07-24 16:15:10,575] [funambol.transport.http] [INFO] 
[D69C0FC11C1D9CDBEF76CE3EC3EC55AF] [80.81.243.26] [fac-354692047212549] 
[] [] Request processed.


I notice that Funambol doesn't event create the user from sogo when i 
try to login.


is the funambol-connector incompatible with this new version?

Mit freundlichen Grüßen
*Christian Holzberger*
(Inhaber)

--
MOSAIK Software   -   Inhaber: Christian Holzberger
Tel.: 0571 / 730 71 46   -   Fax: 0571 / 730 71 46 9

Dankerser Str. 20
32423 Minden

AGB    - Fernwartung 
   - 
Preisliste 


Steuernummer: 335/5091/1890-Ust. ID.: DE257761637

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