Fsdbase Problem

[kostoed97]

Hi !
My System is CentOS 5.6

When I run the installation ... I all goes well. But when I run, the example, file main.pl 500 internal error, and so on all the files.(.pl .htm and etc.)

Help please !

[L. D. James]

Hi !
My System is CentOS 5.6

When I run the installation ... I all goes well. But when I run, the example, file main.pl 500 internal error, and so on all the files.(.pl .htm and etc.)

Help please !

How are you running the main.pl file? It should be run in crontab.

Will you post the output of setup.sh?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

./setup.sh
Verfying neccessary perl modules are installed...
..................
Checking for tables for database: fsd...
Creating tables...
Tables Created...
Setup Finished successfully.
You can run runfsdbase.sh to start your database.
Set it up to run each minute to continue the database update

[L. D. James]

./setup.sh
Verfying neccessary perl modules are installed...
..................
Checking for tables for database: fsd...
Creating tables...
Tables Created...
Setup Finished successfully.
You can run runfsdbase.sh to start your database.
Set it up to run each minute to continue the database update

Thanks, kostoed97.

I can't tell from your messages how you're trying to run main.pl. Actually there isn't a reason to try to run main.pl or any of the other pl files. The text you just showed is telling you to run "runfsdbase.sh". It should be run regularly. Run it every minute in crontab.

Run the html file you see in the directory to actually browse the fsdbase flightlog.

I'll try to make this clearer during the setup in future updates.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

How do I register a new CID on the server with fsdbase ?

[L. D. James]

How do I register a new CID on the server with fsdbase ?

It's automatic. When someone flies on the server, the registration is automatic.

By the way, running the crontab task (runfsdbase.sh) is an important component. But all you have to do is run the runfsdbase.sh as a crontab and you don't have to do anything else. Access the application by the html file. The whole operation should be very seamless.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

And what file should start to conduct the registration, and then for example, already have a CID and Password, and we should enter, I enter the data and I opened a perl script and not Web page

[kostoed97]

And where .pl files are located ?
In folder fsdbase or in cgi-bin ?

[L. D. James]

And where .pl files are located ?
In folder fsdbase or in cgi-bin ?

They are located whereever you choose. You apparently had them located someone, in such the setup.sh program found them. They should be located where you placed the "packagelocation =" parameter in the fsdbase.cfg file.

Did you set up the runfsdbase.sh to run as a crontab event? Run the "runfsdbase.sh" from the console and see if you get any errors. If you don't just run it as a crontab even every minute and you're all set.

To access the application run the html file from a web browser.

Thanks for taking the time to test the application and give feedback.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

What html-file to run to access the application?
Runfsdbase.sh error does not
Then why, when I open a file for example login.htm all you need to fill in this form and front of me open perl script code

If you want to look at: []

there set fsdbase, cron is configured

[L. D. James]

What html-file to run to access the application?
Runfsdbase.sh error does not
Then why, when I open a file for example login.htm all you need to fill in this form and front of me open perl script code

If you want to look at: http://aero.mosteam.net/stat/

there set fsdbase, cron is configured

Kostoed97. I'm composing a response to your question. In the meantime, remove the link that you have configure. For now, make it stat.x with the .x being something random to not immediately post publicly where it's located. I'm going to email you a configuration to make the site more secure, then you can reactivate the link.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[L. D. James]

I see you have removed the link from the public. Give me a few minutes to give you a download to repair the security concern I was looking at.

Also, open a test directory and let's fix your ability to run *.pl files over the web rather than displaying the *.pl files.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[L. D. James]

Create a test directory that can be accessed from the web. Put just this in the test directory and less work on making it execution-able. Since it's a very simple file and doesn't contain any compromising information, it's okay if the file is displayed rather than executed.

Name the file: test.pl

#!/usr/bin/perl

print "Content-type: text/html\n\n";

print "Hello world!\n"; Save the test.pl file. Execute:

chmod +x test.plYou can run it from the console with:

./test.plIt should print two lines separated by spaces.

If you get past that, run it from the web and it should say print only one line to the browser that says:

“Hello world!”

When this works we'll go to the next step. If this fails we'll have to fix your apache configuration to execute the perl files.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I can execute this after 5 minutes, please wait...
:)

[kostoed97]

He showed me this:

Content-type: text/html

Hello world!

[L. D. James]

He showed me this:

Content-type: text/html

Hello world!

I'll help you with setting up your system to execute the .pl files. I have to go on an errand and will be back later. I'll work with you on that when I return.

In the meantime, grab fsdbase-v1.87b.tar.bz2 from the download section of http://flightsime.apollo3.com . This will fix the security concern I was seeing in your link. It'll be save to test the new link on the web.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

ok, take me few minutes - i setup it

[L. D. James]

ok, take me few minutes - i setup it

Basically to enable executing the .pl files rather than displaying (or downloading them) check for the following lines in your httpd.conf file:

<Directory />
# Options FollowSymLinks
Options Indexes FollowSymLinks MultiViews +ExecCGI +Includes
AllowOverride All
</Directory> You may have other lines in the “<directory>” directive, but make sure you include “+ExeCGI +Includes” in that block.

Make sure in where you have a list of AddHandlers you include this:

AddHandler cgi-script .cgi .pl That should do it. Test your test.pl file. If that works, you shouldn't have any problems with the fsdbase program.

-- L. D. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Don't work

I can give httpd.conf file - and can you see it ?

[L. D. James]

Don't work

I can give httpd.conf file - and can you see it ?

Use http://upload.apollo3.com/~ljames/upload (http://upload.apollo3.com/%7Eljames/upload) .

I'm a little late for my engagement, but will try to study it and respond before I leave.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I uploaded it.
Let me, when you are done

[L. D. James]

Use http://upload.apollo3.com/~ljames/upload (http://upload.apollo3.com/%7Eljames/upload) .

I'm a little late for my engagement, but will try to study it and respond before I leave.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

At a glance, you have two <Directory /> blocks in a row. Comment out the one that doesn't have the +ExeCGI and +Includes in it so that you only have one <Directory /> block.

Also, your "AddHandler cgi-script .cgi" is commented out. Remove the "#" and add .pl to it.

It should read:

AddHandler cgi-script .cgi .plRemember to restart the web server after you have made those changes.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

If I open fsdbase.htm and enter here needed information, click submit and I see error 500(Internal Server Error)

[L. D. James]

If I open fsdbase.htm and enter here needed information, click submit and I see error 500(Internal Server Error)

That's most likely because you're having problems with your apache/perl configuration. Did you make the changes to the httpd.conf file?

If you send me the file again I can tell you if you've made the proper changes. What is the output of the test.pl file from the web?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

I uploaded httpd.conf file again

test.pl - error 500 too

[L. D. James]

I uploaded httpd.conf file again

test.pl - error 500 too

You're having problems because you didn't make the changes I'm mentioning in my messages. Start at the top of your httpd.conf file. Look search for:

