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

Re: Login problems


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


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:



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


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

# 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

# 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

# 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

# program to use for file compression
gzip       = gzip -S .gz

### How to send mail.  The sendmail command is used unless smtphost is set.
sendmail   = /usr/bin/sendmail -t
# smtphost =
# smtptimeout = 60

# Available printers
Laser      = lpr -Plaser
Epson      = lpr -PEpson

# 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?


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


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

        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
Ledger-smb-users mailing list