Hi Josip,
Are you able to connect to the mysql using the same credentials as
> bacula but using mysql client with "-h localhost" option, e.g.
> mysql -h localhost -u bacula -p bacula
>
Yep! that works!
[root@ops:~] #mysql -ubacula -p -h localhost
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 32
Server version: 5.5.42 MySQL Community Server (GPL) by Remi
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql>
Still need some ideas, unfortunately! :(
Thanks!!!
Tim
On Fri, Mar 27, 2015 at 11:13 AM, Josip Deanovic <djosip+n...@linuxpages.net
> wrote:
> Quoting message written on Friday 2015-03-27 11:01:52:
> > Hello Heitor,
> >
> > I can see in your dir.conf that you are using an "admin" user to connect
> > to
> > > your database.
> > > Did you try the bacula user? This is the one created by the
> > > grant_x_privileges script.
> >
> > I took a look at the grant_mysql_privileges script. And noticed that the
> > password entry wasn't set. So I set the password to the one I use and
> > ran the script again.
> >
> > And I was able to connect and run a query against the database:
> >
> > [root@ops:/etc/bacula] #mysql -ubacula -p -e "use bacula; select * from
> > Version"
> > Enter password:
> > +-----------+
> >
> > | VersionId |
> >
> > +-----------+
> >
> > | 14 |
> >
> > +-----------+
> >
> > Then I tried changing the DB login information in the director conf to
> > match what was in the mysql grant script:
> >
> > # Generic catalog service
> > Catalog {
> > Name = JokefireCatalog
> > # Uncomment the following line if you want the dbi driver
> > # dbdriver = "dbi:mysql"; dbaddress = localhost; dbport = 3306
> > dbname = "bacula"; dbuser = "bacula"; dbpassword = "secret"
> > }
> >
> > Then tried to startup the director again:
> >
> > [root@ops:/etc/bacula] #service bacula-dir start
> > Starting bacula-dir: [ OK ]
> >
> > [root@ops:/etc/bacula] #service bacula-dir status
> > bacula-dir dead but subsys locked
> >
> > But no luck, unfortunately. :(
> >
> > Same errors are turning up in the logs:
> >
> > [root@ops:/etc/bacula] #tail /var/log/bacula/bacula.log
> > 27-Mar 11:00 bacula-dir JobId 0: Fatal error: Query failed: SELECT
> > VersionId FROM Version: ERR=no such table: Version
> > 27-Mar 11:00 bacula-dir JobId 0: Fatal error: Could not open Catalog
> > "JokefireCatalog", database "bacula".
> > 27-Mar 11:00 bacula-dir JobId 0: Fatal error: Query failed: SELECT
> > VersionId FROM Version: ERR=no such table: Version
> > 27-Mar 11:00 bacula-dir ERROR TERMINATION
> > Please correct configuration file: /etc/bacula/bacula-dir.conf
> >
> > Any other ideas?
>
> Are you able to connect to the mysql using the same credentials as
> bacula but using mysql client with "-h localhost" option, e.g.
> mysql -h localhost -u bacula -p bacula
>
>
> --
> Josip Deanovic
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website,
> sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for
> all
> things parallel software development, from weekly thought leadership blogs
> to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
> _______________________________________________
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