# AddHandler allows you to map certain file extensions to "handlers":
# actions unrelated to filetype. These can be either built into the server
# or added with the Action directive (see below)
#
# To use CGI scripts outside of ScriptAliased directories:
# (You will also need to add "ExecCGI" to the "Options" directive.)
#
AddHandler cgi-script .cgiChange that to:

# AddHandler allows you to map certain file extensions to "handlers":
# actions unrelated to filetype. These can be either built into the server
# or added with the Action directive (see below)
#
# To use CGI scripts outside of ScriptAliased directories:
# (You will also need to add "ExecCGI" to the "Options" directive.)
#
AddHandler cgi-script .cgi .plWhat you're doing is adding ".pl" to that line. I see you have "AddHandler cgi-script" mentioned a few times in your code. But I'm suggesting that you change this specific line.

Try your "test.pl". If it fails send your httpd.conf and I'll look for another decrepency.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I add .pl - restart web server

error 500

[L. D. James]

I add .pl - restart web server

error 500

There's a chance you might not have the perl support installed in your server.

Will you type in the following line. Most distros call the web server with, "httpd". Some might call it by a different name such as, "apache", or "apache2". If you type in the command and get an error try one of the different hames.

httpd -lWill you give me the output of that command?

Also, will you send me the httpd.conf file again?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

[L. D. James]

Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

Try installing the perl support with a variation of:

yum install perl-cgi

You might have to look for how it's listed in your repo with a variation of:

yum search perl-cgi

Then pick out the closes match to install.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

# yum search perl-cgi
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: centos.hostace.ru
* epel: mirror.xfes.ru
* extras: centos.hostace.ru
* rpmforge: ftp-stud.fht-esslingen.de
* updates: centos.hostace.ru
============================== Matched: perl-cgi ===============================
perl-CGI.noarch : Handle Common Gateway Interface requests and responses
perl-CGI-Ajax.noarch : Mechanism for AJAX or DHTML based web applications
perl-CGI-Application.noarch : Framework for building reusable web-applications
perl-CGI-Application-Plugin-Output-XSV.noarch : Generate csv output from a
: CGI::Application runmode
perl-CGI-Application-Plugin-QueryHash.noarch : Get back query params as
: hash(ref)
perl-CGI-Auth-Auto.noarch : Automatic authentication maintenance and persistence
: for cgi scripts
perl-CGI-Cookie-Splitter.noarch : Perl module to split big cookies into smaller
: ones
perl-CGI-Debug.noarch : Module for CGI programs debugging
perl-CGI-Ex.noarch : Perl module to make powerful application writing fun and
: easy
perl-CGI-FastTemplate.noarch : Extension for managing templates and performing
: variable interpolation
perl-CGI-GuruMeditation.noarch : Guru Meditation for CGIs
perl-CGI-Kwiki.noarch : A Quickie Wiki that's not too Tricky
perl-CGI-Lite.noarch : Process and decode WWW forms and cookies
perl-CGI-Log.noarch : Centralized logging of debug, error, status and success
: messages
perl-CGI-Minimal.noarch : A lightweight CGI form processing package
perl-CGI-Out.noarch : Buffer output when building CGI programs
perl-CGI-PathInfo.noarch : Lightweight CGI processing package for using
: PATH_INFO
perl-CGI-Persistent.noarch : Transparent state persistence for CGI applications
perl-CGI-Prototype.noarch : Perl module to create a CGI application by
: subclassing
perl-CGI-Response.noarch : Respond to CGI requests
perl-CGI-Screen.noarch : Extension for easy creation of multi screen CGI scripts
perl-CGI-Scriptpaths.noarch : Find web relevant paths even without ENV set
perl-CGI-Session.noarch : Persistent session data in CGI applications
perl-CGI-Session-Hidden.noarch : Persistent session using hidden fields
perl-CGI-Simple.noarch : Perl module that implements a CGI.pm compliant CGI
: interface
perl-CGI-SpeedyCGI.x86_64 : Speed up perl scripts by running them persistently
perl-CGI-Untaint.noarch : Process CGI input parameters
perl-CGI-Untaint-date.noarch : Perl module to validate a date
perl-CGI-Untaint-email.noarch : Perl module to validate an email address.
perl-CGI-Upload.noarch : CGI class for handling browser file uploads
perl-CGI-Validate.noarch : Advanced CGI form parser and type validation
perl-CGI-WML.noarch : Subclass of CGI.pm for WML output and WML methods
perl-CGI-WeT.noarch : Suite of modules to themeify a website
perl-CGI-Widget.noarch : Create common page elements
perl-CGI-XML.noarch : Extension for converting CGI.pm variables to/from XML
perl-CGI-XMLForm.noarch : Extension of CGI.pm which reads/generates formated XML

what from it ?

[kostoed97]

I installed:

yum install perl-CGI.noarch perl-CGI-Application.noarch
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: centos.hostace.ru
* epel: mirror.xfes.ru
* extras: centos.hostace.ru
* rpmforge: ftp-stud.fht-esslingen.de
* updates: centos.hostace.ru
Setting up Install Process
Package perl-CGI is obsoleted by perl, trying to install 4:perl-5.8.8-32.el5_6.3.x86_64 instead
Package 4:perl-5.8.8-32.el5_6.3.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package perl-CGI-Application.noarch 0:4.31-1.el5.rf set to be updated
--> Processing Dependency: perl-HTML-Template for package: perl-CGI-Application
--> Running transaction check
---> Package perl-HTML-Template.noarch 0:2.9-1.el5.2 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================== ==============================
Package Arch Version Repository Size
================================================== ==============================
Installing:
perl-CGI-Application noarch 4.31-1.el5.rf rpmforge 73 k
Installing for dependencies:
perl-HTML-Template noarch 2.9-1.el5.2 epel 72 k

Transaction Summary
================================================== ==============================
Install 2 Package(s)
Upgrade 0 Package(s)

Total download size: 145 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): perl-HTML-Template-2.9-1.el5.2.noarch.rpm | 72 kB 00:00
(2/2): perl-CGI-Application-4.31-1.el5.rf.noarch.rpm | 73 kB 00:00
--------------------------------------------------------------------------------
Total 364 kB/s | 145 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-HTML-Template 1/2
Installing : perl-CGI-Application 2/2

Installed:
perl-CGI-Application.noarch 0:4.31-1.el5.rf

Dependency Installed:
perl-HTML-Template.noarch 0:2.9-1.el5.2

[L. D. James]

I installed:

