On Thu, Oct 6, 2022 at 8:33 PM Serveria Support <users@sogo.nu> wrote:
> Sure, here you go. It's very basic actually, I didn't make any heavy
> tweaking:
>
[snip]
SOGoUserSources =
(
{
type = sql;
id = users;
viewURL =
"mysql://mailuser:password@localhost:3306/mailserver/sogo_users";
canAuthenticate = YES;
isAddressBook = NO;
userPasswordAlgorithm = ssha512;
}
);
[snip]
Can you please connect to the "mailserver" database and then do:
describe table sogo_users;
I am expecting something like this:
MySQL -uUSER -ppassword mailserver # After you connect, I'd like to see the
output of
describe table sogo_users;
I am expecting to see column names and definitions:
root@localhost [mailserver]> desc sogo_users;
+-------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+-------+
| sogo_id | int unsigned | NO | | 0 | |
| c_uid | varchar(255) | NO | | | |
| c_name | varchar(255) | YES | | NULL | |
| c_password | varchar(256) | YES | | NULL | |
| c_cn | varchar(255) | NO | | | |
| mail | varchar(255) | NO | | | |
| displayName | varchar(255) | YES | | NULL | |
| kind | varchar(100) | YES | | NULL | |
| multiple_bookings | int | YES | | NULL | |
+-------------------+--------------+------+-----+---------+-------+
Most importantly I'd like to see the c_uid, c_name, c_password, c_cn...
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
