Ashley,
Sweet...a little progress:
Again, on Ubuntu Edgy did:
sudo su postgres
psql ledger-smb
(since ledger-smb is database name)
at ledger-smb=# prompt did
\dt
and got:
List of relations
Schema | Name | Type | Owner
--------+------------+-------+------------
public | session | table | ledger-smb
public | users | table | ledger-smb
public | users_conf | table | ledger-smb
(3 rows)
then did the
ledger-smb=# GRANT ALL ON session TO "ledger-smb";
and it returned:
GRANT
Sweet!
OK, so now I did that with the other two table names, users and
users_conf, per your instructions.
Went back to the admin.pl page, tried both
admin
as password and
(nothing in the space)
and it still returned "access denied." Hmmm.
Here is my /etc/ledger-smb/ledger-smb.conf file:
------------------------------------------
session : DB
logging : 0
# Set language for login and admin pages
language :
# If you have LaTeX installed, set to 1
latex : 1
# Maximum number of invoices that can be printed on a cheque
check_max_invoices : 5
[environment]
# If the server can't find applications, append to the path
PATH: /usr/local/pgsql/bin
PATH: /usr/local/bin
# If on Mac OS X using Fink's Perl libs, append to the path
#PERL5LIB = /sw/lib/perl5
[paths]
# spool directory for batch printing
spool = /var/lib/ledger-smb/spool
# path to user configuration files
userspath = /var/lib/ledger-smb/users
# templates base directory
templates = templates
# member file
#PERL5LIB = /sw/lib/perl5
[paths]
# spool directory for batch printing
spool = /var/lib/ledger-smb/spool
# path to user configuration files
userspath = /var/lib/ledger-smb/users
# templates base directory
templates = templates
# member file
memberfile = /var/lib/ledger-smb/users/members
localepath = locale/po
[programs]
# program to use for file compression
gzip = gzip -S .gz
[mail]
### How to send mail. The sendmail command is used unless smtphost is set.
sendmail = /usr/bin/sendmail -t
# smtphost = 127.0.0.1
# smtptimeout = 60
[printers]
# Available printers
Laser = lpr -Plaser
Epson = lpr -PEpson
[globaldb]
# These paramaters *must* be set correctly
# for LedgerSMB >= 1.2 to work
DBConnect = dbi:Pg:dbname=ledger-smb;host=localhost;port=5432
DBUserName = ledger-smb
DBPassword = admin
----------------------------------
(There may be some repetition in there as I had to paste that page by
page from nano since I am not at the host computer to use gedit or
whatver else directly).
One more step down, but is there something I have missed perhaps?
Best,
Matt
On 3/5/07, Ashley J Gittins <..hidden..> wrote:
> On Tue, 6 Mar 2007, Matt Jackson wrote:
> > Ashley,
> > The plot thickens! lol
> > OK I tried the following, after doing a
> > sudo su postgres
> > and then psql
> > and then got the
> > postgres=#
> > prompt and entered the following, with teh following result:
> >
> > postgres=# GRANT ALL ON SESSION TO "ledger-smb";
> > ERROR: relation "session" does not exist
>
> D'oh! Sorry, when you run psql, add the database name as a parameter, ie:
>
> psql ledger-smb
>
> so that it actually opens the LSMB database, which contains the session table.
>
> > Then I tried this, with the following result:
> >
> > postgres=# GRANT ALL ON * TO "ledger-smb";
> > ERROR: syntax error at or near "*" at character 14
> > LINE 1: GRANT ALL ON * TO "ledger-smb";
> > ^
>
> Ahh, sorry - my bad again, that syntax is invalid. I don't know how to
> specify "all tables", so you would need to list them all out separately if
> you wanted to do that. You can get a list of tablenames by entering
>
> \dt
>
> in psql.
>
> > Is my next step to find that config file? Must I be missing something from
> > it?
>
> Nope, stick with the psql bits, once we get past my bad advice we'll decide
> where to blindly run from there B-D
>
> --
> Regards,
> Ashley J Gittins
> web: http://www.purple.dropbear.id.au
> jabber: ..hidden..
>
> -------------------------------------------------------------------------
> 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
--
Regards,
Matt