Paul, The database was created via PgAdmin, from the admin.pl the dataset and a user have been set up with success. But when trying to connect as user by using login.pl I get the 500 error web page. Did you have some help?.
Thanks 2006/10/8, Paul Tammes <[EMAIL PROTECTED]>: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Fabien Adouani wrote: > > > Fabien, > > you created a user for PostgreSQL database (sql-ledger I suppose, that > is the default in howto and faq iirc) and so you can login to the admin.pl > . > > Did you also create a database, either via admin.pl or via PgAdmin, and > add a user for that database via admin.pl? Before you did that, a login > will be as futile as resistance to the Borg... > > Thank you for your previous answer, I appreciated. > > > > I'm trying to install SQL leger via FTP. > > > > > > > > I'm using FileZilla, Zipgenius, webshell4 and my ISPphpPgAdmin. I have a > > cgi-bin folder and the CGI dir function. > > > > > > > > I uploaded sql ledger files to my cgi-bin, I created an .htaccess file. > I > > was able to set up a PostgreSQL database and run the admin.pl. I created > a > > sql ledger user and I succeed with that. But I cannot run the login.pl, > I > > get the 500 error and I cannot carry on. What I can do to solve this > > problem? > > > > > > > > Should I use ASCII or binary transfer type for the .htaccess file? > > > > Should I CHMOD some files or folder? And which files and/ or folder? > > > > Do I need to set up .htpasswd file for both users and templates > directories? > > > > > > > > Thanks in advance and I really appreciate your help. > > > > > > > > Kind regards, > > > > > > > > Fabien > > > > > > 2006/10/6, Dieter Simader <[EMAIL PROTECTED]>: > >> Installing via ftp is quite easy but your ISP must play along. > >> > >> a) you must be able to configure your virtual server to run perl > scripts > >> from the directory where you set up SQL-Ledger > >> b) plpgsql must be installed in template1 or at least your ISP must > >> cooperate and install the language handler for your database > >> > >> Once you've got all this in place upload the compressed file an ungzip. > If > >> you cannot do that ungzip locally and upload the sql-ledger folder. > >> > >> Then create a .htaccess file in the sql-ledger folder and put this in > >> the file > >> > >> DirectoryIndex login.pl > >> Options +ExecCGI > >> > >> Use the program as you would on a private server. admin.pl works just > the > >> same. The only difference is that you supply the name of the database > >> instead of letting the program create one for you. You are most likely > not > >> allowed to create new databases outside of pgadmin or whatever your ISP > >> uses so you create a new database with pgadmin and enter the name of > the > >> database in the admin screen when you create a new dataset. > >> > >> -- > >> Dieter Simader http://www.sql-ledger.com Tel: (408) 898-4421 > >> DWS Systems Inc. Accounting Software Fax: (780) 478-5281 > >> ============== On a clear disk you can seek forever ================ > >> > >> On Fri, 6 Oct 2006, Fabien Adouani wrote: > >> > >>> Hi, > >>> > >>> I'm trying for more than 2 weeks to install Sql-ledger on my shared > >>> web server (www.surftown.com). As I don't have the access to the > >>> server's configuration files, > >>> > >>> I'm trying with the FTP installation but without success. > >>> > >>> > >>> > >>> I'm getting this with admin.pl: > >>> > >>> > >>> > >>> 500 Internal Server Error > >>> > >>> The server encountered an internal error or misconfiguration and was > >>> unable to complete your request. > >>> > >>> Please contact the server administrator, [EMAIL PROTECTED] and inform them > >>> of the time the error occurred, and anything you might have done that > >>> may have caused the error. > >>> > >>> More information about this error may be available in the server error > >> log. > >>> > >>> > >>> Apache/1.3.37 Server at xxx.com Port 80 > >>> > >>> > >>> > >>> My questions are: > >>> > >>> > >>> > >>> If it's possible for me to run SQL-ledger on surftown Linux advance > >> package? > >>> What should I do more to be able to run a smooth installation? > >>> > >>> > >>> > >>> Linux Advance package: > >>> > >>> PHP4 > >>> > >>> Sun ASP > >>> > >>> MySQL 4 Databases > >>> > >>> phpMyAdmin > >>> > >>> PostgrSQL 7.3 Databases > >>> > >>> phpPgAdmin > >>> > >>> Egne CGI-scripts > >>> > >>> > >>> > >>> Thank you for your help > >>> > >>> > >>> > >>> > >> > >> > ------------------------------------------------------------------------- > >> 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 > >> _______________________________________________ > >> sql-ledger-users mailing list > >> [email protected] > >> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > >> > > > > > > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.2 (GNU/Linux) > Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org > > iD8DBQFFKUky4ruw/FH66T8RAhEjAJ0X51dt0bWv8/LkMCkUOyGKzabWCACgjzhT > q4a5c9xDeuI5o5r2to+p23Q= > =n3Qn > -----END PGP SIGNATURE----- > > ------------------------------------------------------------------------- > 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 > _______________________________________________ > sql-ledger-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > -- Fabien Adouani Sweden ------------------------------------------------------------------------- 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 _______________________________________________ sql-ledger-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
