Hi folks.
I found the following mistakes.
The parameter host must not be the real IP-Address of the host.
In my configuration it was
host = 192.168.100.93
That is wrong.
The try with
host = 127.0.0.1
brought the same error.
Only
host = localhost
works fine.
Additional the following was necessary.
In the parameter pass in /bacula-web/configs/bacula.conf
I had blank in "pass = ". After changing it to "pass =" without the
blank
at the end of the equal sign, then the error message disappears.
Solution without the apostrophes:
"host = localhost"
"pass ="
Now the Message
DB Error: connect failed
Is really solved.
Br Robert
From: Robert Kromoser
Sent: Donnerstag, 26. Mai 2011 13:38
To: bacula-users@lists.sourceforge.net
Subject: FW: bacula-web error - [ SOLVED]
Hi Davide.
No I changed the host parameter back to 192.168.100.93 and did the good
old
System restart and now the error message won't come but I run in another
problem
But for this I will start a new thread.
Br Robert
From: Robert Kromoser
Sent: Donnerstag, 26. Mai 2011 09:17
To: 'bacula-users@lists.sourceforge.net'
Subject: FW: bacula-web error
Hi Davide.
A change of the host parameter to 127.0.0.1 has the same effect with the
same error message.
Here the mysql variant:
[root@CBCK0001 ~]# mysql -u bacula -h 192.168.100.93 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use bacula;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+------------------+
| Tables_in_bacula |
+------------------+
| BaseFiles |
| CDImages |
| Client |
| Counters |
| Device |
| File |
| FileSet |
| Filename |
| Job |
| JobHisto |
| JobMedia |
| Location |
| LocationLog |
| Log |
| Media |
| MediaType |
| Path |
| PathHierarchy |
| PathVisibility |
| Pool |
| Status |
| Storage |
| UnsavedFiles |
| Version |
+------------------+
24 rows in set (0.00 sec)
mysql> select count(*) from Job;
+----------+
| count(*) |
+----------+
| 36 |
+----------+
1 row in set (0.00 sec)
mysql>
I think that a connect with mysql -u bacula -h 192.168.100.93 -p
and given no password works as designed.
I also tried it with
mysql -u bacula -h 127.0.0.1 -p
mysql -u bacula -h localhost -p
but I always get the same results as using
maxsql u bacula -h 192.168.100.93 -p
When I call http://bck0001.kinamu.local/bacula-web I got always the same
error message:
DB Error: connect failed
Does someone has any other idea?
br Robert
From: dfra...@dflc.ch [mailto:dfra...@dflc.ch] On Behalf Of Bacula-Dev
Sent: Mittwoch, 25. Mai 2011 15:54
To: Robert Kromoser
Cc: bacula-users@lists.sourceforge.net
Subject: Re: bacula-web error
Hi Robert,
Is the bacula-web installation and MySQL Server the same machine ?
Did you tried to change the ip address of the MySQL server by 127.0.0.1
Another test to do when you test with the MySQL client
# mysql -u bacula -h 192.168.100.93 -p
Best regards
Davide
========================================================
Hi folks.
No I installed and configured bacula-web as described in the link
http://bacula-web.dflc.ch/index.php/admin/articles/configuring-bacula-we
b.html
<http://bacula-web.dflc.ch/index.php/admin/articles/configuring-bacula-w
eb.html>
I got the correct test page as described in
http://bacula-web.dflc.ch/index.php/admin/articles/testing-your-bacula-w
eb-installation.html
<http://bacula-web.dflc.ch/index.php/admin/articles/testing-your-bacula-
web-installation.html>
But if I try to start the default page with
http://<server>/bacula-web/
index.php
<http://%3cserver%3e/bacula-web/index.php>
then I get the following error message:
DB Error: connect failed.
In my Bacula Evaluation system CBCK0001 the database user bacula has
(sorry) no password.
My parameters in /var/www/html/bacula-web/configs/bacula.conf are:
root = /bacula-web
IndexReport = 1
mode = Full
lang = en_US
[.Database]
host = 192.168.100.93
login = bacula
pass =
db_name = bacula
db_type = mysql
# db_port = 3306
When I connect to mysql database with
mysql -u bacula -p
password:
without giving a password, just pressing enter
and then I change the database using
use bacula;
then I can select data from e.g.
select count(*) from Job;
Why cannot connect the bacula-web application to the mysql database
bacula?
br Robert
PS:
In the link
http://bacula-web.dflc.ch/index.php/admin/articles/configuring-bacula-we
b.html
<http://bacula-web.dflc.ch/index.php/admin/articles/configuring-bacula-w
eb.html>
you can see the following:
Modify the parameters in the config file config/bacula.conf following
your database server configuration
but here is one "s" missing.
It should be
Modify the parameters in the config file configs/bacula.conf following
your database server configuration
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
