Raised This Month: $12 Target: $400
 3% 

[SQL] MySQL Connector :: Remote Database (+Natives)


Post New Thread Reply   
 
Thread Tools Display Modes
joropito
AlliedModders Donor
Join Date: Mar 2009
Location: pfnAddToFullPack
Old 10-05-2013 , 10:36   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #21

Quote:
Originally Posted by K.K.Lv View Post
another problem , I think you have to consider the handler of the connection, I think most of coders knowing the error code of MySql, like "CR_SERVER_GONE_ERROR(error No. is 2006)" and the "CR_SERVER_LOST(error No. is 2013)", so I suggest you that check whether the handler of the connection is valid or not before you execute the query
Best way is using mysql_pconnect().

I like how oracle drivers works with tns names.
You have a connection pool for a unique name (can have more than 1 different pool). Then you can tell your app to use that pool for each operation. The drivers itself handle reconnection (can be achieved with mysql_pconnect).
__________________

Divide et vinces
approved plugins | steam account

I don't accept PM for support. Just ask on forums.
If you're looking for private work, PM me.
joropito is offline
Send a message via MSN to joropito
claudiuhks
Yam Inside®™℠
Join Date: Jan 2010
Location: Living Randomly
Old 10-06-2013 , 05:40   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #22

Quote:
Originally Posted by K.K.Lv View Post
another problem , I think you have to consider the handler of the connection, I think most of coders knowing the error code of MySql, like "CR_SERVER_GONE_ERROR(error No. is 2006)" and the "CR_SERVER_LOST(error No. is 2013)", so I suggest you that check whether the handler of the connection is valid or not before you execute the query
Thank you. I will remember that and I will do some tests soon.
But for now, if the MySQL remote server is nice enough, the MySQL options function with the reconnecting feature enabled should be enough.
__________________

Last edited by claudiuhks; 10-06-2013 at 05:41.
claudiuhks is offline
Send a message via MSN to claudiuhks Send a message via Yahoo to claudiuhks Send a message via Skype™ to claudiuhks
K.K.Lv
Veteran Member
Join Date: Aug 2008
Location: GameFolder
Old 10-06-2013 , 21:59   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #23

@joropito
you are right, a connection pool will be nice
__________________
QQ:116268742
K.K.Lv is offline
Send a message via MSN to K.K.Lv
bcKq
Member
Join Date: Dec 2012
Location: Tczew, Poland
Old 11-07-2013 , 13:21   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #24

PHP Code:
failed to loadModule/Library "remote_database" required for plugin.  Check modules.ini
Modules.ini
PHP Code:
mysql
;sqlite
fun
engine
fakemeta
;geoip
;sockets
;regex
nvault
cstrike
csx
hamsandwich
remote_database 
It's uploaded into amxmodx/modules folder. I don't know why it doesn't want to load.
AMXX 1.8.2
Linux
Newest SteamCMD version
Metamod v1.21p37 2013/05/30 (5:13)

Also it says in amx_modules:
PHP Code:
unknown                 unknown     unknown              bad load 
EDIT:

Your module SQL Lite connector loads normally. It's only this module.
__________________
This is my signature.

Last edited by bcKq; 11-08-2013 at 08:06.
bcKq is offline
claudiuhks
Yam Inside®™℠
Join Date: Jan 2010
Location: Living Randomly
Old 11-10-2013 , 10:28   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #25

It should be running, but I think the version of MySQL is too recent for old operating systems.
I will attach to this message tonight another versions that should be working with any old OS.
__________________
claudiuhks is offline
Send a message via MSN to claudiuhks Send a message via Yahoo to claudiuhks Send a message via Skype™ to claudiuhks
bcKq
Member
Join Date: Dec 2012
Location: Tczew, Poland
Old 11-10-2013 , 11:35   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #26

I think that my MySQL version is 5.1.39. Unfortunately, I can't change that because I only rent this server.
__________________
This is my signature.
bcKq is offline
claudiuhks
Yam Inside®™℠
Join Date: Jan 2010
Location: Living Randomly
Old 03-08-2014 , 20:11   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #27

Pushed a build.
__________________
claudiuhks is offline
Send a message via MSN to claudiuhks Send a message via Yahoo to claudiuhks Send a message via Skype™ to claudiuhks
metal_upa
Senior Member
Join Date: Jun 2016
Old 01-26-2018 , 13:32   Re: [SQL] MySQL Connector :: Remote Database (+Natives)
Reply With Quote #28

Did anyone still has this module? it seems download link is not available.
metal_upa is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 18:29.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode