Re: [vchkpw] off topic qmailadmin suggestion
On Jun 12, 2004, at 9:32 PM, Remo Mattei wrote: Tom I open it with dreamweaer and it work fine now By work fine, do you mean that you were just able to apply the patch, or that that the patch also solved your problem? -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
Re: [vchkpw] off topic qmailadmin suggestion
On Sun, 13 Jun 2004 23:06:25 -0700, Tom Collins [EMAIL PROTECTED] wrote: On Jun 12, 2004, at 9:32 PM, Remo Mattei wrote: Tom I open it with dreamweaer and it work fine now By work fine, do you mean that you were just able to apply the patch, or that that the patch also solved your problem? -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/ It would seem that he could not open the patch properly because of either: a \r\n that did not work in *nix, or \n which did not work on his Windows box. X-Istence
[vchkpw] off topic qmailadmin suggestion
Hello guys anyone , I know this is off topic but it will be great if anyone has seen this error and help out... vmysql: sql error[3]: Commands out of sync; this is from my apache log. Thanks, Remo Mattei Network Security Engineer cell 801-808-unix email [EMAIL PROTECTED] attachment: winmail.dat
RE: [vchkpw] off topic qmailadmin suggestion
More logs and I am not sure on how to fix this thanks for the help.. could not create limits table CREATE TABLE limits ( domain CHAR(64) PRIMARY KEY, maxpopaccounts INT(10) NOT NULL DEF AULT -1, maxaliases INT(10) NOT NULL DEFAULT -1, maxforwards INT(10) NOT NULL DEFAULT -1, maxautorespondersINT(10) NOT NULL DEFAULT -1, maxmailinglists INT(10) NOT NULL DEFAULT -1, diskquota INT(12) NOT NULL DEFAULT 0, maxmsgcount INT(12) NOT NULL DEFAULT 0, defaultquota INT(12) NOT NULL DEFAULT 0, defaultmaxmsgcount INT(12) NOT NULL DEFAULT 0, disable_pop TINYINT(1) N OT NULL DEFAULT 0, disable_imap TINYINT(1) NOT NULL DEFAULT 0, disable_dialup TINYINT(1) NOT NULL DEFAULT 0, disable_passwordchanging TINYINT(1) NOT NULL DEFAULT 0, disable_webmail TINYINT(1) NOT NULL DEFAULT 0, disable_relayTINYINT(1) NOT NULL DEFAULT 0, disable_smtp TINYINT(1) NOT NULL DEFAULT 0, perm_account TINYINT(2) NOT NULL DEFAULT 0, perm_alias TINYINT(2) NOT NULL DEFAULT 0, perm_fo rward TINYINT(2) NOT NULL DEFAULT 0, perm_autoresponder TINYINT(2) NOT NULL DEFAULT 0, perm_maillist TINYINT(4) NOT NULL DEFAULT 0, perm_quota TINYINT(2) NOT NULL DEFAULT 0, perm_defaultquota TINYINT(2) NOT NULL DEFAULT 0 ) Remo Mattei Network Security Engineer cell 801-808-unix email [EMAIL PROTECTED] _ From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, June 12, 2004 7:21 PM To: [EMAIL PROTECTED] Subject: [vchkpw] off topic qmailadmin suggestion Hello guys anyone , I know this is off topic but it will be great if anyone has seen this error and help out... vmysql: sql error[3]: Commands out of sync; this is from my apache log. Thanks, Remo Mattei Network Security Engineer cell 801-808-unix email [EMAIL PROTECTED] attachment: winmail.dat
RE: [vchkpw] off topic qmailadmin suggestion
Tom sorry but the patch has been uploaded is in the wrong format could you please reupload it in text format I get this: diff -ru vpopmail-5.4.0/vmysql.c vpopmail-5.4.0-fw1/vmysql.c --- vpopmail-5.4.0/vmysql.c 2004-01-14 06:56:41.0 +0700 +++ vpopmail-5.4.0-fw1/vmysql.c 2004-06-06 16:10:54.848660760 +0700 @@ -203,41 +203,36 @@ mysql_init(mysql_update); mysql_options(mysql_update, MYSQL_OPT_CONNECT_TIMEOUT, (char *)timeout); - /* Try to connect to the mysql update server with the specified database. */ + /* Try to connect to the mysql update server */ if (!(mysql_real_connect(mysql_update, MYSQL_UPDATE_SERVER, - MYSQL_UPDATE_USER, MYSQL_UPDATE_PASSWD, - MYSQL_UPDATE_DATABASE, MYSQL_UPDATE_PORT, NULL, 0))) { - - /* Could not connect to the update mysql server with the database - * so try to connect with no database specified - */ - if (!(mysql_real_connect(mysql_update, MYSQL_UPDATE_SERVER, - MYSQL_UPDATE_USER, MYSQL_UPDATE_PASSWD, NULL, MYSQL_UPDATE_PORT, - NULL, 0))) { - - /* if we can not connect, report a error and return */ - verrori = VA_NO_AUTH_CONNECTION; - return(VA_NO_AUTH_CONNECTION); - } - - /* we were able to connect, so create the database */ - snprintf( SqlBufUpdate, SQL_BUF_SIZE, - create database %s, MYSQL_UPDATE_DATABASE ); - if (mysql_query(mysql_update,SqlBufUpdate)) { - - /* we could not create the database - * so report the error and return - */ - fprintf(stderr, vmysql: sql error[1]: %s\n, mysql_error(mysql_update)); - return(-1); - } - - /* set the database */ - if (mysql_select_db(mysql_update, MYSQL_UPDATE_DATABASE)) { - fprintf(stderr, could not enter %s database\n, MYSQL_UPDATE_DATABASE); - return(-1); - } + MYSQL_UPDATE_USER, MYSQL_UPDATE_PASSWD, NULL, MYSQL_UPDATE_PORT, + NULL, 0))) { + + /* if we can not connect, report a error and return */ + verrori = VA_NO_AUTH_CONNECTION; + return(VA_NO_AUTH_CONNECTION); + } + + /* set the database we use */ + if (mysql_select_db(mysql_update, MYSQL_UPDATE_DATABASE)) { + /* we were able to connect, so create the database */ + snprintf( SqlBufUpdate, SQL_BUF_SIZE, + create database %s, MYSQL_UPDATE_DATABASE ); + if (mysql_query(mysql_update,SqlBufUpdate)) { + + /* we could not create the database + * so report the error and return + */ + fprintf(stderr, vmysql: sql error[1]: %s\n, mysql_error(mysql_update)); + return(-1); + } + /* set the database (we just created)*/ + if (mysql_select_db(mysql_update, MYSQL_UPDATE_DATABASE)) { + fprintf(stderr, could not enter (just created) %s database\n, MYSQL_UPDATE_DATABASE); + return(-1); + } } + return(0); } not that good Remo Mattei Network Security Engineer cell 801-808-unix email [EMAIL PROTECTED] -Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: Saturday, June 12, 2004 7:53 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] off topic qmailadmin suggestion On Jun 12, 2004, at 6:25 PM, Remo Mattei wrote: More logs and I am not sure on how to fix this thanks for the help.. Try patch 967994 on SourceForge http://vpopmail.sf.net/. I've rolled it into the 5.4 branch of CVS and it will be in 5.4.5. I think it will help with that error. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/
RE: [vchkpw] off topic qmailadmin suggestion
Tom I open it with dreamweaer and it work fine now Thanks, Remo Mattei Network Security Engineer cell 801-808-unix email [EMAIL PROTECTED] -Original Message- From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Saturday, June 12, 2004 10:20 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] off topic qmailadmin suggestion Tom sorry but the patch has been uploaded is in the wrong format could you please reupload it in text format I get this: diff -ru vpopmail-5.4.0/vmysql.c vpopmail-5.4.0-fw1/vmysql.c --- vpopmail-5.4.0/vmysql.c 2004-01-14 06:56:41.0 +0700 +++ vpopmail-5.4.0-fw1/vmysql.c 2004-06-06 16:10:54.848660760 +0700 @@ -203,41 +203,36 @@ mysql_init(mysql_update); mysql_options(mysql_update, MYSQL_OPT_CONNECT_TIMEOUT, (char *)timeout); - /* Try to connect to the mysql update server with the specified database. */ + /* Try to connect to the mysql update server */ if (!(mysql_real_connect(mysql_update, MYSQL_UPDATE_SERVER, - MYSQL_UPDATE_USER, MYSQL_UPDATE_PASSWD, - MYSQL_UPDATE_DATABASE, MYSQL_UPDATE_PORT, NULL, 0))) { - - /* Could not connect to the update mysql server with the database - * so try to connect with no database specified - */ - if (!(mysql_real_connect(mysql_update, MYSQL_UPDATE_SERVER, - MYSQL_UPDATE_USER, MYSQL_UPDATE_PASSWD, NULL, MYSQL_UPDATE_PORT, - NULL, 0))) { - - /* if we can not connect, report a error and return */ - verrori = VA_NO_AUTH_CONNECTION; - return(VA_NO_AUTH_CONNECTION); - } - - /* we were able to connect, so create the database */ - snprintf( SqlBufUpdate, SQL_BUF_SIZE, - create database %s, MYSQL_UPDATE_DATABASE ); - if (mysql_query(mysql_update,SqlBufUpdate)) { - - /* we could not create the database - * so report the error and return - */ - fprintf(stderr, vmysql: sql error[1]: %s\n, mysql_error(mysql_update)); - return(-1); - } - - /* set the database */ - if (mysql_select_db(mysql_update, MYSQL_UPDATE_DATABASE)) { - fprintf(stderr, could not enter %s database\n, MYSQL_UPDATE_DATABASE); - return(-1); - } + MYSQL_UPDATE_USER, MYSQL_UPDATE_PASSWD, NULL, MYSQL_UPDATE_PORT, + NULL, 0))) { + + /* if we can not connect, report a error and return */ + verrori = VA_NO_AUTH_CONNECTION; + return(VA_NO_AUTH_CONNECTION); + } + + /* set the database we use */ + if (mysql_select_db(mysql_update, MYSQL_UPDATE_DATABASE)) { + /* we were able to connect, so create the database */ + snprintf( SqlBufUpdate, SQL_BUF_SIZE, + create database %s, MYSQL_UPDATE_DATABASE ); + if (mysql_query(mysql_update,SqlBufUpdate)) { + + /* we could not create the database + * so report the error and return + */ + fprintf(stderr, vmysql: sql error[1]: %s\n, mysql_error(mysql_update)); + return(-1); + } + /* set the database (we just created)*/ + if (mysql_select_db(mysql_update, MYSQL_UPDATE_DATABASE)) { + fprintf(stderr, could not enter (just created) %s database\n, MYSQL_UPDATE_DATABASE); + return(-1); + } } + return(0); } not that good Remo Mattei Network Security Engineer cell 801-808-unix email [EMAIL PROTECTED] -Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: Saturday, June 12, 2004 7:53 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] off topic qmailadmin suggestion On Jun 12, 2004, at 6:25 PM, Remo Mattei wrote: More logs and I am not sure on how to fix this thanks for the help.. Try patch 967994 on SourceForge http://vpopmail.sf.net/. I've rolled it into the 5.4 branch of CVS and it will be in 5.4.5. I think it will help with that error. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter hand-held Network Tester: http://sniffter.com/