Basic Help

[Iberiaorbit]

In order to export flights to any web site you have to install certain script in such site. FsPassengers2004 provides for free that script.
Once the script is working in your host you have to edit settings. I need help here too.
What in the world is localhost database? the host IP, my web domain name? I have that confusion between database and local host. The
rest seems pretty much easy.
I titled this post basic help cause after all we had to pass to reach this point this last steep should be an easy answer mor some of you.

[pegase]

The theory is easy:
When you connect to your fspadmin/index.php and opent the Edit general settings link
The value for Server: is the name of the machine where MySQL is running.
(This value is stored in setting.php under the variable $cfg['mysql_server'].

The value for database: is the name of thedatabase you have created.
(This value is stored in setting.php under the variable $cfg['databaselocalhost']

The application can be quite difficult.
You have to know exactly what must be used for the Server name. Only your web hoster can give it for sure.

The admin settings can tell you exactly what goes wrong

If the problem is about an unknown server name '11001: error = "Host not found" ) you get
Not connected
to wrongserver server
Database: flightlogs

mySql error:
Unknown MySQL Server Host 'wrongserver' (11001)

If the problem is about an unreachable ip address (error = "Can't assign requested address" ) you get
Not connected
to 194.206.232.215 server
Database: flightlogs

mySql error:
Can't connect to MySQL server on '194.206.232.215' (10049)

If the connexion is rejected (for any other reason than login password) you get
Not connected
to localhost server
Database: flightlogs

mySql error:
Can't connect to MySQL server on 'localhost' (10061)

(For example my MYSQL server rejects any connexion via the internet network board or under the name 'localhost' )

If the problem is about a wrong login password
mySql error:
Not connected
to goodserver server
Database: flightlogs

mySql error:
Access denied for user 'zob'@'goodserver.domainname' (using password: NO/YES)


If the connexion to the server is OK but the database you have in configuration does not exists, (here I called a database named 'badexample'
You get
Not connected
to ns1 server
Database: badexample

mySql error:
Unknown database 'badexample'

Last but not least, when the connexion is OK you get

Connected
to goodservernameexample server
Database: gooddatabaseexample

These are all results I could reproduce but off course, ther could be some others. Anyway, the error code number is an important indication. here is
alist of others possible errors

case 10004: error = "Interrupted system call"; break;
case 10009: error = "Bad file number"; break;
case 10013: error = "Permission denied"; break;
case 10014: error = "Bad address"; break;
case 10022: error = "Invalid argument (not bind)"; break;
case 10024: error = "Too many open files"; break;
case 10035: error = "Operation would block"; break;
case 10036: error = "Operation now in progress"; break;
case 10037: error = "Operation already in progress"; break;
case 10038: error = "Socket operation on non-socket"; break;
case 10039: error = "Destination address required"; break;
case 10040: error = "Message too long"; break;
case 10041: error = "Protocol wrong type for socket"; break;
case 10042: error = "Bad protocol option"; break;
case 10043: error = "Protocol not supported"; break;
case 10044: error = "Socket type not supported"; break;
case 10045: error = "Operation not supported on socket"; break;
case 10046: error = "Protocol family not supported"; break;
case 10047: error = "Address family not supported by protocol family"; break;
case 10048: error = "Address already in use"; break;
case 10049: error = "Can't assign requested address"; break;
case 10050: error = "Network is down"; break;
case 10051: error = "Network is unreachable"; break;
case 10052: error = "Net dropped connection or reset"; break;
case 10053: error = "Software caused connection abort"; break;
case 10054: error = "Connection reset by peer"; break;
case 10055: error = "No buffer space available"; break;
case 10056: error = "Socket is already connected"; break;
case 10057: error = "Socket is not connected"; break;
case 10058: error = "Can't send after socket shutdown"; break;
case 10059: error = "Too many references, can't splice"; break;
case 10060: error = "Connection timed out"; break;
case 10061: error = "Connection refused"; break;
case 10062: error = "Too many levels of symbolic links"; break;
case 10063: error = "File name too long"; break;
case 10064: error = "Host is down"; break;
case 10065: error = "No Route to Host"; break;
case 10066: error = "Directory not empty"; break;
case 10067: error = "Too many processes"; break;
case 10068: error = "Too many users"; break;
case 10069: error = "Disc Quota Exceeded"; break;
case 10070: error = "Stale NFS file handle"; break;
case 10091: error = "Network SubSystem is unavailable"; break;
case 10092: error = "WINSOCK DLL Version out of range"; break;
case 10093: error = "Successful WSASTARTUP not yet performed"; break;
case 10071: error = "Too many levels of remote in path"; break;
case 11001: error = "Host not found"; break;
case 11002: error = "Non-Authoritative Host not found"; break;
case 11003: error = "Non-Recoverable errors: FORMERR, REFUSED, NOTIMP"; break;
case 11004: error = "Valid name, no data record of requested type"; break;

[SWAFO]

I think he knows what he's talking about!

[Iberiaorbit]

Does he? for I am trying to put all those values and switch them and I don't connect... where in the world is Dan?

[SWAFO]

Dan doesn't reply to your thread for 2 hours, and you ask "where in the heck is Dan?" Dan is busy my friend. He has a life outside of
FSP... it's quite difficult tryin to run the company all by himself. Give him time, he will come!

[pegase]

Let's take it easy Iberiaorbit No, I have no idea where is Dan..

Don't waste time trying all my error example...

Try rather to put the values you have then, cut and past the error message in the forum.

I can't promise you any result. but just my best trying to help.

[Iberiaorbit]

I know he will come, he allways does and helps. I didn't want to sound like complaining. I am just impatient. I sent him some e-mails that
still not replied. I know I am not the only customer. Just been a long way to here and now I am stuck again.

[Iberiaorbit]

Not connected
to localhost server
Database: guilow_fspdb

mySql error:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[Iberiaorbit]

I created the mysql database guilow_fspdb and got this e-mail
username: guilow_fspdb
password: arandomword
database name: guilow_fspdb
database host: 100webcustomers.com
database port: 3306

also I know my server host IP is 70.84.13.163
and 100webcustomers.com as server/host name.

[pegase]

OK, then try to replace 'localhost' by '100webcustomers.com' , cut and paste the result

[Iberiaorbit]

Not connected
to localhost server
Database: 100webcustomers.com

mySql error:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[SWAFO]

Also, you posted your initial message 2 hours before you posted your message asking "where the heck is Dan". RELAX!!! Dan has to
sleep too, not to mention that he's got a life outside of FSP. I can see if you waited 24 hours and no reply (that'd still sound a little
impatient to me), but just 2 HOURS!!! Give me a break man. Relax, he'll be here to save the day soon!

[Iberiaorbit]

you relax, I am just making my questions. nobody ask you to answer them or tell me where is Dan. shut up



Post Edited ( 08-17-05 18:20 )

[pegase]

Wrong move Iberia

Not connected
to localhost server (Here put 100webcustomers.com)
Database: 100webcustomers.com (Here put guilow_fspdb)

Asta luego

[Iberiaorbit]

I already have it that way and the message still
Not connected
to localhost server
Database: 100webcustomers.com

mySql error:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)