Hello Eduardo.
> only change de user and password, before make and makeinstall.
>
> attacch the file with dump vpopmail database.
I understood your advice.
I have already challenged your correct procesure.
But now(6/6/2003 14:24), vpopmail don't have still run properly.
Thank you for your advice.
> P.D : where are you? in Korea or japon, or near there. i live in costa
> rica, but a im colombian.
I'm Japanese.
I live in Tokyo.
I think that your mail-server or client PC clock is out of true.
I recommend NetworkTimeProtcol SERVER.
See you.
Eduardo Garcia wrote:
> 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'
> #
>
>
