Control Panel bug

[Brujeria]

Sorry my bad English.

Well I got the cabaltoolz v3 to add on my site ..... I use the UserCP for player add points in the panel. It works certinho, but the problem when many players start to use the panel at the same time and falls and writes the message "Unable Conect!". I need to give a restart in XAMPP for him to return to work.

My question is, why this happening? and how to solve this problem the panel stop falling.

thank you very much

[MentaL]

[emi]

use free tds instead of sql

[Brujeria]

hi
TDS what would it be? please be more specific or can make me a tuto explaining how to fix this.

I thank you very much. thanks

[emi]

read it carefully:http://forum.ragezone.com/f459/cabal...ta-2-a-464817/

[Brujeria]

That first link was to download FreeTDS?

link this off

[emi]

no i said read all posts carefully somewhere is the thing with FreeTds

[Brujeria]

Yes it says I have to use the FreeTDS instead of msql ....

but the problem is not that give you with this freetds ...... I need a tuto how to do this ... (where downloading, installing, configuring)

sorry but I'm a little newbie in sql

thanks

[emi]

FreeTDS for Windows
================================

First download the right version of the lib for your version of PHP.

PHP 5.1.x
http://kromann.info/php5_1-Release_TS/php_dblib.dll

PHP 5.2.x
http://kromann.info/php5_2-Release_TS/php_dblib.dll

PHP 6.x
http://kromann.info/php6-Release_TS/php_dblib.dll

Place the .dll in the PHP extensions directory (extension_dir in php.ini)


Here are my php.ini settings:

magic_quotes_gpc = Off or
magic_quotes_gpc = On and magic_quotes_sybase = On

;extension=php_mssql.dll
extension=php_dblib.dll

; Valid range 0 - 2147483647. Default = 4096.
mssql.textlimit = 20971520

; Valid range 0 - 2147483647. Default = 4096.
mssql.textsize = 20971520

; Use NT authentication when connecting to the server
mssql.secure_connection = Off

You will also need to create c:\freetds.conf

[global]
host = 127.0.0.1
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520


Note: "tds version = 8.0" is correct for MSSQL 2000, use 9.0 for MSSQL 2005
and 10.0 for MSSQL 2008.

[Brujeria]

emi5893

thank you for the help you're giving me

so one more question: I use xampp within his portfolio have PHP 5.2 .... would this folder from my php .... to be able to put this setup that you said up there?

[emi]

put the 5.2 version in \php\lib

[Brujeria]

not have php / lib

---------- Post added at 01:04 PM ---------- Previous post was at 12:54 PM ----------

set everything up as explained ... but my panel this fall .... traffic that he's too big and falls far ..... = /

[Darkcyde]

It would be C:\xampp\PHP\ext for windows...

thats where the .dll goes, make sure you comment out all the mssql dll's in the php.ini and add the dblib extension.

create the freetds.conf making sure to use your SQL ip address and your set...


check this page: http://docs.moodle.org/en/Installing_MSSQL_for_PHP

there is a section titled: Using FreeTDS on Windows

follow those directions stopping at #5 for Moodle config as it is not needed... and you'll be good as gold.

[Brujeria]

ok thanks, I'll do the tests, and will be responding.

---------- Post added at 05:27 AM ---------- Previous post was at 04:47 AM ----------

$CFG->dbtype = 'mssql_n'; // Required
$CFG->dbhost = 'localhost'; // assuming MS SQL is on the same server, otherwise use an IP
$CFG->dbname = 'moodle'; // or whatever you called the database you created
$CFG->dbuser = 'yourusername'; // I usually use the 'sa' account (dbowner perms are enough)
$CFG->dbpass = 'yourpassword';
$CFG->dbpersist = false;
$CFG->prefix = 'mdl_'; //Prefix, you can change it, but NEVER leave it blank.]

nao entendi esta parte onde devo colocar isto?


I use XAMPP for my site link .... I need to install that Moodle ..... or not necessary?


Thank!

[chumpywumpy]

The Freetds addon is more stable than the native php libs but either should work.

[Brujeria]

installed, comfigurei, but still my myhoy continues to fall with the traffic access control panel,

I do not know but what I Disispero with it, can no more be giving restart the xampp every 5 minutes for the player to access the DISTRIBUTORS of points ..

Thanks to all who try to help me