The problem is with not using the right database user. If you create a dataset with the name postgres and you enter pgsql for the upgrade there is nothing to upgrade for the user.
The proper procedure to upgrade is to check the database name you use by clicking on one of the logins. Then you use this database name for the upgrade. I should also point out that, contrary to Jonas' believe, you cannot ruin anything because not only do a I check if the dataset belongs to the user but also check if the dataset is in fact one which belongs to SQL-Ledger. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Mon, 3 Jun 2002, Jonas Smedegaard wrote: > On Sun, 2 Jun 2002, Brent Kearney wrote: > > > I was using sql-ledgers v1.6.9. After unpacking 1.8.4 over top, and > > clicking the 'Upgrade Dataset' button (after filling out the pgsql > > username & password fields), I get message, "All Datasets up to date!". > > I had the exact same problem yesterday. After some investigation I gave up > and simply hacked the progrma to be less obnoxious about which databases > to upgrade. > > Dieter: I imagine the source of the problem lies in using a more strict > access to the postgres server than the average setup (never allowing > master access from the web browser, only a specific account holding all > ledger databases, and the use the suexec feature of Apache to run as that > same user). > > Beware that this can ruin non-postgres databases hosted on the same > postgres server. But then again - you get a second screen where you can > unselect wrongly selected databases by hand before you do the actual > update (and you DID use separate login for each set of databases and avoid > master login from a browser, right?). > > Attached is the diff that made it work for me. > > - Jonas > > _______________________________________________________________ Don't miss the 2002 Sprint PCS Application Developer's Conference August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm _______________________________________________ Listinfo https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.geocrawler.com/redir-sf.php3?list=sql-ledger-users
