Re: [SOGo] Address Book on Postgresql
Ok, all worked. I've reimposted the sogo password and used the patch for the address book. So now i can view som data, but i need more clarifications How can I store other datas ? ( Home Phone ? fax ? address and so on ? ) Thanks in advice Il 07/02/2013 10:40, Christian Mack ha scritto: Am 2013-02-07 09:45, schrieb Dario Carbone: Ok, thanks. But don't work too, the sogo.log report : 2013-02-07 09:31:19.322 sogod[28259] PG0x0x7ffcfc9a4d80 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'testuser' AND c_folder_type = 'Contact' 2013-02-07 09:31:19.323 sogod[28259] PG0x0x7ffcfccb2140 SQL: SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%carb%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%') Feb 07 09:31:19 sogod [28259]: [ERROR] 0x0x7ffcfcc813a0[SQLSource] could not run SQL 'SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%')': PostgreSQL72Exception: 0x7ffcfcc722d0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x7ffcfccb2140[PostgreSQL72Channel]: connection=0x0x7ffcfcc9bf00[PGConnection]: connection=0x0x7ffcfccbb460): ERROR: permission denied for relation t_gab But if I so the query with the command line psql, all work. Any ideas ? ... stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string cut Are you sure you used user "sogo" with password "sogo" for psql too? That's what you instruct SOGo to use. Kind regards, Christian Mack -- Carbone Dario Primeur Customer Services S.r.l. EMAIL: dario.carb...@primeur.com URL: http://www.primeur.com Mobile: +39 3488960584
Re: [SOGo] sogo-tool expire-autoreply script
Hello, just one question to be sure : u%*master:[password] but when running manually via /usr/sbin/sogo-tool expire-autoreply %u*master:[password] I just get errors: Can we use %u in the authname ? (I don't see this in the doc). Or do we need to write a wrapper to call sogo-tool expire-autoreply for each user ? (with dovecot as imap/sieve server) David. -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] ZEG burned to ISO DVD using remastersys
I put the Zero Effort Groupware image .vmdk into bootable ISO format! I am now able to pop a Live DVD into an AMD64 machine and run ZEG on hardware rather than VMWare. I can run it as live or install it. This is handy for testing and could help build production hardware without having to start from scratch. I have used Remastersys which works best with Ubuntu. Start ZEG in VMWare. Log into the ZEG terminal with sogo/sogo Follow the Remastersys instructions for creating a Ubuntu ISO http://geekconnection.org/remastersys/ Install FTP so you can download the file to your CD burning computer apt-get install proftpd-basic ucf chose:standalone Get CuteFTP or whatever FTP package on your host computer host: sogo user: sogo pw: sogo Then download the ISO from /home/remastersys/remastersys/ Test this ISO by using it as the CD-ROM in a new virtual machine in VMWare Workstation. Burn it to DVD (too big for CD) and test on target hardware. Regards, Wayland -- Mobile: 07925 431381 Office: 01787 388165 -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] /tmp Drafts problem
Hi, I've an issue with the last version of SOGo. I'll try to explain, I'm sorry, in advance, if I'm not perfectly clear. English was not my native language. The SOGoMailSpoolPath seems to keep all mails who was previously saved in Drafts folder. When I write a mail, I can see the prototype of the mail in $SOGoMailSpoolPath/login/newDraftX/.info.plist file . And if I send it immediately, the .info.plist was delete correctly and all is good. BUT, if I save it in the Drafts folder to resume later, the .info.plist file previously created does not disappear And if I unset SOGoMailSpoolPath, the file does not delete even if i sent it immediately. Any ideas? ps: my system: cat /etc/debian_version 6.0.6 dpkg -s sogo | grep Version Version: 2.0.4b-1 dpkg -s libsope-core4.9 | grep Version Version: 4.9.r1664.20130204 Part of the SOGo config: sogod SOGoLoginModule Mail sogod SOGoDayEndTime 20 sogod SOGoSieveServer sieve://localhost:4190/?tls=YES sogod SOGoAppointmentSendEMailNotifications YES sogod SOGoSieveScriptsEnabled YES sogod SOGoTrashFolderName Trash sogod OCSEMailAlarmsFolderURL postgresql://sogo:@localhost:5432/sogo/sogo_alarms_folder sogod SOGoFoldersSendEMailNotifications YES sogod GCSFolderDebugEnabled NO sogod SOGoDebuggingEnabled NO sogod OCSSessionsFolderURL postgresql://sogo:@localhost:5432/sogo/sogo_sessions_folder sogod SOGoDayStartTime 8 sogod SOGoUserSources '( too long... )' sogod SOGoVacationEnabled YES sogod SOGoBusyOffHours YES sogod NGUseUTF8AsURLEncoding YES sogod SOGoPageTitle 'Webmail - Université Paris-Est - Marne-la-Vallée' sogod SOGoProfileURL postgresql://sogo:@localhost:5432/sogo/sogo_user_profile sogod SOGoLanguage French sogod OCSFolderManagerSQLDebugEnabled NO sogod SOGoSentFolderName Sent sogod NGImap4DisableIMAP4Pooling NO sogod WODebugZipResponse NO sogod SOGoMailingMechanism smtp sogod SOGoForceIMAPLoginWithEmail NO sogod SOGoAuthenticationMethod LDAP sogod SOGoPasswordChangeEnabled YES sogod SOGoMailAuxiliaryUserAccountsEnabled YES sogod SOGoMailShowSubscribedFoldersOnly YES sogod SOGoDraftsFolderName Drafts sogod SOGoForwardEnabled YES sogod SOGoEnableEMailAlarms YES sogod SOGoACLsSendEMailNotifications YES sogod SOGoUIxDebugEnabled NO sogod SoDebugObjectTraversal NO sogod SoSecurityManagerDebugEnabled NO sogod GCSFolderStoreDebugEnabled NO sogod NGImap4ConnectionStringSeparator / sogod SOGoMailComposeMessageType html sogod LDAPDebugEnabled NO sogod SOGoDoNotRedirectRootPage NO sogod SOGoUIxAdditionalPreferences YES sogod SOGoIMAPAclConformsToIMAPExt YES sogod SOGoAuthenticationType sogo sogod SOGoSuperUsernames '( admin )' sogod SOGoTimeZone Europe/Paris sogod SOGoCASServiceURL https://cas.univ-mlv.fr/ sogod SOGoMailDomain univ-mlv.fr sogod SOGoMailSpoolPath /tmp sogod SOGoSMTPServer smtp.univ-mlv.fr sogod SOGoMailMessageCheck every_5_minutes sogod SOGoMailCustomFromEnabled NO sogod SOGoIMAPServer imap://localhost:143/?tls=YES sogod SOGoTrustProxyAuthentication NO sogod SOGoFirstDayOfWeek 1 sogod SOGoMemcachedHost 127.0.0.1 sogod SOGoFirstWeekOfYear First4DayWeek sogod SOGoNotifyOnExternalModifications YES sogod OCSFolderInfoURL postgresql://sogo:@localhost:5432/sogo/sogo_folder_info sogod SOGoMailSortByThreads NO sogod SOGoSupportedLanguages '( French, English )' sogod SOGoDebugRequests NO sogod PGDebugEnabled NO -- Vishaal Golam - Centre de Ressources Informatiques Université de Marne-la-Vallée - Citée Descartes 5 bd Descartes Champs-sur-Marne - 77454 Marne-la-Vallée Cedex 2 Tél : +33 (0)1 60 95 74 55 Fax : 74 60 E-mail : vishaal.go...@univ-mlv.fr -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Carddav setup help
I'm not sure at all, which log do I check? From: t...@surety-networks.com Date: Sun, 17 Feb 2013 10:01:06 -0500 To: users@sogo.nu Subject: Re: [SOGo] Carddav setup help Is the traffic making it to the appliance? - Troy shafert...@surety-networks.com On Feb 16, 2013, at 1:42 PM, K B tallk...@hotmail.com wrote: I've just installed the ZEG 2.0.4 appliance in Virtualbox, and trying to set up BB10 using CardDav. I'm getting an error saying account so...@example.com can't be authenticated. I can't find the logs where any messages would be regarding this error. Any help would be appreciated. I'm assuming I don't need to do any extra configuring to ZEG 2.0.4 to get carddav working? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Address Book on Postgresql
Am 2013-02-18 11:39, schrieb Dario Carbone: Il 07/02/2013 10:40, Christian Mack ha scritto: Am 2013-02-07 09:45, schrieb Dario Carbone: Ok, thanks. But don't work too, the sogo.log report : 2013-02-07 09:31:19.322 sogod[28259] PG0x0x7ffcfc9a4d80 SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'testuser' AND c_folder_type = 'Contact' 2013-02-07 09:31:19.323 sogod[28259] PG0x0x7ffcfccb2140 SQL: SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%carb%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%') Feb 07 09:31:19 sogod [28259]: [ERROR] 0x0x7ffcfcc813a0[SQLSource] could not run SQL 'SELECT * FROM t_gab WHERE (LOWER(c_cn) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%' OR LOWER(mail) LIKE '%testuser%')': PostgreSQL72Exception: 0x7ffcfcc722d0 NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x7ffcfccb2140[PostgreSQL72Channel]: connection=0x0x7ffcfcc9bf00[PGConnection]: connection=0x0x7ffcfccbb460): ERROR: permission denied for relation t_gab But if I so the query with the command line psql, all work. Any ideas ? ... stringpostgresql://sogo:sogo@localhost:5432/sogo_gab/t_gab/string cut Are you sure you used user sogo with password sogo for psql too? That's what you instruct SOGo to use. Ok, all worked. I've reimposted the sogo password and used the patch for the address book. So now i can view som data, but i need more clarifications How can I store other datas ? ( Home Phone ? fax ? address and so on ? ) You should look at the specification for the ldap class inetOrgPerson. It has the attributes: description fax, facsimileTelephoneNumber interationaliSDNNumber l, localityName physicalDeliveryOfficeName postalAddress postalCode postOfficeBox registeredAddress st, stateOrProviceName street, streetAddress telephoneNumber telexNumber displayName departmentNumber homePhone, homeTelephoneNumber homePostalAddress jpegPhoto (deprecated) labeledURI mail mobile, mobileTelephoneNumber o, organizationName pager, pagerTelephoneNumber photo roomNumber I didn't test them all, but most of them should be shown in the address book. But be aware that multivalue entries (e.g. mail) are only shown once. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Problem First time installing sogo on Ubuntu 12.04
Do you know if the ZEG appliance can be cloned to a real server easily? (the Ubuntu one already set up with outlook mapi) I was thinking just dumping the virtual machine's hard disk image to a ghost image etc... then just ghosting that over to a real hard drive, sticking it into the server and seeing if it boots. That way I just have to mess with configs. -K -Original Message- From: Steve Ankeny [mailto:stev...@cinergymetro.net] Sent: Saturday, February 16, 2013 6:49 AM To: users@sogo.nu Subject: Re: [SOGo] Problem First time installing sogo on Ubuntu 12.04 Did you install 'sope?' And, have you considered the ZEG appliance? It would give you a good test before doing it yourself. On 02/15/2013 09:05 PM, administrator wrote: Hey guys, I'm trying to install sogo for the first time. I want to rip apart my exchange 2010 server(s). They have proven very unstable, no matter what you do. This morning for no reason mail stopped flowing all together, no errors in the logs, only a reboot fixed it. I'm tired of getting calls in the morning. Time to format and try something new. -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] /tmp Drafts problem
Hello Vishaal Golam Am 2013-02-18 15:04, schrieb GOLAM Vishaal: ... The SOGoMailSpoolPath seems to keep all mails who was previously saved in Drafts folder. No, it will save draft emails there before saving them into the Drafts folder of the user. AFAIK this is in order to get better performance. When I write a mail, I can see the prototype of the mail in $SOGoMailSpoolPath/login/newDraftX/.info.plist file . And if I send it immediately, the .info.plist was delete correctly and all is good. BUT, if I save it in the Drafts folder to resume later, the .info.plist file previously created does not disappear As you didn't send it that is normal behaviour. When you send it later, it will disappear. And if I unset SOGoMailSpoolPath, the file does not delete even if i sent it immediately. That is because if you unset SOGoMailSpoolPath, SOGo will use its default /tmp as SOGoMailSpoolPath. As that is not the same path you used before, it can't delete the existing one, because it doesn't know about it. Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problem First time installing sogo on Ubuntu 12.04
Take a look at the thread: ZEG burned to ISO DVD using remastersys https://inverse.ca/sogo/lists/arc/users/2013-02/msg00229.html Somewhere in that process you should be able to come up with a process that works for you. I do not know if it can be 'ghosted,' but I do not doubt that it could. It appears to me that converting the ZEG to an ISO is an ideal way to use it as a bootable DVD or as an alternative to installing it natively instead of keeping with the virtual machine concept. On 02/18/2013 11:11 AM, administrator wrote: Do you know if the ZEG appliance can be cloned to a real server easily? (the Ubuntu one already set up with outlook mapi) I was thinking just dumping the virtual machine's hard disk image to a ghost image etc... then just ghosting that over to a real hard drive, sticking it into the server and seeing if it boots. That way I just have to mess with configs. -K -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] ZEG: Outlook 2003 worked only once
DNS problem? 2013/2/17 Wayland Sothcott wayl...@sothcott.co.uk On 17/02/2013 17:16, Wayland Sothcott wrote: Matthias Gasser mailing@... writes: to amend something more useful: here is the output of the samba.log: http://pastie.org/5451961 It seems there is an issue with the kinit (kerberos) -Matthias On 28.11.2012, at 21:54, der.keim@... wrote: Hi, With the ZEG installation, I connected via Outlook 2003 to Sogo. It worked for the first time quite nice (except of missing sender names). But then no connection was possible anymore, a restart of sogo did also not help. Which log file should I investigate? What could have happened? Keim -- users@... https://inverse.ca/sogo/lists I have ZEG running and can email between sogo1 and sogo2 between two web browsers. However when I attached Outlook 2003 as per the Client instructions; To configure Outlook: It would not send emails nor show emails received by sogo1. On the 2nd booting of Outlook it simply hangs. Regards, Wayland. OK, getting a bit further with this. The email side of Outlook 2003 seems stable. However Contacts - Personal Address Book says The set of folders is unavailable. The server is not available -- Mobile: 07925 431381 Office: 01787 388165 -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Carddav setup help
The first place I'd start is pinging the appliance then a port scan to ensure its available on that port. If those come back fine then it could be a sogo auth issue that someone more experienced could answer. I'm still learning it myself. - Troy Shafer t...@surety-networks.com On Feb 18, 2013, at 10:36 AM, K B tallk...@hotmail.com wrote: I'm not sure at all, which log do I check? From: t...@surety-networks.com Date: Sun, 17 Feb 2013 10:01:06 -0500 To: users@sogo.nu Subject: Re: [SOGo] Carddav setup help Is the traffic making it to the appliance? - Troy Shafer t...@surety-networks.com On Feb 16, 2013, at 1:42 PM, K B tallk...@hotmail.com wrote: I've just installed the ZEG 2.0.4 appliance in Virtualbox, and trying to set up BB10 using CardDav. I'm getting an error saying account so...@example.com can't be authenticated. I can't find the logs where any messages would be regarding this error. Any help would be appreciated. I'm assuming I don't need to do any extra configuring to ZEG 2.0.4 to get carddav working? -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problem First time installing sogo on Ubuntu 12.04
Don't overlook the power of a virtual machine! We take regular snapshots of our configuration, so as to be able to return if needed. It does not backup the mail by itself but it allows us to backup/restore within minutes if something should happen (power outage, etc.) It helped us when we did the upgrade from Ubuntu 11.04 to 12.04 It's a powerful way to backup/restore a system. We're using VMware ESXi 5 as the base OS for our HP Proliant (with two instances of Windows Server 2008 and the ZEG), but VirtualBox works as well. On 02/18/2013 11:11 AM, administrator wrote: Do you know if the ZEG appliance can be cloned to a real server easily? (the Ubuntu one already set up with outlook mapi) I was thinking just dumping the virtual machine's hard disk image to a ghost image etc... then just ghosting that over to a real hard drive, sticking it into the server and seeing if it boots. That way I just have to mess with configs. -K -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Printing question (font) ....
When printing the calendar, we get a font error: This is a screenshot of a PDF printed from the Weekly Planner layout. I've tried editing the 'Advanced' printing options, but it would appear it's picking up the wrong font on the server side (i.e., within the ZEG) Would installing other fonts correct the error? It's being printed from within a Windows Remote Desktop, so it should be using Windows fonts.
Re: [SOGo] /tmp Drafts problem
Le Lundi 18 Février 2013 17:34 CET, Christian Mack christian.m...@uni-konstanz.de a écrit: As you didn't send it that is normal behaviour. When you send it later, it will disappear. That's the problem. The plist file was not delete and /tmp/ cumulates old (saved-)sent mails of all users! Can anybody confirm that bugs ? Thx. -- Vishaal Golam - Centre de Ressources Informatiques Université de Marne-la-Vallée - Citée Descartes 5 bd Descartes Champs-sur-Marne - 77454 Marne-la-Vallée Cedex 2 Tél : +33 (0)1 60 95 74 55 Fax : 74 60 E-mail : vishaal.go...@univ-mlv.fr -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Problem First time installing sogo on Ubuntu 12.04
Since EXI/ESXI? Server didn't work with my own hardware, I built a massive monster set of servers with a core i7 24+ GB ram each, WIN2K8 Hosts, running Vmware server 2.0. However nightly windows backups of about 10 VM's really takes a strain on vmware server's performance, so for brief periods machines become undersponsive during that time. I was messing around with virtualbox 4.2 in headless mode so I can measure how much better the performance is, plus I can assign an unlimited number of cpu cores and it's free. ESX server is just linux with a hypervisor on top anyways, nothing really native about it like they say it is, so I'm assuming virtualbox will have similar performance on Ubuntu 12.04. The other benefit will be the linux block level caching that windows doesn't have. The unusual requirement that is a bit too much for a VM is the fact that we have jumbo shared inboxes (Shipping/Support etc...) where each one has about 10 people using the same box simultaneously, and they do searches all the time when the DB's are 200GB+ sometimes. Mail is just one of those things that I want to completely isolate from my active directly and windows infrastructure now. Since we only have about 10 actual email accounts anyways. This way if the domain controller isn't up before the mail server, there's no messed up authentication, etc... This is a problem I often have when it comes to windows, having too many things relying on each other makes for headaches after power outages etc. Windows updates being the worst. So the idea is one independent box, it's own Open LDAP, it's own DNS (copying my internal zone from my windows dns) and then deleting my existing mail servers. At some point, if I find Ubuntu is a stable active directory replacement, get rid of each windows server one by one (if possible). For vm's at least the hosts being Ubuntu also. -K -Original Message- From: Steve Ankeny [mailto:stev...@cinergymetro.net] Sent: Monday, February 18, 2013 12:10 PM To: users@sogo.nu Subject: Re: [SOGo] Problem First time installing sogo on Ubuntu 12.04 Don't overlook the power of a virtual machine! We take regular snapshots of our configuration, so as to be able to return if needed. It does not backup the mail by itself but it allows us to backup/restore within minutes if something should happen (power outage, etc.) It helped us when we did the upgrade from Ubuntu 11.04 to 12.04 It's a powerful way to backup/restore a system. We're using VMware ESXi 5 as the base OS for our HP Proliant (with two instances of Windows Server 2008 and the ZEG), but VirtualBox works as well. On 02/18/2013 11:11 AM, administrator wrote: Do you know if the ZEG appliance can be cloned to a real server easily? (the Ubuntu one already set up with outlook mapi) I was thinking just dumping the virtual machine's hard disk image to a ghost image etc... then just ghosting that over to a real hard drive, sticking it into the server and seeing if it boots. That way I just have to mess with configs. -K -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Problem First time installing sogo on Ubuntu 12.04
10VMs are a lot of nightly backup! We use VMware ESXi 5 on an HP Proliant (24GB RAM, AMD Quad-Core, 1.2T) with the following: Windows Server 2008R2 RDC (every user connects with RDP) Windows Server 2008R2 SQL (our accounting apps use MS-SQL) SOGo ZEG (starting as Ubuntu 11.04 now 12.04 and latest 'sogo) It sounds like you need to simplify your architecture (with only 10 accounts) (we have 8 accounts) Converting the ZEG to an ISO would allow you to install it with more disk space (to facilitate the shared accounts that require a large amount of disk space) Maybe that's where the savings should come! A large disk space requirement in a VM still requires a lot of resources for backup. It appears the size of the shared mailboxes precludes doing backups of snapshots. We are not using Active Directory or Samba (we want to use Samba4 domain functions) Right now, authentication is strictly by LDAP on the 'sogo' box, but each Windows machine requires accounts. Domain functions will simply allow us to synchronize account parameters, and we're not there yet. It may not matter whether you use VMware or VirtualBox, but if it can be installed natively via the ISO, that might work better for disk space needs. Maybe you can point the shared mailboxes to a separate storage server? It might make backup easier to do incremental backups of the mailboxes only. Or, just do a mirror on the separate storage server? We define 'dns' on our gateway and ip_phone devices (6-7 phones, 15-20 ip_addresses plus wlan) We have a separate storage server which we use for backup (Novaback on the Windows side) We've taken 'dns' and other network services away from the Windows boxes, but we define the printers via the Remote Desktop Connection (terminal services) on the Windows RDC Server. Everybody uses the same applications (with some lockdown on certain apps or files/folders) Our ZEG does 'ldap' authentication and mail services. We want to use it as a Samba domain later, but we will have to install Samba4 (as it was not originally in the ZEG) and configure user accounts. We're using a mix of Windows 7 and (two) Linux Mint clients. We have one PIII-386 Linux Thinstation that works better than the Windows clients! It's amazing. It sounds like the bottleneck in your environment are the large shared mail accounts. Move them to a separate storage server (point the mailboxes via 'webmin') and you should free up resources. Just a thought On 02/18/2013 03:20 PM, administrator wrote: Since EXI/ESXI? Server didn't work with my own hardware, I built a massive monster set of servers with a core i7 24+ GB ram each, WIN2K8 Hosts, running Vmware server 2.0. However nightly windows backups of about 10 VM's really takes a strain on vmware server's performance, so for brief periods machines become undersponsive during that time. I was messing around with virtualbox 4.2 in headless mode so I can measure how much better the performance is, plus I can assign an unlimited number of cpu cores and it's free. ESX server is just linux with a hypervisor on top anyways, nothing really native about it like they say it is, so I'm assuming virtualbox will have similar performance on Ubuntu 12.04. The other benefit will be the linux block level caching that windows doesn't have. The unusual requirement that is a bit too much for a VM is the fact that we have jumbo shared inboxes (Shipping/Support etc...) where each one has about 10 people using the same box simultaneously, and they do searches all the time when the DB's are 200GB+ sometimes. Mail is just one of those things that I want to completely isolate from my active directly and windows infrastructure now. Since we only have about 10 actual email accounts anyways. This way if the domain controller isn't up before the mail server, there's no messed up authentication, etc... This is a problem I often have when it comes to windows, having too many things relying on each other makes for headaches after power outages etc. Windows updates being the worst. So the idea is one independent box, it's own Open LDAP, it's own DNS (copying my internal zone from my windows dns) and then deleting my existing mail servers. At some point, if I find Ubuntu is a stable active directory replacement, get rid of each windows server one by one (if possible). For vm's at least the hosts being Ubuntu also. -K -- users@sogo.nu https://inverse.ca/sogo/lists
RE: [SOGo] Problem First time installing sogo on Ubuntu 12.04
Thanks, Currently I do have them on a different storage server :) The first 2010 exchage is a vm (client access), the second 2010 exchange is solely for storage. Currently I don't have a storage bottleneck (raid 10 does miracles with cheap Samsung spinpoint drives and an areca controller). That's good that sogo has built in users, that's all I cared for anyways as far as using the active directory. I'd rather the sogo box be up if everything else windows suddenly dies. The advantage will be taking the storage server and throwing sogo on it by itself and removing the other exchange vm. I just created a sogo live iso, I'm not seeing it boot to an installer though... just drops me to the prompt after booting (wich is good at least). It's using the linux-generic kernel wich is also really good so it will boot on anything. I'm considering doing a tar backup inside the sogo vm, then restoring the backup to my fresh 10.04 box and overwrite the whole thing over the network. Does anyone else have any comments on outlook performance on huge 100GB+ mailboxes? And if there's any kind of limit as to the maximum size of a mailbox or database? -Original Message- From: Steve Ankeny [mailto:stev...@cinergymetro.net] Sent: Monday, February 18, 2013 4:38 PM To: users@sogo.nu Subject: Re: [SOGo] Problem First time installing sogo on Ubuntu 12.04 10VMs are a lot of nightly backup! We use VMware ESXi 5 on an HP Proliant (24GB RAM, AMD Quad-Core, 1.2T) with the following: Windows Server 2008R2 RDC (every user connects with RDP) Windows Server 2008R2 SQL (our accounting apps use MS-SQL) SOGo ZEG (starting as Ubuntu 11.04 now 12.04 and latest 'sogo) It sounds like you need to simplify your architecture (with only 10 accounts) (we have 8 accounts) Converting the ZEG to an ISO would allow you to install it with more disk space (to facilitate the shared accounts that require a large amount of disk space) Maybe that's where the savings should come! A large disk space requirement in a VM still requires a lot of resources for backup. It appears the size of the shared mailboxes precludes doing backups of snapshots. We are not using Active Directory or Samba (we want to use Samba4 domain functions) Right now, authentication is strictly by LDAP on the 'sogo' box, but each Windows machine requires accounts. Domain functions will simply allow us to synchronize account parameters, and we're not there yet. It may not matter whether you use VMware or VirtualBox, but if it can be installed natively via the ISO, that might work better for disk space needs. Maybe you can point the shared mailboxes to a separate storage server? It might make backup easier to do incremental backups of the mailboxes only. Or, just do a mirror on the separate storage server? We define 'dns' on our gateway and ip_phone devices (6-7 phones, 15-20 ip_addresses plus wlan) We have a separate storage server which we use for backup (Novaback on the Windows side) We've taken 'dns' and other network services away from the Windows boxes, but we define the printers via the Remote Desktop Connection (terminal services) on the Windows RDC Server. Everybody uses the same applications (with some lockdown on certain apps or files/folders) Our ZEG does 'ldap' authentication and mail services. We want to use it as a Samba domain later, but we will have to install Samba4 (as it was not originally in the ZEG) and configure user accounts. We're using a mix of Windows 7 and (two) Linux Mint clients. We have one PIII-386 Linux Thinstation that works better than the Windows clients! It's amazing. It sounds like the bottleneck in your environment are the large shared mail accounts. Move them to a separate storage server (point the mailboxes via 'webmin') and you should free up resources. Just a thought On 02/18/2013 03:20 PM, administrator wrote: Since EXI/ESXI? Server didn't work with my own hardware, I built a massive monster set of servers with a core i7 24+ GB ram each, WIN2K8 Hosts, running Vmware server 2.0. However nightly windows backups of about 10 VM's really takes a strain on vmware server's performance, so for brief periods machines become undersponsive during that time. I was messing around with virtualbox 4.2 in headless mode so I can measure how much better the performance is, plus I can assign an unlimited number of cpu cores and it's free. ESX server is just linux with a hypervisor on top anyways, nothing really native about it like they say it is, so I'm assuming virtualbox will have similar performance on Ubuntu 12.04. The other benefit will be the linux block level caching that windows doesn't have. The unusual requirement that is a bit too much for a VM is the fact that we have jumbo shared inboxes (Shipping/Support etc...) where each one has about 10 people using the same box simultaneously, and they do searches all the time when the DB's are 200GB+ sometimes.
[SOGo] BTS activities for Monday, February 18 2013
Title: BTS activities for Monday, February 18 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Monday, February 18 2013 idlast updatestatus (resolution)categorysummary 2246 2013-02-18 11:08:41 updated (open) Backend General Set password lifetime without ppolicy overlay in LDAP 2247 2013-02-18 15:52:10 updated (open) Web Mail Support for mailto links with subject and body included in URL
