> On Wed, 2005-11-23 at 01:17, [EMAIL PROTECTED] wrote:
> > > > Is there any possiblity to connect to the MySql version 5.x database
> > > > (bucula-dir is not to be connected ) ?
> > >
> >
> > > I use mysql-5.0.15 (compiled on Solaris 10 FCS) with no problems so far.
> > > Robert.
> >
> > Here are the error-messages :
> >
> > asterix: # bacula-dir -c /etc/bacula/bacula-dir.conf 22-Nov 23:00
> > bacula-dir:
> > Fatal error: Could not open database bacula".
> > 22-Nov 23:00 bacula-dir: Fatal error: mysql.c:170 Unable to nnect to
> > MySQL server.| Database=bacula User=bacula It is probably not
> > running or your password is incorrect.
> > 22-Nov 23:00 bacula-dir ERROR TERMINATION Please correct
> > configuration file: /etc/bacula/bacula-dir.conf
> > asterix: #
> >
> >
> > Here is my bacula-dir.conf (only a part) :
> >
> > # Generic catalog service
> > Catalog {
> > Name = MyCatalog
> > dbname = bacula; user = bacula; password = '';
> > }
> >
>
> > Did you compile yourself or used a rpm-package ?
> >
>
> Self compiled, Solaris doesn't use rpm's.
>
> > If you compiled yourself :
> > Did you use a special distribution from MySql ?
> >
> > Thanks...
> I have compiled with standard source available from mysql's website.
>
> I'm quit sure that your problems are because you have not setup mysql
> properly as others have pointed out.
> This is all covered in the mysql Reference manual located at:
>
> http://dev.mysql.com/doc/refman/5.0/en/index.html
>
> Take a look at the section (2.9 Post-installation Setup and Testing)
> You cannot proceed with bacula until your mysql setup is working
> correctly, then all you have to do is run the bacula scripts to create
> the bacula data base (This is covered in the bacula manual). If there is
> a root password setup in mysql you need to use the -p option
> something like:
>
> ./create_bacula_database -p
>
> and enter the password when asked.
http://dev.mysql.com/doc/refman/5.0/en/index.html>
> Robert
>
My MySql-database is now running since 2 Month without any
problems.
I could access it by php-programs (5.x), mysql-administrator and so
on.
For Bacula I followed the described steps:
1. MySQL-Database is running
2. /etc/bacula/create_mysql_database
3. /etc/bacula/create_mysql_tables
4. /etc/bacula/grant_mysql_privileges
==> the database was created
==> the user "bacula" was created for the hosts
1. "%"
2. "localhost"
3. "asterix" (my host-name)
including all rights to "bacula"
If I used
- bacula-dir with database="bacula",user="bacula",password=""
==> fault
- bacula-dir with database="bacula",user="root",password=""
==> fault (I deleted the password for user root for this test)
- bacula-dir with database="mysql",user="root",passeword=""
==> fault
So it´s not possible to connect with bacula-dir from my server to my
server.
I looked into the source-code and found only "mysql.c" wich made
the connection to MySql.
I checked my config-prot from bacula (config.prot & config.out)
again:
all path´s are correct and bacula found all mysql-files and libraries.
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=click
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
