Re: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?
- Original Message - From: Jeff Hill [EMAIL PROTECTED] To: vpopmail list [EMAIL PROTECTED] Sent: Friday, June 13, 2003 11:12 AM Subject: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions? I'm working on adding users directly to the mysql tables. It appears from the list archive that this is reasonable, but I'm not certain if there's any catch? I do this pretty regularly with no ill effect The only thing I have noticed is that the user's maildir wont get created until their 1st message arrives This can cause a problem if the user tries to login to qmailadmin before receiving any mail, as qmailadmin spits an error because it tries to write a lock file to the non-existent maildir There was a discussion a while back on the qmailadmin list about the the pros/cons of creating accounts directly in SQL... maybe have a look at this thread : http://www.mail-archive.com/[EMAIL PROTECTED]/msg03509.html Michael.
Re: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?
Thank you, very much. I thoroughly scanned the vpopmail list, but I didn't think about the qmailadmin list (next time I'll remember). My original solution to the error message was simply to send a Welcome e-mail to the new user immediately after they signup. However, perhaps it is best to create the directories first, so I've now scripted PHP to do it, with the right permissions. My only issue with having PHP create the directories was the additional execution time, but it's not that big of a deal, given the numbers. Thanks again, Jeff Hill At 09:13 AM 13/06/2003 +1000, Michael Bowe wrote: - Original Message - From: Jeff Hill [EMAIL PROTECTED] To: vpopmail list [EMAIL PROTECTED] Sent: Friday, June 13, 2003 11:12 AM Subject: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions? I'm working on adding users directly to the mysql tables. It appears from the list archive that this is reasonable, but I'm not certain if there's any catch? I do this pretty regularly with no ill effect The only thing I have noticed is that the user's maildir wont get created until their 1st message arrives This can cause a problem if the user tries to login to qmailadmin before receiving any mail, as qmailadmin spits an error because it tries to write a lock file to the non-existent maildir There was a discussion a while back on the qmailadmin list about the the pros/cons of creating accounts directly in SQL... maybe have a look at this thread : http://www.mail-archive.com/[EMAIL PROTECTED]/msg03509.html Michael.
Re: [vchkpw] Adding users
Joe Oaks wrote: This has been covered, check the archives more :) 1) how are your current accounts held, /etc/password mysql db Current accounts are in post.office on an NT machine. Software.com sold out a couple of years ago and the new company dropped post.office. Every day that goes by makes me more anxious. I've spent time looking at the passwords in post.office (and archives and google and ...) and haven't found any way to convert. My current plan is using a sniffer and putting usernames and passwords into a file, and then ramming them through vaddsuser. 2) there is vconvert command that will convert to a usuable format for vpopmail. I looked at this long enough to determine it wouldn't work with post.office passwords. 3) the archives have an example script you can do if your user names and passwords are in a text file. Search for post from me, as I asked this same question. I'll look for the post. Thanks for the response. Pat
RE: [vchkpw] Adding users
A simpler solution is to build vpopmail with clear text passwords and learning passwords. The first time they pop in, it will learn their pop password, and put it into a clear text field as well as an encrypted field. Makes it easier for Help Desk people. Regards, Tren -Original Message- From: Pat Walsh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:09 AM To: Vchkpw Subject: Re: [vchkpw] Adding users Joe Oaks wrote: This has been covered, check the archives more :) 1) how are your current accounts held, /etc/password mysql db Current accounts are in post.office on an NT machine. Software.com sold out a couple of years ago and the new company dropped post.office. Every day that goes by makes me more anxious. I've spent time looking at the passwords in post.office (and archives and google and ...) and haven't found any way to convert. My current plan is using a sniffer and putting usernames and passwords into a file, and then ramming them through vaddsuser. 2) there is vconvert command that will convert to a usuable format for vpopmail. I looked at this long enough to determine it wouldn't work with post.office passwords. 3) the archives have an example script you can do if your user names and passwords are in a text file. Search for post from me, as I asked this same question. I'll look for the post. Thanks for the response. Pat
Re: [vchkpw] Adding users
- Original Message - From: Pat Walsh [EMAIL PROTECTED] To: Vchkpw [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:09 AM Subject: Re: [vchkpw] Adding users Current accounts are in post.office on an NT machine. Software.com sold out a couple of years ago and the new company dropped post.office. Every day that goes by makes me more anxious. I've spent time looking at the passwords in post.office (and archives and google and ...) and haven't found any way to convert. My current plan is using a sniffer and putting usernames and passwords into a file, and then ramming them through vaddsuser. Hi Pat, We had the same problem, when we migrated from Post.Office to vpopmail last year We had a list of original passwords that people used when they 1st signed up with our ISP. But since then many of them had changed their passwords so our list wasnt 100% accurate. In the end we enabled the password capturing features of our RADIUS server so that we could capture peoples passwords as they dialled in. This gave us a pretty complete password list within a week or two. We just set the remaining vpopmail passwords to the original password we had on file This gave us a pretty complete list, and after we migrated all the mailboxes across, we just fielded the tech calls from any remaining users and reset their passwords as appropriate. Make sure you compile vpopmail with --enable-logging=p and --enable-clear-passwd=y. This will let you tech desk staff be able to view what people are typing in as their password should their authentication fail. Also they can see what actual password is stored in the vpopmail account. Michael.
Re: [vchkpw] Adding users
Tren Blackburn wrote: A simpler solution is to build vpopmail with clear text passwords and learning passwords. The first time they pop in, it will learn their pop password, and put it into a clear text field as well as an encrypted field. Makes it easier for Help Desk people. I'm pretty sure that I installed with learning passwords enabled in anticipation of this migration. Is there a way to verify that? Also, I tried adding a user and it insisted on wanting a password - vadduser and the qmailadmin. I assume for learning to take affect you need a blank password. So, how to create a user w/o a password? Pat Regards, Tren -Original Message- From: Pat Walsh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:09 AM To: Vchkpw Subject: Re: [vchkpw] Adding users Joe Oaks wrote: This has been covered, check the archives more :) 1) how are your current accounts held, /etc/password mysql db Current accounts are in post.office on an NT machine. Software.com sold out a couple of years ago and the new company dropped post.office. Every day that goes by makes me more anxious. I've spent time looking at the passwords in post.office (and archives and google and ...) and haven't found any way to convert. My current plan is using a sniffer and putting usernames and passwords into a file, and then ramming them through vaddsuser. 2) there is vconvert command that will convert to a usuable format for vpopmail. I looked at this long enough to determine it wouldn't work with post.office passwords. 3) the archives have an example script you can do if your user names and passwords are in a text file. Search for post from me, as I asked this same question. I'll look for the post. Thanks for the response. Pat -- Pat Walsh Involved, Inc. http://www.involved.com 503-226-4006
RE: [vchkpw] Adding users
Yup, with vadduser, just go: ~vpopmail/bin/vadduser -n user@domain -n means no password. To test then, do a: telnet 0 110 USER user@domain PASS whatever QUIT Then do a ~vpopmail/bin/vuserinfo user@domain and look for the password. Regards, Tren -Original Message- From: Pat Walsh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 2:18 PM To: Vchkpw Subject: Re: [vchkpw] Adding users Tren Blackburn wrote: A simpler solution is to build vpopmail with clear text passwords and learning passwords. The first time they pop in, it will learn their pop password, and put it into a clear text field as well as an encrypted field. Makes it easier for Help Desk people. I'm pretty sure that I installed with learning passwords enabled in anticipation of this migration. Is there a way to verify that? Also, I tried adding a user and it insisted on wanting a password - vadduser and the qmailadmin. I assume for learning to take affect you need a blank password. So, how to create a user w/o a password? Pat Regards, Tren -Original Message- From: Pat Walsh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:09 AM To: Vchkpw Subject: Re: [vchkpw] Adding users Joe Oaks wrote: This has been covered, check the archives more :) 1) how are your current accounts held, /etc/password mysql db Current accounts are in post.office on an NT machine. Software.com sold out a couple of years ago and the new company dropped post.office. Every day that goes by makes me more anxious. I've spent time looking at the passwords in post.office (and archives and google and ...) and haven't found any way to convert. My current plan is using a sniffer and putting usernames and passwords into a file, and then ramming them through vaddsuser. 2) there is vconvert command that will convert to a usuable format for vpopmail. I looked at this long enough to determine it wouldn't work with post.office passwords. 3) the archives have an example script you can do if your user names and passwords are in a text file. Search for post from me, as I asked this same question. I'll look for the post. Thanks for the response. Pat -- Pat Walsh Involved, Inc. http://www.involved.com 503-226-4006
Re: [vchkpw] Adding users
On Tue, Dec 03, 2002 at 05:31:37PM -0800, Pat Walsh wrote: I've got hundreds of email addresses to migrate from a different server. I can easily add username/passwords using vadduser, but would like to add names to the accounts also. Is there a switch I haven't found? Immediately after running vadduser you could run vmoduser with the -c flag. Cory -- Cory Wright Stand Blue Technology http://www.standblue.net/
RE: [vchkpw] Adding users
-Original Message- From: Pat Walsh [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 4 December 2002 12:32 PM To: [EMAIL PROTECTED] Subject: [vchkpw] Adding users I've got hundreds of email addresses to migrate from a different server. I can easily add username/passwords using vadduser, but would like to add names to the accounts also. Is there a switch I haven't found? You do it like this : vadduser -c Some Name [EMAIL PROTECTED] password Michael.
RE: [vchkpw] Adding users
This has been covered, check the archives more :) 1) how are your current accounts held, /etc/password mysql db 2) there is vconvert command that will convert to a usuable format for vpopmail. 3) the archives have an example script you can do if your user names and passwords are in a text file. Search for post from me, as I asked this same question. Joe -Original Message- From: Pat Walsh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 5:32 PM To: [EMAIL PROTECTED] Subject: [vchkpw] Adding users I've got hundreds of email addresses to migrate from a different server. I can easily add username/passwords using vadduser, but would like to add names to the accounts also. Is there a switch I haven't found? -- Pat Walsh Involved, Inc. http://www.involved.com 503-226-4006
Re: [vchkpw] Adding users
Perfect, thanks. Pat Cory Wright wrote: On Tue, Dec 03, 2002 at 05:31:37PM -0800, Pat Walsh wrote: I've got hundreds of email addresses to migrate from a different server. I can easily add username/passwords using vadduser, but would like to add names to the accounts also. Is there a switch I haven't found? Immediately after running vadduser you could run vmoduser with the -c flag. Cory -- Cory Wright Stand Blue Technology http://www.standblue.net/ -- Pat Walsh Involved, Inc. http://www.involved.com 503-226-4006
