hi

On Sun, Feb 12, 2012, at 11:15 AM, Adrian Reyer wrote:
> Perhaps there are different assumtions on where your mysql.sock resides?
> It doesn't exactly claim 'Permission denied', 'Authorization failed' or
> similar, it might as well be unable to access the socket due to
> permissions or location.
> You could try and connect via tcp/ip to verify, just add the
> DB Address = "localhost";
> statement to your catalog definition.
>
> Catalog {
>   Name = MyCatalog
>   dbname = "bacula"; dbuser = "bacula"; DB Address = "localhost";
>   dbpassword = "DBPass"
> }

modifying,

        # Generic catalog service
        Catalog {
          Name = MyCatalog
-         dbname = "bacula"; dbuser = "bacula"; dbpassword = "DbPass"
+         dbname = "bacula"; dbuser = "bacula"; DB Address =
"localhost"; dbpassword = "DbPass"
        }

then,

        service bacula-dir restart
        bacula-dir -d -v -t -c bacula-dir.conf

returns ok, with no error. so, TCP works.

checking,

        grep sock /etc/my.cnf -B1

                [client]
                socket                          =
                /var/cache/mysql/mysql.sock

                [mysqld_safe]
                socket                          =
                /var/cache/mysql/mysql.sock

                [mysqld_secure_installation]
                socket                          =
                /var/cache/mysql/mysql.sock

                [mysqld]
                socket                          =
                /var/cache/mysql/mysql.sock

        ls -al /var/cache/mysql/mysql.sock
                srwxrwxrwx 1 mysql mysql 0 Feb 12 18:08
                /var/cache/mysql/mysql.sock=

checking, i've verifyied all of my other mysql-socket-using apps are ok
with that specified socket location.

Q: is bacula presumimg some other location, rather than adopting the
settings in /etc/my.cnf, or the executable's default,

        mysqladmin --print-defaults
                mysqladmin would have been started with the following
                arguments:
                  --socket=/var/cache/mysql/mysql.sock --password=######
                  --port=3306 

on a hunch,

        ln -sf /var/cache/mysql/mysql.sock /var/run/mysql/mysql.sock

and returning

-         dbname = "bacula"; dbuser = "bacula"; DB Address =
"localhost"; dbpassword = "DbPass"
+         dbname = "bacula"; dbuser = "bacula"; dbpassword = "DbPass"

then,

        service bacula-dir restart
        bacula-dir -d -v -t -c bacula-dir.conf

is, now, ok.

checking,

        grep sock `grep -rlni sock /usr/lib64/bacula`
                    if ($args{db_socket}) {
                        $ENV{PGHOST}=$args{db_socket};
                    if ($args{db_socket}) {     # unix socket is fastest
                    than net socket
                        $addr = "socket=$args{db_socket}";
                # db_socket=

looks like a socket specification can be made.  reading @ bacula docs,

        Configuring_Director.html
                DB Socket = socket-name
                        This is the name of a socket to use on the local
                        host to connect to the database. This directive
                        is used only by MySQL and is ignored by SQLite.
                        Normally, if neither DB Socket or DB Address are
                        specified, MySQL will use the default socket. If
                        the DB Socket is specified, the MySQL server
                        must reside on the same machine as the Director.

it's supposed to use the default socket ...

specifying the socket manually,

        rm  /var/run/mysql/mysql.sock
-         dbname = "bacula"; dbuser = "bacula"; dbpassword = "DbPass"
+         dbname = "bacula"; dbuser = "bacula"; DB Socket =
"/var/cache/mysql/mysql.sock"; dbpassword = "DbPass"

and, now,

        service bacula-dir restart
        bacula-dir -d -v -t -c bacula-dir.conf

returns ok.

as you suspected -- socket location! i'd suspect bacula *should* take
the socket location as specified in /etc/my.cnf, but the manual spec of
socket location in the bacula-dir.conf Catalog stanza is an apparently
working solution.

thanks a lot.

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users