Here it is:
MariaDB [mailserver]> describe sogo_users;
+------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| c_uid | varchar(100) | NO | | NULL | |
| c_name | varchar(100) | NO | | NULL | |
| c_password | varchar(106) | NO | | NULL | |
| c_cn | varchar(100) | NO | | NULL | |
| mail | varchar(100) | NO | | NULL | |
| domain | varchar(100) | NO | | NULL | |
+------------+--------------+------+-----+---------+-------+
6 rows in set (0.006 sec)
But I think you're going the wrong way. Windows Mail and other software
clients can log in and send/receive emails just fine using these
credentials.
On 2022-10-06 21:01, Odhiambo Washington wrote:
I am expecting a table equivalent to this.
On Thu, Oct 6, 2022 at 8:50 PM Odhiambo Washington
<odhia...@gmail.com> wrote:
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 '^$|^.*#' ¯\_(ツ)_/¯ :-)
--
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)