Short version:
I made it past the DB permissions and now fail inside import_users.pl
edited ledger-smb.conf
DBConnect = dbi:Pg:dbname=prodlsmb;host=localhost;port=5432
DBUserName = 'Ledger-SMB_Owner'
#DBPassword = set me to correct password
then
$ ./import_members.pl users/members
DBI
connect('dbname=prodlsmb;host=localhost;port=5432',''Ledger-SMB_Owner'',...)
failed: FATAL: role "'Ledger-SMB_Owner'" does not exist
at LedgerSMB/Sysconfig.pm line 99
Error: No GlobalDBH Configured or Could not Connect
Compilation failed in require at LedgerSMB/User.pm line 35.
BEGIN failed--compilation aborted at LedgerSMB/User.pm line 35.
Compilation failed in require at ./import_members.pl line 28.
BEGIN failed--compilation aborted at ./import_members.pl line 28.
Need help in the import_users script.
Thanks in advance,
Louis
**********************************************
Long version:
***********************************************
pass number 2....
(1) unpack ledger-smb-1.2.0b3.tar.gz in /tmp and read releasenotes and
UPGRADE, etc.
(2) do the Build.pl thing in /tmp and make sure all CPAN modules are present.
(3) make a clean copy
/usr/local# rm -rf ledger-smb
/usr/local# mkdir ledger-smb
/usr/local# cd ledger-smb
/usr/local/ledger-smb# cp -a ../sql-ledger/* ./
/usr/local/ledger-smb# more VERSION
2.6.19
/usr/local/ledger-smb# ls users/
Hethcote-Logo.eps jb.conf members sql-ledger.eps test.conf
Hethcote-Logo.png lbmoore.conf root login.conf sql-ledger.png
/usr/local/ledger-smb#
$ psql template1
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
template1=# drop database prodlsmb;
DROP DATABASE
template1=> \q
(4) Use pg_dump insteat createdb -T to make the transistion database
$ pg_dump hethcote > sl-2-ls.sql
$ sed -i -e's/SQL-Ledger_Owner/Ledger-SMB_Owner/' sl-2-ls.sql
$ createdb -O Ledger-SMB_Owner prodlsmb
CREATE DATABASE
$ psql prodlsmb
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
prodlsmb=# \i sl-2-ls.sql
.
.
.
GRANT
Prodlsmb=# select version from defaults;
version
---------
2.6.12
(1 row)
edit users/members, et al to change prodsqlg to prodlsmb and
dbuser appropriately
unpack ledger-smb-1.2.0b3.tar.gz over /usr/local/ledger-smb and
correct ownership with chown -R
prodlsmb=> \i Pg-upgrade-2.6.12-2.6.17.sql
psql:Pg-upgrade-2.6.12-2.6.17.sql:1: ERROR: relation "session_session_id_seq"
already exists
psql:Pg-upgrade-2.6.12-2.6.17.sql:8: ERROR: relation "session" already exists
ALTER TABLE
ALTER TABLE
UPDATE 4939
ALTER TABLE
ALTER TABLE
UPDATE 1
prodlsmb=> select version from defaults;
version
---------
2.6.17
(1 row)
prodlsmb=> \i Pg-upgrade-2.6.17-2.6.18.sql
BEGIN
psql:Pg-upgrade-2.6.17-2.6.18.sql:2: NOTICE: ALTER TABLE / ADD PRIMARY KEY
will create implicit index "chart_pkey" for table "chart"
ALTER TABLE
LOCK TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
UPDATE 4939
.
.
.
CREATE FUNCTION
UPDATE 1
COMMIT
prodlsmb=> select version from defaults;
version
---------
2.6.18
(1 row)
prodlsmb=> \i Pg-upgrade-2.6.18-2.6.19.sql
BEGIN
psql:Pg-upgrade-2.6.18-2.6.19.sql:3: NOTICE: ALTER TABLE / ADD PRIMARY KEY
will create implicit index "ap_pkey" for table "ap"
ALTER TABLE
.
.
.
COMMENT
INSERT 0 26
DROP TABLE
CREATE FUNCTION
CREATE FUNCTION
COMMIT
prodlsmb=> update users_conf set password = md5('my_password');
UPDATE 1
prodlsmb=> \q
<<< Yay >>>
(5) run the import-users script
cp ledger-smb.conf.default ledger-smb.conf
set:
DBConnect = dbi:Pg:dbname=prodlsmb;host=localhost;port=5432
DBUserName = 'Ledger-SMB_Owner'
#DBPassword = set me to correct password
$ ./import_members.pl users/members
DBI
connect('dbname=prodlsmb;host=localhost;port=5432',''Ledger-SMB_Owner'',...)
failed: FATAL: role "'Ledger-SMB_Owner'" does not exist
at LedgerSMB/Sysconfig.pm line 99
Error: No GlobalDBH Configured or Could not Connect
Compilation failed in require at LedgerSMB/User.pm line 35.
BEGIN failed--compilation aborted at LedgerSMB/User.pm line 35.
Compilation failed in require at ./import_members.pl line 28.
BEGIN failed--compilation aborted at ./import_members.pl line 28.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
