FSD Base

[jayden]

Hi larry,

I the FSDBase config file there is the following:
dbname = fsdbase
dbuser = username
dbpass = password

but nothing saying dbhost etc so i could host the DB on my other webserver. Is there a way to do this?

Thanks

Jayden

[L. D. James]

Hi, Jayden.

Thanks for pointing out the oversight. I'll add the server parameter before the day is over and update the download package.

By the way, I see you have two accounts on the system, jayden and jaydens (both have the exact fullname). This is discouraged. We will have to delete one of them. Which one of the accounts will you prefer keeping?

-- L. James

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

[jayden]

Sorry about that, i re-registered because i forgot i had already. Please could you delete the jaydens account.

Many Thanks

[L. D. James]

Put the server host on the same line with the dbname separated by a colon as in:

fsdbase:localhost

You can also use a third paramater for port number as in:

fsdbase:localhost:3306

-- L. James

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

[jayden]

how do i run the setup.sh?

[L. D. James]

./setup.sh

-- L. James

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

[jayden]

sorry do i need to run it in CMD if so what is the command to?

[L. D. James]

Jayden, do you know that this is a Linux based program? If you're running it on a Linux system, all you do is open it, run the setup.sh (just like all Linux packages) and you will be up and running. It's all automatic.

If you're trying to install it on a perl based Windows platform, I have no way of testing it, and I haven't ever ran perl on Windows.

Again, if you're on a Linux system, just type ./setup.sh and press enter.

-- L. James

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

[jayden]

It is a windows system, but i already run perls on it. Ill see if i can remember how.

[jayden]

Can you link multiple servers to the FSDBase and make one 'master' server? Also could you make a version for windows?

[L. D. James]

>Can you link multiple servers to the FSDBase and make one
>'master' server? Also could you make a version for windows?

The servers are linked by the fsd.conf file. As long as the servers are link, FSDBase logs everything on all the servers automatically.

-- L. James

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

[jayden]

Ok, does the master server log or will the secondary server log as i have a linux server connecting to a windows server aswell as another windows server. I was also wondering if server are connected do they share the same certs?

[L. D. James]

Each server has it's own log. Each sever has it's own cert file. However, you could log into either server using login information from either certificate file. Running Servinfo or FSDBase on either server will show (or log) the same connection information no matter which server has the traffic.

When they are connected, they are one network, so checking the information on either server will show you the information that is on the one network.


-- L. James

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

[L. D. James]

By the way, congratulations on the Linux addition.

-- L. James

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

[jayden]

Thanks, as asked before would it be possible to adapt it for windows - if you could adapt the .sh to a .pl it would run fine for me on windows

Jayden

[jayden]

Also if i may i would like to add one more request into FSDBase which i think might benefit the program ( i dont know if it is hard to do or not):

I think within the registration script they should also have their CID & P/W that they are assigned with put into a teamspeak server (selectable) user database. The reason i ask this is that, I operate comms off teamspeak, and in the 'Networks' section of FSInn under 'Voice' TS is clicked and the only problem is that FSInn tries to log the user into teamspeak with the CID & P/W they are signed onto the network with. If FSInn didnt do that then life may be easier (lol - not that i dont like the idea). It would also for other communites save the number of SA's needed to reg people on the server.

Just a thought.

Thanks,
Jayden

[L. D. James]

>Thanks, as asked before would it be possible to adapt it for
>windows - if you could adapt the .sh to a .pl it would run
>fine for me on windows
>
>Jayden

I could consider writing a Windows version of the tools, but I don't see having time in the immediate future. Since I'm currently spending time developing the Linux Webbased utility, I invite comments, suggestions and feature request for that aspect.

-- L. James

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

[jayden]

Ok, i think i will re-format all my servers to Linux! I am really liking what i hear aobut FSDBase, may i ask if my above request would be possible aswell as another:

Could you put in a 'Live' whos online that will display whos online catagorized (ATC/Pilots - showing CID, Rating For ATC and what server they are connected to) aswell is in like a google map?

Many thanks

Jayden

[jayden]

At the moment my main server registration process is the following:

A users registers on a web script, that then adds them into the server using telnet. Now when i look at the server they have not been added into the cert.txt file. If i connect servers together will it authenticate the users from the telnet registration or is there a way to get the cert file to update to show the people that have registered through telnet.

Jayden

[L. D. James]

The telnet interface for the FSD server makes changes for the current session, but does not change the cert file. You would have to either manually change update the cert file, or have your script do it.

-- L. James

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

[jayden]

Ok, with the FSDBase package is a reg script included as i personally prefer the one you have made to my basic one?

Jayden

[L. D. James]

It's in the process of being added.

-- L. James

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

[jayden]

Is there a registration page included for FSDBase?

Jayden

[L. D. James]

>Is there a registration page included for FSDBase?
>
>Jayden

I don't understand your question. If you're asking for a registration requirement for using FSDBase, there's no such requirement. As you can see, the resource pointed to for support via the readme file, is generous.

