Re: [vchkpw] off topic qmailadmin suggestion

2004-06-14 Thread Tom Collins
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

2004-06-14 Thread Jan-Willem Regeer
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

2004-06-12 Thread Remo Mattei
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

2004-06-12 Thread Remo Mattei
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

2004-06-12 Thread Remo Mattei
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

2004-06-12 Thread Remo Mattei
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/