[latest new] Exporting flight log online to VA

[pegase]

Could anyone help the post is falling down in the post

Well, it is terribly difficult to provide efficient help about database connexion as there are plenties of different possibilities depending how your
ISP has implemented the PHP and MySQL .

It seems that your login/password is not accepted by your database. Are you sure that the login/passw for your database is the same than for FTP ?

[DanSteph]

bigkid90 wrote:
Hey guys i have extracted and set the main stuff up in General Settings, but i get this error on the side
FsPassengers 1.5 status

Not connected
to localhost server
Database: globalat@globalatc.net

mySql error:
Access denied for user: 'globalat@localhost' (Using password: NO)
the globalat is the username for the FTP but i need a password for the FTP (wwhich i do know) but why is it telling me (Using password:
NO) cause i am Well anyways THanks for any help...Cheers
COA_420

SQL DB password and data have nothing to do with FTP , unless you want to spend the next 1000 years
trying all the possibilities I suggest you ask you provider for those data:

1-How can I create/use a MySQL DB ?
2-what are the server, DB name and login data so I can access it ?

once you have those informations go into the FsP admin part and fill them.

Hope it help ?

Dan

[bigkid90]

what are the server, DB name and login data so I can access it ?

I have all the info now all i need to do is find out what belongs in the Server and Database blocks. the link in the FTP is something like
this globalat@globalatc.net/public_html/va/FsPadmin/ ...if that helps



Post Edited ( 08-12-05 04:26 )

[vollmey]

BigKid,

Do have a SQL database available to you?? If you do, you will have a Username, Database name, Password, and host name for that
database. All of this is seperate from your Website stuff, it will not be the same.

SQL databases and FTP to upload your data too your website are two very diffrerent things.

Now if you do have a SQL database you need to read the READ ME instructions that is included with the VA download. Halfway down the
first page you will FSPAdmin section. That will set up your SQL database and get it ready for you or whomever wants to upload there
flights to your database. But, you need to have all the files on the webserver before you run FSPAmin.

Hope that helps you a bit.


Hi Dan, hows things going?? Been on vacation for a bit, things look to be going good.

[bigkid90]

K, yes we do have a SQL Database i created a Username and Password and the Database is called globalat_fspassengers...now i just
gotta find out the server name then...thanks for all your help, i hate SQL lol as you can maybye see

[bigkid90]

ERrR 1 more problem i get this error i set evreything up like it should be..

Not connected
to 70.96.188.26 server
Database: globalat_fspassengers

mySql error:
Access denied for user: 'COA420@box26.bluehost.com' (Using password: YES)



Post Edited ( 08-15-05 00:04 )

[reed]

How do I add the list of flights in my custom designed site? what PHP code do I have to type, and to limit the list of maybe the last 10 or
15 flights??

thanks forward!

/Philip Nordlander,

[Captain Binkles]

You would do something like select * from reports order by date DESC, limit 0,10

Just off the top of my head

[vollmey]

Bigkid,

Is that what your getting when FSpassengers tries to connect???

[bigkid90]

Negative thats what it tells me on the side of my Admin Page

[reed]

>Captain Binkles
>select * from reports order by date DESC, limit 0,10

Sonuds nice... but how do the whole php code looks like? for an example.

Thanks forward!
/Philip Nordlander,

[vollmey]

Bigkid,

You got something set up wrong then. Did you run the setup in the instructions??

[reed]

Okey, if I set I limit to 6.. works fine but the script will not add the number of pages on automatic... how can I made that?

/Philip Nordlander,

[albert]

DanSteph wrote:

For webmaster the file that you must provide to each members
is really simple: ("anyname.cfg" go into "config_va" folder)
------------------------------------------------------------------------------------
menu_name=Virtual Pilot Group;
base_url=http://www.fspassengers.com;
path_stats=pageofstats.php;
path_export=getflight.php;
username=visitor;
password=test;
------------------------------------------------------------------------------------

For the username and password on this config file where do i get the username and pass from. Like is it the username and pass for FsPadmin pannel, the
SQL pass, or WHAT? PLEASE HELP

[JayKae]

You make it up BUT in your admin you HAVE to add that user using the made up username and password so that they can log their
flights.