On 07/06/06, Georger Araujo <[EMAIL PROTECTED]> wrote:
> Possible solutions below.
>
> 1. Try sudo.

That's a possibility. All hosts have a standardised sudo config,
adding in a few entries for backing databases would be do-able.

> 2. How do you connect to MySQL locally, TCP/IP or
> socket? In that case, you might want to log into MySQL
> as root and

I haven't specified a connection method, all the scripts are running
standard MySQL utilities, mysql, mysqlshow etc. which I believe use
socket connections unless otherwise instructed with -h.

> SELECT User, Host, Password FROM mysql.user;
>
> to see if your passwords are OK. My output is as
> follows:

Yeah, I'd already checked the users and hosts tables and they look
fine. If I remove the password from ~root/.my.cnf MySQL prompts for a
password for 'root'@'localhost' which is the behaviour I'd like

mysql> SELECT User, Host, Password FROM mysql.user;
+----------+-----------------------+------------------+
| User     | Host                  | Password         |
+----------+-----------------------+------------------+
| root     | localhost             | cryptedpass |
| cacti    | localhost             | cryptedpass |
| wikiuser | %                     | cryptedpass |
| wikiuser | localhost             | cryptedpass |
| wikiuser | localhost.localdomain | cryptedpass |
+----------+-----------------------+------------------+

I I said before, I'll try a wrapper and see if that bypasses the
environmental problems my scripts are having running directly by the
File Daemon.

Thanks for the suggestions.

Will.


_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to