Re: [SOGo] SOGo not releasing tcp spockets?

2013-01-23 Thread John Bieling
Glad I could help, will this be fixed in 2.0.4? Or is it already fixed 
in the current codebase (git clone...)?


Thanks
John

Am 23.01.2013 00:50, schrieb Jean Raby:

On 13-01-18 1:41 PM, John Bieling wrote:

I investigated the problem further. I dumped the output of netstat
before and after I restarted sogo. Before the restart (running 12 h) I
had 280 conns (steadily increasing all day), after the restart I was
back to 40.

The diff shows that almost all of the persistent connections, which only
go away by restarting sogo are somehow *ldap* related: (VERBUNDEN =
ESTABLISHED):

 tcp0  0 localhost.localdom:ldap localhost.localdo:53381
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:51077
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:54146
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:34959
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:50318
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:51081
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:34964
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:36243
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:41362
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:36240
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:49309
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:56988
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:44452
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:44451
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:39330
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:49312
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:46261
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:47551
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:60351
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:41661
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:57017
VERBUNDEN
 tcp0  0 localhost.localdom:ldap localhost.localdo:46264
VERBUNDEN
...


These ldap conns are used to authenticate any sogo related http/webdav
request with the local ldap server, right? Why do they stay?

Is it possible to tell ldap to release these connections after a 
timeout?

Is it possible to switch to a socket-based-communictaion?


Thanks for pointing that out, there was a leak in the error path of 
the password checking code.


Now fixed: 
https://github.com/inverse-inc/sogo/commit/9e38c5060ab161704e86398475f36aca105d2404




Thanks for your time
John






On 01/17/2013 12:04 PM, John Bieling wrote:

My sogo installation is running on a virtuozo system (server4you.com)
and I have a limit of 1200 numtcpsock. If I sync my adressbook via
thunderbird, I can see via

cat /proc/user_beancounters

that the number of held numtcpsock is going up. But it is not going
down again, it just stays there. Now if my server runs for about a
day, I reach the limit, which will disconnect my server from the
outside, since no new connections can be established.

Before reaching the limit, I can ssh into the maschine and restart
sogo and the numtcpsock value drops from about 1000 back to 50
(which is normal). This is now automated by a cron job, but why is
that happening?

Has someone else experienced this?

In my sogo profile I have setup an extra IMAP account (gmx.de) and
when I click through the gmx folders in the sogo web-interface, for
each folder-click the numtcpsock value increases by 1 or 2 as well.
And is not going back down.

Any Idea? The incomming connections vor CardDAV and CalDAV are http
request, right? Can I tweak something there?

Thanks
John







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


Re: [SOGo] Login on Sogo

2013-01-23 Thread Christian Mack
Hello Stefan


Am 2013-01-23 08:38, schrieb i...@gruenberger-online.de:
 
 after i´ve start the virtual box appliance, i´ve acces via web browser
 firefox on the web interface.
 
 when i will logon on the example mail accounts the webbrowser go to the
 internet and said: The web address you entered could not be found. 
 
 what settings i have to change.
 

Does the following Bugreport help you?
Bug #2192
http://www.sogo.nu/bugs/view.php?id=2192


Kind regards,
Christian Mack

-- 
Christian Mack
Gruppe Informationsdienste
Rechenzentrum Universität Konstanz
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Funambol: Officer not working / How to workaround

2013-01-23 Thread Nicolas Fabre

Hi all,

I have seen same error in my funambol logs.
What is interesting for me is :

Encountered: \\ (92), after : \r

It happens when i sync cards from sogo to a blackberry via funambol.


I had similars issues with events sync from sogo to a blackberry via 
funambol


Encountered: \r (13), after : \r

There is a post about that here :
http://mail.opengroupware.org/pipermail/sogo/2010-April/006005.htm

So obviously i thank about spaces in my contacts somewhere (in 
descriptions or something).
After deleting unnecessary informations (notes in the other tab), the 
sync run ok again.


I have an old 8.5 funambol server (the only one who works well with 
these damned blackberrys) and fresh funambol-sogo-1.0.9 connector.

What is your funambol server version?

hope that can help

Nicolas FABRE


Le 13/01/2013 00:14, der.k...@gmx.de a écrit :

OK, another log from ds-server.log:

Writing to Sogo works, but retrieving fails:

[2013-01-12 23:53:45,471] [funambol.handler] [ERROR]
[C7930FAC2C6929FC509A305F6E7BC7DE] [192.168.178.40] [fol-VU5SRUFMRFVBTDpvdXQ=]
[doc] [] Error processing message
com.funambol.common.pim.vcard.TokenMgrError: Lexical error at line 16, column
1.  Encountered: \\ (92), after : \r
at
com.funambol.common.pim.vcard.VCardSyntaxParserTokenManager.getNextToken(VCardSyntaxParserTokenManager.java:2621)
at
com.funambol.common.pim.vcard.VCardSyntaxParser.jj_ntk(VCardSyntaxParser.java:1707)


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


