[Maia-users] mySQL permissions issue

[Robert LeBlanc]

-----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 at localhost IDENTIFIED BY 'passwd';

and

  GRANT CREATE, DROP, ALTER, SELECT, INSERT, UPDATE, DELETE ON maia.* TO
maia at backup.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 <rjl at renaissoft.com>
Renaissoft, Inc.
Maia Mailguard <http://www.maiamailguard.com/>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGKddIGmqOER2NHewRAqjHAJ9bGydRjkD+kiw0KPlqwRTtOAtCYQCfVocQ
H9nKk6zd4Lnp3NQelGIQqBk=
=pQEY
-----END PGP SIGNATURE-----