-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
craig carriere wrote:
> Yet another of my dumb newbie questions. I have MM
1.0.2 running on a
> SLES 10 mail server which operates very well. I have a
backup mail
> server on which I have
postfix/amavsd-new/SA/clam/Mailzu running. I
> presently have a separate bayes database for this mail
system residing
> on another mySQL server. I want to have both system
use and feed into
> the same bayes system so I have configured the backup
mail server to
> utilize the maia bayes database. I have granted
permission to my maia
> user to connect from any host and for the database to
accept connections
> for any host. With this set-up I now can connect to
the maia bayes
> database from my backup mail server which is what I
wanted; however,
> maia on my main mail server is unable to connect to the
maia database.
> I am sure I am doing something obvious wrong again, but
I expected
> allowed connections from any host would include
localhost.
You can use multiple GRANT statements, of course--you don't
have to come
up with a single GRANT that works for everything. In your
case for
instance you probably want two separate GRANT statements,
e.g.:
GRANT CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE
ON maia.* TO
maia localhost IDENTIFIED BY 'passwd';
and
GRANT CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE
ON maia.* TO
maiabackup.host IDENTIFIED BY 'passwd';
That's a bit tighter than having to grant access to maia*, and
lets you
be a bit clearer about the two distinct users.
- --
Robert LeBlanc <rjlrenaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamail
guard.com/>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFGKddIGmqOER2NHewRAqjHAJ9bGydRjkD+kiw0KPlqwRTtOAtCYQCf
VocQ
H9nKk6zd4Lnp3NQelGIQqBk=
=pQEY
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users
|
