Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Steve Ankeny

What about MariaDB 10.0?  I don't see a libs package.

On 04/09/2015 11:54 AM, Gilles Gagniard wrote:

Hello,

I think this is actually linked to the recent mariadb upgrade, not because of 
mariadb-server, but because of mariadb-libs ie the client side.

Here is where it fails (there is a could not allocate MySQL4 connection error 
in the logs) :

https://github.com/inverse-inc/sope/blob/6452ca58fbd7ee4850ae06bd7228a4feeb21441b/sope-gdl1/MySQL/MySQL4Channel.m#L143

mysql_init() is just doing some client-side initialization (such as setting up 
threads on so on), which fails.
No actual connection attempt has been done yet ! This is done at a later stage 
by mysql_real_connect().

So here is the list of workarounds that can be ruled out :
- This is not related to credentials or privileges or actual database content 
(we have not even tried to connect to the mysql server at this stage)
- Changing the server to older/newer mariadb or even mysql cannot help with 
this issue (same reason than above)

The only thing that could actually be tried is to downgrade mariadb-libs to 
5.5.35 which is the client sogo uses.

Gilles

Le Jeudi 9 Avril 2015 16:28 CEST, Alessandro Briosi a...@metalit.com a écrit:



Il 09/04/2015 15:03, Jeroen Beerstra ha scritto:

The only thing I haven't tried is mysql, postgresql and mariadb both have the 
same problem. So I don't think it's related to changes in recent mariadb

Just a wild guess here (or a long shot if you prefere :P ).
Could it be that the name resolution is not pointing to the correct
host, or that the daemons for some reason are listening only on
localhost (127.0.0.1) so the connection fails?
Have you tried with the host IP?

Ciao.
Alessandro



--
users@sogo.nu
https://inverse.ca/sogo/lists







--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Jeroen Beerstra
As said, same problem when I use the local Lan hostname. The host file hasn't 
changed. 

My guess is a software version problem somewhere since multiple users report 
having updated to centos 7.1, as have I

Op 9 apr. 2015 18:59 schreef Steve Ankeny stev...@cinergymetro.net:

 actually, I'd agree . . . 

 You use 'localhost'  What about using 127.0.0.1?  And, since it worked 
 once, has hosts file changed? 

 On 04/09/2015 10:28 AM, Alessandro Briosi wrote: 
  
  Il 09/04/2015 15:03, Jeroen Beerstra ha scritto: 
  The only thing I haven't tried is mysql, postgresql and mariadb both have 
  the same problem. So I don't think it's related to changes in recent 
  mariadb 
  Just a wild guess here (or a long shot if you prefere :P ). 
  Could it be that the name resolution is not pointing to the correct 
  host, or that the daemons for some reason are listening only on 
  localhost (127.0.0.1) so the connection fails? 
  Have you tried with the host IP? 
  
  Ciao. 
  Alessandro 
  
  
  

 -- 
 users@sogo.nu 
 https://inverse.ca/sogo/lists 
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Bug: Incorrect Apache config file in Debian/Ubuntu packages

2015-04-09 Thread Charles Marcus
On 4/9/2015 1:01 AM, Zhang Huangbin z...@iredmail.org wrote:
 On Apr 9, 2015, at 10:30 AM, Zhang Huangbin z...@iredmail.org wrote:

 Ubuntu 14.x, and upcoming Debian 8 ship Apache-2.4, there's no
 /etc/apache2/conf.d/ anymore, SOGo.conf should be installed under
 /etc/apache2/conf.d/conf-available/, and enabled with command
 'a2enconf SOGo'.

 Sorry, typo error, the new directory is /etc/apache2/conf-available/.

Methinks you should go open a formal bug for these kinds of things?

-- 
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Jeroen Beerstra
The only thing I haven't tried is mysql, postgresql and mariadb both have the 
same problem. So I don't think it's related to changes in recent mariadb 

