I am expecting a table equivalent to this. [image: sogo.jpg]
On Thu, Oct 6, 2022 at 8:50 PM Odhiambo Washington <[email protected]> wrote: > > > On Thu, Oct 6, 2022 at 8:33 PM Serveria Support <[email protected]> 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 '^$|^.*#' ¯\_(ツ)_/¯ :-)
