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: localhost Database: vpopmail
#--------------------------------------------------------
# Server version 3.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,
pw_clear_passwd char(16) default NULL,
PRIMARY KEY (pw_name,pw_domain)
) TYPE=MyISAM;
#
# Dumping data for table 'vpopmail'
#