yum install perl-CGI.noarch perl-CGI-Application.noarch
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: centos.hostace.ru
* epel: mirror.xfes.ru
* extras: centos.hostace.ru
* rpmforge: ftp-stud.fht-esslingen.de
* updates: centos.hostace.ru
Setting up Install Process
Package perl-CGI is obsoleted by perl, trying to install 4:perl-5.8.8-32.el5_6.3.x86_64 instead
Package 4:perl-5.8.8-32.el5_6.3.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package perl-CGI-Application.noarch 0:4.31-1.el5.rf set to be updated
--> Processing Dependency: perl-HTML-Template for package: perl-CGI-Application
--> Running transaction check
---> Package perl-HTML-Template.noarch 0:2.9-1.el5.2 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================== ==============================
Package Arch Version Repository Size
================================================== ==============================
Installing:
perl-CGI-Application noarch 4.31-1.el5.rf rpmforge 73 k
Installing for dependencies:
perl-HTML-Template noarch 2.9-1.el5.2 epel 72 k

Transaction Summary
================================================== ==============================
Install 2 Package(s)
Upgrade 0 Package(s)

Total download size: 145 k
Is this ok [y/N]: y
Downloading Packages:
(1/2): perl-HTML-Template-2.9-1.el5.2.noarch.rpm | 72 kB 00:00
(2/2): perl-CGI-Application-4.31-1.el5.rf.noarch.rpm | 73 kB 00:00
--------------------------------------------------------------------------------
Total 364 kB/s | 145 kB 00:00
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-HTML-Template 1/2
Installing : perl-CGI-Application 2/2

Installed:
perl-CGI-Application.noarch 0:4.31-1.el5.rf

Dependency Installed:
perl-HTML-Template.noarch 0:2.9-1.el5.2

Without the [ code ] tags for your program output your messages are a bit hard to read. I have to study a lot of text to try to see where you're typing and where you're showing output.

Anyway, it looks like you installed perl-cgi. Does the test.pl work at this time? Also I would like to see if the httpd.conf is correctly configured after the last editing, when you get a chance (if the test.pl fails).

Also, show an output with:

httpd -lif the test.pl fails.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I am a little hard to navigate the system, because I'm just starting to learn linux. And I'm only 14 years ... And sorry for my broken English - I'm from Russia and some words from the google translator.
So, I recently reinstalled apache - send you config - can you tell me step by step what to do

Or can you modify my new config apache ?

[L. D. James]

I am a little hard to navigate the system, because I'm just starting to learn linux. And I'm only 14 years ... And sorry for my broken English - I'm from Russia and some words from the google translator.
So, I recently reinstalled apache - send you config - can you tell me step by step what to do

Or can you modify my new config apache ?

You didn't have to reinstall apache. There was nothing wrong with apache. It was functioning perfectly. We can start over since you reinstalled apache. It's just a matter of configuring it. I'm sure we were about a message away from having the perl configuration completed.

Also, being 14 years old isn't a detriment. I believe 14 is the average of many of the users you find typing in the forums.

When you installed perl-cgi it configured your other apache for the installation. Will you execute the module check to see if the perl support is in this one?

Will you give me the output of:

httpd -lAlso, you'll need to make the changes to the httpd.conf I gave you in the previous messages. Run the test.pl link and see if it works. If it doesn't I'll study your httpd.conf file to see if you made the two changes correctly.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

output of httpd -l :

Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

[L. D. James]

output of httpd -l :

Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

Try using yum to uninstall then reinstall the perl-cgi module. Try:

yum remove package-namethen
yum install package-nameThen show me the "httpd -l" output.

Change package-name to the name of the perl-cgi package you installed. That should reinstall the perl support into apache.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I reinstall LAMP
(Apache, Mysql, PHP)
Take me few minutes - I install fsdbase...

And what does this command ?

rpm -qa | grep -i mysql

output this command:

perl-DBD-MySQL-3.0007-2.el5
mysql-libs-5.1.57-1.el5.art
mysqlclient15-5.0.90-1.el5.art
mysql-server-5.1.57-1.el5.art
mysql-5.1.57-1.el5.art

[L. D. James]

I reinstall LAMP
(Apache, Mysql, PHP)
Take me few minutes - I install fsdbase...

Are you saying everything else is working ok? The apache and perl installation? Does the test.pl work?

And what does this command ?

rpm -qa | grep -i mysqloutput this command:

perl-DBD-MySQL-3.0007-2.el5
mysql-libs-5.1.57-1.el5.art
mysqlclient15-5.0.90-1.el5.art
mysql-server-5.1.57-1.el5.art
mysql-5.1.57-1.el5.art

It's showing you what you have installed on your computer.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

I install fsdbase and when i run "runfsdbase.sh" I look this:


flock() on closed filehandle TEMPOUT at ./main.pl line 532.
print() on closed filehandle TEMPOUT at ./main.pl line 533.
flock() on closed filehandle TEMPOUT at ./main.pl line 534.


Error 500 and remained

[L. D. James]

I install fsdbase and when i run "runfsdbase.sh" I look this:


flock() on closed filehandle TEMPOUT at ./main.pl line 532.
print() on closed filehandle TEMPOUT at ./main.pl line 533.
flock() on closed filehandle TEMPOUT at ./main.pl line 534.
Error 500 and remained

What do you get when you run the test.pl script from the internet?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

When I run test.pl from internet I get error 500

[L. D. James]

When I run test.pl from internet I get error 500

Is there a reason why you won't perform the steps I gave you to resolve this issue?

If you want to perform the steps, to save you from having to review the many messages, you might start out by running:

yum remove perl-CGI.noarch
yum install perl-CGI.noarch

httpd -l-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Command yum remove "perl-cgi":

Package(s) perl-CGI.noarch available, but not installed.
No Packages marked for removal

Command "yum install perl-cgi":

Setting up Install Process
Package perl-CGI is obsoleted by perl, trying to install 4:perl-5.8.8-32.el5_6.3.i386 instead
Package 4:perl-5.8.8-32.el5_6.3.i386 already installed and latest version
Nothing to do

[L. D. James]

Command yum remove "perl-cgi":

Hi, Misha. That's not the command I gave you for removing the package. You might consider copying and pasting to make sure you get the commands spelled correctly. They have to be exact to work.

Package(s) perl-CGI.noarch available, but not installed.
No Packages marked for removalCommand "yum install perl-cgi":

Setting up Install Process
Package perl-CGI is obsoleted by perl, trying to install 4:perl-5.8.8-32.el5_6.3.i386 instead
Package 4:perl-5.8.8-32.el5_6.3.i386 already installed and latest version
Nothing to doTry this:

yum remove perl-CGI.noarch
yum install perl-CGI.noarch
httpd -l-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Hi, Mr.James !

[root@mosteam ~]# yum remove perl-CGI.noarch
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: perl-CGI.noarch
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: mirror.corbina.net
* epel: mirror.xfes.ru
* extras: mirror.corbina.net
* rpmforge: ftp-stud.fht-esslingen.de
* updates: mirror.corbina.net
Package(s) perl-CGI.noarch available, but not installed.
No Packages marked for removal

------------------------------------------------

