Hi,
I have a problem about (qmail + vpopmail + MySQL) system.
My system is qmail + vpopmail + qmailadmin + MySQL.
Q1.)
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
ftp
http://www.softagency.co.jp/MySQL/Downloads/MySQL-4.0/mysql-4.0.13.tar.gz
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
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 &
/usr/local/mysql/bin/mysqlshow
+-----------+
| Databases |
+-----------+
| mysql |
| test |
+-----------+
cd /usr/local/src/vpopmail-5.2.1
./configure --enable-roaming-users=y --enable-mysql=y
--enable-incdir=/usr/local/mysql/include/mysql
--enable-libdir=/usr/local/mysql/lib/mysql
--enable-sqlincdir=/usr/local/mysql/include/mysql
--enable-sqllibdir=/usr/local/mysql/lib/mysql
make
make install-strip
/usr/local/mysql/bin/mysqladmin create vpopmail
/usr/local/mysql/bin/mysql
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
/usr/local/mysql/bin/mysqlshow
+-----------+
| 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.
