Re: [SOGo] Sogo First installation problem with configuration file

2013-05-13 Thread Der PCFreak

Hi Atef,

The latest versions of SOGo configure the user sogo as a daemon user.
As you can see it /etc/passwd

sogo:x:999:999:SOGo daemon:/var/lib/sogo:/usr/sbin/nologin

this user has no login shell and therefore cannot be used with sudo.

If you are root or can get root (sudo -i) then you can use the command 
su to act as the user sogo.


Example

su -p -c YourCommand sogo

will execute YourCommand as the user sogo

Here some more examples

su -p -c 'defaults write sogod SOGoTimeZone Europe/Berlin' sogo
su -p -c 'defaults write sogod SOGoMailDomain yourdomain.com' sogo
su -p -c 'defaults write sogod SOGoLanguage English' sogo

So you see, it is very easy but at the moment not correct in the 
documentation.


I hope I could help you.

Kind regards

PCFreak


On 13.05.2013 04:02, Atef wrote:

Hi,

I'm installing sogo using these steps;

sudo apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4

sudo su
echo deb http://inverse.ca/ubuntu precise precise  /etc/apt/sources.list
exit

sudo apt-get update
sudo apt-get install sogo sope4.9-gdl1-mysql memcached rpl

mysql stuff...

Then when i want to begin configuration;

i do

sudo su sogo

result  This account is currently not available.

I tried to look for /home/sogo.. but not found
I have only /home/paul which is my home..

so, I have followed the guide without doing sudo su sogo

defaults write sogod SOGoTimeZone Europe/Paris


And I found the file created  /home/paul/GNUstep/Defaults/.GNUstepDefaults

But after this i'm not able to login with the web interface.

Please tell me how can I configure Sogo correctly (Steps to follow in order to
create a configuration file in the right place..)

Thanks in advance!

Best regards,


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


[SOGo] Samba lost mysql connection

2013-05-13 Thread Fabio Onorini
Hello sogo users,
every morning I need to restart samba service on my sogo test server.

Without this operation, I can't connect with outlook.
This is only test server, that not receive or send mail during night.

Today I see this rows in samba log:

2013-05-13 07:54:10.841 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900 SQL: SELECT count(*) FROM socfs_sogo1;
2013-05-13 07:54:10.861 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900   ERROR: MySQL server has gone away
2013-05-13 07:54:10.861 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900 SQL: CREATE TABLE socfs_sogo1 ( c_path VARCHAR(255)
PRIMARY KEY, c_parent_path VARCHAR(255), c_type TINYINT NOT NULL,
c_creationdate INT NOT NULL, c_lastmodified INT NOT NULL, c_version INT NOT
NULL DEFAULT 0, c_deleted TINYINT NOT NULL DEFAULT 0, c_content LONGTEXT);
2013-05-13 07:54:10.861 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900   ERROR: MySQL server has gone away
/usr/sbin/samba: Uncaught exception MAPIStoreIOException, reason: could not
create special table 'socfs_sogo1'
[2013/05/13 07:54:11,  0]
mapiproxy/servers/default/nspi/dcesrv_exchange_nsp.c:1394(dcesrv_exchange_nsp_unbind)
  dcesrv_exchange_nsp_unbind


Maybe with no activity on server, samba lost connection with mysql and need
restart to work correctly.

Any suggestion?

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

Re: [SOGo] Openchange with a member DC server

