Have you tried to read
http://www.sogo.nu/files/docs/SOGo%20Installation%20Guide.pdf ?
There is a section: *Authentication using SQL*
There is an example and note at the bottom:
Certain database columns must be present in the view/table, such as :
❏
c_uid
- will be used for authentication – it's the username or
[email protected]
)
❏
c_name
- which can be identical to c_uid – will be used to uniquely identify
entries
❏
c_password
– password of the user, plain-text, md5 or sha encoded for now
❏
c_cn
- the user's common name – such as “John Doe”
❏
mail
– the user's mail address
So, make sure that you have these columns and that's it.
This is an example from my side:
CREATE TABLE sogo_users (id int(11) PRIMARY KEY AUTO_INCREMENT, c_uid
VARCHAR(128) UNIQUE KEY, c_name VARCHAR(128), c_password VARCHAR(32),
c_cn VARCHAR(128), mail VARCHAR(128), kind VARCHAR(100),
multiple_bookings int );
Regards,
Igor
Christian Tardif wrote, On 02/10/2013 18:30:
I try not to use the LDAP environment. I would like to authenticate
against a MySQL database. But the documentation is relatively poor on
the MySQL side. I don't seem to find the exact SQL schema in order to
even create a user. Something's missing.
Christian...
On 2013-10-02 12:10, Szládovics Péter wrote:
2013-10-02 17:28 keltezéssel, Christian Tardif írta:
Hi,
I'm new to SOGo, and I just performed a MySQL-only installation for
SOGo (meaning no LDAP at all in the setup). I did modify the
sogo.conf for MySQL, and a sogo restart created the necessary
tables... (well.... as far as I understand: sogo_folder_info,
sogo_sessions_folder, sogo_user_profile), all empty
I did try to find out how should I create an admin user. But I
didn't find anything useful. I found, in the documentation, how to
create the admin user in LDAP, but nothing for MySQL. Even more, it
looks like the database is not complete enough to allow user creation.
What did I miss?
Christian Tardif
One of your LDAP users.
Eg.: SOGoSuperUsernames = ( Administrator );
--
Szládovics, Péter
Onlinedemo.HU <http://www.onlinedemo.hu>
Any sufficiently advanced technology is indistinguishable from magic.
/Arthur C. Clarke/
--
[email protected]
https://inverse.ca/sogo/lists
