OK
I purged postgresql and ledgersmb and reinstalled.
http://localhost/ledgersmb/setup.pl I am able to access the page
Super-user login ledgersmb
Password xxxxx
Database Company
/var/log/apache2/error.log
DBI connect('dbname=Company','ledgersmb',...) failed:
FATAL: database "Company" does not exi 2013-03-13 20:54:27
EDT STATEMENT: CREATE DATABASE "Company" WITH TEMPLATE
template0 ENCODING 'UTF8' st at LedgerSMB/Database.pm line
287
2013-03-13 20:54:56 EDT FATAL: database "Company" does not
exist DBD::Pg::db do failed: ERROR: permission denied to create
database at LedgerSMB/Database.pm line 429. 2013-03-13
20:55:03 EDT ERROR: permission denied to create database DBD::Pg::db
do failed: ERROR: permission denied to create database at
LedgerSMB/Database.pm line 429. 2013-03-13 20:55:03 EDT
STATEMENT: CREATE DATABASE "Company" WITH TEMPLATE
template0 ENCODING 'UTF8' Compilation failed in require
at /usr/share/ledgersmb/setup.pl line
8. 2013-03-13 21:00:58
EDT LOG: provided user name (postgres) and authenticated user name
(root) do not match [Wed Mar 13 20:54:27 2013] [error] [client ::1]
Premature end of script headers: setup.pl, referer: http://localhost/
2013-03-13 21:00:58 EDT FATAL: Peer authentication failed for user
"postgres" ledgersmb/setup.pl
/var/log/postgresql/postgresql-9.1-main.log
2013-03-13 20:54:27 EDT ERROR: permission denied to create database
DBI connect('dbname=Company','ledgersmb',...) failed:
FATAL: database "Company" does not exi 2013-03-13
20:54:27 EDT STATEMENT: CREATE DATABASE "Company" WITH
TEMPLATE template0 ENCODING 'UTF8' st at LedgerSMB/Database.pm line
287
2013-03-13 20:54:56 EDT FATAL: database "Company" does
not exist DBD::Pg::db do failed: ERROR: permission denied to create
database at LedgerSMB/Database.pm line 429. 2013-03-13
20:55:03 EDT ERROR: permission denied to create database
So I tried
~# /usr/share/ledgersmb/tools/prepare-company-database.sh
--company Company
--pgsql-contrib /usr/share/postgresql/9.1/extentions --password
xxxxx --srcdir /usr/share/ledgersmb/sql/modules/LOADORDER psql:
FATAL: Peer authentication failed for user "postgres" missing
file /usr/share/ledgersmb/sql/modules/LOADORDER/sql/modules/LOADORDER!
(use --srcdir argument) usage: prepare-company-database.sh --company
COMPANY --pgsql-contrib DIR [option1 .. optionN]
/etc/postgresql/9.1/main/pg_hba.conf
# "local" is for Unix domain socket connections only
local all all peer
local all all md5
/etc/postgresql/9.1/main/postgresql.conf
listen_addresses = '*' # what IP address(es) to listen on;
I used the same password for all the questions
Is this a permissions issue? and if so what files or directory?
Geordie
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
