Ashley and all,
A little MORE progress!
I found this line online:
su - postgres -c "psql ledgersmb -c \"update users_conf set password =
md5('yada') where id = 1;\""
at http://209.85.165.104/search?q=cache:6QHn7YILxyYJ:rpmfind.net/linux/RPM/sourceforge/l/le/ledger-smb/ledger-smb-1.2.0b5-1.noarch.html+md5(%27admin%27)+ledgersmb&hl=en&ct=clnk&cd=3&gl=us
and so I ran this:
sudo su postgres
psql ledger-smb
update users_conf set password = md5('yada') where id = 1;
and it worked!
I set the password as administrator this time and now I am in!!
I went to PgDatabase admin button and tried to set a user but got
Error!
LedgerSMB/User.pm:301
FATAL: password authentication failed for user "monshishiinc"
why is it failing on the NEW user I am trying to create? Does that
mean my ledger-smb (superuser) password is wrong?
- Matt
On 3/5/07, Matt Jackson <..hidden..> wrote:
> 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
>
--
Regards,
Matt