Op 9 apr. 2015 14:32 schreef Steve Ankeny stev...@cinergymetro.net:

 (1) try MariaDB 10.x 

 (2) move back to MySQL 

 (3) try PostgreSQL 


 On 04/09/2015 07:30 AM, schif...@polytech.unice.fr wrote: 
  I made this new user with no more results. The only changes are the url in 
  my logs, like : 
  [ERROR] 0x0x7f2dcac33220[GCSChannelManager] could not open channel 
  MySQL4Channel[0x0x7f2dcb017190] connection=0x(null) for 
  mysql://host.org/sogo/sogo_sessions_folder 
  
  So as you can see, the problem is still the same : for joining the 
  sessions_folder table, SOGo seems to not use the login/password and the 
  port. 

 -- 
 users@sogo.nu 
 https://inverse.ca/sogo/lists 
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] rpcproxy not installed?

2015-04-09 Thread FoxNET
hello
Already tested, it does not work, by cons for it and I just made a nice 
discovery frankly, I found this link and it works in Outlook 2013 without 
installing OpenChange / Samba and iRedMail

http://www.iredmail.org/docs/activesync.outlook.html 
http://www.iredmail.org/docs/activesync.outlook.html

Michel


 Le 9 avr. 2015 à 13:39, Gerald Brandt g...@majentis.com a écrit :
 
 On 2015-04-08 5:10 PM, Scott Jordahl wrote:
 me third.
 
 Thanks Ludovic for getting us closer to having this available. Very much 
 looking forward to trying it out 
 
 On 04/08/2015 02:55 PM, Steve Ankeny wrote:
 me neither . . . 
 
 On 04/08/2015 04:15 PM, Gerald Brandt wrote: 
 Nope, hadn't seen that.  I knew previous version didn't have it, but it 
 was mentioned it would be back in place by 2.2.14.  Hopefully in 2.2.18.  
 I can't move ahead without it. 
 
 Gerald 
 
 
 Anyone try the zentyal rpcproxy package with a standard inverse repo install?
 
 Gerald
 
 
 -- 
 This message has been scanned for viruses and 
 dangerous content by MailScanner http://www.mailscanner.info/, and is 
 believed to be clean.



