Why not use vpopmail with --enable-mysql=y --enable-valias=y
Then use only the vchkpw authentication method in sqwebmail.
Ken Jones
Viktor Norin writes:
> Hi!
>
> I uderstand that solution, but it doesn't suit me because I want to use
> MySQL and valias function in Vpopmail. It's written in SqWebMail:
> MySQL authentication
> This module allows authentication information to be stored in a
> MySQL database.
> * Supports both physical and virtual mail accounts.
>
> Why can't I adjust one more option like
> MYSQL_LOGIN_FIELD=MYSQL_LOGIN_USER@MYSQL_LOGIN_DOMAIN?
>
>
> Tim Hunter wrote:
>
>> Use vpopmail as your authentication method, not mysql.
>>
>> ----- Original Message -----
>> From:Viktor Norin
>> To: Sam Varshavchik
>> Cc: [EMAIL PROTECTED]
>> Sent: Sunday, May 27, 2001 8:08 AM
>> Subject: authmysql and virtual domains
>> Hi fellows!
>>
>> I installed Vpopmail 4.10.7 with --enable-mysql=y
>> --enable-large-site=n options.
>> Now I have Database vpopmail with table vpopmail:
>>
>>
>>
>------------+-----------+---------------+--------+--------+------------+------------------------------------------+----------+-----------------+
>
>>
>> | pw_name | pw_domain | pw_passwd | pw_uid | pw_gid |
>> pw_gecos | pw_dir |
>> pw_shell | pw_clear_passwd |
>>
>>
>------------+-----------+---------------+--------+--------+------------+------------------------------------------+----------+-----------------+
>
>>
>> | postmaster | aaa.ee | mVJzt7Qdx3I3c | 0 | 0 |
>> Postmaster | /home/vpopmail/domains/aaa.ee/postmaster |
>> 50000000 | ppp |
>> | aaa | bbb.ee | 3PVIhp.iywe5c | 0 | 0 |
>> aaa | /home/vpopmail/domains/bbb.ee/aaa |
>> 50000000 | aaa |
>> | aaa | aaa.ee | 9xtHbelRNdNz6 | 0 | 0 |
>> aaa | /home/vpopmail/domains/aaa.ee/aaa |
>> 50000000 | aa |
>> | postmaster | bbb.ee | usrYOk.zumqI2 | 0 | 0 |
>> Postmaster | /home/vpopmail/domains/bbb.ee/postmaster |
>> 50000000 | ppp |
>>
>>
>------------+-----------+---------------+--------+--------+------------+------------------------------------------+----------+-----------------+
>
>>
>> Compiling SqWebMail-2.0.0.20010519 with --with-authmysql
>> option.
>> Configuring authmysqlrc:
>>
>> MYSQL_DATABASE vpopmail
>> MYSQL_USER_TABLE vpopmail
>> MYSQL_CRYPT_PWFIELD pw_passwd
>> MYSQL_LOGIN_FIELD pw_name
>> MYSQL_HOME_FIELD pw_dir
>> MYSQL_UID_FIELD pw_uid
>> MYSQL_GID_FIELD pw_gid
>>
>> Here starts the problem. How could I adjust
>> MYSQL_LOGIN_FIELD to virtual domains???
>> As far as I concurn MYSQL_LOGIN_FIELD demand full email
>> (like user@domain), but by default Vpopmail is making a
>> separate field for "pw_domain" domain.
>>
>> Any ideas?
>>
>>
>> --
>> Best Regards,
>> Viktor Norin
>> __________________________________________________
>> Starline Web Services http://www.starline.ee
>> Tallinn, Estonia
>> tel. +372 5073 242 ICQ : 4624610
>>
>>
> --
> Best Regards,
> Viktor Norin
> __________________________________________________
> Starline Web Services http://www.starline.ee
> Tallinn, Estonia
> tel. +372 5073 242 ICQ : 4624610
>