Re: [SOGo] Re: SOGo upgrade issue

2015-07-20 Thread Steve Ankeny

On 07/18/2015 05:34 PM, Christian M. Jensen wrote:

hi.

this is just a suggestion, if the problem really just is the postinst 
script


download the package using wget or other local tool
then unpack it and extract the DEBIAN folder from it like this

*NOTE* foo.deb is the package you modify
*NOTE* tmpdir is the folder you extract the deb archive to.
*NOTE* hacked.deb is the package you install!

dpkg-deb -x foo.deb tmpdir
dpkg-deb --control foo.deb tmpdir/DEBIAN

now edit the postinst script

 nano tmpdir/DEBIAN/control

now pack the deb file and install it

dpkg -b tmpdir hacked.deb
dpkg -i hacked.deb

I've done this my self a few times, and might just be what you need if 
you don't want to compile it

just a suggestion.

Regards
Christian Jensen


thx, Christian

I tried Rowland's suggestion last evening ('sudo apt-get -f install'), 
and it didn't resolve the issue.


It certainly seems to me that I need a CORRECT 'samba' package, and if 
it's strictly the postinst script, as the error notes, and as Rowland 
suggested, then your methodology just might get me over the hump.


here were the latest steps I took --

adam@sogo:~$ sudo apt-get remove samba  (no errors)

adam@sogo:~$ sudo apt-get update  sudo apt-get upgrade (installed 
remaining packages)


adam@sogo:~$ sudo apt-get install python-ocsmanager (package withheld above)

('python-ocsmanager' requires 'samba' which generates the following error)

Setting up samba (2:4.1.18+dfsg-3~inverse1) ...
Installing new version of config file /etc/logrotate.d/samba ...
Installing new version of config file /etc/init/smbd.conf ...
Installing new version of config file /etc/init.d/samba ...
update-rc.d: /etc/init.d/samba exists during rc.d purge (use -f to force)
dpkg: error processing package samba (--configure):
 subprocess installed post-installation script returned error exit status 1

(edit /var/lib/dpkg/status to read install ok installed then)

adam@sogo:~$ sudo apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
dpkg: error: parsing file '/var/lib/dpkg/status' near line 645 package 
'samba':

 Config-Version for package with inappropriate Status
E: Sub-process /usr/bin/dpkg returned an error code (2)
adam@sogo:~$

So, it appears to me that SOMEONE needs to edit the post-installation 
script.


I will try one more time using the 'sudo update-rc.d -f samba remove' 
command (as I did before)


Then I'll try your suggestion (probably this evening EDT -- NY time)

thx for the suggestion



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


[SOGo] 3 users sources

2015-07-20 Thread Sogo User

  
  
Hello,
  
  I'd like to use 3 users sources in my SOGo.conf.
  
  One LDAP is used to authenticate and as addressbook.
  One SQL is used to authenticate and as addressbook. (commented out
  during tests, work as expected)
  One LDAP is used as addressbook only.
  
  My question is : is it possible to use both LDAP databases, one
  used to authenticate and addressbook and another as only
  addressbook ?
  
  I can see the "auth/addressbook" LDAP source in the Contacts tab
  but not the "addressbook only" source in this tab.
  
  I'm pretty sure of the source config in SOGo.conf :
  
  SOGoUserSources = (
  {
              type = ldap;
              CNFieldName = cn;
              IDFieldName = cn;
              UIDFieldName = sAMAccountName;
              baseDN = "ou=users,dc=domain,dc=lan";
              bindDN = "cn=bind_user,cn=Users,dc=domain,dc=lan";
              bindPassword = password;
              bindFields = (mail);
              canAuthenticate = YES;
              displayName = "Domain users";
              hostname = ldap://xxx.xxx.xxx.xxx:389;
              id = AD source;
              isAddressBook = YES;
              MailFieldNames = (mail);
              IMAPLoginFieldName = mail;
          },
          {
              type = ldap;
              CNFieldName = cn;
              IDFieldName = cn;
              UIDFieldName = cn;
              baseDN = "dc=domain,dc=contacts";
              bindDN = "cn=bind_user,dc=domain,dc=contacts";
              bindPassword = password;
              canAuthenticate = NO;
              displayName = "Open LDAP";
              hostname = ldap://xxx.xxx.xxx.xxx:389;
              id = "Open LDAP source";
              idAddressBook = YES;
          }
  );
  
  The connection to the second source (the one causes problems) is
  OK using those credentials with LDAPAdmin software
  
  Any idea ?
  
  Thanks
  

  



Re: [SOGo] Re: SOGo upgrade issue

