| View previous topic :: View next topic |
| Author |
Message |
gabonacorp
Joined: 27 Dec 2007
Posts: 12
|
 Posted: Thu Dec 27, 2007 21:55 Post subject: my gameserver provider doesn't let me to run mysql |
 |
|
hi folks,
my game server provider doesn't let me to run mysql, so i have to find another solution to run my nwn1 pw with external database.
do you have any idea what should i use with nwnx2 and odbc (linux server of course)?
maybe a solution to access a database via internet, but i think this will be slow and make some lag. what's yours opinion about this?
thank you very much for your help.
gabonacorp |
|
| Back to top |
|
 |
Tenkawa
Joined: 25 Aug 2005
Posts: 15
|
| Posted: Fri Dec 28, 2007 3:26 Post subject: |
|
|
| sqlite |
|
| Back to top |
|
|
gabonacorp
Joined: 27 Dec 2007
Posts: 12
|
| Posted: Fri Dec 28, 2007 20:14 Post subject: |
|
|
it means that is there sqlite for linux?
the linux nwnx2.ini doesn't have this option... |
|
| Back to top |
|
|
william_hunter
Joined: 31 Jan 2007
Posts: 149
|
| Posted: Fri Dec 28, 2007 23:54 Post subject: |
|
|
How many people are on your server? If you have tons, maybe you have to worry about bandwidth losses to SQL communication, but I think it won't be much of an issue, really. Its not like you are making DB queries endlessly most of the time anyhow, is it? Why not try hosting the DB locally and connecting the mod to it?
_________________
The Realm of Tharagon NWN PW |
|
| Back to top |
|
|
virusman
Joined: 30 Jan 2005
Posts: 1020
Location: Russia
|
| Posted: Fri Dec 28, 2007 23:58 Post subject: |
|
|
| Well, there was an experimental build of NWNX ODBC2 for SQLite. I'll try to compile it in a few days. |
|
| Back to top |
|
|
gabonacorp
Joined: 27 Dec 2007
Posts: 12
|
| Posted: Sat Dec 29, 2007 2:14 Post subject: |
|
|
| william_hunter wrote: | | How many people are on your server? If you have tons, maybe you have to worry about bandwidth losses to SQL communication, but I think it won't be much of an issue, really. Its not like you are making DB queries endlessly most of the time anyhow, is it? Why not try hosting the DB locally and connecting the mod to it? |
maximum 20 players. i am a newbie about mysql, what you think, is it tons?  |
|
| Back to top |
|
|
gabonacorp
Joined: 27 Dec 2007
Posts: 12
|
| Posted: Sat Dec 29, 2007 2:14 Post subject: |
|
|
| virusman wrote: | | Well, there was an experimental build of NWNX ODBC2 for SQLite. I'll try to compile it in a few days. |
wow, that would be greatfull! |
|
| Back to top |
|
|
william_hunter
Joined: 31 Jan 2007
Posts: 149
|
| Posted: Sun Dec 30, 2007 2:18 Post subject: |
|
|
| gabonacorp wrote: | | william_hunter wrote: | | How many people are on your server? If you have tons, maybe you have to worry about bandwidth losses to SQL communication, but I think it won't be much of an issue, really. Its not like you are making DB queries endlessly most of the time anyhow, is it? Why not try hosting the DB locally and connecting the mod to it? |
maximum 20 players. i am a newbie about mysql, what you think, is it tons? |
You should be able to host an SQL server on a different site than the game host with 20 or fewer players, and see very little (if any) lag from the SQL to game host communications. The connections between game host and server are limited in most situations anyhow. Are you running lots of database intensive scripting?
_________________
The Realm of Tharagon NWN PW |
|
| Back to top |
|
|
gabonacorp
Joined: 27 Dec 2007
Posts: 12
|
| Posted: Sun Dec 30, 2007 15:44 Post subject: |
|
|
| william_hunter wrote: | | You should be able to host an SQL server on a different site than the game host with 20 or fewer players, and see very little (if any) lag from the SQL to game host communications. The connections between game host and server are limited in most situations anyhow. Are you running lots of database intensive scripting? |
no, i don't think so. we use hcr2, so usually i use non-dropable item for store persistent datas for the PCs. hcr2 use it sometimes, and i need it for some DM tools. Honestly, our PW is in progress, and i don't know exactly how we will use the external database, but our scripters want to be sure about this issue, because in the future it will show them the way and the possibilities. |
|
| Back to top |
|
|
FunkySwerve
Joined: 02 Jun 2005
Posts: 377
|
| Posted: Sun Dec 30, 2007 21:49 Post subject: |
|
|
If your pw isn't already running, then you probably aren't THAT committed to staying with your provider, right? I would hunt down one that lets you use MySQL if at all possible. You aren't hosting with DS are you?
Funky |
|
| Back to top |
|
|
gabonacorp
Joined: 27 Dec 2007
Posts: 12
|
| Posted: Sun Dec 30, 2007 22:07 Post subject: |
|
|
| FunkySwerve wrote: | If your pw isn't already running, then you probably aren't THAT committed to staying with your provider, right? I would hunt down one that lets you use MySQL if at all possible. You aren't hosting with DS are you?
Funky |
i live in Hungary, what is a 10 million country. unfortunately we don't have to many game server provider with normal cost, so if it is possible i would like to find some solution in this place. |
|
| Back to top |
|
|
Gryphyn
Joined: 20 Jan 2005
Posts: 431
|
| Posted: Mon Dec 31, 2007 0:53 Post subject: |
|
|
| gabonacorp wrote: | | FunkySwerve wrote: | If your pw isn't already running, then you probably aren't THAT committed to staying with your provider, right? I would hunt down one that lets you use MySQL if at all possible. You aren't hosting with DS are you?
Funky |
i live in Hungary, what is a 10 million country. unfortunately we don't have to many game server provider with normal cost, so if it is possible i would like to find some solution in this place. |
Will they host ANY database? (if not MySQL).
If they won't host, you're left with any of the embedded databases (like SQLite) that becomes part of the plugin. - you need to write the plugin.
I've posted code for the SQLServer database. This is based on ODBC, someone would need to 're-do' the driver/connection sting section for your choice database
Cheers
Gryphyn |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