Re: [SOGo] SOGo not releasing tcp spockets?

2013-01-23 Thread Ludovic Marcotte

On 23/01/13 03:18, John Bieling wrote:
Glad I could help, will this be fixed in 2.0.4? Or is it already fixed 
in the current codebase (git clone...)? 

It's fixed in git and will be part of 2.0.4.

--
Ludovic Marcotte
+1.514.755.3630  ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)

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


[SOGo] SQL errors on funambol sync, what am i doing wrong?

2013-01-23 Thread John Bieling

Hi,

I am failing on the last step of my sogo setup: Funambol Sync.

I followed the installation guide:
- standard sogo install with PostgreSQL 8.4
- standard Funambol 10.0.0.3 bundle setup (using 
postgresql-9.2-1002.jdbc4.jar + json_simple_1.1.jar)

- sogo-card SyncSource setup
- SOGoOfficer changed to inverse
- FunV10 android app

What I changed from the standard setup:
- only DS Server is started,
- CTP, Inbox Listener and PIM Listener are NOT started

With my andoid device and the FunV10 app I can connect (using my sogo 
username + password) and sync ok, no error on the phone.


However the new contacts do not show up in my sogo account. I get a few 
different kind of errors in the postgresql log:



2013-01-23 18:47:34 CET ERROR:  relation null_quick does not exist at 
character 20
2013-01-23 18:47:34 CET STATEMENT:  SELECT c_name FROM null_quick WHERE 
c_component = 'vcard'


2013-01-23 18:47:34 CET ERROR:  syntax error at or near null at 
character 39
2013-01-23 18:47:34 CET STATEMENT:  SELECT c_cn, c_mail, c_o, c_name 
FROM null


2013-01-23 18:47:36 CET ERROR:  syntax error at or near null at 
character 13
2013-01-23 18:47:36 CET STATEMENT:  INSERT INTO null (c_name, c_content, 
c_creationdate, c_lastmodified, c_version) VALUES ($1,$2,$3,$4,$5)


2013-01-23 18:47:36 CET ERROR:  current transaction is aborted, commands 
ignored until end of transaction block
2013-01-23 18:47:36 CET STATEMENT:  SELECT c_name FROM null_quick WHERE 
c_name = $1


2013-01-23 18:54:47 CET ERROR:  function upper(bigint) does not exist at 
character 45
2013-01-23 18:54:47 CET HINT:  No function matches the given name and 
argument types. You might need to add explicit type casts.
2013-01-23 18:54:47 CET STATEMENT:  select count(*) from fnbl_last_sync 
where ( UPPER(principal) = upper($1))


Any Idea? Thanks for your help.

John


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


Re: [SOGo] Re: Windows client can't join Samba4 domain after adding dcerpc entries into smb.conf

2013-01-23 Thread Marco Coli

Il 18/05/2012 15:54, Alberto Federico Turelli ha scritto:

I forgot to mention that OpenChange provisioning was done just after
installing it.

I am following the documentation, slightly adapting it to my situation
(MySQL backend, Postfix IMAP server) where I already reached the point
of making Outlook users set up a profile and use mail and calendar.

The only missing point to a fully functional domain controller seems
the unavailable RPC server.


I have same issue. Only difference from Alberto is the server platform, 
Centos 6.x in my case, but the problem is the same:


adding Openchange lines to smb.conf cause any domain-related activity on 
the clients fail with


RPC server not available message.

It seems like an on/off situation, you can use samba4 with openchange for 
outlook OR you can use samba4 for AD Controller, but not both.

There is no solution to this problem?

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


Re: [SOGo] Re: Windows client can't join Samba4 domain after adding dcerpc entries into smb.conf

2013-01-23 Thread Jean Raby

On 13-01-23 1:37 PM, Marco Coli wrote:

Il 18/05/2012 15:54, Alberto Federico Turelli ha scritto:

I forgot to mention that OpenChange provisioning was done just after
installing it.

I am following the documentation, slightly adapting it to my situation
(MySQL backend, Postfix IMAP server) where I already reached the point
of making Outlook users set up a profile and use mail and calendar.

The only missing point to a fully functional domain controller seems
the unavailable RPC server.


I have same issue. Only difference from Alberto is the server platform,
Centos 6.x in my case, but the problem is the same:

adding Openchange lines to smb.conf cause any domain-related activity on
the clients fail with

RPC server not available message.

It seems like an on/off situation, you can use samba4 with openchange
for outlook OR you can use samba4 for AD Controller, but not both.

There is no solution to this problem?


Could you try with these lines instead (notice the + sign):

