I have a problem about (qmail + vpopmail + MySQL) system.
My system is qmail + vpopmail + qmailadmin + MySQL.

I want to register MySQL tables of vpopmail database.
I performed the following command.

-------------------command start --------
groupadd mysql
mkdir -p /usr/local/mysql/var
useradd -g mysql -d /usr/local/mysql/var mysql
cd /usr/local/src
tar -xzf mysql-4.0.13.tar.gz
rm -f mysql-4.0.13.tar.gz
cd mysql-4.0.13
./configure --prefix=/usr/local/mysql --with-charset=ujis
-with-extra-charsets=all --with-mysqld-user=mysql
make install

/usr/local/mysql/bin/mysql_install_db --user=mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql/var
/usr/local/mysql/bin/mysqld_safe --user=mysql &

| Databases |
| mysql     |
| test      |

cd /usr/local/src/vpopmail-5.2.1
./configure --enable-roaming-users=y --enable-mysql=y
make install-strip
/usr/local/mysql/bin/mysqladmin create vpopmail
mysql > grant select,insert,update,delete,create on vpopmail.* to
[EMAIL PROTECTED] identified by 'password';

Query OK, 0 rows affected (0.00 sec)

mysql > exit


| Databases |
| mysql     |
| test      |
| vpopmail  |

qmail starting.

/home/vpopmail/bin/vadddomain good.for.com

qmail restarting.

setenv LD_LIBRARY_PATH /usr/local/mysql/lib/mysql
/home/vpopmail/bin/vconvert -c -m

Add user "[EMAIL PROTECTED]" through qmailadmin.

/usr/local/mysql/bin/mysqlshow vpopmail
Database: vpopmail
| Tables |

-------------------command finish --------
I created virtual domain(example.  good.for.com) to vpopmail.
At this time, I think that Automatically Something tables of vpopmail
is created in the MySQL.
Is my thinking mistake?
Do I have to add manually tables of vpopmail to MySQL.

Thank you in advance.

Yasuyuki Toyoda.

Reply via email to