Re: [Bacula-users] Can't run bacula any more.
2017-03-16 06:32:51
Erik P. Olsen schrieb:
> On 2017-03-15 at 21:17:07 Dan Langille wrote:
>
>>> On Mar 14, 2017, at 2:42 AM, Erik P. Olsen <epodata AT gmail DOT com> wrote:
>>>
>>> On 2017-03-13 at 22:52:04 Richard wrote:
>>>
>>>> What you have for privileges is what I would expect. My
>>>> "grant_mysql_privileges" script has two lines - the first will do the
>>>> "localhost" setup for the bacula user. Assuming that your script is
>>>> lacking that, you might want to add it and try rerunning the script.
>>>>
>>>> grant all privileges on ${db_name}.* to ${db_user}@localhost ${pass};
>>>> grant all privileges on ${db_name}.* to ${db_user}@"%" ${pass};
>>>
>>> In my script the lines are:
>>>
>>> use mysql
>>> grant all privileges on ${db_name}.* to ${db_user}@localhost ${pass}
>>> ${ssl_options};
>>> grant all privileges on ${db_name}.* to ${db_user}@"%" ${pass}
>>> ${ssl_options};
>>> select * from user;
>>> flush privileges;
>>>
>>> Ups, I now see that a semicolon is missing after "use mysql".
>>> I'll add it and rerun the script:
>>> Oh it won't let me do the "use mysql;" Access denied.
>>
>> Perhaps connect to mysql using the user name / password you have in the
>> Catalog definition.
>
>
> [erik@Erik-PC ~]$ mysql bacula --user=bacula
> ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'bacula'
> [erik@Erik-PC ~]$
>
> I am afraid it will never work :-(
>
does the user 'erik' has any privilege on the mysql engine?
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: [Bacula-users] Can't run bacula any more., (continued)
- Re: [Bacula-users] Can't run bacula any more.,
Andreas Nastke <=
- Re: [Bacula-users] Can't run bacula any more., Erik P. Olsen
- Re: [Bacula-users] Can't run bacula any more., Richard
- Re: [Bacula-users] Can't run bacula any more., Erik P. Olsen
- Re: [Bacula-users] Can't run bacula any more., Wanderlei Huttel
- Re: [Bacula-users] Can't run bacula any more., Josh Fisher
- Re: [Bacula-users] Can't run bacula any more., Wanderlei Huttel
- [Bacula-users] [END OF THREAD]Re: Can't run bacula any more., Erik P. Olsen
- Re: [Bacula-users] [END OF THREAD]Re: Can't run bacula any more., Heitor Faria
- Re: [Bacula-users] [END OF THREAD]Re: Can't run bacula any more., Wanderlei Huttel
- Re: [Bacula-users] [END OF THREAD]Re: Can't run bacula any more., Josip Deanovic
|
|
|