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 the dataset and a sql ledger user and I succeed with that. But I cannot run the login.pl, I get the 500 Internal server 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, 2006/10/8, Fabien Adouani <[EMAIL PROTECTED]>: > > 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 -- 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
