[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Debian new Install



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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users