### Configuration required by OpenChange server ###
dcerpc endpoint servers = +epmapper, +mapiproxy
dcerpc_mapiproxy:server = true
dcerpc_mapiproxy:interfaces = exchange_emsmdb, exchange_nsp, exchange_ds_rfr
### Configuration required by OpenChange server ###


--
Jean Raby
jr...@inverse.ca  ::  +1.514.447.4918 (x120) ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)

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


Re: [SOGo] Re: Windows client can't join Samba4 domain after adding dcerpc entries into smb.conf

2013-01-23 Thread Marco Coli

Il 23/01/2013 19:48, Jean Raby ha scritto:

Could you try with these lines instead (notice the + sign):

### Configuration required by OpenChange server ###
dcerpc endpoint servers = +epmapper, +mapiproxy
dcerpc_mapiproxy:server = true
dcerpc_mapiproxy:interfaces = exchange_emsmdb, exchange_nsp, 
exchange_ds_rfr

### Configuration required by OpenChange server ###




Thank you for your answer. I will try asap and I will let you know.
--
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] Migrating SOGo

2013-01-23 Thread Donny Brooks
I am trying to setup a new machine to move our SOGo installation to. I 
am a bit rusty as th elast one I installed from the ground up was way 
back in the early 1.x days. However I have followed the directions and 
installed all the sogo stuff, memcached, sope49-mysql, mysql, etc and 
configured what I can find in the docs. With this move we are also 
moving to our new samba domain so that has changed also. We are doing 
TLS security and I think I have the .GNUstepDefaults configured correctly.


I am able to log in but when I do I get this:

object not found: SOGo = dbrooks

So looking in the logs I see this:

2013-01-23 16:27:25.102 sogod[26569] ERROR(-[NSNull(misc) 
forwardInvocation:]): called selector objectForKey: on NSNull !
2013-01-23 16:27:25.112 sogod[26569] ERROR(-[NSNull(misc) 
forwardInvocation:]): called selector setObject:forKey: on NSNull !

2013-01-23 16:27:25.112 sogod[26569]   didn't set return value for type 'v'
Jan 23 16:27:25 sogod [26569]: SOGoRootPage successful login for user 
'dbrooks' - expire = -1  grace = -1
10.8.3.130 - - [23/Jan/2013:16:27:25 GMT] POST /SOGo/connect HTTP/1.1 
200 27/45 0.015 - - 0
2013-01-23 16:27:25.119 sogod[26569] ERROR(-[NSNull(misc) 
forwardInvocation:]): called selector objectForKey: on NSNull !
2013-01-23 16:27:25.129 sogod[26569] ERROR(-[NSNull(misc) 
forwardInvocation:]): called selector setObject:forKey: on NSNull !

2013-01-23 16:27:25.129 sogod[26569]   didn't set return value for type 'v'
10.8.3.130 - - [23/Jan/2013:16:27:25 GMT] GET /SOGo/dbrooks HTTP/1.1 
404 36/0 0.012 - - 8K


Nothing really stands out to me there. Does it look like there is 
something I have missed?


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

Re: [SOGo] Migrating SOGo

2013-01-23 Thread Ludovic Marcotte

On 23/01/13 17:30, Donny Brooks wrote:

object not found: SOGo = dbrooks
That means your SOGoUserSources is wrong. Correctly set IDFieldName and 
UIDFieldName.


--
Ludovic Marcotte
+1.514.755.3630  ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)

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

Re: [SOGo] Migrating SOGo

2013-01-23 Thread Donny Brooks



On 01/23/2013 04:35 PM, Ludovic Marcotte wrote:

On 23/01/13 17:30, Donny Brooks wrote:

object not found: SOGo = dbrooks
That means your SOGoUserSources is wrong. Correctly set IDFieldName 
and UIDFieldName.

--
Ludovic Marcotte
+1.514.755.3630  ::www.inverse.ca
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence 
(www.packetfence.org)


Thanks for the super fast reply. That was indeed the problem. Had uid in 
one place and uidNumber in another. Changed the uidNumber to uid and it 
worked.

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

Re: [SOGo] Thunderbird 17/Lightning 1.9 cache errors

2013-01-23 Thread Sauro Cerri

Find the problem described; patched both files as suggested and distributed to
client; the problem disappear on the events and task can't be modified.
Thanks

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


[SOGo] BTS activities for Wednesday, January 23 2013

2013-01-23 Thread SOGo reporter
Title: BTS activities for Wednesday, January 23 2013





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Wednesday, January 23 2013

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
2090
	2013-01-23 10:13:35
	updated (open)
	Web Calendar
	Unable to share Calendar with LDAP Group
	
	  
	
1937
	2013-01-23 09:59:13
	closed (not a bug)
	Backend Address Book
	Unable to subscribe to shared address book