Re: [qmailtoaster] IMail migration
Ping for a reply...anyone know the answer to my original post? - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] IMail migration
Kevin Donohue wrote: Hello all. I am hoping someone can answer a few questions I have to help me in testing a migration from IPSwitch's IMail to QMail Toaster. IMail keeps it's address book, forwarding, and user based filters in flat text files. I can not seem to find documentation on exactly where these account functions are stored by default in QMail Toaster. Can someone please point me in the right direction? I read through multiple manuals, both for toaster and the software packages they are based on, but I can not find the exact info I need. Any help would be appreciated. BTW, I have info on converting the mail boxes from IMail to Toaster, so if anyone need that, let me know. QMail Toaster stores the user info (aliases, forwards, passwords, etc.) in a MySQL database (vpopmail). If you're savvy in scripting, you could write something that would take your flat-text files and import the info into the database once it's set up. - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] IMail migration
Jake, I already have it installed and put in a test user. I added a forward, a filter, and an entry in the address book. I then looked for entries in the MySQL DB and found the following using PHPMyAdmin: vpopmail DB with 4 tables (dir_control, lastauth, testdomain (mine), and valias. Inside testdomain, I see the user's info that includes pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell, pw_clear_passwd. I see no references to the addressbook entry, filter, or forward I entered. I looked in the filesystem and in other MySQL tables, but I find nothing. I can log out and in and the entries are still there. Any thoughts? - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] IMail migration
If you have the user list in txt, you can always use some shell script. You can call /home/vpopmail/bin/vadduser to add users to QT without any risk of adding inconsistent information. On 2/2/06, Kevin Donohue [EMAIL PROTECTED] wrote: Jake,I already have it installed and put in a test user.I added a forward,a filter, and an entry in the address book.I then looked for entries in the MySQL DB and found the following using PHPMyAdmin:vpopmail DB with 4 tables (dir_control, lastauth, testdomain (mine), andvalias.Inside testdomain, I see the user's info that includes pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell, pw_clear_passwd.I see no references to the addressbook entry, filter, or forward Ientered.I looked in the filesystem and in other MySQL tables, but I find nothing.I can log out and in and the entries are still there. Anythoughts?-QmailToaster hosted by: VR Hosted http://www.vr.org-To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [qmailtoaster] IMail migration
Natalio, Actually, IMail uses MSSQL as a backend for it's user database, so I use a program to go between MySQL and MSSQL that pulls all the needed information in for me. It's called mss2sql.exe from Intelligent Converters ($40 at http://www.convert-in.com/mss2sql.htm) for those of you who need it. Very handy. I just need to find out how to import the addressbooks, per user spam filters, and forwarders for about 8k users. As stated earlier (http://www.mail-archive.com/qmailtoaster-list@qmailtoaster.com/msg02366.html) I already installed qmail-toaster stock and put in a test user with test info, but can't find the info in the DB and there are no files. On Thu, 2006-02-02 at 17:07 -0300, Natalio Gatti wrote: If you have the user list in txt, you can always use some shell script. You can call /home/vpopmail/bin/vadduser to add users to QT without any risk of adding inconsistent information. On 2/2/06, Kevin Donohue [EMAIL PROTECTED] wrote: Jake, I already have it installed and put in a test user. I added a forward, a filter, and an entry in the address book. I then looked for entries in the MySQL DB and found the following using PHPMyAdmin: vpopmail DB with 4 tables (dir_control, lastauth, testdomain (mine), and valias. Inside testdomain, I see the user's info that includes pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell, pw_clear_passwd. I see no references to the addressbook entry, filter, or forward I entered. I looked in the filesystem and in other MySQL tables, but I find nothing. I can log out and in and the entries are still there. Any thoughts? - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - QmailToaster hosted by: VR Hosted http://www.vr.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]