2015-07-20 Thread Sven Nielsen


Setting up samba (2:4.1.18+dfsg-3~inverse1) ...
Installing new version of config file /etc/logrotate.d/samba ...
Installing new version of config file /etc/init/smbd.conf ...
Installing new version of config file /etc/init.d/samba ...
update-rc.d: /etc/init.d/samba exists during rc.d purge (use -f to force)
dpkg: error processing package samba (--configure):
  subprocess installed post-installation script returned error exit status 1


As a workaround, have you tred simply to remove or rename 
/etc/init.d/samba to something else before running 'apt-get install -f 
? This should get you around this error and one step further..


Sven


Processing triggers for ureadahead (0.100.0-16) ...
E: Sub-process /usr/bin/dpkg returned an error code (1)
adam@sogo:~$



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


Re: [SOGo] Re: SOGo upgrade issue

2015-07-20 Thread Steve Ankeny

On 07/20/2015 10:24 AM, Sven Nielsen wrote:


Setting up samba (2:4.1.18+dfsg-3~inverse1) ...
Installing new version of config file /etc/logrotate.d/samba ...
Installing new version of config file /etc/init/smbd.conf ...
Installing new version of config file /etc/init.d/samba ...
update-rc.d: /etc/init.d/samba exists during rc.d purge (use -f to 
force)

dpkg: error processing package samba (--configure):
  subprocess installed post-installation script returned error exit 
status 1


As a workaround, have you tred simply to remove or rename 
/etc/init.d/samba to something else before running 'apt-get install 
-f ? This should get you around this error and one step further..


Sven


Processing triggers for ureadahead (0.100.0-16) ...
E: Sub-process /usr/bin/dpkg returned an error code (1)
adam@sogo:~$




that was Rowland Penney's original suggestion --

(1) edit '/var/lib/dpkg/status'
(2) run 'sudo update-rd.d samba remove'
(3) and 'sudo apt-get -f install'

I've run all three but the last time I didn't run (2) because there 
wasn't an error before the attempt (only after)  What you cite here is 
the error AFTER I ran 'sudo apt-get -f install' which admittedly is the 
clue.


And, as others have suggested, it shows the problem with the script in 
the Inverse 'samba' package.


I'll do these tonight before attempting to download and edit myself.

I think Inverse should fix their 'samba' package.  Maybe a bug report 
should be filed?




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


Re: [SOGo] Re: SOGo upgrade issue

2015-07-20 Thread Sven Nielsen

Am 20.07.2015 um 17:18 schrieb Steve Ankeny:

On 07/20/2015 10:24 AM, Sven Nielsen wrote:


Setting up samba (2:4.1.18+dfsg-3~inverse1) ...
Installing new version of config file /etc/logrotate.d/samba ...
Installing new version of config file /etc/init/smbd.conf ...
Installing new version of config file /etc/init.d/samba ...
update-rc.d: /etc/init.d/samba exists during rc.d purge (use -f to
force)
dpkg: error processing package samba (--configure):
  subprocess installed post-installation script returned error exit
status 1


As a workaround, have you tred simply to remove or rename
/etc/init.d/samba to something else before running 'apt-get install
-f ? This should get you around this error and one step further..

Sven


Processing triggers for ureadahead (0.100.0-16) ...
E: Sub-process /usr/bin/dpkg returned an error code (1)
adam@sogo:~$




that was Rowland Penney's original suggestion --

(1) edit '/var/lib/dpkg/status'
(2) run 'sudo update-rd.d samba remove'


No ;), I mean, just _manually_ rename the file with:

# mv /etc/init.d/samba /etc/init.d/samba_old

Sven

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


Re: AW: [SOGo] Activesync trouble with IMAP LIST loop

2015-07-20 Thread Angelo Conforti

Hi and thank you for your suggestion.
I always define the 
SOGoDraftsFolderName/SOGoSentFolderName/SOGoTrashFolderName and the 
specified folder always exists. I changed folder path separator (in 
dovecot and SOGo, from . to /) and the behaviour changes; now the 
Trash and Sent folder is correctly recognized.


But the main problem is that SOGo starts to loop with:


