Re: [qmailtoaster] IMail migration

2006-02-06 Thread Kevin Donohue
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

2006-02-02 Thread Jake Vickers

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

2006-02-02 Thread Kevin Donohue

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

2006-02-02 Thread Natalio Gatti
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

2006-02-02 Thread Kevin Donohue

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]