[root@mosteam ~]# yum install perl-CGI.noarch
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: mirror.corbina.net
* epel: mirror.xfes.ru
* extras: mirror.corbina.net
* rpmforge: ftp-stud.fht-esslingen.de
* updates: mirror.corbina.net
Setting up Install Process
Package perl-CGI is obsoleted by perl, trying to install 4:perl-5.8.8-32.el5_6.3.i386 instead
Package 4:perl-5.8.8-32.el5_6.3.i386 already installed and latest version
Nothing to do

[L. D. James]

Hi, Mr.James !

[root@mosteam ~]# yum remove perl-CGI.noarch
Loaded plugins: fastestmirror
Setting up Remove Process
No Match for argument: perl-CGI.noarch
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: mirror.corbina.net
* epel: mirror.xfes.ru
* extras: mirror.corbina.net
* rpmforge: ftp-stud.fht-esslingen.de
* updates: mirror.corbina.net
Package(s) perl-CGI.noarch available, but not installed.
No Packages marked for removal------------------------------------------------

[root@mosteam ~]# yum install perl-CGI.noarch
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: mirror.corbina.net
* epel: mirror.xfes.ru
* extras: mirror.corbina.net
* rpmforge: ftp-stud.fht-esslingen.de
* updates: mirror.corbina.net
Setting up Install Process
Package perl-CGI is obsoleted by perl, trying to install 4:perl-5.8.8-32.el5_6.3.i386 instead
Package 4:perl-5.8.8-32.el5_6.3.i386 already installed and latest version
Nothing to do

You only showed two of the three lines in my last message. You didn't show “httpd -l”.

Will you give me the output of the “httpd -l”.

Try this:

httpd -l
yum install mod_perl
httpd -lThat's three lines. Depending on the output of the last line I'll look to giving you and update for your httpd.conf.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

1. Show "httpd -l" :

[root@mosteam ~]# httpd -l
Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

2. :

[root@mosteam ~]# yum install mod_perl
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: mirror.corbina.net
* epel: mirror.xfes.ru
* extras: mirror.corbina.net
* rpmforge: ftp-stud.fht-esslingen.de
* updates: mirror.corbina.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mod_perl.i386 0:2.0.4-6.el5 set to be updated
--> Processing Dependency: perl(BSD::Resource) for package: mod_perl
--> Running transaction check
---> Package perl-BSD-Resource.i386 0:1.28-1.fc6.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================== ==============================
Package Arch Version Repository Size
================================================== ==============================
Installing:
mod_perl i386 2.0.4-6.el5 base 4.0 M
Installing for dependencies:
perl-BSD-Resource i386 1.28-1.fc6.1 base 29 k

Transaction Summary
================================================== ==============================
Install 2 Package(s)
Upgrade 0 Package(s)

Total download size: 4.1 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): perl-BSD-Resource-1.28-1.fc6.1.i386.rpm | 29 kB 00:00
(2/2): mod_perl-2.0.4-6.el5.i386.rpm | 4.0 MB 00:02
--------------------------------------------------------------------------------
Total 1.7 MB/s | 4.1 MB 00:02
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-BSD-Resource 1/2
Installing : mod_perl 2/2

Installed:
mod_perl.i386 0:2.0.4-6.el5

Dependency Installed:
perl-BSD-Resource.i386 0:1.28-1.fc6.1

Complete!

3. Show "httpd -l" after install:

Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

[L. D. James]

1. Show "httpd -l" :

[root@mosteam ~]# httpd -l
Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c2. :

[root@mosteam ~]# yum install mod_perl
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* atomic: www7.atomicorp.com
* base: mirror.corbina.net
* epel: mirror.xfes.ru
* extras: mirror.corbina.net
* rpmforge: ftp-stud.fht-esslingen.de
* updates: mirror.corbina.net
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mod_perl.i386 0:2.0.4-6.el5 set to be updated
--> Processing Dependency: perl(BSD::Resource) for package: mod_perl
--> Running transaction check
---> Package perl-BSD-Resource.i386 0:1.28-1.fc6.1 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

================================================== ==============================
Package Arch Version Repository Size
================================================== ==============================
Installing:
mod_perl i386 2.0.4-6.el5 base 4.0 M
Installing for dependencies:
perl-BSD-Resource i386 1.28-1.fc6.1 base 29 k

Transaction Summary
================================================== ==============================
Install 2 Package(s)
Upgrade 0 Package(s)

Total download size: 4.1 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): perl-BSD-Resource-1.28-1.fc6.1.i386.rpm | 29 kB 00:00
(2/2): mod_perl-2.0.4-6.el5.i386.rpm | 4.0 MB 00:02
--------------------------------------------------------------------------------
Total 1.7 MB/s | 4.1 MB 00:02
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing : perl-BSD-Resource 1/2
Installing : mod_perl 2/2

Installed:
mod_perl.i386 0:2.0.4-6.el5

Dependency Installed:
perl-BSD-Resource.i386 0:1.28-1.fc6.1

Complete! 3. Show "httpd -l" after install:

Compiled in modules:
core.c
prefork.c
http_core.c
mod_so.c

Place in your httpd.conf file:


<Files ~ "\.(pl|cgi)$">
SetHandler perl-script
PerlResponseHandler ModPerl::PerlRun
Options +ExecCGI
PerlSendHeader On
</Files>Restart your Apache server and run the test.pl and let me know the output.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Woohoo !!

test.pl run success, but fsdbase show error 500

[L. D. James]

Woohoo !!

test.pl run success, but fsdbase show error 500

fsdbase.sh is to be run from the crontab as mentioned in the setup when it was created.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

fsdbase was in crontab, but internal server error...
if test.pl work, but fsdbase doesn't work, what could it be ???

[L. D. James]

fsdbase was in crontab, but internal server error...
if test.pl work, but fsdbase doesn't work, what could it be ???

I don't know how a message "internal server error" could possibly be generated from the crontab. Where did you get this output?

The test.pl is a server application run from the web. The runfsdbase.sh is a console application run from cron.

Would you mind posting a link to your fsdbase.htm? This is a link to mine:

http://flightsim.apollo3.com/fsdbase/fsdbase.htm

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

Internal server error (500) I see, when I enter information in fsdbase.htm (example: CID or Name) (When open stats.pl), fsdbase open normal.

[L. D. James]

Internal server error (500) I see, when I enter information in fsdbase.htm (example: CID or Name) (When open stats.pl), fsdbase open normal.

You didn't make a reference to my question about a link.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

http://fly.mosteam.net/stat/fsdbase.htm

[L. D. James]

http://fly.mosteam.net/stat/fsdbase.htm

Will you post the output of the stats.pl when run from a terminal window?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

