Re: [SOGo] Admin user after installation

[Igor Vitorac]

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
usern...@domain.tld
)
❏
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 
Any sufficiently advanced technology is indistinguishable from magic.
/Arthur C. Clarke/




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

Re: [SOGo] Admin user after installation

[Szládovics Péter]

Ok, I'm correcting me: One of your existing users.

2013-10-02 18:30 keltezéssel, Christian Tardif írta:
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 
Any sufficiently advanced technology is indistinguishable from magic.
/Arthur C. Clarke/





--
Szládovics, Péter

Onlinedemo.HU 
Any sufficiently advanced technology is indistinguishable from magic.
/Arthur C. Clarke/
--
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] Admin user after installation

[Christian Tardif]

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 
Any sufficiently advanced technology is indistinguishable from magic.
/Arthur C. Clarke/


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

Re: [SOGo] Admin user after installation

[Szládovics Péter]

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 
Any sufficiently advanced technology is indistinguishable from magic.
/Arthur C. Clarke/
--
users@sogo.nu
https://inverse.ca/sogo/lists

[SOGo] Admin user after installation

[Christian Tardif]

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
--
users@sogo.nu
https://inverse.ca/sogo/lists