Re: [Bacula-users] bacula-web error

[Bacula-Dev]

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:///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
--
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

[Bacula-users] bacula-web error

[Robert Kromoser]

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:///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

 

--
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

Re: [Bacula-users] Bacula-web - Error query: 4

[Juan Luis Frances]

Hi,

Is your catalog empty? Run a test job and refresh bacula-web.

El Friday 29 February 2008 11:08:38 nda escribió:
> Hi Juan Luis,
>
> db_type is correct (mysql in my case)
> Here is my  http://www.nabble.com/file/p1572/bacula.conf bacula.conf .
> DB password is hidden but correct in the production file.
>
> Regards,
>
> Nico
>
> Juan Luis Frances wrote:
> > The code:
> > else if ( $this->driver == "pgsql") {
> > $dbsize = $this->link->query("select
> > pg_database_size('$this->dbs_name')")
> > or die ("classes.inc: Error query: 4");
> >
> >
> > Maybe "db_type" in  bacula.conf file is wrong. If you have mysql then:
> > db_type = mysql

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[nda]

Hi Juan Luis,

db_type is correct (mysql in my case)
Here is my  http://www.nabble.com/file/p1572/bacula.conf bacula.conf .
DB password is hidden but correct in the production file.

Regards,

Nico


Juan Luis Frances wrote:
> 
> The code:
> else if ( $this->driver == "pgsql") {
> $dbsize = $this->link->query("select 
> pg_database_size('$this->dbs_name')")
> or die ("classes.inc: Error query: 4");
> 
> 
> Maybe "db_type" in  bacula.conf file is wrong. If you have mysql then:
> db_type = mysql
> 

-- 
View this message in context: 
http://www.nabble.com/Bacula-web---Error-query%3A-4-tp15714690p1572.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[nda]

Hi Juan Luis,

db_type is correct (mysql in my case)
Here is my  http://www.nabble.com/file/p15755160/bacula.conf bacula.conf .
DB password is hidden but correct in the production file.

Regards,

Nico


Juan Luis Frances wrote:
> 
> The code:
> else if ( $this->driver == "pgsql") {
> $dbsize = $this->link->query("select 
> pg_database_size('$this->dbs_name')")
> or die ("classes.inc: Error query: 4");
> 
> 
> Maybe "db_type" in  bacula.conf file is wrong. If you have mysql then:
> db_type = mysql
> 

-- 
View this message in context: 
http://www.nabble.com/Bacula-web---Error-query%3A-4-tp15714690p15755160.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[nda]

Hi Juan Luis,

db_type is correct (mysql in my case)
Here is my  http://www.nabble.com/file/p15755157/bacula.conf bacula.conf .
DB password is hidden but correct in the production file.

Regards,

Nico


Juan Luis Frances wrote:
> 
> The code:
> else if ( $this->driver == "pgsql") {
> $dbsize = $this->link->query("select 
> pg_database_size('$this->dbs_name')")
> or die ("classes.inc: Error query: 4");
> 
> 
> Maybe "db_type" in  bacula.conf file is wrong. If you have mysql then:
> db_type = mysql
> 

-- 
View this message in context: 
http://www.nabble.com/Bacula-web---Error-query%3A-4-tp15714690p15755157.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[Juan Luis Frances]

The code:
else if ( $this->driver == "pgsql") {
$dbsize = $this->link->query("select 
pg_database_size('$this->dbs_name')")
or die ("classes.inc: Error query: 4");


Maybe "db_type" in  bacula.conf file is wrong. If you have mysql then:
db_type = mysql

El Wednesday 27 February 2008 16:15:17 nda escribió:
> John Drescher-2 wrote:
> > Is your database mysql?
> >
> > I ask this because I use postgresql and I know for a fact that
> > bacula-web does not work with postgresql without some patching.
> > John
>
> Hi,
>
> We are using Mysql but i first installed bacula with SQLite, then installed
> the package for mysql, but didn't reinstall all from scratch.
> I installed using apt-get (Ubuntu Server 7.10) and not from source.
>
> Regards,
>
> nico

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[John Drescher]

On Fri, Feb 29, 2008 at 3:38 AM, nda <[EMAIL PROTECTED]> wrote:
>
>  Hi Jason,
>
>  Thanks for the feedback, i'll try to learn how to use the bconsole
>  efficiantly.
>
When I have had errors like that with bacula-web. I usually go to the
source (search for the error message) and find out what line is
failing. Then try to figure out what is causing this. It usually is a
permissions problem, or some module is not installed, or the database
can not be contacted using the ip address of the database server.

Also, there are at a few other web viewing applications that are
currently being developed. One is bweb. With that you can actually run
jobs which you can not do in bacula-web which is a read only view.
There is also a bacula module for webmin (http://www.webmin.com/) that
allows similar operations as the other two with some ability to
configure the services.

There are even more web frontends here:

http://wiki.bacula.org/doku.php?id=3rd_party_addons

John

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[nda]

Hi Jason,

Thanks for the feedback, i'll try to learn how to use the bconsole
efficiantly.

Nico


Jason A. Kates wrote:
> 
> Nico,
> 
> I don't know how many people are using bacula-web, nor at what level it
> is supported.
> 
> My understanding is that for a GUI the development is being done on BAT.
> 
> Most people use bconsole to manage bacula.   I would suggest making it
> work then play with the GUI's.   I think that you will find that the GUI
> will just slow you down.
>   -Jason
> -- 
> 
> Jason A. Kates ([EMAIL PROTECTED]) 
> Fax:208-975-1514
> Phone:  212-400-1670 x2
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Bacula-web---Error-query%3A-4-tp15714690p15754213.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[Jason A. Kates]

Nico,

I don't know how many people are using bacula-web, nor at what level it
is supported.

My understanding is that for a GUI the development is being done on BAT.

Most people use bconsole to manage bacula.   I would suggest making it
work then play with the GUI's.   I think that you will find that the GUI
will just slow you down.
-Jason


On Fri, 2008-02-29 at 00:14 -0800, nda wrote:
> Hi,
> 
> Nobody can help me on this issue?
> The error message give no info at all...
> 
> Thanks,
> 
> Nico
> 
> nda wrote:
> > 
> > Hi,
> > 
> > We are currently testing Bacula at work, but it isn't a easy task...
> > Installation seems ok and i succeed the catalog backup.
> > I'm now trying to mage the web interface work, but i get this error
> > message :
> > Error query: 4
> > 
> > Don't know how to solve that... I found a few topic about that error on
> > internet, but no solutions...
> > 
> > As we are coming from Backup Exec, it's really different software!
> > 
> > Nico
> > 
> 
-- 

Jason A. Kates ([EMAIL PROTECTED]) 
Fax:208-975-1514
Phone:  212-400-1670 x2




-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[nda]

Hi,

Nobody can help me on this issue?
The error message give no info at all...

Thanks,

Nico

nda wrote:
> 
> Hi,
> 
> We are currently testing Bacula at work, but it isn't a easy task...
> Installation seems ok and i succeed the catalog backup.
> I'm now trying to mage the web interface work, but i get this error
> message :
> Error query: 4
> 
> Don't know how to solve that... I found a few topic about that error on
> internet, but no solutions...
> 
> As we are coming from Backup Exec, it's really different software!
> 
> Nico
> 

-- 
View this message in context: 
http://www.nabble.com/Bacula-web---Error-query%3A-4-tp15714690p15753952.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[nda]

John Drescher-2 wrote:
> 
> 
> Is your database mysql?
> 
> I ask this because I use postgresql and I know for a fact that
> bacula-web does not work with postgresql without some patching.
> John
> 
Hi,

We are using Mysql but i first installed bacula with SQLite, then installed
the package for mysql, but didn't reinstall all from scratch.
I installed using apt-get (Ubuntu Server 7.10) and not from source.

Regards,

nico
-- 
View this message in context: 
http://www.nabble.com/Bacula-web---Error-query%3A-4-tp15714690p15715347.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula-web - Error query: 4

[John Drescher]

On Wed, Feb 27, 2008 at 9:43 AM, nda <[EMAIL PROTECTED]> wrote:
>
>  Hi,
>
>  We are currently testing Bacula at work, but it isn't a easy task...
>  Installation seems ok and i succeed the catalog backup.
>  I'm now trying to mage the web interface work, but i get this error message
>  :
>  Error query: 4
>
>  Don't know how to solve that... I found a few topic about that error on
>  internet, but no solutions...
>
>  As we are coming from Backup Exec, it's really different software!
>
Is your database mysql?

I ask this because I use postgresql and I know for a fact that
bacula-web does not work with postgresql without some patching.
John

-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Bacula-web - Error query: 4

[nda]

Hi,

We are currently testing Bacula at work, but it isn't a easy task...
Installation seems ok and i succeed the catalog backup.
I'm now trying to mage the web interface work, but i get this error message
:
Error query: 4

Don't know how to solve that... I found a few topic about that error on
internet, but no solutions...

As we are coming from Backup Exec, it's really different software!

Nico
-- 
View this message in context: 
http://www.nabble.com/Bacula-web---Error-query%3A-4-tp15714690p15714690.html
Sent from the Bacula - Users mailing list archive at Nabble.com.


-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] bacula-web Error query: 4

[deval74]

Dear Dan
Many thanks for your reply.
I do have another query while configuring bacula-web. I have untared bacula-gui 
and than run ./configure and checked pre-requisite and copied bacula-web to 
documentroot of apache "/var/www/html/ and run test.php its running 
successfully and chnaged permission for /var/www/html/bacula-web to apache user.

But its giving me following error when opening https://192.168.0.238/bacula-web

Error query: 4

I am not able to understand why this error is coming
Please help me if somebody has faced similar error.

Best Regards


DEVAL KULSHRESTHA

- Original Message 
From: Dan Langille <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: bacula users ; Deval Kulshrestha 
<[EMAIL PROTECTED]>
Sent: Monday, 18 February, 2008 6:54:59 PM
Subject: Re: [Bacula-users] Required Bacula GUI for Configuration

On Feb 18, 2008, at 8:17 AM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>  
wrote:

> Hi
> I am a new user of Bacula, Evaluating various option with bacula.
> My Interest area's are .
> 1. Online Remote Backup Functionality: I found Bacula is quite  
> stable and suitable for this purpose.
> 2. Multiple OS support: I have tested bacula with Intel/AMD 32 bit/ 
> 64 bit arch. Linux, Solaris and WindowsXP. Its working  
> Satisfactorily there.
> 3. Disk based backup: Bacula is again working well on this front as  
> well.
> 4. Ease of Use and administration: I found that bacula is having  
> multiple Interactive utility and console( BCONSOLE, BAT, BIMAGEMGR,  
> BWX-CONSOLE, BGNOME-CONSOLE, TRAY-MONITOR, BWEB BRESTORE, and  
> BACULA-WEB) a very long list of Interactive utilities. But i didn't  
> get a single GUI/WEB utility which  allows me to control the  
> configuration part of BACULA.
> Like following
> 1. Creating and Defining Clients.
> 2. Creating and Defining Storage Targets.
> 3. Creating and Defining File Set.
>
> which i feel  would be very usefull if available within a product  
> like Bacula.
> Every time whenever i have to perform any of (1,2,3) activities i  
> will have to make changes in any of the configuration file(bacula- 
> dir.conf, etc)
>
> Otherwise all "operational options" are available there in GUI  
> utility.
>
> This could be my Limitation of awareness and understanding also  
> about the product and features. If somebody have solution for this  
> please help me to know that.


There is no GUI configuration tool for Bacula.

-- 
Dan Langille -- http://www.langille.org/
[EMAIL PROTECTED]










  Did you know? You can CHAT without downloading messenger. Go to 
http://in.messenger.yahoo.com/webmessengerpromo.php/ -
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users