Using Firebird as the RDBMS

obsidian-studios · Joined: 16 Feb 2005 Posts: 36 Location: Jacksonville, FL

I would like to use Firebird as the RDBMS for my mod. I have a dedicated Firebird db server already and am seasoned in Fb db development and administration etc.

At first I am a little concerned with a column requiring a name of name. Since name is a SQL-92 or SQL-99 (going from memory) resevered keyword. However I believe to be a minor issue since I can change column and table names in the aps_include file.

My problem is I am getting nothing. I have the odbc driver installed. DSN setup, and tested to be working. I imported the erf, and am doing the SQLInit() in my on modules load event. However all tests to insert values do nothing.

I have logging set to 2 in my .ini file? The dll is in place? Where should the log file for this be? I must have missed something or not done something as part of the setup. I am expecting errors, but getting nothing with no log in site is not encouraging.

Any help or assistance is greatly appreciated.

TulipVorlax · Posted: Wed Feb 16, 2005 7:08 Post subject:

logs files are in logs.0 folder
can't help you more than that sorry

obsidian-studios · Joined: 16 Feb 2005 Posts: 36 Location: Jacksonville, FL

in the nwn\ directory right? I only have a logs folder. I assume it will create that folder if it needs to log something there. Since I do not have that folder or a log. I am pretty sure it's not loading, working or something. I am sure it is something I did or did not do. At least I hope so.

TulipVorlax · Posted: Wed Feb 16, 2005 7:39 Post subject:

Try to create the folder yourself next time.
Mine is : « E:\NWN\logs.0 »

obsidian-studios · Joined: 16 Feb 2005 Posts: 36 Location: Jacksonville, FL

I did it and same thing nothing. I have seen some server puke stuff out where the points and xp usually appears. Not sure the name of that win at the moment. Not sure if there is something I can add there for further debug or print statements? It does not seem like the nwnx stuff is getting loaded, but you would thing a failed function call would be logged some where? When I have the log level turned up. I assume there would be some sql init or statup output in the log as normal for level 2 logging? So at a min I should get that or something if the nwnx stuff i loading correctly? Pretty sure my problem is there?

obsidian-studios · Joined: 16 Feb 2005 Posts: 36 Location: Jacksonville, FL

also just for a test case I swapped over to the sqllite db just to see if it would make a diff. No go still nothing so I must have missed something?

Thought I followed the directions to the T?

TulipVorlax · Posted: Wed Feb 16, 2005 19:33 Post subject:

Hum. That's weird.
I think you sould at least have logs files even if your mod don't even used the database. NwnX2 is supposed to produce a log file everytime it is started and it even make a backup of the olds logs files.

You could try to re-download NwnX2 files (and all plugins files that you wanna use). And place them all in the same folder as your nwserver.exe and verifie all settings in nwnx.ini file.

Here are my settings :

TulipVorlax · Posted: Wed Feb 16, 2005 19:48 Post subject:

So, it seem that you are doing that on Linux.
If that is the case, i can't help you anymore...
Sorry.
_________________
My comps.

My little forum.

JeroenB · Joined: 31 Dec 2004 Posts: 228 Location: Netherlands

You should get a Logs.0 directory in your NWN directory when you start the NWServer application. It generates that in default. So, first try running nwn server without nwnx to see if it creates the directory.

obsidian-studios · Joined: 16 Feb 2005 Posts: 36 Location: Jacksonville, FL

Ah ha, it's how I was starting nwn. I was not executing the nwsever.exe I was running it via the nwnloader or nwnmain.

Not sure if that was in the instructions or not, my bad. If not

Also FYI, for obvious reason I am developing this on windows so nothing is on linux at the moment. However before the module goes public for testing and etc. I will build a dedicated linux server just to run nwn. I already have a dedicated db server and other servers, all Linux of course. Wink

Ok so now I have files being created and etc in logs.0 but for some reason still no db stuff? Only general server and player stuff in the logs.0 directory. For now till I get things working I am just going to try get the sqllite db running. But no go. Once I get that up and running I will switch over to ODBC and proceed on building db and module.

I am doing this witht eh ODBC2 driver, should I try the older one?

Thanks to all so far helping out. Really appreciated.

obsidian-studios · Joined: 16 Feb 2005 Posts: 36 Location: Jacksonville, FL

Ok looks like my bad. I should have been executing nwnx2.exe, dooh. Morron. Looks like it's making calls and logging them. Time to get the building. So no problems on win.

Now I just need info about Firebird on Linux. Is the odbc stuff on linux specific to mysql? Can I still use a ODBC driver on linux?

TulipVorlax · Posted: Thu Feb 17, 2005 7:48 Post subject:

JeroenB · Joined: 31 Dec 2004 Posts: 228 Location: Netherlands

No, the linux version currently only supports MySQL. So, you will have to write your own plugin if you want to connect to Firebird.

Papillon · x-man Joined: 28 Dec 2004 Posts: 1060 Location: Germany

Uhm, well, we originally had an ODBC and a MYSQL module. But I am not sure if I still have the sources flying around somewhere.... I can try to find them if anyones wants it.
_________________
Papillon

obsidian-studios · Joined: 16 Feb 2005 Posts: 36 Location: Jacksonville, FL

Yes I would like them, however if I have to make something I may just go ahead add direct support via a plugin or something rather than ODBC. Unless it's less effort to implement the odbc stuff.

The NWNX Community Forum