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 AT lists.sourceforge DOT 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: dfranco AT dflc DOT ch [mailto:dfranco AT dflc DOT ch] On
Behalf Of Bacula-Dev
Sent: Mittwoch, 25. Mai 2011 15:54
To: Robert Kromoser
Cc: bacula-users AT lists.sourceforge DOT 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
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
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
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