problems with admin.pl login failure

View: New views
8 Messages — Rating Filter:   Alert me  

problems with admin.pl login failure

by Harondel J. Sibble :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Okay, just did a fresh install on Ubuntu 9.0.4 server of LedgerSMB 1.2.18.

I am down to

    Create Datasets and Users
    =========================
    1) Create Datasets:
    Browse to:
    http://hostname/ledgersmb/admin.pl

in the INSTALL file. I am logging in using MYPASSWORD, but when it comes time
to create the dataset, if I use MYPASSWORD, I get

    Error!

       LedgerSMB/User.pm:324
       FATAL: password authentication failed for user "ledgersmb"


and if I use MYROLEPASSWORD, I get to the Create Dataset page, but when I
click continue, I get

    Error!

       LedgerSMB/User.pm:387
       fe_sendauth: no password supplied

Checking the Nabble list archives hasn't enlightened me :-(

Of note, this machine also has SQL-Ledger installed, specifically Version
2.8.25

--
Harondel J. Sibble
Sibble Computer Consulting
Creating Solutions for the small and medium business computer user.
help@... (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice)


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Re: problems with admin.pl login failure

by Stroller :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On 19 Oct 2009, at 06:49, Harondel J. Sibble wrote:
> ...
>    Error!
>
>       LedgerSMB/User.pm:387
>       fe_sendauth: no password supplied
> ...

I had some problems with LedgerSMB after a recent Perl upgrade.

I found the contents of /var/log/apache2/error_log quite illuminating.  
I don't suppose there's anything useful in there? Try `tail -f`ing it  
in a terminal window, then attempting your log on.

> Of note, this machine also has SQL-Ledger installed, specifically  
> Version
> 2.8.25

Obviously, this could be related. Are they using different databases?

Stroller.


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Re: problems with admin.pl login failure

by Harondel J. Sibble :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



On 19 Oct 2009 at 7:35, Stroller wrote:

> I had some problems with LedgerSMB after a recent Perl upgrade.
>
> I found the contents of /var/log/apache2/error_log quite illuminating.  
> I don't suppose there's anything useful in there? Try `tail -f`ing it  
> in a terminal window, then attempting your log on.

Hmm, looking at the logs for previous attempts shows basically the same
error, and indicates an authentication problem, will details tomorrow.
 
> Obviously, this could be related. Are they using different databases?

I would assume so..... since both create different database tables with the
sql setup scripts???
--
Harondel J. Sibble
Sibble Computer Consulting
Creating Solutions for the small and medium business computer user.
help@... (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice)


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Re: problems with admin.pl login failure

by Luke-74 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Sun, 18 Oct 2009, Harondel J. Sibble wrote:

>     Create Datasets and Users
>     =========================
>     1) Create Datasets:
>     Browse to:
>     http://hostname/ledgersmb/admin.pl
>
> in the INSTALL file. I am logging in using MYPASSWORD, but when it comes time
> to create the dataset, if I use MYPASSWORD, I get
>
>     Error!
>
>        LedgerSMB/User.pm:324
>        FATAL: password authentication failed for user "ledgersmb"

Does the psql ledgersmb user actually have permission to create databases?

You might try manually logging in as the ledgersmb user via the psql
shell, and trying to create a fake dataset.

All else fails, as a cluge you can create the datasets manually, and then
have ledgersmb create them.  You'll get an error, but the end result
*should* be a successfully created company.

Luke

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Re: problems with admin.pl login failure

by Harondel J. Sibble :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



On 19 Oct 2009 at 4:21, Luke wrote:

> Does the psql ledgersmb user actually have permission to create databases?

Here's what I see in the PostgeSQL User page in webmin.

Username     Requires password?     Can create databases?     Can create
users?     Valid until  
ledgersmb Yes Yes No Forever
postgres Yes Yes Yes Forever
sql-ledger No Yes Yes Forever

I'm beginning to think this might be because of a mistake I made, I
downloaded and started the install with 1.2.9 rather than 1.2.18 and the sql
database file Pg-central.sql, I'd assume has some changes between the
versions?

I've dropped the database and and any users created and am going back to
start of setup to see if that resolves things any.
 

--
Harondel J. Sibble
Sibble Computer Consulting
Creating Solutions for the small and medium business computer user.
help@... (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice)


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Re: problems with admin.pl login failure

by Chris Travers-5 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



On Sun, Oct 18, 2009 at 10:49 PM, Harondel J. Sibble <help@...> wrote:
Okay, just did a fresh install on Ubuntu 9.0.4 server of LedgerSMB 1.2.18.

I am down to

   Create Datasets and Users
   =========================
   1) Create Datasets:
   Browse to:
   http://hostname/ledgersmb/admin.pl


Two questions:
1)  Aside from passwords, exactly which boxes are you filling in?  For example are you filling in the superusername and password?
2)  Are you expecting to create a new db at the same time?  If so, which account are you using for the superuser account?

Best Wishes,
Chris Travers


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Re: problems with admin.pl login failure

by Harondel J. Sibble :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



On 19 Oct 2009 at 15:56, Chris Travers wrote:

> Two questions:
> 1)  Aside from passwords, exactly which boxes are you filling in?  For
> example are you filling in the superusername and password?

Doesn't seem to matter, the ONLY place where MYPASSWORD works is in the
initial login using uid ledgersmb, after that anytime I use the ledgersmb
uid, I have to use the MYROLEPASSWORD.

> 2)  Are you expecting to create a new db at the same time?  If so, which
> account are you using for the superuser account?

<eyeballs glazing over>

;-)

I've steadfastly avoided getting to know postgres in particular and sql
servers in general over the past few years, I see now that's been a bad
choice....  On a related note, any recommendations for a good book on
postgres in particular and sql in general?

As to the problem, after redoing things as per

http://www.howtoforge.com/ledgersmb_debian_etch

and wth the caveats on the passwords in item 1, it's now up and running.
--
Harondel J. Sibble
Sibble Computer Consulting
Creating Solutions for the small and medium business computer user.
help@... (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice)


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Re: problems with admin.pl login failure

by Chris Travers-5 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



On Mon, Oct 19, 2009 at 4:47 PM, Harondel J. Sibble <help@...> wrote:


On 19 Oct 2009 at 15:56, Chris Travers wrote:

> Two questions:
> 1)  Aside from passwords, exactly which boxes are you filling in?  For
> example are you filling in the superusername and password?

Doesn't seem to matter, the ONLY place where MYPASSWORD works is in the
initial login using uid ledgersmb, after that anytime I use the ledgersmb
uid, I have to use the MYROLEPASSWORD.

> 2)  Are you expecting to create a new db at the same time?  If so, which
> account are you using for the superuser account?

<eyeballs glazing over>

;-)

Ok.  My questions are answered.

For the superuser username, make sure you are using "postgres" and have the role password for postgres in the corresponding password box.

For the normal user, use ledgersmb for your username and the appropriate password for that db role there.

This is re-engineered for 1.3.

Best Wishes,
Chris Travers


------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users