phpmyadmin and maia database

Hi,

Sorry if this have addressed before but I can't search the
searchable 
archive.  It looks like it is under maintenance or
something.

I have phpmyadmin setup for mysql databases.  This is in
prepare for 
moving the maia to another server running 1.0.1.  Someone
here suggest 
that I run the upgrade script to take care of it but that
won't work for 
me since it is a production machine.  My plan of actions are
the following:

1)  Stop amavisd-new and dump the database to a file.
2)  important that database file to the new server's mysql
3)  run the upgrade script on the new server to alter the
tables and etc.
4)  test it further.

How do I look at the mail contents under phpmyadmin?  the
mail contents 
are encrypted with blowfish.  Thank you.
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users

Jacky Li wrote:

> I have phpmyadmin setup for mysql databases.  This is
in prepare for 
> moving the maia to another server running 1.0.1. 
Someone here suggest 
> that I run the upgrade script to take care of it but
that won't work for 
> me since it is a production machine.  My plan of
actions are the following:
> 
> 1)  Stop amavisd-new and dump the database to a file.
> 2)  important that database file to the new server's
mysql
> 3)  run the upgrade script on the new server to alter
the tables and etc.
> 4)  test it further.

That sounds fine.  Remember also to copy the Blowfish key
from the old
server to the new one, so that you'll be able to decrypt
mail that was
encrypted on the old server.


> How do I look at the mail contents under phpmyadmin? 
the mail contents 
> are encrypted with blowfish.

You can't decrypt the mail contents from within phpmyadmin,
since that
tool doesn't know anything about encryption.  To decrypt
the mail
contents, you need to use Maia's web interface (which uses
the Mcrypt
support built into your PHP and the Blowfish key installed
on your web
server to do the work).

-- 
Robert LeBlanc <rjlrenaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamail
guard.com/>

_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users