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

Re: Login problems

Chris,

Trying hard to figure this out, lol, did the following:

(from my Ubuntu Edgy command line)

sudo su postgres

(which gives me ..hidden.. vs ..hidden.. at shell prompt)

psql

(which gives me "postgres=#" prompt)

grant all on session to ledger-smb

(which was, I believe, the username I set up, according to this
tutorial: http://www.ubuntuforums.org/showthread.php?p=2236136 )

but then no confirmation message like those CREATE MAKE DATABASE or
whatever messages came up.

I tried to login again at the login.pl page with ledger-smb and
password, but got access denied and then tried to login at the
admin.pl page with password admin as set up in above link, as well as
a blank password field and got access denied on first, session expired
on second.

Any further ideas, or perhaps I did this wrong?

Please advise. I would really like to start fresh in LedgerSMB and
contribute some sort of guide for retail and internet sales accounting
using LSMB.

Thanks!

- Matt


On 3/4/07, Chris Travers <..hidden..> wrote:

In the database you imported the Pg-central.sql into:

grant all on session to [ledgersmb-dbuser];
etc.

You enter these commands via psql.

Best Wishes,
Chris Travers

On 3/4/07, Matt Jackson <..hidden..> wrote:
> Chris,
>
> Thanks for the reply. I did create the database as a sudo su superuser.
>
> So I guess this leads me to "where are the session,
> session_session_id_seq, etc. files located?" Or, what commands do I
> use to alter them?
>
> Am I on the right track?
>
> Please advise.
>
> Best,
> Matt
>
>
>
> On 3/3/07, Chris Travers <..hidden..> wrote:
> > Hi Matt,
> >
> > I have seen this happen a few times in the past.  There are a few
> > things that can cause this problem, but the most frequent is a
> > database permission issue.  Make sure that the database user you are
> > connecting as has access to the session, session_session_id_seq,
> > users, users_id_seq, users_conf.  The user will need all privileges on
> > these tables.
> >
> > This can happen when you create the central database with a superuser
> > but try to connect with a normal user in PostgreSQL.
> >
> > Best WIshes,
> > Chris Travers
> >
> > On 3/2/07, Matt Jackson <..hidden..> wrote:
> > > Hello, all.
> > >
> > > Excited to be part of the LedgerSMB community now, I am very
> > > interested in learning this system so I can contribute to
> > > documentation on how to use LedgerSMB in a web-based business/retail
> > > environment.
> > >
> > > I have a business-degree background with a functional knowledge of
> > > double-entry accounting.
> > >
> > > I have started a small online clothing business, but I the business is
> > > not able to afford the $190 for the SQL-Ledger manual, which I still
> > > feel would probably be very helpful even using LedgerSMB.
> > >
> > > In any event, I have successfully installed Version 1.2.0 Release
> > > Candidate 1 on my Ubuntu Edgy machine, but I am having a hard time
> > > logging in, getting the "Access Denied!" message when I type "admin"
> > > in on the admin.pl page. "admin" was the password I set on the
> > > md5("admin") step on the Ubuntu LedgerSMB tutorial I found:
> > >
> > > http://ubuntuforums.org/showthread.php?t=311029
> > >
> > > Any advice?
> > >
> > >
> > >
> > >
> > > --
> > > Regards,
> > > Matt J.
> > >
> > > -------------------------------------------------------------------------
> > > 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
>
> -------------------------------------------------------------------------
> 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