Chris,
When I did this on Ubuntu Edgy:
sudo su postgres
psql -U ledger-smb ledger-smb
(user and dbname are same)
I get the prompt without being challenged for a password.
Does this make my system weird? lol
Regards,
Matt J.
On 3/5/07, Chris Travers <..hidden..> wrote:
> Try:
> psql -U ledger-smb [dbname]
> type your password, from your config file, it is "admin."
>
> Are you able to log in?
>
> Best Wishes,
> Chris Travers
>
> On 3/5/07, Matt Jackson <..hidden..> wrote:
> > Hmm...tried more stuff...
> >
> > Tried to add a user, thinking it might be the next piece of advice and got:
> >
> > Error!
> >
> > Dataset missing!
> >
> > Any ideas here? lol
> >
> > - Matt
> >
> >
> >
> > On 3/5/07, Matt Jackson <..hidden..> wrote:
> > > 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
> > >
> >
> >
> > --
> > Regards,
> > Matt
> >
> > -------------------------------------------------------------------------
> > 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
> >
>
> -------------------------------------------------------------------------
> 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