[SOGo] to better understand Sogo
Hi all, I had to do some work in the mysql database where sogo keep his datas. Anyway, i have a question about the way sogo organize the calendar and addressbook datas. I noticed that there are 3 tables for each personal calendar or each personal addressbook. 1 for acl, 1 for datas (quick) and 1 who has exactly the same structure if it's a calendar or an addressbook. My question is what is the relationship between calendar tables and adressbook table and basically how does it work? Thanks in advance -- *Nicolas FABRE* -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] to better understand Sogo
Hi, if this is a proper db model then the relationships should be visible in the foreign key relations ;-) Am 28.06.2012 13:36, schrieb Nicolas - Lileo: Hi all, I had to do some work in the mysql database where sogo keep his datas. Anyway, i have a question about the way sogo organize the calendar and addressbook datas. I noticed that there are 3 tables for each personal calendar or each personal addressbook. 1 for acl, 1 for datas (quick) and 1 who has exactly the same structure if it's a calendar or an addressbook. My question is what is the relationship between calendar tables and adressbook table and basically how does it work? Thanks in advance -- *Nicolas FABRE* -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Funambol does not work
Stáhnul jsem si SOGo ZEG v2.0.0 rc3 Naklonoval jsem uživatele v LDAP. Přihlášení do webového rozhraní bylo ok Potom jsem stáhl funambol klient 10.1.6, nastavil jsem adresu a přilhašovací jméno. http://10.0.0.61/funambol/ds , nastavil jsem datove zdroje, ale když zkouším spustit synchronizaci, tak vyskočí chybová hláška Sync not completed. Network error. ( http://10.0.0.61/funambol/ds funguje) V předchozích verzí mi to fungovalo. Dělám to proto, protože nemůžu vytvořit uživatele for native outlook. Order of add user: Clone user in LDAP(U:bartlu P: HndkiC ) samba-tool user add bartlu New password: HndkiC User 'bartlu' created successfully samba-tool user setexpiry bartlu --noexpiry openchange_newuser --create bartlu Zde se objeví chyba: sogo@sogo:~$ sudo openchange_newuser --create bartlu Traceback (most recent call last): File /usr/sbin/openchange_newuser, line 66, in module openchange.newuser(lp, creds, username=args[0]) File /usr/lib/pymodules/python2.7/openchange/provision.py, line 290, in newuser res = db.search(base=user_dn, scope=SCOPE_BASE, attrs=[*]) NameError: global name 'SCOPE_BASE' is not defined Můžete mi prosím vás pomoct? Díky -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Funambol does not work
I downloaded SOGO ZEG v2.0.0 RC3 I cloned the user in LDAP. Login to the web interface was ok Then I downloaded 10.1.6 Funambol client, I set přilhašovací address and name. http://10.0.0.61/funambol/ds, I set the data source, but when I try to start the synchronization, the error message pops up Sync not completed. Network error. (Http://10.0.0.61/funambol/ds works) In previous versions it worked me. I'm doing this because I can create users for native outlook. Order of add user: Clone user in LDAP (U: P Bartl: HndkiC) samba-user tool add Bartl New password: HndkiC User's Bartl 'created successfully samba-user tool setexpiry Bartl - noexpiry openchange_newuser - create Bartl Here, the error occurs: sogo @ sogo: ~ $ sudo openchange_newuser - create Bartl Traceback (most recent call last): File / usr / sbin / openchange_newuser, line 66, in module openchange.newuser (lp, creds, username = args [0]) File / usr/lib/pymodules/python2.7/openchange/provision.py, line 290, in newuser res = db.search (base = user_dn, scope = SCOPE_BASE, attrs = [*]) NameError: global name 'SCOPE_BASE' is not defined Can you please help? thanks-- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] to better understand Sogo
Hi all, I am also trying to get the big picture about mysql tables' relationships and about the way SOGo stores data. Three default tables for each user means a lot of tables in environments like - say - 500 users: has anyone already tried to migrate the database structure to three single tables, with an extra field to match the current user? Is there any configuration option to keep the data in a more-or-less fixed number of tables? Thanks in advance for any help, suggestion and/or comment. Alberto On 28 June 2012 13:36, Nicolas - Lileo nicolas.fa...@lileo.fr wrote: Hi all, I had to do some work in the mysql database where sogo keep his datas. Anyway, i have a question about the way sogo organize the calendar and addressbook datas. I noticed that there are 3 tables for each personal calendar or each personal addressbook. 1 for acl, 1 for datas (quick) and 1 who has exactly the same structure if it's a calendar or an addressbook. My question is what is the relationship between calendar tables and adressbook table and basically how does it work? Thanks in advance -- Nicolas FABRE -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Funambol does not work
I downloaded SOGO ZEG v2.0.0 RC3 I cloned the user in LDAP. Login to the web interface was ok. Then I downloaded 10.1.6 Funambol client, I set address(http://10.0.0.61/funambol/ds) and name:password. I set the data source, but when I try to start the synchronization, the error message pops up: Sync not completed. Network error. (Http://10.0.0.61/funambol/ds works) In previous versions of sogo, it worked for me. I'm doing this because I cant create users for native outlook. So thats why i trying funambol method. Order of add user: Clone user in LDAP (User: Bartl Password: HndkiC) samba-user tool add Bartl New password: HndkiC User's Bartl 'created successfully samba-user tool setexpiry Bartl - noexpiry ok... openchange_newuser - create Bartl Here, the error occurs: sogo @ sogo: ~ $ sudo openchange_newuser - create Bartl Traceback (most recent call last): File / usr / sbin / openchange_newuser, line 66, in module openchange.newuser (lp, creds, username = args [0]) File / usr/lib/pymodules/python2.7/openchange/provision.py, line 290, in newuser res = db.search (base = user_dn, scope = SCOPE_BASE, attrs = [*]) NameError: global name 'SCOPE_BASE' is not defined I would like to see one of these methods work. Can you please help? thanks -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] to better understand Sogo
Hi, thanks for the answer, Actually i checked the foreign key relations and there is no relationships between tables... Cheers *Nicolas FABRE* Tél : 09 72 29 97 47 Tél : 02 28 08 75 24 LILEO 1 rue du Tonkin - 44000 NANTES http://www.lileo.fr Le 28/06/2012 14:18, Buddy Butterfly a écrit : Hi, if this is a proper db model then the relationships should be visible in the foreign key relations ;-) Am 28.06.2012 13:36, schrieb Nicolas - Lileo: Hi all, I had to do some work in the mysql database where sogo keep his datas. Anyway, i have a question about the way sogo organize the calendar and addressbook datas. I noticed that there are 3 tables for each personal calendar or each personal addressbook. 1 for acl, 1 for datas (quick) and 1 who has exactly the same structure if it's a calendar or an addressbook. My question is what is the relationship between calendar tables and adressbook table and basically how does it work? Thanks in advance -- *Nicolas FABRE* -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] error after updating
hello, today i decided to upgrade my sogo installation (who was working well) my server is a centos6 64 bis so i do : yum update sogo and yum update sope49-gdl1-mysql and service sogod restart and now i've an error just after authentication in sogo.log : Jun 28 17:07:55 sogod [8120]: SOGoRootPage successful login for user 'alain.defrance' - expire = -1 grace = -1 EXCEPTION: NSException: 0x2d2faf8 NAME:NSInvalidArgumentException REASON:NGLdapEntry(instance) does not recognize asDictionary INFO:(nu) what can i do ? thanks for your help Alain -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] error after updating
Hello Alain On 2012-06-28, at 11:18 AM, alain.defra...@univ-evry.fr alain.defra...@univ-evry.fr wrote: today i decided to upgrade my sogo installation (who was working well) my server is a centos6 64 bis so i do : yum update sogo and yum update sope49-gdl1-mysql and service sogod restart and now i've an error just after authentication in sogo.log : Jun 28 17:07:55 sogod [8120]: SOGoRootPage successful login for user 'alain.defrance' - expire = -1grace = -1 EXCEPTION: NSException: 0x2d2faf8 NAME:NSInvalidArgumentException REASON:NGLdapEntry(instance) does not recognize asDictionary INFO:(nu) Make sure to update *all* your SOPE packages. yum check-update | awk 'BEGIN { printf yum -y install } /(sogo|sope)/ { printf %s , $1 }' | bash Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] to better understand Sogo
Hi, really? This is unbelievable. Are we back in 1970? Do people know what a ER diagramm is (special focus should be on the R here ;-)? Am 28.06.2012 16:54, schrieb Nicolas - Lileo: Hi, thanks for the answer, Actually i checked the foreign key relations and there is no relationships between tables... Cheers *Nicolas FABRE* Tél : 09 72 29 97 47 Tél : 02 28 08 75 24 LILEO 1 rue du Tonkin - 44000 NANTES http://www.lileo.fr Le 28/06/2012 14:18, Buddy Butterfly a écrit : Hi, if this is a proper db model then the relationships should be visible in the foreign key relations ;-) Am 28.06.2012 13:36, schrieb Nicolas - Lileo: Hi all, I had to do some work in the mysql database where sogo keep his datas. Anyway, i have a question about the way sogo organize the calendar and addressbook datas. I noticed that there are 3 tables for each personal calendar or each personal addressbook. 1 for acl, 1 for datas (quick) and 1 who has exactly the same structure if it's a calendar or an addressbook. My question is what is the relationship between calendar tables and adressbook table and basically how does it work? Thanks in advance -- *Nicolas FABRE* -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Shared calendar issues
Hi, We have a shared calendar set up for all of our users under one dumm account (called admin). Several people subscribe to this calendar, and we have ACLs set so that all users can modify/add/delete entries. Some of users can view and edit the calendar fine. One can view the calendar but not add anything. A couple cannot view or edit the calendar. I've tried looking into the database, and the sogo_user_profile folder looks the same for a working and non-working user. The admin[digits]_acl for the shared calendar shows ACLs for both users. At one point I seemed to be able to solve these kinds of issues by logging in as admin to the web interface, and removing and re-adding the ACLs, and using the Subscribe User checkbox in the permissions window. I've tried this and the problem continues for both of the users above. I don't see any useful errors other than a bunch of these: 2012-06-28 11:06:27.967 sogod[1968] WARNING(-[NSNull(misc) length]): called NSNull -length (returns 0) !!! I'm not sure if they are related to my issue. Does anyone have experience in troubleshooting shared calendars? I'd be willing to share extracts of my database privately if this would help track down the problem. Thank you, Nathan Lyryx Learning Inc -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Is it possible...
To have SOGo running on one machine, with all the other services running from a Mac Server? I have an instance of OS X Server 10.6, which has LDAP, Calendar, and Mail, all running and configured. Can I point SOGo to use those services, and just have the DB and Web interface on the SOGo machine? Ben -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Thursday, June 28 2012
Title: BTS activities for Thursday, June 28 2012 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Thursday, June 28 2012 idlast updatestatus (resolution)categorysummary 1828 2012-06-28 12:15:54 updated (open) Backend Address Book CardDAV clients do not detect the Global Address Book. 1581 2012-06-28 08:51:39 updated (open) Web Mail "text/html" content type is not handled correctly by SOGO webmail UI, message shows as empty however there are text
Re: Re: [SOGo] to better understand Sogo
Hi, If you see the tables, they have same name except acl and quick add as suffix. This is the relation. Vikas On Thu, 28 Jun 2012 21:35:41 +0530 wrote Hi, really? This is unbelievable. Are we back in 1970? Do people know what a ER diagramm is (special focus should be on the R here ;-)? Am 28.06.2012 16:54, schrieb Nicolas - Lileo: Hi, thanks for the answer, Actually i checked the foreign key relations and there is no relationships between tables... Cheers Nicolas FABRE Tél : 09 72 29 97 47 Tél : 02 28 08 75 24 LILEO 1 rue du Tonkin - 44000 NANTES http://www.lileo.fr Le 28/06/2012 14:18, Buddy Butterfly a écrit: Hi, if this is a proper db model then the relationships should be visible in the foreign key relations ;-) Am 28.06.2012 13:36, schrieb Nicolas - Lileo: Hi all, I had to do some work in the mysql database where sogo keep his datas. Anyway, i have a question about the way sogo organize the calendar and addressbook datas. I noticed that there are 3 tables for each personal calendar or each personal addressbook. 1 for acl, 1 for datas (quick) and 1 who has exactly the same structure if it's a calendar or an addressbook. My question is what is the relationship between calendar tables and adressbook table and basically how does it work? Thanks in advance -- Nicolas FABRE With Regards, Vikas Sinha-- users@sogo.nu https://inverse.ca/sogo/lists