Ticket #1542 (Closed: fixed)

On installing the 1.0.2 livesupport-station Debian packages under Ubuntu, I'm getting the following errors:

root@douglas:/home/douglas/downloads/livesupport# dpkg -i livesupport-station
dpkg: error processing livesupport-station (--install):
 cannot access archive: No such file or directory
Errors were encountered while processing:
 livesupport-station
root@douglas:/home/douglas/downloads/livesupport# dpkg -i livesupport-station_1.0.2-1_i386.deb
Selecting previously deselected package livesupport-station.
(Reading database ... 66437 files and directories currently installed.)
Unpacking livesupport-station (from livesupport-station_1.0.2-1_i386.deb) ...
Checking for required tools...
Exectuable sed found...
Exectuable psql found...
Exectuable php found...
Exectuable pear found...
Exectuable odbcinst found...
Checking for validity of apache daemon group www-data...
Apache daemon group www-data OK.
Setting up livesupport-station (1.0.2-1) ...
Making post-install steps for the LiveSupport scheduler.
Using the following installation parameters:
  installation directory: /opt/livesupport
  database server:        localhost
  database:               LiveSupport
  database user:          livesupport
  database user password: livesupport
  apache daemon group:    www-data
  apache document root:   /var/www
Checking for required tools...
Executable sed found...
Executable psql found...
Executable php found...
Executable pear found...
Executable odbcinst found...
Modifying postgresql access permissions...
/opt/livesupport/bin/postInstallStation.sh: line 243: /etc/init.d/postgresql: No such file or directory
Creating database and database user...
ERROR:  user "livesupport" already exists
ERROR:  database "LiveSupport" already exists
Creating ODBC data source and driver...
Registering LiveSupport ODBC data source...
Configuring PEAR packages needed by LiveSupport
 (with destdir: /opt/livesupport)
Installing PEAR packages needed by LiveSupport to directory:
 /opt/livesupport
 Archive_Tar: upgrading to Archive_Tar-1.3.1 OK
 Console_Getopt: upgrading to Console_Getopt-1.2 OK
 XML_RPC: upgrading to XML_RPC-1.4.4 OK
 PEAR: upgrading to PEAR-1.3.5 OK
 Calendar: upgrading to Calendar-0.5.2 OK
 DB: upgrading to DB-1.7.6 OK
 File: upgrading to File-1.2.0 OK
 File_Find: upgrading to File_Find-0.3.1 OK
 HTML_Common: upgrading to HTML_Common-1.2.1 OK
 HTML_QuickForm: upgrading to HTML_QuickForm-3.2.5 OK
 XML_Util: upgrading to XML_Util-1.1.1 OK
 XML_Parser: upgrading to XML_Parser-1.2.6 OK
 XML_Beautifier: upgrading to XML_Beautifier-1.1 OK
 XML_Serializer: upgrading to XML_Serializer-0.15.0 OK
Install of PEAR packages needed by LiveSupport finished OK.
Setting up directory permissions...
Configuring apache ...
/etc/apache/conf.d N
/etc/apache2/conf/modules.d N
/etc/httpd/conf.d N
###############################
 Could not configure Apache
  include following file into apache config manually:
  /opt/livesupport/etc/apache/90_php_livesupport.conf
###############################
done
Restarting apache...
apache N
apache2 Y
 * Forcing reload of web server  (Apache2)...                            [ ok ]
httpd N
done
Creating symlinks...
Initializing database...
DB Error: connect failed
 [nativecode=Unable to connect to PostgreSQL server: could not connect to server: Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5432?] ** Array
Database connection problem.
Check if database 'LiveSupport' exists with corresponding permissions.
Database access is defined by 'dsn' values in var/conf.php (in storageServer directory).
dpkg: error processing livesupport-station (--install):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 livesupport-station
root@douglas:/home/douglas/downloads/livesupport# 

============================= =============================

I reinstalled Postgres 7.4, and got the following output from cat /etc/postgresql/pg_hba.conf:

