On Saturday 14 October 2006 3:21 pm, Danita Zanre wrote: > > I just did this. The only problem I had was importing the Sql > > Ledger backup file into Postgres as the sql- ledger user. > > I had this problem trying to import it back as the sql-ledger user, but was > able to import it okay as postgres. However, now, when I try to login, I > get > > Error! > > FATAL: IDENT authentication failed for user "sql-ledger"
As you have deduced, this is a problem with authentication against the database. This is configured in the pg_hba file. This file contains the configuration of which computers can connect to the database and how to check their authentication. NOTE: In this specific case, this is for the SQL-Ledger app connecting to the database NOT for the people who will actually be using sql-ledger There is not one specific way to configure this. Once you understand how it's configured, you have to configure it to your specific network and security needs. for example: Do you have sql-ledger and postgresql on the same server ? Do you use SSL ? MD5 ? Kerberos ? Do you have other applications using the postgresql server ? If your new configuration is the same as your old one... maybe you can use your old pg_hba file from the old server ? if you search the list archives you should hit a large number of threads that discuss this issue and how configure it depending on your needs and network environment. http://sourceforge.net/search/?ml_name=sql-ledger-users&type_of_search=mlists&group_id=4320&words=IDENT+authentication+failed OR.... A more detailed explanation is here in the Postgresql docs http://www.postgresql.org/docs/8.1/interactive/client-authentication.html For that matter.. the installation info on the Sql-ledger website has basic info about how to configure this too :) Hope this helps. Roy ------------------------------------------------------------------------- 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 _______________________________________________ sql-ledger-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
