Hello Toyoda.
you are a one big problem.
before made a comand make, do you have modify file vmysql.h.
in this file chahge de user and pass of user, this is my vmysql.h. see
* Edit to match your set up */
#define MYSQL_UPDATE_SERVER "localhost"
#define MYSQL_UPDATE_USER "root"
#define MYSQL_UPDATE_PASSWD "cow"
#define MYSQL_READ_SERVER "localhost"
#define MYSQL_READ_USER "root"
#define MYSQL_READ_PASSWD "cow"
only change de user and password, before make and makeinstall.
attacch the file with dump vpopmail database.
see you later.
enzo
Eduardo Garcia.
P.D : where are you? in Korea or japon, or near there. i live in costa
rica, but a im colombian.
Toyoda Yasuyuki wrote:
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.
# MySQL dump 8.14
#
# Host: localhostDatabase: vpopmail
#
# Server version3.23.41
#
# Table structure for table 'dir_control'
#
CREATE TABLE dir_control (
domain char(64) NOT NULL default '',
cur_users int(11) default NULL,
level_cur int(11) default NULL,
level_max int(11) default NULL,
level_start0 int(11) default NULL,
level_start1 int(11) default NULL,
level_start2 int(11) default NULL,
level_end0 int(11) default NULL,
level_end1 int(11) default NULL,
level_end2 int(11) default NULL,
level_mod0 int(11) default NULL,
level_mod1 int(11) default NULL,
level_mod2 int(11) default NULL,
level_index0 int(11) default NULL,
level_index1 int(11) default NULL,
level_index2 int(11) default NULL,
the_dir char(160) default NULL,
PRIMARY KEY (domain)
) TYPE=MyISAM;
#
# Dumping data for table 'dir_control'
#
INSERT INTO dir_control VALUES ('dom_89',1,0,3,0,0,0,61,61,61,0,2,4,0,0,0,'');
#
# Table structure for table 'lastauth'
#
CREATE TABLE lastauth (
user char(32) NOT NULL default '',
domain char(64) NOT NULL default '',
remote_ip char(18) NOT NULL default '',
timestamp bigint(20) NOT NULL default '0',
PRIMARY KEY (user,domain)
) TYPE=MyISAM;
#
# Dumping data for table 'lastauth'
#
#
# Table structure for table 'vpopmail'
#
CREATE TABLE vpopmail (
pw_name char(32) NOT NULL default '',
pw_domain char(64) NOT NULL default '',
pw_passwd char(40) default NULL,
pw_uid int(11) default NULL,
pw_gid int(11) default NULL,
pw_gecos char(48) default NULL,
pw_dir char(160) default NULL,
pw_shell char(20) default NULL,
