Re: Install difficulties

["Chris Travers" <..hidden..>]

Hi;

Short version:
A few people have found that the current password structure seems to
have difficulty with some passwords.  The good news is that the
problem will be completely resolved in 1.2...

In the mean time, I suggest changing the PostgreSQL password.

Long version:
The SQL-Ledger codebase obfuscates the PostgreSQL password by running
it through pack and unpack.  We are not quite sure why but some
passwords that result in having embedded quotes in their packed
representation don't work.  Since this part of the application is
being re-engineered (and the obfuscation is being done away with), we
currently suggest using a different password, or for single user
systems (with the web server and db server running on the same box),
you can use trust authentication (not recommended for multi-user
installs or multi-application systems).

Hope this helps,
Chris Travers

On 11/1/06, Terence Carney <..hidden..> wrote:
> Hi.
>
> I am currently switching to ledger-smb from sql-ledger and I have started
> from scratch - no conversion attempts.
>
> After doing the necessary upgrades to Postgresql I finally got the setup
> steps completed. I was able to connect to the database during the setup
> phase. New user was added succesfully.
>
> When trying to use login.pl I get the following error:
>
> --------------------------------------------------------
> Error!
>
> FATAL: password authentication failed for user "ledgersmb"
> --------------------------------------------------------
>
> I can access the server remotely and locally via psql using the proper
> username/passwword conbination. I a little familiar with Perl but not enough
> to follow what is actually going on. I've had no success with searches.
>
> Pointers in the right direction would be appreciated.
>
> Debian/Gnu Linux:       Sarge (kernel 2.4.27)
> ledger-smb:             1.1.1c (tarball-1.1.1d)
> Postgresql:             8.1.4
> Perl:                   5.8.4
> pg_hba.conf snippet:
> ---------------------------------------------------------------------
> local   all         postgres                          ident sameuser
> local   all         postgres                          ident sameuser
> local   all         ledgersmb                         md5
> local   all         root                              md5
> host    all         all         127.0.0.1/32          md5
> host    all         all         192.168.1.0/24        md5
> ---------------------------------------------------------------------
>
> Thanks,
>
>
> Terence.
>
> Selterra.Com
> ----------------------
> ..hidden..
>
> Affordable Reseller WebHosting
> Go to: http://resellerhosting.selterra.com
>
> AntiSpamID:AS323
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users