MySQL starting time

[ShaDoOoW]

Got one issue that when my server have been turned on or restarted, nwnx runs before MySQL is really started. MySQL is installed as service though. Is there way to start NWNX after it will be possible to connect to MySQL? Other than check for db connection in nwscript and if its not bound, then do restart...
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect

[Paul R]

(caveat I don't run the Windows version so this may not be relevant)

Guess it depends how you start nwnx, if it's as a service like srvany then try it as a delayed start service. If via startup folder or in the registry try using a cmd script and doing a net start command for MySQL and then nwnx after.

Paul
_________________
oops

[Baaleos]

I had this problem too,
where nwnx tries to run before all the services are up n running.

I resolved it via a batch file.

In the bat file, tell it to
ping -n 10 127.0.0.1 >NUL

you can change the number 10, to whatever you want, to change the duration of the wait.

This basically tells it to ping itself for 10 seconds, which in my case at least, is enough time for php and mysql to get up and running.


so if your php/mysql service is started by running an executable, you can do this in a bat file

start C:\Servers\MYSQL\MYSQL.exe
ping -n 20 127.0.0.1 >NUL
start C:\Servers\NWN\NWNX2.exe


Note - In some cases, you will have problems with the arguments that nwnx tries to read in, eg - INI Values, or locating the modules folder, if you try to execute it from a folder location other than the nwn folder, or a folder shared with nwnx2.exe itself.

I resolved this by putting the BAT in the nwn folder, with nwnx2.exe, and then just execute a shortcut to the bat file instead, from the startup folder.

[ShaDoOoW]

Guess I will try to change NWNX to not load module if it won't be able to connect db then. Not sure when I try that though.
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect

[Baaleos]

To do that, you will need to build a unique version of nwnx_odbc

The functions currently inside the database plugin, are designed to be accessed from nwn, but since your plan is to not load nwn server if the database connection cannot be established, it causes a chicken and egg sorta situation.

All in all, you would likely need
1. The nwnx2.exe to send a request to the odbc plugin, before module loading, and
2. The odbc plugin to respond to it.


My suggestion would be a 'while' loop, to determine if the database has become available.

[Gryphyn]

In windows your can give services dependencies.
I'm sure there would be a similar facility in non-windows O/S's
Just make the NWNX service dependent on the MySQL one. This way NWNX will not start until/unless MySQL is already running.

[Baaleos]

In other news... I actually do know the answer to
"What came first, the chicken or the egg?"


The Chicken would have been born, from an egg, that was not a chicken egg. (Evolution - if your a believer)

So, you can say, 1. The Egg did come first, but 2. It wasnt technically a chicken egg, since it was laid by a bird of a different species.

Its like an indian woman giving birth to an 8 legged child..... The mutations can be that extreme even for animals, and these often give rise to new species.
One minute, you have a dodo, next minute, its laying an egg, which hatches in to a chicken.


Anyway... this was completely random, wanted to post it in the post above, but forgot.

[Asparius]

Hmmm... a crude solution would be somethong like this:
Make a program that repeatedly attempts to connect to mysql database.
When this program succesfully connects and run a query (like "SELECT NOW()"), it will run nwnx2.exe.

Still it leaves a problem when mysql crash during server running...

[Baaleos]

A batch file csn do all of this no need for a program. I used a bat file for my garrys mid server, it would automatically restart the server if the process ever vanished.

[ShaDoOoW]

[Gryphyn]