Output stats.pl in terminal:
[root@mosteam stat]# ./stats.pl
[Wed Jun 29 12:13:39 2011] stats.pl: "my" variable $cnt masks earlier declaration in same scope at ./stats.pl line 1192.
Fsdbase - Version 1.87
<table width=100% bgcolor="#33ffff" id=main1><tr><td>
<a href=fsdbase.htm>[Main]</a> &nbsp
<a href=stats.pl?cmd=recentflights>[Recent Flights]</a> &nbsp
<a href=stats.pl?cmd=recentusers>[Recent Users]</a> &nbsp
<a href=stats.pl?cmd=search>[Search]&nbsp </td>
<td>[Logged in as:: Nobody]</a></td></tr>
<tr><td> <a href=stats.pl?cmd=login1>[Login]
</td></tr></table id=main1>
[Wed Jun 29 12:13:39 2011] stats.pl: DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.8/CGI/Session/Driver/mysql.pm line 50.
</a><hr><br>FSDBase Version 1.87

[L. D. James]

Output stats.pl in terminal:
[root@mosteam stat]# ./stats.pl
[Wed Jun 29 12:13:39 2011] stats.pl: "my" variable $cnt masks earlier declaration in same scope at ./stats.pl line 1192.
Fsdbase - Version 1.87
<table width=100% bgcolor="#33ffff" id=main1><tr><td>
<a href=fsdbase.htm>[Main]</a> &nbsp
<a href=stats.pl?cmd=recentflights>[Recent Flights]</a> &nbsp
<a href=stats.pl?cmd=recentusers>[Recent Users]</a> &nbsp
<a href=stats.pl?cmd=search>[Search]&nbsp </td>
<td>[Logged in as:: Nobody]</a></td></tr>
<tr><td> <a href=stats.pl?cmd=login1>[Login]
</td></tr></table id=main1>
[Wed Jun 29 12:13:39 2011] stats.pl: DBD::mysql::db do failed: MySQL server has gone away at /usr/lib/perl5/site_perl/5.8.8/CGI/Session/Driver/mysql.pm line 50.
</a><hr><br>FSDBase Version 1.87

I'm going to install your Linux distro on a computer and test the setup to see what's missing. I'll get back to you on this.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[L. D. James]

Hi, .

Comment out (or remove) the block we put:

# <Files ~ "\.(pl|cgi)$">
# SetHandler perl-script
# PerlResponseHandler ModPerl::PerlRun
# Options +ExecCGI
# PerlSendHeader On
# </Files>Place the Options directive "ExecCGI" instead of "+ExecCGI". Make sure you have the Addhandler in your httpd.conf also. The test the test.pl file and the stats.pl scripts.

#
#
AddHandler cgi-script .cgi .pl
#
<Directory />
Options FollowSymLinks ExecCGI
AllowOverride None
</Directory>
#
<Directory "/var/www/html">
#
#
# Possible values for the Options directive are "None", "All",
# or any combination of:
# Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
#
# Note that "MultiViews" must be named *explicitly* --- "Options All"
# doesn't give it to you.
#
# The Options directive is both complicated and important. Please see
# http://httpd.apache.org/docs/2.2/mod/core.html#options
# for more information.
#
Options Indexes FollowSymLinks ExecCGI

#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
#
AllowOverride None

#
# Controls who can get stuff from this server.
#
Order allow,deny
Allow from all

</Directory>
#
#-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

After this changes:
#
#
AddHandler cgi-script .cgi .pl
#
<Directory />
Options FollowSymLinks ExecCGI
AllowOverride None
</Directory>
#
<Directory "/var/www/html">
#
#
# Possible values for the Options directive are "None", "All",
# or any combination of:
# Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews
#
# Note that "MultiViews" must be named *explicitly* --- "Options All"
# doesn't give it to you.
#
# The Options directive is both complicated and important. Please see
# http://httpd.apache.org/docs/2.2/mod/core.html#options
# for more information.
#
Options Indexes FollowSymLinks ExecCGI

#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# Options FileInfo AuthConfig Limit
#
AllowOverride None

#
# Controls who can get stuff from this server.
#
Order allow,deny
Allow from all

</Directory>
#
#

If I open test.pl in browser - error 500
If I open stats.pl in browser - error 500 too

[L. D. James]

After this changes:


If I open test.pl in browser - error 500
If I open stats.pl in browser - error 500 too

Will you give me the output of:

httpd -MThanks.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

httpd -M output:


[root@mosteam ~]# httpd -M
Loaded Modules:
core_module (static)
mpm_prefork_module (static)
http_module (static)
so_module (static)
auth_basic_module (shared)
auth_digest_module (shared)
authn_file_module (shared)
authn_alias_module (shared)
authn_anon_module (shared)
authn_dbm_module (shared)
authn_default_module (shared)
authz_host_module (shared)
authz_user_module (shared)
authz_owner_module (shared)
authz_groupfile_module (shared)
authz_dbm_module (shared)
authz_default_module (shared)
ldap_module (shared)
authnz_ldap_module (shared)
include_module (shared)
log_config_module (shared)
logio_module (shared)
env_module (shared)
ext_filter_module (shared)
mime_magic_module (shared)
expires_module (shared)
deflate_module (shared)
headers_module (shared)
usertrack_module (shared)
setenvif_module (shared)
mime_module (shared)
dav_module (shared)
status_module (shared)
autoindex_module (shared)
info_module (shared)
dav_fs_module (shared)
vhost_alias_module (shared)
negotiation_module (shared)
dir_module (shared)
actions_module (shared)
speling_module (shared)
userdir_module (shared)
alias_module (shared)
rewrite_module (shared)
proxy_module (shared)
proxy_balancer_module (shared)
proxy_ftp_module (shared)
proxy_http_module (shared)
proxy_connect_module (shared)
cache_module (shared)
suexec_module (shared)
disk_cache_module (shared)
file_cache_module (shared)
mem_cache_module (shared)
cgi_module (shared)
version_module (shared)
evasive20_module (shared)
perl_module (shared)
php5_module (shared)
proxy_ajp_module (shared)
ssl_module (shared)
ispmgr_module (shared)
Syntax OK

[L. D. James]

httpd -M output:


[root@mosteam ~]# httpd -M
Loaded Modules:
core_module (static)
mpm_prefork_module (static)
http_module (static)
so_module (static)
auth_basic_module (shared)
auth_digest_module (shared)
authn_file_module (shared)
authn_alias_module (shared)
authn_anon_module (shared)
authn_dbm_module (shared)
authn_default_module (shared)
authz_host_module (shared)
authz_user_module (shared)
authz_owner_module (shared)
authz_groupfile_module (shared)
authz_dbm_module (shared)
authz_default_module (shared)
ldap_module (shared)
authnz_ldap_module (shared)
include_module (shared)
log_config_module (shared)
logio_module (shared)
env_module (shared)
ext_filter_module (shared)
mime_magic_module (shared)
expires_module (shared)
deflate_module (shared)
headers_module (shared)
usertrack_module (shared)
setenvif_module (shared)
mime_module (shared)
dav_module (shared)
status_module (shared)
autoindex_module (shared)
info_module (shared)
dav_fs_module (shared)
vhost_alias_module (shared)
negotiation_module (shared)
dir_module (shared)
actions_module (shared)
speling_module (shared)
userdir_module (shared)
alias_module (shared)
rewrite_module (shared)
proxy_module (shared)
proxy_balancer_module (shared)
proxy_ftp_module (shared)
proxy_http_module (shared)
proxy_connect_module (shared)
cache_module (shared)
suexec_module (shared)
disk_cache_module (shared)
file_cache_module (shared)
mem_cache_module (shared)
cgi_module (shared)
version_module (shared)
evasive20_module (shared)
perl_module (shared)
php5_module (shared)
proxy_ajp_module (shared)
ssl_module (shared)
ispmgr_module (shared)
Syntax OK

