Re: [Bacula-users] Bacula on Ubuntu 12.04.01

2013-01-15 Thread Sven Gehr 
> You should also reset the above line to "md5" instead of "trust"

ok, I chanege the line to:


hostlocalhost   all 0.0.0.0/0   md5


> Check if DB Adress = "localhost" is set in your Bacula-Directory


after the install the section looks like:



Catalog {
   Name = MyCatalog
# Uncomment the following line if you want the dbi driver
# dbdriver = "dbi:sqlite3"; dbaddress = 127.0.0.1; dbport =
   dbname = "bacula"; DB Address = ""; dbuser = "bacula"; dbpassword = 
"geheim"
}

I set the DB Address an now it works.



many many thanks !!!



-- 
Viele Grüsse

Sven Gehr

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula on Ubuntu 12.04.01

2013-01-15 Thread lst_hoe02 

Zitat von Sven Gehr :

> I add the line:
>
>
> hostlocalhost   all 127.0.0.1/32trust
>
>
> an restart the server. Same problem again.

Check if DB Adress = "localhost" is set in your Bacula-Directory  
config file, if not the unix sockets are used, which work by trusting  
the matching OS user. It does not work if you test as root or other  
non-bacula user.
You should also reset the above line to "md5" instead of "trust"

Regards

Andreas




--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula on Ubuntu 12.04.01

2013-01-15 Thread Sven Gehr 
I add the line:


hostlocalhost   all 127.0.0.1/32trust


an restart the server. Same problem again.



Am 15-01-2013 10:42, schrieb lst_ho...@kwsoft.de:
> Zitat von Sven Gehr :
> 
>> Hi@all,
>> 
>> I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I
>> install with the following command:
>> 
>> 
>> aptitude install postgresql
>> aptitude install bacula-director-pgsql bacula-common-pgsql
>> bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console
>> 
>> 
>> and answer the questions:
>> 
>> Konfigurieren der Datenbank für bacula-director-pgsql mit
>> dbconfig-common: Ja
>> PostgreSQL-Anwendungspasswort für bacula-director-pgsql: 
>> secret
>> 
>> 
>> Now I want test my director with:
>> 
>> bacula-dir -t
>> 
>> and get the error:
>> 
>> bacula-dir: dird.c:954 Konnte Catalog "MyCatalog", database "bacula"
>> nicht öffnen.
>> bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to 
>> PostgreSQL
>> server. Database=bacula User=bacula
>> Possible causes: SQL server not running; password incorrect;
>> max_connections exceeded.
>> 15-Jan 10:04 bacula-dir ERROR TERMINATION
>> Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf
>> 
>> 
>> The role 'bacula' is available:
>> 
>> 
>> postgres=# \dg[+]
>>  List of roles
>>   Role name |   Attributes   | Member 
>> of
>> | Description
>> ---++---+-
>>   bacula|| {}
>> |
>>   postgres  | Superuser, Create role, Create DB, Replication | {}
>> |
>> 
>> 
>> 
>> but I miss the script's (create_bacula_database, make_bacula_tables 
>> and
>> grant_bacula_privileges). Where can I find the scripts on my
>> ubuntu-system?
>> 
> 
> Hello
> 
> you should check pg_hba.conf. It is set restrictive on a stock Ubuntu
> 12.04 install and be aware that per default unix sockets are used if
> you dont at least specify "localhost" as target.
> 
> Regards
> 
> Andreas
> 
> 
> 
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow 
> -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and 
> experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Viele Grüsse

Sven Gehr

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula on Ubuntu 12.04.01

2013-01-15 Thread Sven Gehr 
I checked whether the database exists:



postgres=# \l
   List of databases
Name|  Owner   | Encoding  |   Collate   |Ctype|   
Access privileges
---+--+---+-+-+---
  bacula| postgres | SQL_ASCII | de_DE.UTF-8 | de_DE.UTF-8 |
  postgres  | postgres | UTF8  | de_DE.UTF-8 | de_DE.UTF-8 |
  template0 | postgres | UTF8  | de_DE.UTF-8 | de_DE.UTF-8 | 
=c/postgres  +
|  |   | | | 
postgres=CTc/postgres
  template1 | postgres | UTF8  | de_DE.UTF-8 | de_DE.UTF-8 | 
=c/postgres  +
|  |   | | | 
postgres=CTc/postgres
(4 rows)