C[0x7faeda617520]: 1 login ** **
S[0x7faeda6130b0]: 1 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS 
ID ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS 
THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN 
NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT 
SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE METADATA 
QUOTA ACL RIGHTS=texk] Logged in
C[0x7faeda617520]: 2 capability
S[0x7faeda6130b0]: * CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID 
ENABLE IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS 
THREAD=ORDEREDSUBJECT MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN 
NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT 
SEARCHRES WITHIN CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE METADATA 
QUOTA ACL RIGHTS=texk
S[0x7faeda6130b0]: 2 OK Capability completed.
C[0x7faeda617520]: 3 ID (x-originating-ip localhost)
S[0x7faeda6130b0]: * ID (name Dovecot)
S[0x7faeda6130b0]: 3 OK ID completed.
C[0x7faeda617520]: 4 LIST  
S[0x7faeda6130b0]: * LIST (\Noselect) / 
S[0x7faeda6130b0]: 4 OK List completed.
C[0x7faeda617520]: 5 LIST  *

[...]

S[0x7faeda6130b0]: 5 OK List completed.
C[0x7faeda617520]: 6 namespace
S[0x7faeda6130b0]: * NAMESPACE ((INBOX/ /)) NIL NIL
S[0x7faeda6130b0]: 6 OK Namespace completed.
C[0x7faeda617520]: 7 LIST  INBOX/*

[...]

S[0x7faeda6130b0]: 7 OK List completed.
C[0x7faeda617520]: 8 list  * return (status (x-guid))
S[0x7faeda6130b0]: * LIST () / INBOX

[...]

S[0x7faeda6130b0]: 8 OK List completed.
C[0x7faeda617520]: 9 unselect
S[0x7faeda6130b0]: 9 BAD No mailbox selected.
C[0x7faeda617520]: 10 select INBOX
S[0x7faeda6130b0]: * FLAGS (\Answered \Flagged \Deleted \Seen \Draft $label4 
$label1 $label2 $Forwarded NonJunk $label3)
S[0x7faeda6130b0]: * OK [PERMANENTFLAGS (\Answered \Flagged \Deleted \Seen 
\Draft $label4 $label1 $label2 $Forwarded NonJunk $label3 \*)] Flags permitted.
S[0x7faeda6130b0]: * 18 EXISTS
S[0x7faeda6130b0]: * 0 RECENT
S[0x7faeda6130b0]: * OK [UNSEEN 18] First unseen.
S[0x7faeda6130b0]: * OK [UIDVALIDITY 1401745328] UIDs valid
S[0x7faeda6130b0]: * OK [UIDNEXT 74123] Predicted next UID
S[0x7faeda6130b0]: * OK [HIGHESTMODSEQ 5633] Highest
S[0x7faeda6130b0]: 10 OK [READ-WRITE] Select completed (0.001 secs).
C[0x7faeda617520]: 11 list  * return (status (x-guid))
S[0x7faeda6130b0]: * LIST () / INBOX

[...]

S[0x7faeda6130b0]: 11 OK List completed.
C[0x7faeda617520]: 12 status INBOX/Trash (UIDVALIDITY)
S[0x7faeda6130b0]: * STATUS INBOX/Trash (UIDVALIDITY 1411639996)
S[0x7faeda6130b0]: 12 OK Status completed.
C[0x7faeda617520]: 13 list  * return (status (x-guid))

[...]

S[0x7faeda6130b0]: 13 OK List completed.
C[0x7faeda617520]: 14 status INBOX/Sent Items (UIDVALIDITY)
S[0x7faeda6130b0]: * STATUS INBOX/Sent Items (UIDVALIDITY 1262625493)
S[0x7faeda6130b0]: 14 OK Status completed.
C[0x7faeda617520]: 15 list  * return (status (x-guid))
S[0x7faeda6130b0]: * LIST () / INBOX

[...]

And at this loop continues till the process reaches the SxVMemLimit, 
without sending data to the client.


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


Re: [SOGo] Re: SOGo upgrade issue

2015-07-20 Thread Steve Ankeny

On 07/20/2015 11:51 AM, Sven Nielsen wrote:

Am 20.07.2015 um 17:18 schrieb Steve Ankeny:

On 07/20/2015 10:24 AM, Sven Nielsen wrote:


Setting up samba (2:4.1.18+dfsg-3~inverse1) ...
Installing new version of config file /etc/logrotate.d/samba ...
Installing new version of config file /etc/init/smbd.conf ...
Installing new version of config file /etc/init.d/samba ...
update-rc.d: /etc/init.d/samba exists during rc.d purge (use -f to
force)
dpkg: error processing package samba (--configure):
  subprocess installed post-installation script returned error exit
status 1


As a workaround, have you tred simply to remove or rename
/etc/init.d/samba to something else before running 'apt-get install
-f ? This should get you around this error and one step further..

Sven


Processing triggers for ureadahead (0.100.0-16) ...
E: Sub-process /usr/bin/dpkg returned an error code (1)
adam@sogo:~$




that was Rowland Penney's original suggestion --

(1) edit '/var/lib/dpkg/status'
(2) run 'sudo update-rd.d samba remove'


No ;), I mean, just _manually_ rename the file with:

# mv /etc/init.d/samba /etc/init.d/samba_old

Sven



noted . . . I'll try your suggestion first (then Rowland's)


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


Re: [SOGo] Mysql Error 'c_description' in 'field list'

2015-07-20 Thread Ghettoblaster

Am 19.07.2015 um 14:57 schrieb Francis Lachapelle:

On Jul 19, 2015, at 6:15 AM, Ghettoblaster gobli...@gmx.de wrote:

Am 17.07.2015 um 15:08 schrieb Francis Lachapelle:

On Jul 17, 2015, at 4:17 AM, goblin gobli...@gmx.de wrote:

Since yesterdays update in wheezy i can't set new tasks in calendar.

Logfile shows mysql error:

Jul 17 10:04:38 sogod [2197]: 0x0x7fc00e32ddd0[GCSFolder] ERROR(-[GCSFolder
writeContent:fromComponent:container:toName:baseVersion:]): cannot insert
content : MySQL4Exception: 0x7fc00e579eb0 NAME:ExecutionFailed
REASON:Unknown column 'c_description' in 'field list'
Jul 17 10:04:38 sogod [2197]: [ERROR]
0x0E37D010[SOGoAppointmentObject]:d6712da1-9b8e-4ec1-b88e-f58ba4985678.ics
write failed: MySQL4Exception: 0x7fc00e579eb0 NAME:ExecutionFailed
REASON:Unknown column 'c_description' in 'field list'
[...]
Jul 17 10:04:38 sogod [2197]: |SOGo| starting method 'REPORT' on uri '/SOGo/
dav/user@sogoserver/Calendar/89D-54C21700-1-762C1380/'
Jul 17 10:04:38 sogod [2197]: 0x0x7fc00e0e5440[SOGoCache] an error occurred
when caching value for key 'user@sogoserver+attributes': WRITE FAILURE
Jul 17 10:04:39 sogod [2197]: 0x0x7fc00e0e5440[SOGoCache] an error occurred
when caching value for key 'user@sogoserver+attributes': WRITE FAILURE
Jul 17 10:04:39 sogod [2197]: 0x0x7fc00e0e5440[SOGoCache] an error occurred
when caching value for key 'user@sogoserver+settings': WRITE FAILURE


What can i do to solve this error?

This has been discussed many times. The database schema has changed; you must 
run sql-update-2.2.17_to_2.3.0-mysql.sh. The script should under 
/usr/share/doc/sogo/. Always read the 'Upgrade' section of the installation 
guide when updating your installation.

https://github.com/inverse-inc/sogo/blob/master/Documentation/SOGoInstallationGuide.asciidoc#L2721

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

Thank you for the answer. I cant execute this script. This is the result:

# sh /usr/share/doc/sogo/sql-update-2.1.17_to_2.3.0-mysql.sh
Username (root): root
Hostname (127.0.0.1): 127.0.0.1
Database (root): databasename
/usr/share/doc/sogo/sql-update-2.1.17_to_2.3.0-mysql.sh: 41: 
/usr/share/doc/sogo/sql-update-2.1.17_to_2.3.0-mysql.sh: Syntax error: ( 
unexpected

Line 41 in the script is the following: function adjustSchema() {

Here is the complete function:

function adjustSchema() {
oldIFS=$IFS
IFS= 
part1=`echo -e \ALTER TABLE $table MODIFY c_partstates mediumtext;\\n\`;
part2=`echo -e \ALTER TABLE $table ADD COLUMN c_description 
mediumtext;\\n\`;
sqlscript=$sqlscript$part1$part2
IFS=$oldIFS
}

Try to explicitly use bash instead of sh.


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

*facepalm* you are right, thank you.
Problem was sitting in front of the screen ;)

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


[SOGo] BTS activities for Monday, July 20 2015

2015-07-20 Thread SOGo reporter
Title: BTS activities for Monday, July 20 2015





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Monday, July 20 2015

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
3172
	2015-07-20 09:13:40
	updated (open)
	SOGo
	Submit add-on to AMO for security review
	
	  
	
3284
	2015-07-20 10:38:41
	updated (open)
	Backend Address Book
	global addressbook supports neither ctag nor sync-token
	
	  
	
1716
	2015-07-20 10:09:28
	updated (open)
	GUI
	Add-on does not not update automatically
	
	  
	
3281
	2015-07-20 09:51:27
	updated (open)
	Web Preferences
	email - auto read ( enable / disable)