2013-05-13 Thread Mark
I am getting the same error :( Any idea how to add these entries? I quess I
will have to edit the script? Not looking forward to that.

ldb.LdbError: (32, 'Unable to find GUID for DN CN=Mailbox Store
(SOGO),CN=First Storage
Group,CN=InformationStore,CN=SOGO,CN=Servers,CN=First Administrative
Group,CN=Administrative Groups,CN=First Organization,CN=Microsoft
Exchange,CN=Services,CN=Configuration,DC=xx,DC=x\n')



On Thu, May 9, 2013 at 8:31 PM, daniele Borini d.bor...@effegidi.it wrote:

 hi,
 i've prepared AD scheda with exchange setup but adding users with 
 openchange_newuser --create daniele i get this error:
 
  Unable to find GUID for DN CN=Mailbox Store (MAILSERVER),CN=First Storage 
 Group,CN=InformationStore,CN=MAILSERVER,CN=Servers,CN=First Administrative 
 Group,CN=Administrative Groups,CN=effegidi,CN=Microsoft 
 Exchange,CN=Services,CN=Configuration,DC=,DC=
 
 surfing inside AD tree i found that CN=Mailbox Store (MAILSERVER),CN=First 
 Storage Group,CN=InformationStore,CN=MAILSERVER completely lacks. I suppose 
 openchange_provision will create those values which are related to exchange 
 server. Perhaps adding these values by hand i can step to the next problem... 
 who knows...




 original message-
 Da: Mark mclar...@gmail.com
 A: users@sogo.nu
 Data: Thu, 9 May 2013 18:55:40 +0200
 --
 
 
 I will find out. I am not a windows admin. Just been asked to assist a 
 customer migrate to
 openchange and SOGo. My windows admin knowledge include 0 exchange 
 experience. :( I will enquire
 and revert
 
 
 
 On Thu, May 9, 2013 at 11:06 AM, Fabio Onorini onofa...@gmail.com  wrote:
 
 Hi Mark,
 have you run exchange setup with prepareschema option on active directory 
 system?
 Without this operation openchange provision doesn't work.
 
 
 
 
 2013/5/8 Mark mclar...@gmail.com

 
 Hi all,
 
 Was wondering if there are any special steps necessary for using openchange 
 with samba
 4 as a member DC server. The samba server has replicated the AD structure 
 from the master
 which already has a exchange entry.
 
 Running openchange_provision failed as there was already an entry for 
 exchange. I am
 not a windows administrator so not too familiar with AD entries.
 
 Should it just work if I point an outlook client at the ip address of the 
 sogo/samba
 server?
 
 Will be testing it tomorrow when I get to a windows client tomorrow.
 
 cheers
 
 
  --
 ---
 Fabio Onorini
 
 


 --



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

Re: [SOGo] Samba lost mysql connection

2013-05-13 Thread Jean Raby

On 13-05-13 4:35 AM, Fabio Onorini wrote:

Hello sogo users,
every morning I need to restart samba service on my sogo test server.

Without this operation, I can't connect with outlook.
This is only test server, that not receive or send mail during night.
this is really strange and looks like bug #2303 
(http://sogo.nu/bugs/view.php?id=2303 - sorry this is in french)


Can you get a pcap of the communication between samba(sogo) and mysql?
Use tcpdump to capture traffic while the communication works, let it run over 
night, and the reproduce the problem the next morning, then stop the capture.


Then send me the pcap in private.

Also, can you paste a few more lines of contexts from the samba log? (50 lines 
above what you showed would be helpful)


Thanks.



Today I see this rows in samba log:

2013-05-13 07:54:10.841 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900 SQL: SELECT count(*) FROM socfs_sogo1;
2013-05-13 07:54:10.861 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900 ERROR: MySQL server has gone away
2013-05-13 07:54:10.861 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900 SQL: CREATE TABLE socfs_sogo1 ( c_path VARCHAR(255)
PRIMARY KEY, c_parent_path VARCHAR(255), c_type TINYINT NOT NULL, c_creationdate
INT NOT NULL, c_lastmodified INT NOT NULL, c_version INT NOT NULL DEFAULT 0,
c_deleted TINYINT NOT NULL DEFAULT 0, c_content LONGTEXT);
2013-05-13 07:54:10.861 samba[2436] MySQL4Channel[0x0x17ffc00]
connection=0x0x2116900   ERROR: MySQL server has gone away
/usr/sbin/samba: Uncaught exception MAPIStoreIOException, reason: could not
create special table 'socfs_sogo1'
[2013/05/13 07:54:11,  0]
mapiproxy/servers/default/nspi/dcesrv_exchange_nsp.c:1394(dcesrv_exchange_nsp_unbind)
   dcesrv_exchange_nsp_unbind


Maybe with no activity on server, samba lost connection with mysql and need
restart to work correctly.

Any suggestion?

--
---
Fabio Onorini


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


Re: [SOGo] Sogo First installation problem with configuration file

2013-05-13 Thread Michael Kedzie

On 05/12/2013 09:02 PM, Atef wrote:

sudo su sogo

result  This account is currently not available.

This is because the sogo user doesn't have a valid shell configured. Use 
the following command instead to specify the BASH shell:


sudo su -s /bin/bash sogo

Now continue following the instructions you are using.
-Mike
--
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] BTS activities for Monday, May 13 2013

2013-05-13 Thread SOGo reporter
Title: BTS activities for Monday, May 13 2013





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Monday, May 13 2013

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
732
	2013-05-13 11:44:27
	updated (open)
	Web Address Book
	Show URL/Link of adressbook like in Calendars
	
	  
	
2317
	2013-05-13 11:15:32
	updated (open)
	Web Address Book
	No links to this calendar feature for Address Books
	
	  
	
2316
	2013-05-13 11:13:10
	updated (open)
	Web Calendar
	Calendarentrys show at the wrong time
	
	  
	
2320
	2013-05-13 07:13:54
	updated (open)
	Web Calendar
	Time shifts when saving/modifying events in SOGo web interface
	
	  
	
2318
	2013-05-13 11:05:21
	updated (open)
	Web Mail
	Problem with cyrillic imap folders
	
	  
	
2299
	2013-05-13 13:16:50
	updated (open)
	with external server
	Unable to Synch Contacts with iCloud in TB
	
	  
	
2319
	2013-05-13 05:37:02
	new (open)
	with SOGo
	Samba lost mysql connection
	
	  
	
2314
	2013-05-13 11:30:31
	closed (not a bug)
	sogo-tool
	tls=YES argument for sieve not parsed correctly in sogo conf