Package: davical
Version: 0.9.9.3-0
Severity: normal
I have the same problem. Allowing a "trust" type connection is out of the
question
so this is how my /etc/postgresql/8.4/main/pg_hba.conf looks like.
# Database administrative login by UNIX sockets
local all postgres ident
# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all root md5
# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
When I run /usr/share/davical/dba/create-database.sh this happens:
postgres@mail:/tmp$ /usr/share/davical/dba/create-database.sh
Password for user davical_dba:
Password for user davical_dba:
Password for user davical_dba:
Password for user davical_dba:
Password for user davical_dba:
Using database: davical_dba%@dbi:Pg:dbname=davical
DBI connect('dbname=davical','davical_dba',...) failed: fe_sendauth: no
password supplied at /usr/share/davical/dba/update-davical-database line 245
Can't connect to database davical at
/usr/share/davical/dba/update-davical-database line 245.
* * * * ERROR * * * *
The database administration utility failed. This may be due to database
permissions for the davical_dba user, or because the Perl DBD::Pg or YAML
libraries are not available.
Check that your pg_hba.conf allows the davical_dba user to connect to the
database (and make sure you've reloaded PostgreSQL since changing that).
Also see: http://wiki.davical.org/w/Install_Errors/No_Perl_YAML
For above output debuging in /usr/share/davical/dba/update-davical-database was
activated.
I can workaround the problem by editing
/usr/share/davical/dba/update-davical-database on line 19 and changing
my $dbpass = "";
to
my $dbpass = "PASSWORD_FOR_USER_davical_dba";
during installation. I am not finished with the setup so I don't know if it
will work later without the workaround.
I guess somehow the script doesn't use the password it asks from the user. I
don't know perl so I can't debug it further.
-- System Information:
Debian Release: 6.0.7
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.32-5-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages davical depends on:
ii debconf 1.5.36.1 Debian configuration management sy
ii libawl-php 0.45-0 Andrew's Web Libraries - PHP Utili
ii libdbd-pg-perl 2.17.1-2+squeeze1 Perl DBI driver for the PostgreSQL
ii libyaml-perl 0.71-1 YAML Ain't Markup Language
ii php5-pgsql 5.3.3-7+squeeze14 PostgreSQL module for php5
ii postgresql-client-8.4 8.4.16-0squeeze1 front-end programs for PostgreSQL
davical recommends no packages.
davical suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