It has been downloaded many times since I put it online. I've had a few questions and suggestions in private emails, but there isn't a lot of feedback at this point.

I must say, I appreciate your feedback.

If you're asking about a page for users to self register to the FSD cert file, I mentioned twice to you that, that feature is being implemented.

-- L. James

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

[jayden]

Sorry i completley forgot, please forgive me for that error. When would you be able to implement it into the package?

Jayden

[jayden]

Hi again Larry,

I have gone to set up FSDBase on my link server (CentOS) and when i run setup.sh i get the following error:

bash-3.1# ./setup.sh
./setup.sh: ./checkformodules.pl: /usr/local/bin/perl: bad interpreter: No such file or directory
Can't continue... [Neccesary Perl modules not installed] correct errors and run setup again.

it is sending the pl to /usr/local/bin/perl altough my perl is in /usr/bin/perl, is there a way to change it as i looked in the setup.sh and it wasnt in there.

Jayden

[L. D. James]

I'll get a resolution to you asap.

-- L. James

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

[jayden]

Thanks you are a STAR!

[L. D. James]

Grab fsdbase-v1.87a.tar.bz2 from http://www.apollo3.com/download/download.php?id=48 .

-- L. James

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

[jayden]

ok will do that now. Also to view the web pages do i need to stick it in my /var/www/html dir or does it not matter what directory its in. also how would i view the web pages?

Jayden

[L. D. James]

>ok will do that now. Also to view the web pages do i need to
>stick it in my /var/www/html dir or does it not matter what
>directory its in. also how would i view the web pages?
>
>Jayden

You can put the package anywhere you choose.

You bring the fsdbase.htm file in your browser.

-- L. James

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

[jayden]

How would i access it in my browser, is there a web link i have to type(im not on the LAN or the server when i am accessing it).

I also when running the setup.sh file, get the following error:
bash-3.1# ./setup.sh
Verfying neccessary perl modules are installed...
.
Perl Module:[ CGI::Session ] NOT installed. Install the module then run setup again.
.
Perl Module:[ Mail::Send ] NOT installed. Install the module then run setup again.
......
Perl Module:[ CGI::Session ] NOT installed. Install the module then run setup again.
.......
Can't continue... [Neccesary Perl modules not installed] correct errors and run setup again.

what does it mean?

Jayden

[L. D. James]

Have you even created any web page at all? Forget about FSDBase for a minute and just create any web page at all. Notice if you can create a webpage that you can bring it up in your browser.

If you don't know how to create a web page that you can bring up in your browser, I'll have to look for a tutorial to show you how to create a web page and make changes to it.

After have done that, then do the same for the fsdbase.htm. Just open up the directory where it's located in your browser.

-- L. James

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

[jayden]

Im running it of my webserver / server so i already have my site hosted in it. Also do you know why i am gettin the error shown above?

Thanks

Jayden

[L. D. James]

You don't have the required modules installed. On most machines you can install them (specifically the ones from your message) by running the command sequence below. I'm showing you what to type. Of course, you'll have to be patient while the system runs it's course between the commands.


perl -MCPAN -e shell
o conf prerequisites_policy ask
install CGI::Session
install Mail::Send


-- L. James

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

[jayden]

Hi,

all working now, just a few questions:

Does the ATC client and FSINn when havign a pilot log in authenticate of the sql db and when going to admin.pl i get the following error:
Software error:

Global symbol "$flightend" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 90.
Global symbol "$year1" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 133.
Global symbol "$mon1" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 133.
Global symbol "$mday1" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 133.
Global symbol "$hour1" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 133.
Global symbol "$min1" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 133.
Global symbol "$sec1" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 133.
Global symbol "$flightend" requires explicit package name at /var/www/flightserver/fsdbase/admin.pl line 148.
Execution of /var/www/flightserver/fsdbase/admin.pl aborted due to compilation errors.

For help, please send mail to the webmaster (root@localhost), giving this error message and the time and date of the error.

is it a prob @ my end,

thanks,

jayden

[L. D. James]

>Hi,
>
>all working now, just a few questions:
>
>Does the ATC client and FSINn when havign a pilot log in
>authenticate of the sql db and when going to admin.pl i get
>the following error:
>Software error:
>
>Global symbol "$flightend" requires explicit package
>name at /var/www/flightserver/fsdbase/admin.pl line 90.
>Global symbol "$year1" requires explicit package
>name at /var/www/flightserver/fsdbase/admin.pl line 133.
>Global symbol "$mon1" requires explicit package name
>at /var/www/flightserver/fsdbase/admin.pl line 133.
>Global symbol "$mday1" requires explicit package
>name at /var/www/flightserver/fsdbase/admin.pl line 133.
>Global symbol "$hour1" requires explicit package
>name at /var/www/flightserver/fsdbase/admin.pl line 133.
>Global symbol "$min1" requires explicit package name
>at /var/www/flightserver/fsdbase/admin.pl line 133.
>Global symbol "$sec1" requires explicit package name
>at /var/www/flightserver/fsdbase/admin.pl line 133.
>Global symbol "$flightend" requires explicit package
>name at /var/www/flightserver/fsdbase/admin.pl line 148.
>Execution of /var/www/flightserver/fsdbase/admin.pl aborted
>due to compilation errors.
>
>For help, please send mail to the webmaster (root@localhost),
>giving this error message and the time and date of the error.
>
>
>is it a prob @ my end,
>
>thanks,
>
>jayden

