Re: [SOGo] SQL errors on funambol sync, what am i doing wrong?
Oh, forgot to mention I too have a multi-domain configuration. Bug filed: http://www.sogo.nu/bugs/view.php?id=2260 smime.p7s Description: S/MIME Cryptographic Signature
[SOGo] Can't Find instructions to change the Mail domain from the ZEG default
Hi Everyone, When I installed the ZEG appliance I could not find a way to change the Mail domain so that I could use the system. I then set about trying to install from scratch using various guides. After the 6th unsuccessful install (there were different points of failure) I found a reference indicating the online guides are out of date and that the ZEG appliance was indeed the correct way to experiment/trial. Does anyone have either a completed guide for either A) an install that will act as a single (no pre-existing LDAP or AD) exchange replacement with MS Outlook as client OR b) how to change the appliance's name to be used with a real domain? (I imagine there are a number of places to change it) PS: This seems to be a fairly obvious use of the software so I'm *SURE* the answer exists, I've just given up trying to find it after 2 days of failing (; Regards, Dave -- -- Dave Osbourne -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] SOGo MySQL bug
I found this notification on Olivier's tutorial Due to a small bug in SOGo, it's strongly recommended to use PostGreSQL and not Mysql. What bug? Where is it? Is it major? I mean as per SOGo official documentation, I went with MySQL, it says it is supported. Should I move away from MySQL then? Can I not use sogo and MySQL in production? Regards, Netwodist -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
I have also been interested in how this can be done. We started with a previous ZEG built on Ubuntu 11.04 and SOGo 1.3.10 Since we had little experience in Linux configuration (specifically, 'ldap' and 'postfix'), we paid Inverse to complete the configuration. IF I understand correctly, SOGo is capable of multi-domain configuration, so it may be as simple as creating a secondary domain (not a child domain) alongside (and then removing) 'example.com' Adding SOGoMailDomain to GNUstepDefaults (pg. 14-16) The 'fly in the ointment' is likely to be 'ldap' and Samba4 You will have to create your domain in those services first (or concurrently) before creating the mail domain in SOGo You will also have to create users and mailboxes in 'cyrus' (not difficult) We created Linux users first, but it's not necessary. I am faced now with adding Samba4 It's not a necessity for us but an enhancement. I would think someone with a bit of experience with 'ldap' and 'samba' could do the work. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL bug
Mysql usage causes the following bug : http://tracker.openchange.org/issues/413 and craches Samba4. Best regards. Olivier. 2013/3/2 Netwodist netwod...@gmail.com I found this notification on Olivier's tutorial Due to a small bug in SOGo, it’s strongly recommended to use PostGreSQL and not Mysql. What bug? Where is it? Is it major? I mean as per SOGo official documentation, I went with MySQL, it says it is supported. Should I move away from MySQL then? Can I not use sogo and MySQL in production? Regards, Netwodist -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
Ah - ok the plot thinckens. I've now found someone else who had that done by Inverse. The LDAP doesn't bother me too much, through the 6 builds I did Yesterday I figured out what is likely necessary in there, what I 'm *NOT* sure about is whether LDAP is even necessary... http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf; seem to imply no LDAP necessary since Samba will do the job. However, looking in the appliance both Samba and LDAP are running. root@sogo:~# ps -ef | grep slapd openldap 968 1 0 09:20 ?00:00:00 /usr/sbin/slapd -h ldap://127.0.0.1:3389/ -g openldap -u openldap -F /etc/ldap/slapd.d root@sogo:~# ps -ef | grep samba root 515 1 0 09:20 ?00:00:00 samba -D ... root 577 515 0 09:20 ?00:00:00 samba -D I'm not so much concerned with the how to change/add my test domain as I am with getting a list of all the places that it needs to be changed/added. I wonder if someone from Inverse would be willing to send the steps (it might that this is a revenue stream so I'd fully understand if not)? D On 2013-03-02 13:04, stev...@cinergymetro.net wrote: I have also been interested in how this can be done. We started with a previous ZEG built on Ubuntu 11.04 and SOGo 1.3.10 Since we had little experience in Linux configuration (specifically, 'ldap' and 'postfix'), we paid Inverse to complete the configuration. IF I understand correctly, SOGo is capable of multi-domain configuration, so it may be as simple as creating a secondary domain (not a child domain) alongside (and then removing) 'example.com' Adding SOGoMailDomain to GNUstepDefaults (pg. 14-16) The 'fly in the ointment' is likely to be 'ldap' and Samba4 You will have to create your domain in those services first (or concurrently) before creating the mail domain in SOGo You will also have to create users and mailboxes in 'cyrus' (not difficult) We created Linux users first, but it's not necessary. I am faced now with adding Samba4 It's not a necessity for us but an enhancement. I would think someone with a bit of experience with 'ldap' and 'samba' could do the work. -- -- Dave Osbourne -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL bug
So, it's not really a SOGo bug? It's a Samba/OpenChange bug involving MySQL? By the way, I appreciate your tutorial. It's a yeoman's job, and you performed it well. On 03/02/2013 08:44 AM, Olivier Bitsch wrote: Mysql usage causes the following bug : http://tracker.openchange.org/issues/413 and craches Samba4. Best regards. Olivier. 2013/3/2 Netwodist netwod...@gmail.com mailto:netwod...@gmail.com I found this notification on Olivier's tutorial Due to a small bug in SOGo, it’s strongly recommended to use PostGreSQL and not Mysql. What bug? Where is it? Is it major? I mean as per SOGo official documentation, I went with MySQL, it says it is supported. Should I move away from MySQL then? Can I not use sogo and MySQL in production? Regards, Netwodist -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
I'd welcome the same (i.e., the steps involved to change the domain) When I considered adding Samba to the ZEG (pre-Samba4), Inverse told me I could configure Samba to authenticate against 'ldap' (leaving 'ldap' configuration intact) or authenticate against 'pam' Presumably, with Samba4, I could authenticate within Samba itself. So, I think you have a choice. It would seem that the list of places starts with where you choose to authenticate. On 03/02/2013 09:27 AM, Dave wrote: Ah - ok the plot thinckens. I've now found someone else who had that done by Inverse. The LDAP doesn't bother me too much, through the 6 builds I did Yesterday I figured out what is likely necessary in there, what I 'm *NOT* sure about is whether LDAP is even necessary... http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf; seem to imply no LDAP necessary since Samba will do the job. However, looking in the appliance both Samba and LDAP are running. root@sogo:~# ps -ef | grep slapd openldap 968 1 0 09:20 ?00:00:00 /usr/sbin/slapd -h ldap://127.0.0.1:3389/ -g openldap -u openldap -F /etc/ldap/slapd.d root@sogo:~# ps -ef | grep samba root 515 1 0 09:20 ?00:00:00 samba -D ... root 577 515 0 09:20 ?00:00:00 samba -D I'm not so much concerned with the how to change/add my test domain as I am with getting a list of all the places that it needs to be changed/added. I wonder if someone from Inverse would be willing to send the steps (it might that this is a revenue stream so I'd fully understand if not)? D -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL bug
Mysql is used by Sogo, but when OpenChange/Samba4 tried to send some information to Sogo, it get this error then give a Panic. You have to restart again Samba4, but the error is back after 1 minutes each time. Olivier. 2013/3/2 Steve Ankeny stev...@cinergymetro.net So, it's not really a SOGo bug? It's a Samba/OpenChange bug involving MySQL? By the way, I appreciate your tutorial. It's a yeoman's job, and you performed it well. On 03/02/2013 08:44 AM, Olivier Bitsch wrote: Mysql usage causes the following bug : http://tracker.openchange.org/issues/413 and craches Samba4. Best regards. Olivier. 2013/3/2 Netwodist netwod...@gmail.com I found this notification on Olivier's tutorial Due to a small bug in SOGo, it’s strongly recommended to use PostGreSQL and not Mysql. What bug? Where is it? Is it major? I mean as per SOGo official documentation, I went with MySQL, it says it is supported. Should I move away from MySQL then? Can I not use sogo and MySQL in production? Regards, Netwodist -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL bug
Il 3/2/13 3:52 PM, Olivier Bitsch ha scritto: Mysql is used by Sogo, but when OpenChange/Samba4 tried to send some information to Sogo, it get this error then give a Panic. You have to restart again Samba4, but the error is back after 1 minutes each time. Can we assume that installations which does not use samba4 at all are not affected by the bug ? Thx -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL bug
Of course, if you don't use Samba4/OpenChange, you will probably not affected by the bug. Olivier 2013/3/2 Davide Bozzelli bu...@olografix.org Il 3/2/13 3:52 PM, Olivier Bitsch ha scritto: Mysql is used by Sogo, but when OpenChange/Samba4 tried to send some information to Sogo, it get this error then give a Panic. You have to restart again Samba4, but the error is back after 1 minutes each time. Can we assume that installations which does not use samba4 at all are not affected by the bug ? Thx -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
Presumably, with Samba4, I could authenticate within Samba itself. So, I think you have a choice. Indeed, I see on the appliance Samba is on the ldap port and ldap is on 3389, but since this is an *appliance* why install something no one is going to use (what would be added to the LDAP on 3389?) and if it is to integrate with an existing ldap server then that isn't in the appliance. I'm still confused. It would seem that the list of places starts with where you choose to authenticate. It might start there, but it's going to be #everything else# too. I found this, which looked promising:- http://tracker.openchange.org/projects/1/wiki/HowTo_build_your_own_OpenChangeSOGo_appliance But after following it (it's not 100% accurate) as a do to list rather than copy and paste it sort of worked until the ldap section. Predictably I get no global superior knowledge since *my* domain isn't in the ldap DB already (there are steps missing). I'm back to square one. Eliciting a list of places to change the domain in the appliance seems to be the only option. Here is my attempt at a list based on my knowledge so far (I still find it hard to believe this hasn't been done already, but are now 4 people asking this same question and you can't all be as stupid as me at googling (; ) 1/ .GNUstepDefault (text edit) 2/ postfix/main.cf (text edit) 3/ LDAP Directory (this will have to be a dump, text edit re-import I think) and Samba, Cyrus, Webmin, Funambol, Apache, Mysql/Postgress David On 2013-03-02 14:50, Steve Ankeny wrote: I'd welcome the same (i.e., the steps involved to change the domain) When I considered adding Samba to the ZEG (pre-Samba4), Inverse told me I could configure Samba to authenticate against 'ldap' (leaving 'ldap' configuration intact) or authenticate against 'pam' On 03/02/2013 09:27 AM, Dave wrote: Ah - ok the plot thinckens. I've now found someone else who had that done by Inverse. The LDAP doesn't bother me too much, through the 6 builds I did Yesterday I figured out what is likely necessary in there, what I 'm *NOT* sure about is whether LDAP is even necessary... http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf; [1] seem to imply no LDAP necessary since Samba will do the job. However, looking in the appliance both Samba and LDAP are running. root@sogo:~# ps -ef | grep slapd openldap 968 1 0 09:20 ? 00:00:00 /usr/sbin/slapd -h ldap://127.0.0.1:3389/ [2] -g openldap -u openldap -F /etc/ldap/slapd.d root@sogo:~# ps -ef | grep samba root 515 1 0 09:20 ? 00:00:00 samba -D ... root 577 515 0 09:20 ? 00:00:00 samba -D I'm not so much concerned with the how to change/add my test domain as I am with getting a list of all the places that it needs to be changed/added. I wonder if someone from Inverse would be willing to send the steps (it might that this is a revenue stream so I'd fully understand if not)? D Links: -- [1] http://www.sogo.nu/files/docs/SOGo%20Native%20Microsoft%20Outlook%20Configuration.pdf -- -- Dave Osbourne -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
As I understand the ZEG: (1) SOGo authenticates against the users defined in the LDAP server. You can clone the 'sogo' user via Webmin and create additional LDAP users. You then create Cyrus mailboxes, and in the ZEG, LDAP users can access their mailbox. Once you create the new mail domain (via GNUstepDefaults), you can associate each user with it. (2) SOGo is designed to replace Exchange Server. THAT's why it authenticates against an LDAP Server (in my opinion) (or as it works for me) You can choose authentication against PAM or MySQL or an existing Active Directory, but you've moved beyond the ZEG, and as I understand the ZEG, it's meant to be a complete solution when configured. The only issue is creating the new LDAP domain and identifying it in SOGo (3) The inclusion of Samba4 in the ZEG is designed to replace Active Directory. You can use it or not. IF you use the Samba Server, you can join your clients to a domain. The only gotcha I see is how you authenticate the Samba users with LDAP or PAM (or with Samba itself) We run the ZEG as an Exchange Server replacement. It provides mailboxes and calendar services. How the mail domain was created is still a bit fuzzy to me, but I believe it involves LDAP mostly. All the rest of it comes together in the ZEG On 03/02/2013 11:41 AM, Dave wrote: Presumably, with Samba4, I could authenticate within Samba itself. So, I think you have a choice. Indeed, I see on the appliance Samba is on the ldap port and ldap is on 3389, but since this is an *appliance* why install something no one is going to use (what would be added to the LDAP on 3389?) and if it is to integrate with an existing ldap server then that isn't in the appliance. I'm still confused. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
It seems to me this point to the need to configure/reconfigure the LDAP Server on the ZEG AFTER configuring LDAP to recognize your mail domain, add it to GNUstepDefaults That should get you 90+% there. I'm drawing from my memory of what Inverse did for us (and a slew of e-mails exchanged between the Inverse tech and myself) (which are not readable to anyone else) I can tell you how to create mailboxes in Cyrus, and I can tell you how to clone the 'sogo' user in Webmin, but I cannot tell you how to create the mail domain (as I do not understand LDAP) And, by the way, from my previous research into LDAP (which included openSuSE, CentOS and Ubuntu), LDAP is an odd beast to begin with, and each iteration seems to change the '.conf' files. It keeps me confused! Like you, I'd still like a step-by-step from Inverse. On 03/02/2013 11:41 AM, Dave wrote: I found this, which looked promising:- http://tracker.openchange.org/projects/1/wiki/HowTo_build_your_own_OpenChangeSOGo_appliance But after following it (it's not 100% accurate) as a do to list rather than copy and paste it sort of worked until the ldap section. Predictably I get no global superior knowledge since *my* domain isn't in the ldap DB already (there are steps missing). -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
You might be able to use text edit However, you should use: su - sogo defaults write sogod SOGoMailDomain acme.com Pg. 14, et seq. On 03/02/2013 11:41 AM, Dave wrote: Here is my attempt at a list based on my knowledge so far (I still find it hard to believe this hasn't been done already, but are now 4 people asking this same question and you can't all be as stupid as me at googling (; ) 1/ .GNUstepDefault (text edit) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: Re: [SOGo] how change example.com form the ZEG
OK, I've done this a few times. There is an easy way of doing this, but it involves changing the domain name in a few different places. I'll dig out my notes and will post shortly. -- Scott -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
OK, I've done this a few times. There is an easy way of doing this, but it involves changing the domain name in a few different places. I'll dig out my notes and will post shortly. -- Scott On 03/02/2013 09:32 AM, Steve Ankeny wrote: It seems to me this point to the need to configure/reconfigure the LDAP Server on the ZEG AFTER configuring LDAP to recognize your mail domain, add it to GNUstepDefaults That should get you 90+% there. I'm drawing from my memory of what Inverse did for us (and a slew of e-mails exchanged between the Inverse tech and myself) (which are not readable to anyone else) I can tell you how to create mailboxes in Cyrus, and I can tell you how to clone the 'sogo' user in Webmin, but I cannot tell you how to create the mail domain (as I do not understand LDAP) And, by the way, from my previous research into LDAP (which included openSuSE, CentOS and Ubuntu), LDAP is an odd beast to begin with, and each iteration seems to change the '.conf' files. It keeps me confused! Like you, I'd still like a step-by-step from Inverse. On 03/02/2013 11:41 AM, Dave wrote: I found this, which looked promising:- http://tracker.openchange.org/projects/1/wiki/HowTo_build_your_own_OpenChangeSOGo_appliance But after following it (it's not 100% accurate) as a do to list rather than copy and paste it sort of worked until the ldap section. Predictably I get no global superior knowledge since *my* domain isn't in the ldap DB already (there are steps missing). -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
Kool! On 03/02/2013 01:14 PM, ScottJ wrote: OK, I've done this a few times. There is an easy way of doing this, but it involves changing the domain name in a few different places. I'll dig out my notes and will post shortly. -- Scott -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
OK, this is what I did in the past to change the ZEG domain name. I
haven't done a lot of testing on the Samba side, so I'm not sure if
there are some changes I missed there. I have some scripts I'm updating
for user management (add/remove, etc) that I'll post once they're done.
-- Scott
ZEG DOMAIN CHANGE
--
DO THIS AT YOUR OWN RISK! Make sure you have a backup/snapshot just in
case you want to rollback if
things go wrong and something bad happens.
o Login as root (sudo -s)
o Stop the LDAP service: root@sogo:~# service slapd stop
o Backup the existing LDAP Database: root@sogo:~# slapcat -v -l
sogo_orig.ldif
o Create a new LDAP data file: root@sogo:~# sed 's/example/newdom/g'
sogo_orig.ldif sogo_new.ldif
where newdom is the new domain name (don't include the )
o If you need to change .com use:
root@sogo:~# sed -e 's/example/newdom/g' -e 's/com/new_gTLD/g'
sogo_orig.ldif sogo_new.ldif
again, new_gTLD is org, net, etc.
o If you need to add additional domain extensions (eg - newdom.org.ca),
you'll need to edit
the sogo_new.ldif file manually
o Edit the file: /etc/ldap/slapd.d/cn=config/olcDatabase={1}hdb.ldif
and replace all example with your new domain name and replace com
with the different gTLD
if needed. Again, if you need additional domain extensions, you'll
need to add those to this
file. Finally, remove the CRC line (2nd line). If you don't you'll
get an error during the
LDAP import
o Remove (or rename) the existing LDAP database: root@sogo:~# rm -r
/var/lib/ldap/*
o Import the new LDAP data file: root@sogo:~# slapadd -v -l sogo_new.ldif
-- You should see *no* errors
o Change the ownership of the new LDAP database files (if not, LDAP
won't run):
root@sogo:~# chown -R openldap: /var/lib/ldap
o Edit /etc/mailname and /etc/saslauthd.conf and replace example with
the new domain
o Edit /etc/postfix/main.cf - Replace example in myhostname with
the new domain
o Edit /etc/postfix/people.ldap - Replace example in search_base
with the new domain
o Update GNUstep:
root@sogo:~# defaults write sogod SOGoTimeZone your_time_zone
(eg - ~# defaults write sogod SOGoTimeZone US/Pacific)
root@sogo:~# defaults write sogod SOGoMailDomain newdom.com
o Edit /home/sogo/GNUstep/Defaults/.GNUstepDefaults and replace all
example entries
with the new domain
o Reboot the ZEG and your new domain name is now in place. The sogo1,
sogo2, and sogo3 users are
still available in the new domain.
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] how change example.com form the ZEG
Very good, Scott! Thanks. I am fine now, but I will test this at some point (and, I'm sure there're others who will do so as well) The steps look familiar to me and confirm my suspicion that it starts with 'ldap' As for 'samba,' you could configure 'samba' to authenticate against 'ldap,' and it would work. You could then use 'samba' as a domain controller and authenticate against the existing 'ldap' database. On 03/02/2013 04:05 PM, Scott Jordahl wrote: OK, this is what I did in the past to change the ZEG domain name. I haven't done a lot of testing on the Samba side, so I'm not sure if there are some changes I missed there. I have some scripts I'm updating for user management (add/remove, etc) that I'll post once they're done. -- Scott ZEG DOMAIN CHANGE -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGo MySQL bug
On 13-03-02 8:44 AM, Olivier Bitsch wrote: Mysql usage causes the following bug : http://tracker.openchange.org/issues/413 and craches Samba4. have you tried with recent nightlies? (~1 week old) Mysql should Just Work (tm) with sogo and samba/openchange. Best regards. Olivier. 2013/3/2 Netwodist netwod...@gmail.com mailto:netwod...@gmail.com I found this notification on Olivier's tutorial Due to a small bug in SOGo, it’s strongly recommended to use PostGreSQL and not Mysql. What bug? Where is it? Is it major? I mean as per SOGo official documentation, I went with MySQL, it says it is supported. Should I move away from MySQL then? Can I not use sogo and MySQL in production? Regards, Netwodist -- 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
[SOGo] BTS activities for Saturday, March 02 2013
Title: BTS activities for Saturday, March 02 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Saturday, March 02 2013 idlast updatestatus (resolution)categorysummary 2260 2013-03-02 06:30:59 new (open) Backend General SQL errors on funambol sync
