Re: [vchkpw] Strange error messages
I'm not sure what version you are trying this with. I just tested it with the unreleased version in CVS and it is working. I don't know that I fixed anything, but in the process I updated some of the error reporting, including the fact that vdeluser checked for the user before the domain. Now if you try to attempt to delete a user from a non-existent domain it reports that the domain doesn't exist rather than the user. #vadddomain test.domain password ONCHANGE add_domain - test.domain #vadddomain test.domain password Error: Domain already exists #vadduser [EMAIL PROTECTED] password ONCHANGE add_user - [EMAIL PROTECTED] #vadduser [EMAIL PROTECTED] password Error: Username exists #vdeluser [EMAIL PROTECTED] password ONCHANGE del_user - [EMAIL PROTECTED] #vdeluser [EMAIL PROTECTED] password Error: User does not exist #vdeldomain test.domain ONCHANGE del_domain - test.domain #vdeldomain test.domain Error: Domain does not exist #vdeluser [EMAIL PROTECTED] password Error: Domain does not exist This DOES NOT mean CVS is ready for use, or release, only that I don't see this bug in CVS. What version are you using? Rick Jonathan wrote: That's the strange thing. They're both removed from the vpopmail directory and the MySQL db. 16 maj 2007 kl. 02.32 skrev Remo Mattei: Jonathan wrote: This is the exact procedure: # vadddomain test.domain Please enter password for postmaster: enter password again: # vadduser [EMAIL PROTECTED] Please enter password for [EMAIL PROTECTED]: enter password again: # vdeluser [EMAIL PROTECTED] Failed to delete user from auth backend Error: Illegal username # vdeldomain test.domain Warning: Failed while attempting to delete domain from auth backend
Re: [vchkpw] Strange error messages
That's the strange thing. They're both removed from the vpopmail directory and the MySQL db. 16 maj 2007 kl. 02.32 skrev Remo Mattei: Jonathan wrote: This is the exact procedure: # vadddomain test.domain Please enter password for postmaster: enter password again: # vadduser [EMAIL PROTECTED] Please enter password for [EMAIL PROTECTED]: enter password again: # vdeluser [EMAIL PROTECTED] Failed to delete user from auth backend Error: Illegal username # vdeldomain test.domain Warning: Failed while attempting to delete domain from auth backend 16 maj 2007 kl. 00.51 skrev Remo Mattei: you need to use the [EMAIL PROTECTED] otherwise it fails unless the user is part of the default domain. Remo Jonathan wrote: Hi, When i try to vdeluser i get "Failed to delete user from auth backend Error: Illegal username" and when i try to vdeldomain i get "Warning: Failed while attempting to delete domain from auth backend" However, both the user and the domain seem to be removed, and can be readded without trouble. Should i care about these errors or can i let them be? -- Remo Mattei !DSPAM:464af030215971336712104! did you check your MYSQL if the user still exist or if it's created? By just checking this I would guess you may not have the right permission on MYSQL for the user settings. -- Remo Mattei
Re: [vchkpw] Strange error messages
Jonathan wrote: > This is the exact procedure: > > # vadddomain test.domain > Please enter password for postmaster: > enter password again: > # vadduser [EMAIL PROTECTED] > Please enter password for [EMAIL PROTECTED]: > enter password again: > # vdeluser [EMAIL PROTECTED] > Failed to delete user from auth backend > Error: Illegal username > # vdeldomain test.domain > Warning: Failed while attempting to delete domain from auth backend > > > 16 maj 2007 kl. 00.51 skrev Remo Mattei: > >> you need to use the [EMAIL PROTECTED] otherwise it fails unless the user >> is part of >> the default domain. >> >> Remo >> >> Jonathan wrote: >>> Hi, >>> >>> When i try to vdeluser i get >>> >>> "Failed to delete user from auth backend >>> Error: Illegal username" >>> >>> and when i try to vdeldomain i get >>> >>> "Warning: Failed while attempting to delete domain from auth backend" >>> >>> However, both the user and the domain seem to be removed, and can be >>> readded without trouble. >>> >>> Should i care about these errors or can i let them be? >>> >>> >>> >>> >> >> >> -- >> Remo Mattei > > !DSPAM:464af030215971336712104! > > did you check your MYSQL if the user still exist or if it's created? By just checking this I would guess you may not have the right permission on MYSQL for the user settings. -- Remo Mattei
Re: [vchkpw] Strange error messages
This is the exact procedure: # vadddomain test.domain Please enter password for postmaster: enter password again: # vadduser [EMAIL PROTECTED] Please enter password for [EMAIL PROTECTED]: enter password again: # vdeluser [EMAIL PROTECTED] Failed to delete user from auth backend Error: Illegal username # vdeldomain test.domain Warning: Failed while attempting to delete domain from auth backend 16 maj 2007 kl. 00.51 skrev Remo Mattei: you need to use the [EMAIL PROTECTED] otherwise it fails unless the user is part of the default domain. Remo Jonathan wrote: Hi, When i try to vdeluser i get "Failed to delete user from auth backend Error: Illegal username" and when i try to vdeldomain i get "Warning: Failed while attempting to delete domain from auth backend" However, both the user and the domain seem to be removed, and can be readded without trouble. Should i care about these errors or can i let them be? !DSPAM:464adf3b88131740420799! -- Remo Mattei
Re: [vchkpw] Strange error messages
you need to use the [EMAIL PROTECTED] otherwise it fails unless the user is part of the default domain. Remo Jonathan wrote: > Hi, > > When i try to vdeluser i get > > "Failed to delete user from auth backend > Error: Illegal username" > > and when i try to vdeldomain i get > > "Warning: Failed while attempting to delete domain from auth backend" > > However, both the user and the domain seem to be removed, and can be > readded without trouble. > > Should i care about these errors or can i let them be? > > !DSPAM:464adf3b88131740420799! > > -- Remo Mattei
[vchkpw] Strange error messages
Hi, When i try to vdeluser i get "Failed to delete user from auth backend Error: Illegal username" and when i try to vdeldomain i get "Warning: Failed while attempting to delete domain from auth backend" However, both the user and the domain seem to be removed, and can be readded without trouble. Should i care about these errors or can i let them be?
Re: [vchkpw] Strange Error
Rick, > François Wautier wrote: > > Hi, > > > > Duly noting the near absolute lack of interest in my previous email (Only > > Devendra Singh responded indicating he had the same problem), I decided > > to go and figure out things my way. > > Good job. I use CDB, and don't know enough about using MySQL with > vpopmail to find something like that. Unless someone objects I plan to > put this in HEAD, and suggest it go into the stable branch too. > > I like the fact that this patch separates hard errors from soft errors, > checking first if it can open the database connection at all and > aborting on failure. It works well with the changes in error handling > that I am working on. > I thought it made sense too. > I wish I understood the base problem better, I don't know if we are just > covering up a database problem. Could be... but is unlikely. >> You are sure you aren't running out of > MySQL children at peak loads, right? Being on the border of having too > many requests for the number of MySQL children allowed could cause what > you are seeing. > I don't really have any load to speak of. And if the problem was that, I think the client would not connect, not report "Lost connection to MySQL server during query". I would also get more complains from the websites not being able to get the data. In any case, my simplistic patch does handle that type of problem better. Cheers, François > Even if that turns out to be your real problem I think this is a better > way to handle opening the database. I have posted the patch on > SourceFORGE. [967994] > > Rick
Re: [vchkpw] Strange Error
François Wautier wrote: Hi, Duly noting the near absolute lack of interest in my previous email (Only Devendra Singh responded indicating he had the same problem), I decided to go and figure out things my way. Good job. I use CDB, and don't know enough about using MySQL with vpopmail to find something like that. Unless someone objects I plan to put this in HEAD, and suggest it go into the stable branch too. I like the fact that this patch separates hard errors from soft errors, checking first if it can open the database connection at all and aborting on failure. It works well with the changes in error handling that I am working on. I wish I understood the base problem better, I don't know if we are just covering up a database problem. You are sure you aren't running out of MySQL children at peak loads, right? Being on the border of having too many requests for the number of MySQL children allowed could cause what you are seeing. Even if that turns out to be your real problem I think this is a better way to handle opening the database. I have posted the patch on SourceFORGE. [967994] Rick
Re: [vchkpw] Strange Error
Hi, Duly noting the near absolute lack of interest in my previous email (Only Devendra Singh responded indicating he had the same problem), I decided to go and figure out things my way. At first, I wrote a small script that would look for the "Delivered-To" line emails found in the "catch-all" account and would redirect them appropriately. But that was too much of a hack, so I did look at the problem itself. And now, the end is near and so I face the final problem. My Friends, I'll say it clear, I'll state my case, I'm almost certain. I've looked the source in full, I've followed each and every pathway. But more, I found the bug and killed it my way. In "vmysql.c", the function "vauth_open_update" works like this If (NOT OK(Connect to given Host/Database) { If( OK (Connect to given Host) Create the Database; } else Complain } else Use it. The initial test is done using the mysql_real_connect function When given both a Host and a Database (+ user name, password and so on) It sometimes fails. The reason stated being "Lost connection to MySQL server during query". The subsequent connect, without a DB name, succeeding, the system tries to create the (already existing) database... and it's all downhill from there. The change I made was to to change the logic to If(Not OK(Connect to given host) Complain and return If(Not OK (Select given Database) Created it and select it Use it. And, in my case at leat, it solved the problem. I do not know why the problem occurred with the apparently correct original code, all I can say is that I now longer have the problem I described before. I attache a "patch" in case someone is foolhardy enough to try it. Cheers, François > Hi, > > I am new to this list. > > I recently installed on a Gentoo linux > > qmail 1.03 (r13) > vpopmail 5.4.0 > maildrop 1.5.3 > qmail-scanner 1.16 ( With some modifs) > > > Everything was working well until today. > > Today, I took my local domain and made it a "virtual" domain on my hosts. > > Things are mostly working, but every now and then I get the following error > message > > @400040b3436602b4f094 delivery 2035: success: > vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmy >sql:_sql_error[3]: > _No_Database_Selected/could_not_create_limits_table_CREATE_TABLE_limits_(_d > The whole SQL query.. > _No_Database_Selected/user_does_not_exist,but_will_deliver_to_/var/vpopmail >/domains/mydomain/mycatchall/ > > > Because I have a "catchall" account, the emails get delivered there instead > of the correct mailbox. I can see that the "Delivered-To" header is set to > the correct user. I can't seem to find a pattern in the occurrence of the > problem The only thing is that I get the feeling it is related to the use > of aliases ( .qmaol-myalias) but I am not sure. > > Has anyone experienced the same problem? Has anyone found a solution? > > Thanks > François Wautier 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); -} +
Re: [vchkpw] Strange Error
At 25/05/04 18:44 (), François Wautier wrote: Hi, I am new to this list. I recently installed on a Gentoo linux qmail 1.03 (r13) vpopmail 5.4.0 maildrop 1.5.3 qmail-scanner 1.16 ( With some modifs) Everything was working well until today. Today, I took my local domain and made it a "virtual" domain on my hosts. Things are mostly working, but every now and then I get the following error message @400040b3436602b4f094 delivery 2035: success: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmysql:_sql_error[3]: _No_Database_Selected/could_not_create_limits_table_CREATE_TABLE_limits_(_d The whole SQL query.. _No_Database_Selected/user_does_not_exist,but_will_deliver_to_/var/vpopmail/domains/mydomain/mycatchall/ Because I have a "catchall" account, the emails get delivered there instead of the correct mailbox. I can see that the "Delivered-To" header is set to the correct user. I can't seem to find a pattern in the occurrence of the problem The only thing is that I get the feeling it is related to the use of aliases ( .qmaol-myalias) but I am not sure. Has anyone experienced the same problem? Has anyone found a solution? Thanks François Wautier I too see this problem from time to time on two different Servers. But, to date I have not been able to understand the Problem. Devendra Singh __ Devendra Singh IndiaMART InterMESH Limited (Global Gateway to Indian Market Place) B-1, Sector 8, Noida, UP - 201301, India EPABX : +91-120-2424945, +91-120-3094634, +91-9810646342 Fax: +91-120-2424943 http://www.indiamart.com http://www.indiangiftsportal.com http://www.indiantravelportal.com __
[vchkpw] Strange Error
Hi, I am new to this list. I recently installed on a Gentoo linux qmail 1.03 (r13) vpopmail 5.4.0 maildrop 1.5.3 qmail-scanner 1.16 ( With some modifs) Everything was working well until today. Today, I took my local domain and made it a "virtual" domain on my hosts. Things are mostly working, but every now and then I get the following error message @400040b3436602b4f094 delivery 2035: success: vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmysql:_sql_error[3]: _No_Database_Selected/could_not_create_limits_table_CREATE_TABLE_limits_(_d The whole SQL query.. _No_Database_Selected/user_does_not_exist,but_will_deliver_to_/var/vpopmail/domains/mydomain/mycatchall/ Because I have a "catchall" account, the emails get delivered there instead of the correct mailbox. I can see that the "Delivered-To" header is set to the correct user. I can't seem to find a pattern in the occurrence of the problem The only thing is that I get the feeling it is related to the use of aliases ( .qmaol-myalias) but I am not sure. Has anyone experienced the same problem? Has anyone found a solution? Thanks François Wautier