Re: [vchkpw] MySQL registration from vpopmail
Hello, Eduardo > say me, do you resolv the problem? Your clock is returned correct. Your clock is No Problem. > send me address to NetworkTimeProtcol SERVER. http://www.eecis.udel.edu/~mills/ntp/clock1a.html In the above URL, You can select ntp public server near your country. > do you have a web page, my web site is www.enzolutions.com, it's only in > spanish sorry. > see you later. Sorry, I have no my web site. But, There is my company's web site. if you like, please refer my company's web site. the following, http://www.roadmap.co.jp/index_e.html Regards. Yasuyuki Toyoda ;-)
Re: [vchkpw] MySQL registration from vpopmail
Hello toyoda. say me, do you resolv the problem? thanks, my clock it's only change to jump expiration date to software TOAD, jejeje,. send me address to NetworkTimeProtcol SERVER. do you have a web page, my web site is www.enzolutions.com, it's only in spanish sorry. see you later. thanks. enzo Eduardo Garcia.
Re: [vchkpw] MySQL registration from vpopmail
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_gec
Re: [vchkpw] MySQL registration from vpopmail
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: localhostDatabase: 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, > le
[vchkpw] MySQL registration from vpopmail
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.