Will you place the test.pl file in two places:

/var/www/html
and
/var/www/cgi-bin

Then run these web addresses in your browser:

http://localhost/test.pl
and
http://localhost/cgi-bin/test.pl

Also send me your complete httpd.conf so that I can see what's different from mine that works and yours that's giving problems.

Just clicking on the links above should suffice to test the files in the locating I just gave you.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I uploaded httpd.conf in your upload manager

[L. D. James]

I uploaded httpd.conf in your upload manager

I need to know the output of links I gave you in my last message.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

In folder cgi-bin error 500 too

[L. D. James]

In folder cgi-bin error 500 too

What about the other place? I need the information to identify what is exactly happening on your server. I set it up in minutes on an installation of Centos. I didn't do anything special. So, it's something very simple that you've done different. So the details I'm asking you are important so that I can identify what it is different from your server and a default installation.

Also, will you give me a link to the test.pl file? You can put the test.pl file into the directory with the fsdbase that you linked in a previous message.

Finally, if you want to, you can create a temporary user ID for me to log in and fix your apache perl support. The latter doesn't matter and doesn't have to be done. I don't mind doing it the way we are already going by giving you a step to test, one step at a time while get gets functioning. It's up to you if you're anxious. I don't mind. And the timely method we are currently using can be look at, as a learning experience.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I give you login and password temp. user from my server.
URL and more information in your private message.
And When I put the test.pl file in folder with fsdbase: I see error 500

[L. D. James]

I give you login and password temp. user from my server.
URL and more information in your private message.
And When I put the test.pl file in folder with fsdbase: I see error 500

Thanks. It was the /var/www/html area that I was asking you to test (from my previous message). I'll check my PM now and let you know how I make out. I'm sure it'll just take a few minutes.

Any private information would be communicated in the PM. Everything else will be communicated here so that other users having a similar problem or issue will have the solution... as well can have the opportunity to give input if they cared to.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Ok, thank you, I'm waiting =)

[L. D. James]

Ok, thank you, I'm waiting =)

You're welcome.

While you we research to find the firewall or other item that's blocking your ssh from working try backing up your current httpd.conf file and replacing it with this one:

httpd.conf (Centos default with cgi .pl activated):
http://download3.apollo3.com/download/download.php?id=24

Test the output of local host with the file placed in the locations of:

Will you place the test.pl file in two places:

/var/www/html
and
/var/www/cgi-bin

Then run these web addresses in your browser:

http://localhost/test.pl
and
http://localhost/cgi-bin/test.pl

Also send me your complete httpd.conf so that I can see what's different from mine that works and yours that's giving problems.

Just clicking on the links above should suffice to test the files in the locating I just gave you.-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

stats.pl works - but registration on server don't work
and when I open admin.pl - I see error 500

[L. D. James]

stats.pl works - but registration on server don't work
and when I open admin.pl - I see error 500

The program is run from the "fsdbase.htm" interface. It's not designed to look at the various files and try to run the files independently. You have to click on the options that are available from the interface. The interface is very simple and basically calls the "stats.pl" file. That's the only part of the file that is set to run from the web.

Again, the operation is very simple. As was shown when you ran the setup.sh file, just place the runfsdbase.sh in crontab and use it by using the fsdbase.htm (or stats.pl) interface and you have full access.

I'm surprised it took so long to get the apache server working, but I only made two changes to the httpd.conf (addhandler .pl and options ExecCGI) and it worked. At present it works with normal CGI support which is installed in CentOS by default. I'll have to work with the mod_perl which is a different interface to make it work with that also.

Glad it's working. I'll entertain feature request after we are sure you can use it and the glitches are out.

I have another operating version, but it isn't packaged yet. I'll also want to create an upgrade interface for users that are running the current packaged version.

Thanks again for testing the application and reporting on it. If you find it useful (which I do), I'm sure we can work together to have it grow into a much fuller application.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

And my question:

Why I click on registration on my server - I redirecting to your fsdbase(apollo3 server)

[kostoed97]

And When I login to the server, with my CID and Password - I see "Sorry, Login failed"
I check all information - Information correct

[L. D. James]

And my question:

Why I click on registration on my server - I redirecting to your fsdbase(apollo3 server)

Do you have a link I can test?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljam3es

[kostoed97]

Link in PM

[L. D. James]

Link in PM

I'm not asking for a password, just a regular public link like this:

http://flightsim.apollo3.com/fsdbase/fsdbase.htm

The application is secure.

edit:
By the way, the link you sent me in PM is broken. It doesn't work.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Ok, How uers can register on my server, if link *register here* in my fsdbae redirecting on your fsdbase

[L. D. James]

Ok, How uers can register on my server, if link *register here* in my fsdbae redirecting on your fsdbase

I'll work on the problem you describe. You don't have to provide a link for me to check, but that would help. I can't see harm in providing a workable link so that I can see what happens different on your server from a test environment that works flawlessly.

In the meantime I'll be installing the application on a local machine to see what happens when I click on the links you're describing. Again. if you provided a link that might help to expedite my understanding that ability to test the resolution.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

Hi, Larry
If user want to register on my fsd server, he click on link *register CID here* and he is redirecting for your fsdbase.

And Why, when I go to your fsdbase and register here - i see file register.pl
in my fsdbase this file is missing ?

And version my fsdbase 1.87, your version 1.90

Help me please !

[L. D. James]

Hi, Larry
If user want to register on my fsd server, he click on link *register CID here* and he is redirecting for your fsdbase.

And Why, when I go to your fsdbase and register here - i see file register.pl
in my fsdbase this file is missing ?

And version my fsdbase 1.87, your version 1.90

Help me please !

I'll work on the resolution. You can help by providing a fsdbase link on your server. Give me something to the effect of:

http://flightsim.apollo3.com/fsdbase/fsdbase.htm

and we'll take it from there. I'll see what's happening on your server and I'll program the modules accordingly.

It can be the same as your productive application for your users or a test area if you don't want to use it at this time.

Thanks in advance for the assistance and participation on the project!

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

Link:
http://aero.mosteam.net/stat/fsdbase.htm

But now server stopping, in 14-15 Hours UTC - He will work

[L. D. James]

Link:
http://aero.mosteam.net/stat/fsdbase.htm

But now server stopping, in 14-15 Hours UTC - He will work

I don't know what you mean by stopping?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Server is workingm server was stopped because I put money on dedicated server on my ISP

[L. D. James]