I don't understand your question.

To run the program, just use the web interface. The modules are not designed to be run independently.

-- L. James

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

[jayden]

I have, but i dont understand how to get to the admin panel. Also does the FSDBase eliminate the use of the cert.txt?

Jayden

[L. D. James]

>I have, but i dont understand how to get to the admin panel.

Log in using the user ID and password you have in the fsdbase.cfg file for the database.

>Also does the FSDBase eliminate the use of the cert.txt?

No. It facilitates it.

-- L. James

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

[jayden]

Ok, will the database be the source that all server logins authenticate off? and will it copy users password from the cert file?

Also how do i get to the admin page on the script?

Jayden

[L. D. James]

>Ok, will the database be the source that all server logins
>authenticate off? and will it copy users password from the
>cert file?

I don't understand your question. But I will say the program is very automatic. I'm sure using it will help things to be clear.

If you experience any problems when using it, let me know.

>
>Also how do i get to the admin page on the script?
>

See my previous message.

-- L. James

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

[lj661]

Hello all I Love the work you are doing here Mr. James, Anyway straight to the point I have the FSD server up and running in Texas and also one in Salmon Arm British Columbia connected every thing working great but my final piece of the puzzle I need to verify Pilot info Flight plans ETC. i have been working on FSD Base but unfortunately i just cant get perl functioning correctly. So where i am now is I Got an Apache Web Server mysql and Php installed and configured. Is it possible to parse the Whazzup file into the MYSQL database just to verify flight info etc. by admins at this point if no web frontend thats fine. Im at the limits of my SQL and programming knowledge and any direction on a way to basically log the Server for administrative purposes verifying flight plans etc would be awesome You have been a wealth of knowledge and this project has really pushed the envelope for me so getting this final issue solved would be much appreciated. Once again thanks for the work done here.

[L. D. James]

>Hello all I Love the work you are doing here Mr. James,
>Anyway straight to the point I have the FSD server up and
>running in Texas and also one in Salmon Arm British Columbia
>connected every thing working great but my final piece of the
>puzzle I need to verify Pilot info Flight plans ETC. i have
>been working on FSD Base but unfortunately i just cant get
>perl functioning correctly. So where i am now is I Got an
>Apache Web Server mysql and Php installed and configured. Is
>it possible to parse the Whazzup file into the MYSQL database
>just to verify flight info etc. by admins at this point if no
>web frontend thats fine. Im at the limits of my SQL and
>programming knowledge and any direction on a way to basically
>log the Server for administrative purposes verifying flight
>plans etc would be awesome You have been a wealth of knowledge
>and this project has really pushed the envelope for me so
>getting this final issue solved would be much appreciated.
>Once again thanks for the work done here.

Can you give the exact error message you get when you run the setup.sh file?

-- L. James

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

[lj661]

thanks for the quick response. A little background this is running on a windows 2003 server I started trying to use Microsoft IIS so originally the errors were this module missing certain times internal server error 500 etc, So i did a Apache server pack and anything calling on perl gets an internal 500, I'm just having no luck with perl, so i was hoping the php sql solution might be available so i can get to the end of this wonderful road. I'm going to keep plugin away at the web server but in order to get some antsy virtual flyers mirated from FSHOST to the much prefered FSD I need a way to log the server thanks again for your help.

[L. D. James]

I don't do much programming in PHP. If you were to run the script under Linux it will automatically indicate which modules are missing and give you the prompt for downloading and installing them.

Even though I feel that Perl is much more advance, standard, and portable than PHP, I might one day start programming in PHP because of the popularity.

As far as Windows, I'm sure the problem is that it doesn't recognize the setup script which checks for the modules and builds the mysql database.

I'm sure it'd work from Cywin on Windows 2003. But as I mentioned earlier in this thread, I really think having a Linux server in your network would be the best way to go.

-- L. James

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

[lj661]

Thanks for the reply one more issue when sitting next to another pilot in multiplayer their lights and motor seem to cycle on and off is that a known issue or can an adjustment be made thanks again for any info.

[L. D. James]

>Thanks for the reply one more issue when sitting next to
>another pilot in multiplayer their lights and motor seem to
>cycle on and off is that a known issue or can an adjustment be
>made thanks again for any info.

Hi, Lj.

You're welcome. It's a pleasure.

By the way, this isn't a feature of FSDBase or this thread discussion. Mixing topics will confuse other users searching for answers.

If you don't see the topic of your question or discussion already listed, please start a new topic and put a description of the subject matter there. It'll make it easier for all.

-- L. James

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