root@douglas:/home/douglas/downloads/livesupport# cat /etc/postgresql/pg_hba.conf
# PostgreSQL Client Authentication Configuration File
# ===================================================
#
# Refer to the PostgreSQL Administrator's Guide, chapter "Client
# Authentication" for a complete description.  A short synopsis
# follows.
#
# This file controls: which hosts are allowed to connect, how clients
# are authenticated, which PostgreSQL user names they can use, which
# databases they can access.  Records take one of seven forms:
#
# local      DATABASE  USER  METHOD  [OPTION]
# host       DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# hostssl    DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# hostnossl  DATABASE  USER  IP-ADDRESS  IP-MASK   METHOD  [OPTION]
# host       DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
# hostssl    DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
# hostnossl  DATABASE  USER  IP-ADDRESS/CIDR-MASK  METHOD  [OPTION]
#
# (The uppercase quantities should be replaced by actual values.)
# The first field is the connection type: "local" is a Unix-domain socket,
# "host" is either a plain or SSL-encrypted TCP/IP socket, "hostssl" is an
# SSL-encrypted TCP/IP socket, and "hostnossl" is a plain TCP/IP socket.
# DATABASE can be "all", "sameuser", "samegroup", a database name (or
# a comma-separated list thereof), or a file name prefixed with "@".
# USER can be "all", an actual user name or a group name prefixed with
# "+", an include file prefixed with "@" or a list containing either.
# IP-ADDRESS and IP-MASK specify the set of hosts the record matches.
# CIDR-MASK is an integer between 0 and 32 (IPv6) or 128(IPv6)
# inclusive, that specifies the number of significant bits in the
# mask, so an IPv4 CIDR-MASK of 8 is equivalent to an IP-MASK of
# 255.0.0.0, and an IPv6 CIDR-MASK of 64 is equivalent to an IP-MASK
# of ffff:ffff:ffff:ffff::. METHOD can be "trust", "reject", "md5",
# "crypt", "password", "krb5", "ident", or "pam".  Note that
# "password" uses clear-text passwords; "md5" is preferred for
# encrypted passwords.  OPTION is the ident map or the name of the PAM
# service.
#
# INCLUDE FILES:
# If you use include files for users and/or databases (see PostgreSQL
# documentation, section 19.1), these files must be placed in the
# database directory. Usually this is /var/lib/postgres/data/, but
# that can be changed in /etc/postgresql/postmaster.conf with the
# POSTGRES_DATA variable. Putting them in /etc/postgresql/ will NOT
# work since the configuration files are only symlinked from
# POSTGRES_DATA.
#
# This file is read on server startup and when the postmaster receives
# a SIGHUP signal.  If you edit the file on a running system, you have
# to SIGHUP the postmaster for the changes to take effect, or use
# "pg_ctl reload".
#
# Upstream default configuration
#
# The following configuration is the upstream default, which allows
# unrestricted access to amy database by any user on the local machine.
#
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
#
#local   all         all                                             trust
# IPv4-style local connections:
#host    all         all         127.0.0.1         255.255.255.255   trust
# IPv6-style local connections:
#
# Put your actual configuration here
# ----------------------------------
#
# This default configuration allows any local user to connect as himself
# without a password, either through a Unix socket or through TCP/IP; users
# on other machines are denied access.
#
# If you want to allow non-local connections, you need to add more
# "host" records before the final line that rejects all TCP/IP connections.
# Also, remember TCP/IP connections are only enabled if you enable
# "tcpip_socket" in /etc/postgresql/postgresql.conf.
#
# DO NOT DISABLE!
# If you change this first entry you will need to make sure the postgres user
# can access the database using some other method.  The postgres user needs
# non-interactive access to all databases during automatic maintenance
# (see the vacuum command and the /usr/lib/postgresql/bin/do.maintenance
# script).
#
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
# Database administrative login by UNIX sockets
local   all         postgres                                        ident sameuser
#
# All IPv4 connections from localhost
# The following line was inserted by the livesupport-station package installer
# the original pg_hba.conf file is saved under pg_hba.conf.before-livesupport
host    all         all         127.0.0.1         255.255.255.255   password
#host    all         all         127.0.0.1         255.255.255.255   ident sameuser
#
# All other connections by UNIX sockets
local   all         all                                             password
#
# All IPv6 localhost connections
#
# reject all other connection attempts
host    all         all         0.0.0.0           0.0.0.0           reject

====================== ======================

In addition, I'm getting the following error message when I try to run /opt/livesupport/usr/lib/pear/bin/install.sh:

root@douglas:/opt/livesupport/usr/lib/pear/bin# ./install.sh
./install.sh: line 120: cd: /opt/livesupport/usr/lib/pear/../../usr: No such file or directory
Configuring PEAR packages needed by LiveSupport
 (with destdir: /opt/livesupport/usr/lib/pear/bin)
Installing PEAR packages needed by LiveSupport to directory:
 /opt/livesupport/usr/lib/pear/bin
 Archive_Tar: install ok: Archive_Tar 1.3.1
installing Archive_Tar-1.3.1 OK
 Console_Getopt: install ok: Console_Getopt 1.2
installing Console_Getopt-1.2 OK
 XML_RPC: install ok: XML_RPC 1.4.4
installing XML_RPC-1.4.4 OK
 PEAR: install ok: PEAR 1.3.5
installing PEAR-1.3.5 OK
 Calendar: Optional dependencies:
package `Date' is recommended to utilize some features.
install ok: Calendar 0.5.2
installing Calendar-0.5.2 OK
 DB: install ok: DB 1.7.6
installing DB-1.7.6 OK
 File: install ok: File 1.2.0
installing File-1.2.0 OK
 File_Find: install ok: File_Find 0.3.1
installing File_Find-0.3.1 OK
 HTML_Common: install ok: HTML_Common 1.2.1
installing HTML_Common-1.2.1 OK
 HTML_QuickForm: install ok: HTML_QuickForm 3.2.5
installing HTML_QuickForm-3.2.5 OK
 XML_Util: install ok: XML_Util 1.1.1
installing XML_Util-1.1.1 OK
 XML_Parser: install ok: XML_Parser 1.2.6
installing XML_Parser-1.2.6 OK
 XML_Beautifier: install ok: XML_Beautifier 1.1
installing XML_Beautifier-1.1 OK
 XML_Serializer: install ok: XML_Serializer 0.15.0
installing XML_Serializer-0.15.0 OK
Install of PEAR packages needed by LiveSupport finished OK.
root@douglas:/opt/livesupport/usr/lib/pear/bin#