[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Instalation Woes
- From: Michael Borck <..hidden..>
- Date: Tue, 13 Feb 2007 00:42:06 +0800
Firstly, I like the direction ledger-smb appears to be heading, hence my
choice to use ledger-smb over sql-ledger.
I am having trouble installing/getting to work ledger-smb. My main
problem is I can't seem to get to the "admin" section (so can't create a
user hence I can't logon to ledger-smb). I have tried various install
methods/options as follows. I am sure I am missing something simple.
Apache finds the pages, I can access postgresql, create databases/users
(via postgres commands). I was originally running Debian (stable),
used the backports for Postgresql 8.1. Didn't work, try Debian(testing)
which include postgres 8.1.
1. Install sql-ledger, use ledger-smb 1.1.8 as a "drop in replacement"
as per Readme. This one get the closest, I login and it gives me the
message that database has been upgraded. When I log in again all I get
is a blank screen. Note sql-ledger appears to be working.
2. Install from .deb packages both 1.20 Beta 3 & 4, and 1.1.99b3.
Neither work, get to "login screen (admin.pl) and "Access denied"
3. Manual install from 1.2.0 Beta 5 source as per INSTALL instructions.
Admin.pl want a password. Ran "perl Build.PL" Runs various postgresql
commands, create users, database and then run Pg-central.sql. No
errors. I can see the tables etc in the database. I configure apache2
and run ledger-smb. Login screen pops up (s far so good) and admin
requires a password. Try just hitting logon didn't work. So next
assumed same as set in ledger-smb.conf, still no luck. Note the
following postgres command fails:
update users_conf set password = md5('yada');
update users_conf set password = md5('yada') where id = 1;
From memory, the error is about password field being type "character
varying" and the information supplied is "character varying". Used psql
to look at schema but doesn't make too much sense to me. I have also
assumed the in pg_hba.conf I need to modify authentication method to md5
(I also tried 'none').
My best guess is that it is not detecting I haven't run ledger-sqb
before and so I don't get "change admin password". So this prevents me
setting up a ledger-smb user and hence never been able to connect to the
Failing that, perhaps the connection to postgresql is somehow failing.
Think that it might be related to pg_hba.conf. Tried, ident, md5 and
none. None of this works.
Note sql-ledger works (apt-get install sql-ledger). I have no "real"
data/accounts to update, so I am not looking at preserving anything from SL.
I have searched the mailing list archives but couldn;t fins anything
Anyone have any ideas what I am doing wrong/missing or have some idea
for me to try? If you need more information please let me know.