Server is workingm server was stopped because I put money on dedicated server on my ISP

Glad you're getting it in order. I see the problem you described. I'll give you a link to the resolution within an hour or so.

Type to you later...

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[L. D. James]

Server is workingm server was stopped because I put money on dedicated server on my ISP

Grab the latest version of fsdbase from the download section of http://flightsim.apollo3.com .

Just run the configure the fsdbase.cfg file and run the setup. It'll automatically update what you already have running.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

When I setup this version i see this:

Checking and setting perl execution path...[#!/usr/bin/perl]
....-
Verfying neccessary perl modules are installed...
...........
Config FSD file error [whazzup] Exiting...
Config FSD file error [whazzup] Exiting...
Setup Finished successfully.
You can run runfsdbase.sh to start your database.
Set it up to run each minute to continue the database update

File runfsdbase.sh is not create
Fsd server is running

[L. D. James]

When I setup this version i see this:

Checking and setting perl execution path...[#!/usr/bin/perl]
....-
Verfying neccessary perl modules are installed...
...........
Config FSD file error [whazzup] Exiting...
Config FSD file error [whazzup] Exiting...
Setup Finished successfully.
You can run runfsdbase.sh to start your database.
Set it up to run each minute to continue the database updateFile runfsdbase.sh is not create
Fsd server is running

Yes. The runfsdbase.sh file wasn't created because the setup.sh had errors. I'll work on the setup application to actually exit when it says it's exiting so that users don't get that false impression that it actually did complete.

In the last version it asked for the path of the fsd.conf file. In this one it asked for the pathname of the fsd file. So the last part of that entry has to include the filename which by default is fsd.conf.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I correct config file and i see this
'@'localhost' (using password: YES) at ./main.pl line 54
Can't continue... [Database access Error] correct database error and run setup again.

Database name and password correct

[L. D. James]

I correct config file and i see this
'@'localhost' (using password: YES) at ./main.pl line 54
Can't continue... [Database access Error] correct database error and run setup again.Database name and password correct

Are you sure? The error you see is the error that is coming from the mysql database. The application tried to open the database but mysql responded with that error.

Check it very closely. Are you able to access the database from the terminal command line with:


mysqll -u [username] -p
(answer password prompt)
use [databasename]
-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I checked username and password - but this error I see too

[L. D. James]

I checked username and password - but this error I see too

You'll have to log in to the mysql system as root, then change the user password to what you want it to be called.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

I reconnect to this database as root, but this error I see again

[BBuchanan]

Oops, sorry, I thought something new had been posted. Please delete.

[L. D. James]

I reconnect to this database as root, but this error I see again

Are you saying you can log into the database as root but you can't log into it with the user account you created?

Did you use the root user account to set the password to what you want the user account to use? That is what I was asking you to do in my previous message.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

Ok, how i can change password user's fsdbase from root
What command do this ??

[L. D. James]

Ok, how i can change password user's fsdbase from root
What command do this ??

Change user password for tom:
mysql>update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom';-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I change password and correct it in fsdbase.cfg but I see this error

[L. D. James]

I change password and correct it in fsdbase.cfg but I see this error

You see which error? The same error? Are you able to use the userid to log into the database from the console using that username and password the same way you logged into it using the root password?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I change in fsdbase database username 'root' and password for root, but program couldn't connect to database, the same error

[L. D. James]

I change in fsdbase database username 'root' and password for root, but program couldn't connect to database, the same error

Are you saying you're using "root" for the user name in fsdbase.cfg and the root password in the password field in the fsdbase.cfg file? And are you saying you get the exact same error you posted earlier?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

Yes yes.....

[L. D. James]

Yes yes.....

I guess your two yes' are indicating that all three questions are yes.

Anyway, will you post the output of the setup.sh command. There's a chance I might notice something.

I can't imagine why mysql would report that error outside of wrong username/password.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

Output setup.sh:

'@'localhost' (using password: YES) at ./main.pl line 54
Can't continue... [Database access Error] correct database error and run setup again.

[L. D. James]

Output setup.sh:

'@'localhost' (using password: YES) at ./main.pl line 54
Can't continue... [Database access Error] correct database error and run setup again.

Can I see the whole setup.sh output? It should only be a few lines.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

$ ./setup.sh
Checking and setting perl execution path...[#!/usr/bin/perl]
....-
Verfying neccessary perl modules are installed...
...........
'@'localhost' (using password: YES) at ./main.pl line 54
Can't continue... [Database access Error] correct database error and run setup again.

[L. D. James]

$ ./setup.sh
Checking and setting perl execution path...[#!/usr/bin/perl]
....-
Verfying neccessary perl modules are installed...
...........
'@'localhost' (using password: YES) at ./main.pl line 54
Can't continue... [Database access Error] correct database error and run setup again.

There is a chance you have some code in your password that is causing the error. Try creating a database user account and ensure to only use letters and numbers for the password.

Use the following link for an example. Replace the items in brackets "[ ]" with something that applies to your specific database.


GRANT all ON [dbname].* TO '[dbuser]'@'localhost' IDENTIFIED BY '[dbpass]';
Be sure to update the fsdbase.cfg file with the appropriate:dbname:
dbuser:
dbpass:

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I run your mysql command, but I see same error

I see 2 items:
1. When I change fsd.conf location in file fsdbase.cfg without name "fsd.conf" - Config FSD server error[whazzup] Exiting...
2. When I change same directive with fsd.conf - I see this mysql error

[L. D. James]

I run your mysql command, but I see same error

I see 2 items:
1. When I change fsd.conf location in file fsdbase.cfg without name "fsd.conf" - Config FSD server error[whazzup] Exiting...
2. When I change same directive with fsd.conf - I see this mysql error

While you post your fsdbase.cfg file? Put "XXX"'s were the dbpass is. Never post any passwords on the internet.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

fsdbase.cfg:

# Sample Configuration File for fsdbase

dbname = fsdbase
dbuser = root
dbpass = XXX
timezone = +4
website = http://aero.mosteam.net/
packagelocation = /var/www/site/data/www/aero.mosteam.net/stat/
fsdconf = /var/www/site/data/fsd1110/unix/fsd.conf

[L. D. James]

fsdbase.cfg:

# Sample Configuration File for fsdbase

dbname = fsdbase
dbuser = root
dbpass = XXX
timezone = +4
website = http://aero.mosteam.net/
packagelocation = /var/www/site/data/www/aero.mosteam.net/stat/
fsdconf = /var/www/site/data/fsd1110/unix/fsd.conf

The fsdbase.cfg file has the root dbuser name. Are you sure you used the new user name from the command I gave you?

Make sure you have the name and password you used from the command.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I run mysql command and change user in fsdbase.cfg - database error again((((

[L. D. James]

I run mysql command and change user in fsdbase.cfg - database error again((((

What did you put in the fsdbase.cfg file for dbuser?

Also, does the dbuser name work from the commandline with mysql?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

# Sample Configuration File for fsdbase

dbname = fsdbase
dbuser = mosteam
dbpass = xxx (password correct, I know :)
timezone = +4
website = http://aero.mosteam.net/
packagelocation = /var/www/site/data/www/aero.mosteam.net/stat/
fsdconf = /var/www/site/data/fsd1110/unix/fsd.conf

[L. D. James]

# Sample Configuration File for fsdbase

dbname = fsdbase
dbuser = mosteam
dbpass = xxx (password correct, I know :)
timezone = +4
website = http://aero.mosteam.net/
packagelocation = /var/www/site/data/www/aero.mosteam.net/stat/
fsdconf = /var/www/site/data/fsd1110/unix/fsd.conf

Are all the files you're using the files from the new fsdbase package (version 187d)?

If you're not sure, open a directory, extra the tar file again and run the setup from there.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I use package 187d

[L. D. James]

I use package 187d

I know some of my messages appear very redundant, but I need to know exactly what you're doing that the applications aren't behaving normally.

Are you saying you opened up the package again and run the setup.sh command from a different directory?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames

[kostoed97]

My directory named not fsdbase. Directory named stat

[L. D. James]

My directory named not fsdbase. Directory named stat

Ok. This is my question. Did you replace all the files from the C version with the D version or did you mix the files?

I'm trying to suggest that you don't mix the files and use just one version. So since you have a directory that you're using called stat, you'd have to move all those files to a different place and put the new files into the directory of your choice.

This is what I'm asking you if you did. This is what I'm suggesting for you to do. It has to be clear to me that you're using a clean extract.

By the way the current version now is E. It'll probably be F before the day is over.

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

I delete old version and upload new version fsdbase

[L. D. James]

I delete old version and upload new version fsdbase

You maybe having problems with your mysql installation.

Are you able to log into the mysql account using the account you created for Fsdbase, then access the database?


ljames@ubunzeus:~/public_html/fsdbase/fsdbase187c$ mysql -u ljames -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9572
Server version: 5.1.54-1ubuntu4 (Ubuntu)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use fsdbase;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>
Replace "ljames" with the username you have set. Replace "fsdbase" with the name of your fsdbase file.

Example:

mysql -u mosteam -p
use fsdbase;
Will you give me the output?

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[kostoed97]

The problem with database resolved itself, probably with the release of new version

But I see new prtoblem:
Setup was successfully, runfsdbase created, but I go to fsdbase.htm and fill, example: CID field, I get software error...

Can't Find FSDConf File...
Compilation failed in require at /home/mosteam.net/stat/stats.pl line 30.
BEGIN failed--compilation aborted at /home/mosteam.net/stat/stats.pl line 31.

But path to fsd.conf is right

[L. D. James]

The problem with database resolved itself, probably with the release of new version

But I see new prtoblem:
Setup was successfully, runfsdbase created, but I go to fsdbase.htm and fill, example: CID field, I get software error...

Can't Find FSDConf File...
Compilation failed in require at /home/mosteam.net/stat/stats.pl line 30.
BEGIN failed--compilation aborted at /home/mosteam.net/stat/stats.pl line 31.But path to fsd.conf is right

The latest version, fsdbase187h will resolve that issue.

-- L. James

--
L. D. James
ljames@apollo.com
www.apollo3.com/~ljames

[BBuchanan]

The problem with database resolved itself, probably with the release of new version

But I see new prtoblem:
Setup was successfully, runfsdbase created, but I go to fsdbase.htm and fill, example: CID field, I get software error...

Can't Find FSDConf File...
Compilation failed in require at /home/mosteam.net/stat/stats.pl line 30.
BEGIN failed--compilation aborted at /home/mosteam.net/stat/stats.pl line 31.

But path to fsd.conf is right

It might be another type of permissions. I'd like to suggest:

chmod 777 /var/www/site/data/fsd1110/unix/ -R


Actually, I truely suggest moving it completely out of the webroot. I have my fsd server:
/fsd
So my full path is shorter:
/fsd/unix/fsd.conf
Then chmod 777 /fsd/ -R

The -R is recursive. Meaning it'll change all the files and folders under /fsd/ to 777.

Then depending on your system (it should be the same, but I can look it up if it doesn't work. Admin is the webroot, cron, fsdbase user for me. Change admin to what it is for your system)

chown admin /fsd/ -R
chgrp admin /fsd/ -R


Another simple way to see who owns a file or folder, using your cp (I think I saw ispconfig) create a folder. Then using FTP like filezilla, look at the owner/group column. Sometimes, it'll be numbers and thats ok. Just replace admin with the numbers.


chown 1006 /fsd/ -R
chgrp 1006 /fsd/ -R


Also remember, the owner and group must match both the fsd.conf and fsdbase.

[L. D. James]

It might be another type of permissions. I'd like to suggest:

chmod 777 /var/www/site/data/fsd1110/unix/ -R
Actually, I truely suggest moving it completely out of the webroot. I have my fsd server:
/fsd
So my full path is shorter:
/fsd/unix/fsd.conf
Then chmod 777 /fsd/ -R

The -R is recursive. Meaning it'll change all the files and folders under /fsd/ to 777.

Then depending on your system (it should be the same, but I can look it up if it doesn't work. Admin is the webroot, cron, fsdbase user for me. Change admin to what it is for your system)

chown admin /fsd/ -R
chgrp admin /fsd/ -R
Another simple way to see who owns a file or folder, using your cp (I think I saw ispconfig) create a folder. Then using FTP like filezilla, look at the owner/group column. Sometimes, it'll be numbers and thats ok. Just replace admin with the numbers.


chown 1006 /fsd/ -R
chgrp 1006 /fsd/ -R
Also remember, the owner and group must match both the fsd.conf and fsdbase.

Brett. Actually the current version will resolve that user's current issue.

Also, the excerpt the user showed isn't an indication of where his fsd server is run. It's very much unlikely that it's run from the webroot. It's most likely run from the fsd owner's home space (~fsd).

The database program (stats.pl) is a web application. It has to be run from the webroot (or what I'm meaning is from a web space).

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

[BBuchanan]

Brett. Actually the current version will resolve that user's current issue.

Also, the excerpt the user showed isn't an indication of where his fsd server is run. It's very much unlikely that it's run from the webroot. It's most likely run from the fsd owner's home space (~fsd).

The database program (stats.pl) is a web application. It has to be run from the webroot (or what I'm meaning is from a web space).

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames (http://www.apollo3.com/%7Eljames)

True. Stats.pl should be in the web root. However on centos the webroot is:
/var/WWW
which is why I said to move it.

[L. D. James]

True. Stats.pl should be in the web root. However on centos the webroot is:
/var/WWW
which is why I said to move it.

So, in this case, the user has placed the web application in a different area... one he appears to have created specifically for it.

As you see, I did the same:

http://flightsim.apollo3.com/fsdbase/

-- L. James

--
L. D. James
ljames@apollo3.com
www.apollo3.com/~ljames