-----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