Am 15-01-2013 10:21, schrieb Sven Gehr:
> Hi@all,
> 
> I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I
> install with the following command:
> 
> 
> aptitude install postgresql
> aptitude install bacula-director-pgsql bacula-common-pgsql
> bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console
> 
> 
> and answer the questions:
> 
> Konfigurieren der Datenbank für bacula-director-pgsql mit
> dbconfig-common:  Ja
> PostgreSQL-Anwendungspasswort für bacula-director-pgsql:  
> secret
> 
> 
> Now I want test my director with:
> 
> bacula-dir -t
> 
> and get the error:
> 
> bacula-dir: dird.c:954 Konnte Catalog "MyCatalog", database "bacula"
> nicht öffnen.
> bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to 
> PostgreSQL
> server. Database=bacula User=bacula
> Possible causes: SQL server not running; password incorrect;
> max_connections exceeded.
> 15-Jan 10:04 bacula-dir ERROR TERMINATION
> Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf
> 
> 
> The role 'bacula' is available:
> 
> 
> postgres=# \dg[+]
>  List of roles
>   Role name |   Attributes   | Member 
> of
> | Description
> ---++---+-
>   bacula|| {}
> |
>   postgres  | Superuser, Create role, Create DB, Replication | {}
> |
> 
> 
> 
> but I miss the script's (create_bacula_database, make_bacula_tables 
> and
> grant_bacula_privileges). Where can I find the scripts on my
> ubuntu-system?
> 
> 
> 
> 
> 
> 
> --
> Viele Grüsse
> 
> Sven Gehr
> 
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow 
> -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and 
> experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Bacula-users mailing list
> Bacula-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Viele Grüsse

Sven Gehr

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Re: [Bacula-users] Bacula on Ubuntu 12.04.01

2013-01-15 Thread lst_hoe02 

Zitat von Sven Gehr :

> Hi@all,
>
> I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I
> install with the following command:
>
>
> aptitude install postgresql
> aptitude install bacula-director-pgsql bacula-common-pgsql
> bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console
>
>
> and answer the questions:
>
> Konfigurieren der Datenbank für bacula-director-pgsql mit
> dbconfig-common:  Ja
> PostgreSQL-Anwendungspasswort für bacula-director-pgsql:  
> secret
>
>
> Now I want test my director with:
>
> bacula-dir -t
>
> and get the error:
>
> bacula-dir: dird.c:954 Konnte Catalog "MyCatalog", database "bacula"
> nicht öffnen.
> bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to PostgreSQL
> server. Database=bacula User=bacula
> Possible causes: SQL server not running; password incorrect;
> max_connections exceeded.
> 15-Jan 10:04 bacula-dir ERROR TERMINATION
> Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf
>
>
> The role 'bacula' is available:
>
>
> postgres=# \dg[+]
>  List of roles
>   Role name |   Attributes   | Member of
> | Description
> ---++---+-
>   bacula|| {}
> |
>   postgres  | Superuser, Create role, Create DB, Replication | {}
> |
>
>
>
> but I miss the script's (create_bacula_database, make_bacula_tables and
> grant_bacula_privileges). Where can I find the scripts on my
> ubuntu-system?
>

Hello

you should check pg_hba.conf. It is set restrictive on a stock Ubuntu  
12.04 install and be aware that per default unix sockets are used if  
you dont at least specify "localhost" as target.

Regards

Andreas



--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

[Bacula-users] Bacula on Ubuntu 12.04.01

2013-01-15 Thread Sven Gehr 
Hi@all,

I want to install bacula on a ubuntu-server (12.04.01-LTS / 64bit). I 
install with the following command:


aptitude install postgresql
aptitude install bacula-director-pgsql bacula-common-pgsql 
bacula-sd-pgsql bacula-fd bacula-sd-tools bacula-console


and answer the questions:

Konfigurieren der Datenbank für bacula-director-pgsql mit 
dbconfig-common:Ja
PostgreSQL-Anwendungspasswort für bacula-director-pgsql:
secret


Now I want test my director with:

bacula-dir -t

and get the error:

bacula-dir: dird.c:954 Konnte Catalog "MyCatalog", database "bacula" 
nicht öffnen.
bacula-dir: dird.c:959 postgresql.c:241 Unable to connect to PostgreSQL 
server. Database=bacula User=bacula
Possible causes: SQL server not running; password incorrect; 
max_connections exceeded.
15-Jan 10:04 bacula-dir ERROR TERMINATION
Bitte die Konfigurationsdatei korrigieren: bacula-dir.conf


The role 'bacula' is available:


postgres=# \dg[+]
 List of roles
  Role name |   Attributes   | Member of 
| Description
---++---+-
  bacula|| {}
|
  postgres  | Superuser, Create role, Create DB, Replication | {}
|



but I miss the script's (create_bacula_database, make_bacula_tables and 
grant_bacula_privileges). Where can I find the scripts on my 
ubuntu-system?






-- 
Viele Grüsse

Sven Gehr

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users