smime.p7s
Description: S/MIME cryptographic signature


Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Jeroen Beerstra
Not sure, I also tried switching from mariadb to postgresql. Same errors :(

From the looks of it this is what happens:
- sogo tries to connect to the db without the sogo user/pwd and ofcourse
this doesn't work
- sogo suspends the db connection for 5 seconds
- result = access denied or object not found

mvg,

Jeroen Beerstra

Op 09-04-15 om 02:27 schreef Ulrich Maurus:
 I run into the same problem last week when upgrading from CentOS 7 to
 CentOS 7.1, which I found a bit stealthy, since the repo links stay
 the same. But a lot of base as well as epel packages are having a major
 upgrades. I am using IPA for authentication with SOGO / Dovecot and that
 went from 3.2 to 4.1, fortunately without a major glitch (up to now :-).
 
 But the SOGO / SOPE49 interface to mariadb / mysql seems to have at
 least intermittent connection problems after the upgrade. It tried to
 backout - go to the older version - for gnustep-base/-make/-filesystem
 from the jaille-sogo repository without luck.
 
 My final solution was to switch the DB from mysql/mariadb to postgreql.
 The combination sogo / sope49 / gnustep from the pre-packaged jaile-sogo
 repo, CentOS  postresql (9.2.10) from the most recent update repo works
 stable since last week.
 
 I found a hint on google that the mysql4 calls / interface  are no
 longer fully supported with MySQL / mariadb 5. At least the problem on
 my server were intermittent so I could access one account via the WEB
 interface after each sogo restart and export teh calendar / contacts
 into text files. As soon as I tried to switch the user account or access
 via the Thunderbird connector things went south... For larger databases
 (I have 14 accounts) a mysql export - postgresql import might be
 feasible. (A short test using phpmysqadmin / phppgadmin did not work...)
 
 Fortunately I use the DB only for the SOGO calendar / contact
 information. The user authentication as well as mail accounts are
 administrated by (Free)IPA bundled with CentOS which provides a LDAP
 (via ldapsearch) as well as pam.d (via sssd) interface.
 
 Kind regards
 
 Uli Maurus
 
 
 On 08/04/15 04:43 PM, Jeroen Beerstra wrote:
 Yes CentOS 7.1, I used to just use newer gnustep-make and gnustep-base
 from either fedora or epel, but guess this doens't work anymore.

 Bad news is I can't get the sogu.nu provided srpms counterparts to
 compile, guess they are just too old for 7 :(

 mvg,

 Jeroen Beerstra

 Op 09-04-15 om 00:19 schreef Schifano Alexandre:
 On 08/04/2015 22:45, Gilles Gagniard wrote: Hello !
 Same issue here. Are you still running your sogo install on centos 7
 by any chance ?
 On my side the only significant change I did is to yum update, which
 upgraded my box to the recently released centos 7.1, which among other
 things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too
 before restarting your server ...
 I tried to rebuild everything in case there is some binary
 compatibility issue, but to no avail.
 Gilles

 Hi,

 I used CentOS 7. After my server reboot I did a yum update and I'm now
 with a CentOS 7.1.
 I tried the new binaries available in the SOGo repository, with the same
 result.

 On 08/04/2015 22:26, Steve Ankeny wrote:
 (1) What version of MariaDB are you using?

 (2) Are you using anything else such as Samba 4 LDAP with MariaDB?

 (3) What are you using for SOGoUserSources?

 I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine.

 I rebooted over the weekend for a kernel upgrade, and I've had no problems.

 My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as
 yours.

 I had an issue creating the OpenChange MySQL user as
 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did
 not like the single quotes.  Once I removed those, everything worked fine.

 I had thought that was the case with the SOGo MySQL user, but it was
 created without single quotes.

 I wonder if it has to do with the MariaDB version?

 Hi,

 I have MariaDB 5.5.41, with no LDAP and no Samba. My user
 authentification is done throught the SQL backend.

 On 04/08/2015 03:55 PM, Jeroen Beerstra wrote:
 Exact same problem here, SOGo used to work just fine and now it doesn't.
 Tried everything I could think of, including altering db host user pwd
 and even recompiling since I´d seen some OS updates.

 also see mysql://localhost/sogo/sogo_sessions_folder in the sogo log,
 while this is defined and used to work as
 mysql://sogo:sogo@localhost:3306/sogo/sogo_sessions_folder

 This is driving me nuts :( Something is clearly broken, if only the log
 would provide some more clou...

 mvg,

 Jeroen Beerstra

 Op 08-04-15 om 15:35 schreef schif...@polytech.unice.fr:
 I tried this and it changed nothing.

 I read more carefully my logd and I saw this before the error previously
 quoted :
 Apr 08 17:12:52 sogod [992]: SOGoRootPage successful login from
 '127.0.0.1' for user 'USER' - expire = -1  grace = -1
 2015-04-08 15:12:52.871 sogod[992] ERROR((null)): could not allocate
 

RE: [SOGo] Ready to go 'Appliance'?

2015-04-09 Thread Milos Jariabka
+1 for Zentyal

-Message d'origine-
De : users-requ...@sogo.nu [mailto:users-requ...@sogo.nu] De la part de heupink
Envoyé : mercredi 8 avril 2015 17:57
À : users@sogo.nu
Objet : Re: [SOGo] Ready to go 'Appliance'?

Or take a look at:
http://www.zentyal.org/

On 4/8/2015 14:41, Jeff Folk wrote:
 On Apr 8, 2015, at 6:51 AM, Charles Marcus wrote:
 Hello all,

 Are there any ready to go 'Appliances' available (totally free or 
 not) for the full SOGo+Samba AD environment that I could point a 
 friend to, who is looking to get off the Microsoft money train?

 Preferably a Debian Stable based one.

 We would prefer a totally free solution, but would not mind one that 
 had an initial cost where he was paying for the work done to provide 
 the 'ready to go' environment, and/or provided a paid support option, 
 but he wants something that doesn't cost 'per-user' or 'per-domain', 
 and that won't 'stop working' if he decided to stop renewing the paid 
 support option in the future.

 Thanks,

 Charles


 I'm not aware of a Debian based 'appliance', but you might have a look at 
 NethServer:

 http://www.nethserver.org

 User management, email, gateway router, SOGo module, etc. I'm using it and 
 like it so far.

 Cheers,
 Jeff

--
users@sogo.nu
https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Ulrich Maurus
I first had issues with postgresql as well but realized it was caused by
the different user authentication. Fortunately there were entries in the
postgresql log and the root cause was that postgresql may / can use
ident as authentication.

For sogo it looks like the DB access is done by user apache from the
WEB interface. In this case the configuration of
/var/lib/pgsql/data/pg_hba.conf is crucial. For me it works if the first
entry (line) are:

hostsogosogo127.0.0.1/32md5
local   sogosogomd5

If I get it right the authentication depends on the order of the lines
inside the file. And if the default entry (pgl 9.2.10 / CentOS 7_1503)

hostall all 127.0.0.1/32ident

comes first SOGo from teh WEB UI will fail since system user apache is
by default not authorized to access the SOGo database.

In this respect PostgreSQL is a bit more tricky then mysql...

The SOGo log messages look very similar to the mysql problem since it's
DB access problem as well.

Mfg

UlI Maurus


On 09/04/15 03:06 AM, Jeroen Beerstra wrote:
 Not sure, I also tried switching from mariadb to postgresql. Same errors :(

 From the looks of it this is what happens:
 - sogo tries to connect to the db without the sogo user/pwd and ofcourse
 this doesn't work
 - sogo suspends the db connection for 5 seconds
 - result = access denied or object not found

 mvg,

 Jeroen Beerstra

 Op 09-04-15 om 02:27 schreef Ulrich Maurus:
 I run into the same problem last week when upgrading from CentOS 7 to
 CentOS 7.1, which I found a bit stealthy, since the repo links stay
 the same. But a lot of base as well as epel packages are having a major
 upgrades. I am using IPA for authentication with SOGO / Dovecot and that
 went from 3.2 to 4.1, fortunately without a major glitch (up to now :-).

 But the SOGO / SOPE49 interface to mariadb / mysql seems to have at
 least intermittent connection problems after the upgrade. It tried to
 backout - go to the older version - for gnustep-base/-make/-filesystem
 from the jaille-sogo repository without luck.

 My final solution was to switch the DB from mysql/mariadb to postgreql.
 The combination sogo / sope49 / gnustep from the pre-packaged jaile-sogo
 repo, CentOS  postresql (9.2.10) from the most recent update repo works
 stable since last week.

 I found a hint on google that the mysql4 calls / interface  are no
 longer fully supported with MySQL / mariadb 5. At least the problem on
 my server were intermittent so I could access one account via the WEB
 interface after each sogo restart and export teh calendar / contacts
 into text files. As soon as I tried to switch the user account or access
 via the Thunderbird connector things went south... For larger databases
 (I have 14 accounts) a mysql export - postgresql import might be
 feasible. (A short test using phpmysqadmin / phppgadmin did not work...)

 Fortunately I use the DB only for the SOGO calendar / contact
 information. The user authentication as well as mail accounts are
 administrated by (Free)IPA bundled with CentOS which provides a LDAP
 (via ldapsearch) as well as pam.d (via sssd) interface.

 Kind regards

 Uli Maurus


 On 08/04/15 04:43 PM, Jeroen Beerstra wrote:
 Yes CentOS 7.1, I used to just use newer gnustep-make and gnustep-base
 from either fedora or epel, but guess this doens't work anymore.

 Bad news is I can't get the sogu.nu provided srpms counterparts to
 compile, guess they are just too old for 7 :(

 mvg,

 Jeroen Beerstra

 Op 09-04-15 om 00:19 schreef Schifano Alexandre:
 On 08/04/2015 22:45, Gilles Gagniard wrote: Hello !
 Same issue here. Are you still running your sogo install on centos 7
 by any chance ?
 On my side the only significant change I did is to yum update, which
 upgraded my box to the recently released centos 7.1, which among other
 things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too
 before restarting your server ...
 I tried to rebuild everything in case there is some binary
 compatibility issue, but to no avail.
 Gilles

 Hi,

 I used CentOS 7. After my server reboot I did a yum update and I'm now
 with a CentOS 7.1.
 I tried the new binaries available in the SOGo repository, with the same
 result.

 On 08/04/2015 22:26, Steve Ankeny wrote:
 (1) What version of MariaDB are you using?

 (2) Are you using anything else such as Samba 4 LDAP with MariaDB?

 (3) What are you using for SOGoUserSources?

 I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine.

 I rebooted over the weekend for a kernel upgrade, and I've had no 
 problems.

 My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as
 yours.

 I had an issue creating the OpenChange MySQL user as
 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did
 not like the single quotes.  Once I removed those, everything worked fine.

 I had thought that was the case with the 

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Steve Ankeny

(1) try MariaDB 10.x

(2) move back to MySQL

(3) try PostgreSQL


On 04/09/2015 07:30 AM, schif...@polytech.unice.fr wrote:

I made this new user with no more results. The only changes are the url in
my logs, like :
[ERROR] 0x0x7f2dcac33220[GCSChannelManager] could not open channel
MySQL4Channel[0x0x7f2dcb017190] connection=0x(null) for
mysql://host.org/sogo/sogo_sessions_folder

So as you can see, the problem is still the same : for joining the
sessions_folder table, SOGo seems to not use the login/password and the
port.


--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Dovecot authentication with domain

2015-04-09 Thread Tom
Please send us your doveconf -n and postconf -n.

Best regards,
Thomas

2015-04-08 21:44 GMT+02:00 Gerald Brandt g...@majentis.com:

  On 2015-04-08 6:59 AM, Tom wrote:

  Hello Gerald,

  for me it is working, but I had to adapt the LDAP Settings in dovecot.

  For Testing purposes it is good to use the doveadm command.

  doveadm -Dv auth test -x service=imap -x rip=127.0.0.1 user.name passw0rd
 doveadm -Dv auth test -x service=imap -x rip=127.0.0.1
 user.n...@domain.com passw0rd

  Best regards,
 Thomas

  http://www.tiri.hamburg/

 2015-04-07 23:50 GMT+02:00 Gerald Brandt g...@majentis.com:

 Hi,

 I can authenticate with dovecot if I just pass in my user name.  If I
 pass in user@domain, the login fails.  It seems that SOGo always passes
 in the domain name.  I either need to make SOGo stop passing in the domain
 name, or have Dovecot/Samba4 accept the domian name.

 Any ideas?

 Gerald



 $ telnet localhost 143
 Trying ::1...
 Connected to localhost.
 Escape character is '^]'.
 * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE 
 STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready.
 1 login gbr bob
 1 OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE 
 SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS THREAD=ORDEREDSUBJECT 
 MULTIAPPEND URL-PARTIAL CATENATE UNSELECT CHILDREN NAMESPACE UIDPLUS 
 LIST-EXTENDED I18NLEVEL=1 CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN 
 CONTEXT=SEARCH LIST-STATUS SPECIAL-USE BINARY MOVE QUOTA] Logged in


 $ telnet localhost 143
 Trying ::1...
 Connected to localhost.
 Escape character is '^]'.
 * OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE IDLE 
 STARTTLS AUTH=PLAIN] Dovecot (Ubuntu) ready.
 1 login g...@domin.com bob
 1 NO [AUTHENTICATIONFAILED] Authentication failed.







I'm currently working without the domain portion.  What did you change
 to allow authentication with domain?

 Gerald




-- 
Thomas Baumann
Lauenburger Str. 31a
21493 Schwarzenbek
Tel. 0172 6646466
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Gilles Gagniard
Hello,

I think this is actually linked to the recent mariadb upgrade, not because of 
mariadb-server, but because of mariadb-libs ie the client side.

Here is where it fails (there is a could not allocate MySQL4 connection error 
in the logs) :

https://github.com/inverse-inc/sope/blob/6452ca58fbd7ee4850ae06bd7228a4feeb21441b/sope-gdl1/MySQL/MySQL4Channel.m#L143

mysql_init() is just doing some client-side initialization (such as setting up 
threads on so on), which fails.
No actual connection attempt has been done yet ! This is done at a later stage 
by mysql_real_connect().

So here is the list of workarounds that can be ruled out :
- This is not related to credentials or privileges or actual database content 
(we have not even tried to connect to the mysql server at this stage)
- Changing the server to older/newer mariadb or even mysql cannot help with 
this issue (same reason than above)

The only thing that could actually be tried is to downgrade mariadb-libs to 
5.5.35 which is the client sogo uses.

Gilles

Le Jeudi 9 Avril 2015 16:28 CEST, Alessandro Briosi a...@metalit.com a écrit:



 Il 09/04/2015 15:03, Jeroen Beerstra ha scritto:
  The only thing I haven't tried is mysql, postgresql and mariadb both have 
  the same problem. So I don't think it's related to changes in recent mariadb

 Just a wild guess here (or a long shot if you prefere :P ).
 Could it be that the name resolution is not pointing to the correct
 host, or that the daemons for some reason are listening only on
 localhost (127.0.0.1) so the connection fails?
 Have you tried with the host IP?

 Ciao.
 Alessandro



 --
 users@sogo.nu
 https://inverse.ca/sogo/lists





-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] rpcproxy not installed?

2015-04-09 Thread FoxNET
Hello

I will return to my message, telling you this to work, but by asking you when 
you 5000 messages there to there a more correct configuration for mail list to 
be faster.

Many greetings

Michel


 Le 9 avr. 2015 à 15:31, FoxNET i...@foxnet.be a écrit :
 
 hello
 Already tested, it does not work, by cons for it and I just made a nice 
 discovery frankly, I found this link and it works in Outlook 2013 without 
 installing OpenChange / Samba and iRedMail
 
 http://www.iredmail.org/docs/activesync.outlook.html 
 http://www.iredmail.org/docs/activesync.outlook.html
 
 Michel
 
 
 Le 9 avr. 2015 à 13:39, Gerald Brandt g...@majentis.com 
 mailto:g...@majentis.com a écrit :
 
 On 2015-04-08 5:10 PM, Scott Jordahl wrote:
 me third.
 
 Thanks Ludovic for getting us closer to having this available. Very much 
 looking forward to trying it out 
 
 On 04/08/2015 02:55 PM, Steve Ankeny wrote:
 me neither . . . 
 
 On 04/08/2015 04:15 PM, Gerald Brandt wrote: 
 Nope, hadn't seen that.  I knew previous version didn't have it, but it 
 was mentioned it would be back in place by 2.2.14.  Hopefully in 2.2.18.  
 I can't move ahead without it. 
 
 Gerald 
 
 
 Anyone try the zentyal rpcproxy package with a standard inverse repo install?
 
 Gerald
 
 
 -- 
 This message has been scanned for viruses and 
 dangerous content by MailScanner http://www.mailscanner.info/, and is 
 believed to be clean.
 



smime.p7s
Description: S/MIME cryptographic signature


Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread schifano
I made this new user with no more results. The only changes are the url in
my logs, like :
[ERROR] 0x0x7f2dcac33220[GCSChannelManager] could not open channel
MySQL4Channel[0x0x7f2dcb017190] connection=0x(null) for
mysql://host.org/sogo/sogo_sessions_folder

So as you can see, the problem is still the same : for joining the
sessions_folder table, SOGo seems to not use the login/password and the
port.


 . . . answer below . . .

 On 04/08/2015 06:19 PM, Schifano Alexandre wrote:
 On 08/04/2015 22:45, Gilles Gagniard wrote: Hello !
 Same issue here. Are you still running your sogo install on centos 7
 by any chance ?
 On my side the only significant change I did is to yum update, which
 upgraded my box to the recently released centos 7.1, which among other
 things updates mariadb from 5.5.35 to 5.5.41. Maybe you did that too
 before restarting your server ...
 I tried to rebuild everything in case there is some binary
 compatibility issue, but to no avail.
 Gilles

 Hi,

 I used CentOS 7. After my server reboot I did a yum update and I'm now
 with a CentOS 7.1.
 I tried the new binaries available in the SOGo repository, with the same
 result.

 On 08/04/2015 22:26, Steve Ankeny wrote:
 (1) What version of MariaDB are you using?

 (2) Are you using anything else such as Samba 4 LDAP with MariaDB?

 (3) What are you using for SOGoUserSources?

 I am using LDAP AD/Samba4 with MariaDB 10.0.17, and it's working fine.

 I rebooted over the weekend for a kernel upgrade, and I've had no
 problems.

 My SOGoProfileURL, OCSSessionsFolderURL etc. is essentially the same as
 yours.

 I had an issue creating the OpenChange MySQL user as
 'openchange-user'@'localhost' (as in the Outlook manual) as MariaDB did
 not like the single quotes.  Once I removed those, everything worked
 fine.

 I had thought that was the case with the SOGo MySQL user, but it was
 created without single quotes.

 I wonder if it has to do with the MariaDB version?

 Hi,

 I have MariaDB 5.5.41, with no LDAP and no Samba. My user
 authentification is done throught the SQL backend.

 IF it's not too difficult, you might try deleting the 'sogo' user and
 recreating it.

 MariaDB prefers creating the user without @localhost but using @%
 instead.  Look at documentation.

 How it looks in MySQL







 Somehow or other, I ended up with sogo and 'openchange-user' (but it
 works fine)

 I'm just trying to think of things you can consider.  Maybe someone will
 know more about MariaDB


 --
 users@sogo.nu
 https://inverse.ca/sogo/lists


-- 
users@sogo.nu
https://inverse.ca/sogo/lists


RE : Re: [SOGo] Ready to go 'Appliance'?

2015-04-09 Thread Alain Abbas
Hello
You could use www.sogxmail.org.  (Not outlook native integra

tion)




Envoyé depuis mon appareil mobile Samsung

 Message d'origine 
De : Alessio Fattorini alessio.fattor...@nethesis.it 
Date : 09/04/2015  13:01  (GMT+01:00) 
A : users@sogo.nu 
Objet : Re: [SOGo] Ready to go 'Appliance'? 
 
On 08/04/2015 14:41, Jeff Folk wrote:
 On Apr 8, 2015, at 6:51 AM, Charles Marcus wrote:

 http://www.nethserver.org

 User management, email, gateway router, SOGo module, etc. I'm using it and 
 like it so far.

+1 for NethServer
great product and great community too :-) maybe I'm a bit involved

-- 
Alessio Fattorini

-- 
users@sogo.nu
https://inverse.ca/sogo/lists
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Sogo and MySQL problem

2015-04-09 Thread Steve Ankeny

actually, I'd agree . . .

You use 'localhost'  What about using 127.0.0.1?  And, since it worked 
once, has hosts file changed?


On 04/09/2015 10:28 AM, Alessandro Briosi wrote:


Il 09/04/2015 15:03, Jeroen Beerstra ha scritto:

The only thing I haven't tried is mysql, postgresql and mariadb both have the 
same problem. So I don't think it's related to changes in recent mariadb

Just a wild guess here (or a long shot if you prefere :P ).
Could it be that the name resolution is not pointing to the correct
host, or that the daemons for some reason are listening only on
localhost (127.0.0.1) so the connection fails?
Have you tried with the host IP?

Ciao.
Alessandro





--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Ready to go 'Appliance'?

2015-04-09 Thread Alessio Fattorini

On 08/04/2015 14:41, Jeff Folk wrote:

On Apr 8, 2015, at 6:51 AM, Charles Marcus wrote:



http://www.nethserver.org

User management, email, gateway router, SOGo module, etc. I'm using it and like 
it so far.


+1 for NethServer
great product and great community too :-) maybe I'm a bit involved

--
Alessio Fattorini

--
users@sogo.nu
https://inverse.ca/sogo/lists