AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Two Questions: 1) dbi-related 2) pragma dynamic (https://forums.alliedmods.net/showthread.php?t=5602)

Mugwump 09-06-2004 12:52

Two Questions: 1) dbi-related 2) pragma dynamic
 
Hey!

1. Is there a way to specify a port for the dbi's connect routine? For example if I wanted to run a Mysql server off of the standard 3306 port could I specify the hostname to be localhost:port ? eg localhost:3307 ?

(if this was asked and answered already pls point me it)

2. I recently saw some discussion recommending larger memory settings using pragma dynamic, I currently use 32768 but my script is nearing 15k lines of code and has hundreds of variables, many of which are large multi-dimensional arrays. In the same thread I saw BAIL recommend a setting of 131072 and someone else post that they observed anything above 32768 causing problems...

So I am wondering if I wont run into issues if I double my current memory to 65536 ?

Your advice is appreciated!
-Mug

BAILOPAN 09-06-2004 14:12

You should be able tospecify a new port in the connection string as the host.

pragma dynamic should be used if you're sure you're getting out of memory errors, but 65536 should be fine.

Mugwump 09-06-2004 14:57

Thank you Bailopan, will give both a try.

-Mug

Mugwump 09-08-2004 15:59

Bail, apparently specifying a port in the dbi_connect host doesn't work afterall, I get this error:

[MySQL] DB Connection failed(2005): Unknown MySQL Server Host '127.0.0.1:3307' (1)

I have tried in addition using localhost and the actual domain of the site but all result in the same error, and I have verified that my Mysql server is running on port 3307 ...

-Mug

BAILOPAN 09-08-2004 16:44

I will fix this in TP5, thanks for the report ;]


All times are GMT -4. The time now is 17:14.

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