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.000000000 +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/