Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8
On 15.10.20 22:04, Götz Reinicke wrote: > But in the sogo database there is the for some entries the database URL saved, > which is set in the sogo.conf. Oh. Didn't know that. Sorry. > So dumping the database on host „mysql-server01“ and importing it at > „new-mysqlserver“ will break all entries! > > This would only work, if the database server dose not has an other name. (I > should have created an DNS alias for it in the past) Maybe it is easier to replace the oldname in the dumpfile before importing it rather than setting up DNS? Something like: sed -e 's/oldname/newname/g' dump.sql -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Howto Migrating database to new database server? Mysql 5.6 => MySQL 8
On 12.10.20 16:00, Götz Reinicke wrote: > (...) > I guess you talk about the database dump? As the database server name will > change, I can’t use the „old“ dump anymore I think. When dumping your database with mysqldump then there is no hostname of the database server in the dump because the hostname is set when mysqldump establishes the connecion, e.g. `mysqldump -h hostname dbname` So you are safe to import this dumpfile on another host. -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] AD LDAP SOGoUserSources
its always easier to brak a complex problem down into small parts.
For AD auth with sogo I would suggest to install some ldap command
line client and test if I can access ldap first.
And if this is working then in the next step configure sogo with
the same auth params.
> Am 25.01.2019 um 10:14 schrieb Rowland Penny (rpenny241...@gmail.com)
> :
>
> On Thu, 24 Jan 2019 14:48:01 -0800
> "Carl Doss" (cd...@bahaicenter.net) wrote:
>
>
>>>
On 1/24/2019 1:28 PM, Matthew Valdez (maval...@ludlums.com) wrote:
Hello,
I am trying to setup the SOGoUserSources by using Active Directory
and LDAP and for some reason I cannot seem to get it to work. I am
able to login if I use the type SQL, but cannot seem to get it to
work with ldap. Any help would be appreciate, this is what I have
for SOGoUserSources, of course modified a little to share with you
all.
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
IDFieldName = uid;
UIDFieldName = uid;
baseDN= "cn=Users,dc=domain,dc=local";
bindDN =
"cn=sogo,cn=Users,dc=domain,dc=local";
bindPassword= password;
canAuthenticate = YES;
displayName= "Shared Addresses";
hostname= "ldap://dns.dc.local:389;;
id = public;
isAddressBook = YES;
}
);
>
> Taking this:
>
> cn=Users,dc=domain,dc=local
>
> and this:
>
> ldap://dns.dc.local:389
>
> into account, is the FQDN of the AD DC really
> 'dns.dc.local' ?
>
> To put it another way, they do not match, 'dc=domain,dc=local' will
> come from your dns domain 'domain.local' so the 'hostname' should be
> 'ldap://' or 'ldap://.domain.local'
>
> Rowland
>
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
--
users@sogo.nu
https://inverse.ca/sogo/lists
AW: [SOGo] Unicode characters in the headers
Mmmh - afaik sogo encodes everything wellm Did you examine whether the email you received is converted to plain text format or a different encoding by a virus scanner or such problems like that? Originalnachricht Von: André Rodier (an...@rodier.me) Gesendet: Samstag, 24. November 2018 23:21 An: users@sogo.nu Antwort an: users@sogo.nu Betreff: Re: [SOGo] Unicode characters in the headers On 2018-11-24 13:21, André Rodier wrote: > Hello, > I am using SOGo 3 on Debian Stretch. > When an email alert for a calendar event is sent to me by SOGo, my > name (André Rodier) is displayed as this: "=?utf-8?q?Andr=C3=A9?= > Rodier" > How can I avoid this,? > Thanks for your help. > > André Rodier This might be a bug in SOGo, as the header is encoded twice with the quoted-printable scheme. Here the source of the original message: --- Return-Path: Received: from osaka.rodier.me by osaka.office.pmc with LMTP id eAczFqbJ+VuoZQAAnYgw/w ; Sat, 24 Nov 2018 21:59:02 + Received: from osaka.rodier.me (localhost [127.0.0.1]) by osaka.rodier.me (Postfix) with ESMTP id 45BF2208D3 for ; Sat, 24 Nov 2018 21:59:02 + (GMT) Received: from localhost (localhost [127.0.0.1]) by osaka.rodier.me (Postfix) with ESMTP id 25BC6208CD for ; Sat, 24 Nov 2018 21:59:02 + (GMT) To: =?utf-8?q?=3D=3Futf-8=3Fq=3FAndr=3DC3=3DA9=3F=3D_Rodier?= X-Priority: 1 Subject: Yo Importance: high MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <6668-5bf9c9a6-1-1bbecc54@189782116> Content-Type: text/plain; charset="utf-8" From: =?utf-8?q?=3D=3Futf-8=3Fq=3FAndr=3DC3=3DA9=3F=3D_Rodier?= Date: Sat, 24 Nov 2018 21:59:02 + User-Agent: SOGo Alarms Notifier/1.0 X-AV-Checked: ClamSMTP (Client IP: 127.0.0.1) eryhwhw wrthwthwthwht wrthwthwhwthw --- As a result, the email client displays the "To" field decoded once, which left an encoded header. This is only happening when the reminders are sent, not when an event is created. -- https://github.com/progmaticltd/homebox -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
AW: [SOGo] Performance BD (Mysql or Postgres)
I would suggest you to keep on using postgresql. Because as you have said there is already a Postgresql instance running in your company and that's why I think your IT team is already familiar with postgresql and no new workflows has to be established (e.G. Database backup). We are running sogo with postgresql in the company too. Von: "Miguel Mucio Santos Moreira" (mig...@prodemge.gov.br)pGesendet: Sonntag, 25. November 2018 02:10An: users@sogo.nuAntwort an: users@sogo.nuBetreff: AW: [SOGo] Performance BD (Mysql or Postgres)Hello Marcus, first of all, thanks for your quick answer, secondly I'll complete my work collegue's e-mail for more information about our enviroment and necessities.Nowadays we have an enviroment with the followings components:Cyrus-Imap Agregator, being 5 Frontends and 5 BackendsPostfix servers for SMTP and submission protocolOpenldap servers PostrgeSQL data base Apache Web ServersWe use as application a Groupware called expressobr, It is almost completly based on tine20 germany Groupware and we support around 10k users.Oficial SOGo document instalation has a PostrgeSQL approach then because of that and also because our enviroment, we are asking about any kind of recommendation regards database performance, specially If there is any favourite between PostgreSQL and MySQL.Best wishes.Thankful--Miguel MoreiraGerenteDPR/SRE/GSR - Gerência de Serviços de Rede+55(31)3339-1401PRODEMGE - Companhia de Tecnologia da Informação do Estado de Minas GeraisAviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. Em Sábado, Novembro 24, 2018 09:23 -02, 'Michael Hekeler' (mich...@hekeler.com) escreveu: 'Performance'...regarding what? For example if you don't know how to use mysql but are confident with postgresql then postgresql 'performs' much better for you.Von: 'Wilton Cesar Goncalves' (wilton.goncal...@prodemge.gov.br)Gesendet: Freitag, 23. November 2018 15:30An: users@sogo.nuAntwort an: users@sogo.nuBetreff: [SOGo] Performance BD (Mysql or Postgres) Hello, I'm installing SOGo in my company and I'd like to know what BD is better in performance Mysql or Postgres? Thanks,-- Wilton César GonçalvesGSR - Gerência de Serviços de RedeCompanhia de Tecnologia da Informação do Estado de Minas Gerais - PRODEMGE Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. --users@sogo.nuhttps://inverse.ca/sogo/lists--users@sogo.nuhttps://inverse.ca/sogo/lists -- users@sogo.nuhttps://inverse.ca/sogo/lists -- users@sogo.nuhttps://inverse.ca/sogo/lists
AW: [SOGo] Performance BD (Mysql or Postgres)
"Performance"...regarding what? For example if you don't know how to use mysql but are confident with postgresql then postgresql "performs" much better for you. Von: "Wilton Cesar Goncalves" (wilton.goncal...@prodemge.gov.br)Gesendet: Freitag, 23. November 2018 15:30An: users@sogo.nuAntwort an: users@sogo.nuBetreff: [SOGo] Performance BD (Mysql or Postgres)Hello, I'm installing SOGo in my company and I'd like to know what BD is better in performance Mysql or Postgres? Thanks,-- Wilton César GonçalvesGSR - Gerência de Serviços de RedeCompanhia de Tecnologia da Informação do Estado de Minas Gerais - PRODEMGE Aviso: Esta mensagem é destinada exclusivamente para a(s) pessoa(s) a quem é dirigida, podendo conter informação sigilosa e legalmente protegida. O uso impróprio será tratado conforme as normas da empresa e a legislação em vigor. Caso não seja o destinatário, favor notificar o remetente, ficando proibidas a utilização, divulgação, cópia e distribuição. -- users@sogo.nuhttps://inverse.ca/sogo/lists -- users@sogo.nuhttps://inverse.ca/sogo/lists
Re: [SOGo] SOGo Login problem
Hi, because your user is able to login into the sogo server, I would assume that your problem is that your webserver is not cofigured correctly and sends wrong/insufficient headers. Please check. Do you have an apache server proxying? nginx? On Tue, Oct 23, 2018 at 05:38:22PM +0100, Andrew Farmer wrote: > Hi, > > I am trying to migrate to a new SOGo server and have it mostly > working. I'm able to access my calendar from Lightning/Thunderbird > but I can't login to the web GUI. The login screen accepts my login > ID and password but, without giving any error, it simply goes back > to the login page. > > Looking at the logs, I seem to be getting logged in OK and then > some session info is written to the PGSQL database. However, I then > see the following in the logfile: > Oct 23 17:32:14 sogod [7321]: |SOGo| starting method 'GET' on uri > '/SOGo/so/arf' > Oct 23 17:32:14 sogod [7321]: |SOGo| traverse(acquire): arf > Oct 23 17:32:14 sogod [7321]: |SOGo| do traverse name: 'arf' > Oct 23 17:32:14 sogod [7321]: |SOGo| traverse miss: name=arf, > acquire: i=0,count=1 > Oct 23 17:32:14 sogod [7321]: |SOGo| miss is last object. > Oct 23 17:32:14 sogod [7321]: |SOGo| handle miss error: > NAME:SoAuthRequired > REASON:authentication required > > Does this mean anything to anyone? Any idea where I can start to > look at what's going on? > > Thanks very much (full logs below), > > Andy Farmer > Films at 59 > Bristol, UK > > > Oct 23 17:32:13 sogod [7321]: |SOGo| starting method 'POST' on uri > '/SOGo/connect' > Oct 23 17:32:13 sogod [7321]: |SOGo| traverse(acquire): SOGo => connect > Oct 23 17:32:13 sogod [7321]: |SOGo| do traverse name: 'SOGo' > Oct 23 17:32:13 sogod [7321]: |SOGo| do traverse name: 'connect' > Oct 23 17:32:13 sogod [7321]: |SOGo| set clientObject: > > Oct 23 17:32:13 sogod [7321]: <0x0x55c4b46c8fe0[NGLdapConnection]> > Using ldap_init (deprecated) for LDAP host:port localhost:389 > Oct 23 17:32:13 sogod [7321]: SOGoRootPage successful login from > '192.0.2.231' for user 'arf' - expire = -1 grace = -1 > Oct 23 17:32:13 sogod [7321]: <0x0x55c4b47775e0[NGLdapConnection]> > Using ldap_init (deprecated) for LDAP host:port localhost:389 > 2018-10-23 17:32:13.491 sogod[7321] -[NGLdapConnection > _searchAtBaseDN:qualifier:attributes:scope:]: search at base > 'ou=users,dc=filmsat59,dc=com' filter '(|(uid=arf)(mail=arf))' for > attrs '*' > 2018-10-23 17:32:13.495 sogod[7321] PostgreSQL72 connection > established: <0x0x55c4b477b140[PGConnection]: > connection=0x0x55c4b4782660> > 2018-10-23 17:32:13.495 sogod[7321] PostgreSQL72 channel > 0x0x55c4b452f7c0 opened (connection=<0x0x55c4b477b140[PGConnection]: > connection=0x0x55c4b4782660>) > 2018-10-23 17:32:13.498 sogod[7321] PostgreSQL72 connection > established: <0x0x55c4b415e270[PGConnection]: > connection=0x0x55c4b4784c70> > 2018-10-23 17:32:13.498 sogod[7321] PostgreSQL72 channel > 0x0x55c4b45b3c70 opened (connection=<0x0x55c4b415e270[PGConnection]: > connection=0x0x55c4b4784c70>) > 2018-10-23 17:32:13.498 sogod[7321] PG0x0x55c4b45b3c70 SQL: BEGIN > TRANSACTION > 2018-10-23 17:32:13.498 sogod[7321] PG0x0x55c4b45b3c70 SQL: SELECT > t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM > sogo_sessions_folder t1 WHERE t1.c_id='br0gWfYRXc1mLHrKuyM0hg==' > 2018-10-23 17:32:13.500 sogod[7321] PG0x0x55c4b45b3c70 SQL: ROLLBACK > TRANSACTION > 2018-10-23 17:32:13.500 sogod[7321] PG0x0x55c4b452f7c0 SQL: BEGIN > TRANSACTION > 2018-10-23 17:32:13.500 sogod[7321] PG0x0x55c4b452f7c0 SQL: INSERT > INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, > c_id) VALUES (1540312333, 1540312333, > '6lfuX0RuOSZa81vKsOohsgagpSgm33PWXnpfgZ8B+RjzvYnkkG4fKuY7DOTJkXXKY4oiRNC1hlz9ttSWHm/oyEQfTTWJ9oL9ikjPIvdj41Ajcmz+86RZ0VdkDMlzF7oHqCeZpIJMarADBNRJ6+lSYCmG0pvrFwH67CbSuDoICdriNCCgheXZjY5kGLupV5mKJK+m4sXTByh3LGr0IbGiUw==', > 'br0gWfYRXc1mLHrKuyM0hg==') > 2018-10-23 17:32:13.501 sogod[7321] PG0x0x55c4b452f7c0 SQL: COMMIT > TRANSACTION > 2018-10-23 17:32:13.503 sogod[7321] PG0x0x55c4b45b3c70 SQL: SELECT > c_settings FROM sogo_user_profile WHERE c_uid = 'arf' > Oct 23 17:32:13 sogod [7321]: |SOGo| request took 0.015663 seconds > to execute > Oct 23 17:32:13 sogod [7321]: 192.0.2.231 "POST /SOGo/connect > HTTP/1.1" 200 50/58 0.017 - - 0 > Oct 23 17:32:14 sogod [7321]: |SOGo| starting method 'GET' on uri > '/SOGo/so/arf' > Oct 23 17:32:14 sogod [7321]: |SOGo| traverse(acquire): arf > Oct 23 17:32:14 sogod [7321]: |SOGo| do traverse name: 'arf' > Oct 23 17:32:14 sogod [7321]: |SOGo| traverse miss: name=arf, > acquire: i=0,count=1 > Oct 23 17:32:14 sogod [7321]: |SOGo| miss is last object. > Oct 23 17:32:14 sogod [7321]: |SOGo| handle miss error: > NAME:SoAuthRequired > REASON:authentication required > Oct 23 17:32:14 sogod [7321]: |SOGo| request took 0.012267 seconds > to execute > Oct 23 17:32:14 sogod [7321]: 192.0.2.231 "GET /SOGo/so/arf > HTTP/1.1" 200 26945/0 0.014 - - 0 > -- > users@sogo.nu > https://inverse.ca/sogo/lists --
[SOGo] Who is using SOGo?
Hello list, I found SOGo, tested it and like it. I want to deploy SOGo in our company. I'm looking for some resources/papers/website/... with lists like "who is using SOgo?" I mean which companies/organization/communities uses SOGo. I need that to show my boss that "serious organizations" rely on SOGo... Can someone help me? -- users@sogo.nu https://inverse.ca/sogo/lists
