My God no longer know what to do to fix this error
that shit happens when many users accession the panel, but is to fix this? need urgent solution: S
http://img199.imageshack.us/img199/4326/errorfu.jpg
that shit happens when many users accession the panel, but is to fix this? need urgent solution: S
http://img199.imageshack.us/img199/4326/errorfu.jpg
I assume you have done the obvious and checked your config.php...
if not, do that..
If you have and it still errors which PHP extension are you using? the built in mssql dll's or the FreeTDS dblib.dll?
It is strongly recommended that you use the dblib.dll as it handles high traffic better.
well I use xampp and I do not know how to install FreeTDS dblib.dll this business, I tried to install it did not help = / would you give me some hint here at the topic of how to fix, or get someone who knows? : S
I'll be assuming you use the latest XAMPP.
First of all Download this:
http://download.moodle.org/download....3/DBLIB_TS.zip
Once you have it downloaded extract the dblib.dll and place it in C:\XAMPP\PHP\ext
Open up php.ini and comment out all the mssql extensions.
(just open it up, press Ctrl+f to find, type in mssql, if you see an Extension place a ; in front of it.)
Add this line to the extensions:
extension=php_dblib.dll
Save it
Now create a txt file at the root of your c:\ drive called freetds.conf and copy this into it:
[global]
host = xxx.xxx.xxx.xxx (ip of the MSSQL server)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520
Make sure you change the xxx.xxx.xxx.xxx to your SQL IP address.
save the file and restart apache/mysql..
All done, you're now using FreeTDS instead of the built in mssql extensions.
Original directions here: http://docs.moodle.org/en/Installing_MSSQL_for_PHP
under the FreeTDS on Windows section.. If you go to the site, stop after step 4 since we dont have Moodle to configure.
Last edited by Darkcyde; 14-12-09 at 10:26 PM.
Ok, I fixed this by doing this:
Go into c:\xampp\php
Open php.ini
Find this line
extension=php_mssql.dll
If there is a semocolon ";" in front of that line, take it out. This was the problem.
It means MSSQL functions in PHP aren't enabled, thus you can't connect using MSSQL. I did that and it fixed it for me, good luck.
not good, already did in every way and nothing worked = /
It have to work,restart apache after you do thatOriginally Posted by hellred3
You can do what Timebomb said but as soon as your traffic goes up the mssql extensions wont be able to keep up and will give you errors. The freetds lib's are best for high traffic.
There are really only about 4 things that can cause this:
1. You have bad data in your config.php.
2. Your php extensions/libs are wrong and cant talk to your SQL.
3. You have bad DB's in SQL.
4. there is no connection from site to SQL server.
There may be a lot more but these are the most common errors.
maybe he can give us the logs....
I'm with this same problem can not solve, the panel works normally, but when many players start to use it and write it falls Unable to conect! Unable to connect or DB2!
deploys freetds I've done everything that was explained, but this error continues. I do not know what to do
you did it wrong then!
1 - I downloaded the dll> http://download.moodle.org/download....3/DBLIB_TS.zip
2 - installed the dll in c: \ xampp \ php \ ext
3 - open c: \ xampp \ php \ php.ini and tried the line (extension php_mysql.dll and below php_dblib.dll added the extension) and saved.
4 - I created a file called freetds.config in c: \ freetds.config and adiconei ...
[global]
host = my ip (ip of the MSSQL server)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520
5 - I did all this and do not know where you are wrong, if I did something wrong please correct me.
Actually cabaltools (and the various mods like destrus) are all known to do this :/
Check your freetds config file
tds version = 8.0
That is only correct if you use sql 2000. If you have 2005 change the tds version to 9.0 (or 10.0 if you have 2008).
1 - I downloaded the dll> http://download.moodle.org/download....3/DBLIB_TS.zip
2 - installed the dll in c: \ xampp \ php \ ext
3 - open c: \ xampp \ php \ php.ini and tried the line (extension php_mysql.dll and below php_dblib.dll added the extension) and saved.
4 - I created a file called freetds.config in c: \ freetds.config and adiconei ...
[global]
host = my ip (ip of the MSSQL server)
port = 1433
client charset = UTF-8
tds version = 8.0
text size = 20971520
5 - I did all this and do not know where you are wrong, if I did something wrong please correct me.
According to the SS you left the mssql extension enabled. you must disable the default mssql dll's for freetds to work right..
as the version of SQL I use SQL 2000.
Darkcyde, explain to me right where I switch to disable the mssql and how do I enable freetds.
thanks
Refer to that post, I explained it all there... remember you have to comment out the default mssql extensions or it wont work right. There should be 2 of them:
extension=php_mssql.dll
extension=php_pdo_mssql.dll
Comment them out:
;extension=php_mssql.dll
;extension=php_pdo_mssql.dll
and add
extension=php_dblib.dll
When you create freetds.conf make sure you arent hiding known file extensions in your OS, creating a txt file then renaming it freetds.conf.txt is a no no. If you unhide known file type extensions change the .txt to .conf
Last edited by Darkcyde; 15-12-09 at 10:08 PM.
Darkcyde, I'm not too good to mess with that, I'm not understand this, I have to remove the MSSQL extension and put the new extension in place?
---------- Post added at 09:08 PM ---------- Previous post was at 09:05 PM ----------
ok thanks I will do the testing and declare you have a SS to see if this correct ok
I've given you steps and links for everything you need to do, I cant do anything else. If you cant figure this out than I wish you luck in actually administering a server cuz it only gets harder. This is one of the most simple tasks an admin faces.
I explain that I did right, and be sorry for disturbing you, but thank
Yes that is right.. now post a SS of your freetds.conf at C:\ root.I explain that I did right, and be sorry for disturbing you, but thank
You dont have to show your SQL IP, I just want to make sure you have it configured right.
Here are the SS excuse the delay
Last edited by Brujeria; 15-12-09 at 11:26 PM.
not before, I tried a leg up upside down and no good, someone on another panel that works well?
Alright everything looks good. Make sure you take the info in parenthesis out of the the conf file.Here are the SS excuse the delay
Reply With Quote
