[SOGo] MySQL4Adaptor trouble
Hello,
I've installed SOGo through official Debian package, I've successfully
configure ldap auth for users.
I now have some troubles with the mysql adapter, which connect well and
and created tables: sogo_folder_info and sogo_user_profile which are
empty for now.
Here are my logs, if you could help me. What i understand is Sogo try to
use a default database auth to write an empty key? which is not what i
wrote into my config file...
Jun 20 11:13:53 sogod [19556]: 0x0x7f2ebdaee870[WOWatchDog] child
spawned with pid 19585
2013-06-20 11:13:53.043 sogod[19585] MySQL4 connection established
0x0x7f2ebd982be0
2013-06-20 11:13:53.043 sogod[19585] MySQL4 channel 0x0x7f2ebd9df410
opened (connection=0x0x7f2ebd982be0,sogo)
2013-06-20 11:13:53.043 sogod[19585] MySQL4Channel[0x0x7f2ebd9df410]
connection=0x0x7f2ebd982be0 SQL: SELECT count(*) FROM sogo_user_profile;
2013-06-20 11:13:53.044 sogod[19585] MySQL4Channel[0x0x7f2ebd9df410]
connection=0x0x7f2ebd982be0 query has results, entering fetch-mode.
2013-06-20 11:13:53.044 sogod[19585] MySQL4Channel[0x0x7f2ebd9df410]
connection=0x0x7f2ebd982be0 SQL: SELECT count(*) FROM sogo_folder_info;
2013-06-20 11:13:53.044 sogod[19585] MySQL4Channel[0x0x7f2ebd9df410]
connection=0x0x7f2ebd982be0 query has results, entering fetch-mode.
*Jun 20 11:13:53 sogod [19585]: [ERROR] *0x0x7f2ebdaee870[WOWatchDog]
an exception occured in runloop NSException: 0x7f2ebd9adf90
NAME:NSInvalidArgumentException REASON:Tried to add nil value for key
'(null):(null):(null):' to dictionary INFO:{localhost:3306:sogo:sogo =
MySQL4Adaptor[0x0x7f2ebdc05f20]: name=MySQL model=no
connection-dict=yes; }
Jun 20 11:13:53 sogod [19556]: 0x0x7f2ebdcf2900[WOWatchDogChild] child
19585 exited
Jun 20 11:13:53 sogod [19556]: 0x0x7f2ebdcf2900[WOWatchDogChild]
avoiding to respawn child before 2013-06-20 11:13:58 +0200
Thanks for any idea/help
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
On 06/19/13 20:43, Michael Vogel wrote: Am 19.06.2013 um 18:26 schrieb Giovanni Bechis: Atm I am using a custom version of postfixadmin, anyway I have this in my config.inc.php: $CONF['encrypt'] = 'md5crypt'; Is this MD5-CRYPT in Dovecot and md5-crypt in SOGo? I have a multidomain setup and I have this line in my sogo.conf userPasswordAlgorithm = crypt; I do not know about Dovecot, I am using Courier-Imap atm. Cheers Giovanni -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Public key
Hi,
i am using Ubuntu 12.04 LTS and i am trying to install SOGo, but i am unable to
even download the sogo package via apt-get as i keep on getting the following
error:
W: GPG error: http://inverse.ca precise Release: The following signatures
couldn't be verified because the public key is not available: NO_PUBKEY
19CDA6A9810273C4
i have tried
sudo apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4
and it still does not work.
i have also tried
sudo apt-get --allow-unauthenticated update
this does also not work
as well as adding APT{Ignore {gpg-pubkey; }}; to the /etc/apt/apt.conf file
to try to bypass the signature verification but none of this works
please assist or provide alternative method of installation
Thanks
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Problem while compiling sogo and sope on ubuntu 12.04
I got sogo sources from git ref ... but after a make, I get the following error : OGoSystemDefaults.m:114:1: erreur: method definition not in @implementation context SOGoSystemDefaults.m:159:38: erreur: ‘self’ undeclared here (not in a function) SOGoSystemDefaults.m:206:1: erreur: method definition not in @implementation context SOGoSystemDefaults.m:208:4: erreur: ‘self’ undeclared here (not in a function) SOGoSystemDefaults.m:212:1: erreur: method definition not in @implementation context Thanks for your help Stéphane Le 19/06/2013 22:38, Ludovic Marcotte a écrit : No you didn't. You haven't installed the GNUstep base development packages as mentioned in the faq. Stéphane PERON s.pe...@free.fr wrote: Hi ludovic, Yes ..It was the page that I used ... So it does not help me ... I have installed all the packages that are described. What is missing to have : SaxAttributeList.h:25:32: erreur fatale: Foundation/NSObject.h : Aucun fichier ou dossier de ce type ??? Stéphane Le 19/06/2013 19:42, Ludovic Marcotte a écrit : On 2013-06-19 12:27 PM, Stéphane PERON wrote: What's wrong ??? I have installed gobjc-4.4 package ... Is there any other packages to install ??? http://lmgtfy.com/?q=how+do+I+compile+SOGo -- Sent from my phone. Please excuse my brevity. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] can't add sogo repository certificate
Hello, I'm trying to SOGo repository certificate but it's not working. root@mailserver:~# apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4 Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /tmp/tmp.fcPyf9SPrJ --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver keys.gnupg.net --recv-key 0x810273C4 gpg: requesting key 810273C4 from hkp server keys.gnupg.net gpg: keyserver timed out gpg: keyserver receive failed: keyserver error Anyone can help with this issue? Thank you Hanane -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] can't add sogo repository certificate
Hello, I'm trying to SOGo repository certificate but it's not working. root@mailserver:~# apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4 Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /tmp/tmp.fcPyf9SPrJ --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver keys.gnupg.net --recv-key 0x810273C4 gpg: requesting key 810273C4 from hkp server keys.gnupg.net gpg: keyserver timed out gpg: keyserver receive failed: keyserver error Anyone can help with this issue? Thank you -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] can't add sogo repository certificate
• Try a different keyserver, e.g. pgp.mit.edu • Make sure your firewall isn't blocking HKP (Port 11371/TCP iirc) On 20.06.2013 13:18, hanane.elyaz...@gmail.com wrote: Hello, I'm trying to SOGo repository certificate but it's not working. root@mailserver:~# apt-key adv --keyserver keys.gnupg.net --recv-key 0x810273C4 Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /tmp/tmp.fcPyf9SPrJ --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver keys.gnupg.net --recv-key 0x810273C4 gpg: requesting key 810273C4 from hkp server keys.gnupg.net gpg: keyserver timed out gpg: keyserver receive failed: keyserver error Anyone can help with this issue? Thank you -- Mit freundlichen Grüßen, / Best Regards, Sven SCHWEDAS Systemadministrator TAO Beratungs- und Management GmbH | Lendplatz 45 | A - 8020 Graz Mail/XMPP: sven.schwe...@tao.at | +43 (0)680 301 7167 http://software.tao.at signature.asc Description: OpenPGP digital signature
[SOGo] How to set up CardDav, CalDav etc for IMAP with eMClient
Hi, Having read some of the recent mails regarding eMClient, I decided to install it and see what it was like. Unfortunately it doesn't seem to work with the Calendar, Address book or Tasks for the IMAP clients. How do I enable these three within the SOGo software so that eMClient IMAP accounts can see them? TIA Ian -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo and postfixadmin?
Am 20.06.2013 11:47, schrieb Giovanni Bechis: On 06/19/13 20:43, Michael Vogel wrote: Am 19.06.2013 um 18:26 schrieb Giovanni Bechis: Atm I am using a custom version of postfixadmin, anyway I have this in my config.inc.php: $CONF['encrypt'] = 'md5crypt'; Is this MD5-CRYPT in Dovecot and md5-crypt in SOGo? I have a multidomain setup and I have this line in my sogo.conf userPasswordAlgorithm = crypt; So crypt in SOGo is 'md5crypt' in postfixadmin? Good to know! BTW: That's really weird ... Michael -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Re: [SOGo] can't add sogo repository certificate
Thank you very much, indeed it was the firewall. opened it and it worked. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Best practice of sogo system / user backup - suggestions?
I have read many backup/restore hints and I have made the following:
- I have one backup scripts that dumps all SOGo calendars and user
settings with sogo-tool. Please see below HELPER BACKUP script
- I have second backup script that picks output from first script and
takes the rest Please see below MAIN BACKUP file
- My backup is based on sogo-tool which is MUCH more safer then simple
DB dump. I am doing additional DB dump as well, just to have additional
way to troubleshoot the problems. Backup with sogo-tool is safer since
it enables you to restore SOGo on newer version which is the case very
often. With simple DB dump you may have problems if you want to install
on fresh SOGo instance with higher version (unless you compile the same
version).
-- HELPER BACKUP script --
#!/bin/sh
# This script is used to backup Sogo calendars and user setttings.
# It must be executed as sogo user
date=`date -I`
#Backup Sogo data files
cd /home/sogo/backup/
/usr/sbin/sogo-tool backup daily_$date ALL backup_report.txt 21
mv backup_report.txt ./daily_$date/
/usr/bin/defaults read sogod ./daily_$date/sogo_conf_text.backup
# these files has to be taken by root cron job for KRONOS backup
tar -cjf daily_$date.tar.bz2 daily_$date
# remove files once packed to archive
rm -rf /home/sogo/backup/daily_$date
#Remove old backup archives
/usr/bin/find /home/sogo/backup -name \*.tar.bz2 -mtime +3 -exec /bin/rm
-f {} \;
-- END HELPER BACKUP script --
-- MAIN BACKUP file --
#!/bin/sh
# This script is used to backup Sogo
date=`date -I`
Stoping some services
#Stop apache server
/etc/init.d/httpd stop
Files
#Backup Sogo data files
# there is another sogo user cron script that backups calendars 1 hour
before this script
cd /root/kronos_backup/backup/
tar -cjf sogo_home_$date.tar.bz2 /home/sogo/
DBs
#Backup DBs
/usr/bin/mysqldump --user=root --opt --databases sogo sogo_bkp_$date.sql
/usr/bin/mysqldump --user=root --opt --databases mysql mysql_bkp_$date.sql
/usr/bin/mysqldump -u root sogo sogo_users sogo_users_bkp_$date.sql
# Backup for etc folder
tar -cjf etc_backup_$date.tar.bz2 /etc
# Pack the DB files
tar -cjf SOGO_DB_$date.tar.bz2 sogo_bkp_$date.sql
tar -cjf MySQL_DB_$date.tar.bz2 mysql_bkp_$date.sql
tar -cjf SOGO_USERS_TBL_$date.tar.bz2 sogo_users_bkp_$date.sql
# Remove sql files
rm -f sogo_bkp_$date.sql
rm -f mysql_bkp_$date.sql
rm -f sogo_users_bkp_$date.sql
Cleanup
#Remove old files
/usr/bin/find /root/kronos_backup/backup -name \*.tar.bz2 -mtime +2
-exec /bin/rm -f {} \;
Starting services
#Start apache server
/etc/init.d/httpd start
-- END MAIN BACKUP file --
When it comes to the restore/migration part:
- you install clean SOGo
- sogo user source restore depends from your deployment
- restore SOGo config (from config made above):
sudo -u sogo defaults write sogo_conf_text.backup
- restore SOGo calendar and user settings with the script like following:
#!/bin/bash
for i in $( ls /home/sogo/temp/ALL/daily_2013-04-01/); do
echo Processing $i user...
sudo -u sogo sogo-tool restore -F ALL
/home/sogo/temp/ALL/daily_2013-04-01 $i
sudo -u sogo sogo-tool restore -p
/home/sogo/temp/ALL/daily_2013-04-01 $i
done
Pay attention that above has been tested on SOGo 2.0.4b with config
located in .Defaults file.
Hope this helps. Do not hesitate to ask for additional clarification.
Regards,
Igor
Götz Reinicke - IT Koordinator wrote, On 19/06/2013 13:28:
Hi,
I'd like to ask what is your best practice to backup restore your sogo
system and/or user data?
Should we do a e.g. database dump/backup of the mysql (what we already
do for other systems) and do a user based sogo-tool backup?
Regarding the sogo-tool, is there a way to do incremental backups and is
it somehow possible to do backups of user groups?
Thanks for any suggestion . Regards . Götz
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] BTS activities for Thursday, June 20 2013
Title: BTS activities for Thursday, June 20 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Thursday, June 20 2013 idlast updatestatus (resolution)categorysummary 2331 2013-06-20 11:53:57 updated (open) with SOGo Inverse SOGo connector (17.05) crashes thunderbird 2298 2013-06-20 20:19:21 assigned (open) Backend Calendar HTTP Error 404 when uploading ICS files using CalDAV containing 'folded' / split-up UTF-8 characters 2312 2013-06-20 03:18:53 assigned (open) Backend Mail Impossible to remove a or read a folder with particular symbol. 397 2013-06-20 14:27:28 resolved (open) SOPE SOGo does not honours the user default for log level 2119 2013-06-20 09:13:06 closed (fixed) OpenChange backend Message sent with blank "Your Name" do not show email address in Outlook 2285 2013-06-20 13:44:52 closed (fixed) OpenChange backend Problem on event/contact edit
