If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > Perl and the DBI > Perl, Java web application deployment

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-28-08, 15:16
Franco_1 Franco_1 is offline
Registered User
 
Join Date: Aug 2008
Posts: 2
Perl, Java web application deployment

I'm supposed to change a web app written in perl and java scripts to dot net environment.
I was given js, pl and tmpl extension files and a link to the website.
I have been able to reproduce the web app pages using the link view source codes and the tmpl files. The db connects to a SQLite.
I installed SQLLitePRo and Perl 5,10,0,1003 yesterday.
I have not changed any part of the original code that I was given.

My problem is, I can't get the program to call the pl and the js files. I get an error message like:
The HTTP verb POST used to access path '/appDirectory/plDirectory/plFilename.pl' is not allowed.


2. Do I have to have the files in a particular folder on my local machine to work?
3. Do I need any configurations to make?

4. Because I'm still using the original codes, I suspect it tries to read from a server nobody seems to know where or which one.
this is a copy of the DBI code:
my $database = DBI->connect("dbi: SQLite:dbname=$$form{SomeName}.db","","") || die "$DBI::errstr\n";
my $statement = $database->prepare("select * from groups");

How do I import these database files into the SQLLITePro to enable me use
the connection string above on my local machine?

Any sugestions will be welcomed.

This is my first web app project and I suspect I've not set the environment correctly.
I really need an
Reply With Quote
  #2 (permalink)  
Old 09-20-08, 19:53
sco08y sco08y is offline
Registered User
 
Join Date: Oct 2002
Location: Baghdad, Iraq
Posts: 697
my $database = DBI->connect("dbi: SQLite:dbname=$$form{SomeName}.db","","") || die "$DBI::errstr\n";

Holy crap, this is a security hole you could float an aircraft carrier through!

You're taking form input and splicing it into your connection string.

If you've absolutely got to let the user pick a database, you must check it against a list of valid databases.

I'm supposed to change a web app written in perl and java scripts to dot net environment.


If you don't know what environment you're running on, how do you know you'd benefit from moving to another environment?

2. Do I have to have the files in a particular folder on my local machine to work?
3. Do I need any configurations to make?


Yes and yes. And without knowing even what webserver you're using, I have no idea where or what.
Reply With Quote
  #3 (permalink)  
Old 09-22-08, 08:25
Franco_1 Franco_1 is offline
Registered User
 
Join Date: Aug 2008
Posts: 2
Perl Java database website

I think you are very right. I have no other info on the existing intranet to continue on this project. Nobody seems to know where the webserver is nor the source codes other than the ones I got from the "view source" from the web site link I received
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On