Re: [SOGo] Newbie questions about SQL authentication

2011-10-17 Thread Chris Moules
On 14/10/11 18:01, Peter Peltonen wrote: Hi, ... I was looking to avoid creating a new IMAP service just for testing SOGo, but unless someone knows a way to access a IMAP user MySQL database securely remotely, I need to start installing a new IMAP server. Best, Peter Well Mysql has SSL

Re: [SOGo] Newbie questions about SQL authentication

2011-10-17 Thread André Schild
Am 17.10.2011 09:47, schrieb Chris Moules: On 14/10/11 18:01, Peter Peltonen wrote: Hi, ... I was looking to avoid creating a new IMAP service just for testing SOGo, but unless someone knows a way to access a IMAP user MySQL database securely remotely, I need to start installing a new IMAP

Re: [SOGo] Newbie questions about SQL authentication

2011-10-17 Thread Peter Peltonen
Hi, 2011/10/17 André Schild an...@schild.ws: Well Mysql has SSL capabilities. I don't know if the SOPE/SOGo client supports them however. Alternatively, a SSH port forward is always a good option. especially if it is just for testing. Quick and easy. This will forward the local 'mysql' port

Re: [SOGo] Newbie questions about SQL authentication

2011-10-14 Thread Julian Robbins
On 13/10/11 15:13, Peter Peltonen wrote: I have done my first SOGo 1.3.8b installation on a CentOS6 server. My aim is to use SQL and not LDAP. I used this excellent guide to sogo where there show you how to set up the config with a SQL database http://www.linuxjournal.com/article/10894

Re: [SOGo] Newbie questions about SQL authentication

2011-10-14 Thread Peter Peltonen
Hi, On Fri, Oct 14, 2011 at 11:28 AM, Julian Robbins julian.robb...@q-par.com wrote: On 13/10/11 15:13, Peter Peltonen wrote: I have done my first SOGo 1.3.8b installation on a CentOS6 server. My aim is to use SQL and not LDAP. I used this excellent guide to sogo where there show you how to

Re: [SOGo] Newbie questions about SQL authentication

2011-10-13 Thread Peter Peltonen
Hi, On Thu, Oct 13, 2011 at 7:00 PM, Christian Reischl christian.reis...@ivv.fraunhofer.de wrote: Hi, you have to create an authentication table (sogo_auth). My MySQL table looks like this: Thanks for the info! What about the admin user, how do I create that? You don't have to manage

Re: [SOGo] Newbie questions about SQL authentication

2011-10-13 Thread Christian Reischl
Hi Peter, you can set admin users in your .GNUstepDefaults using the parameter SOGoSuperUsernames. Command: defaults write sogod SOGoSuperUsernames '(admin.user)' Unfortunately I don't know a solution for your user database problem. kind regards, Christian