I'm going through the Setup wizard after installing moodle.
I get this error:
Error: database driver problem detected
The site administrator should verify server configuration
sqlsrvextensionisnotpresentinphp
I have followed this guid that someone recomended.
http://www.bfcnetworks.com/whitepapers/
Has anyone seen this before and know how to fix it? It is after I enter the MS SQL server info then click next.
I followed those same whitepapers, and had to do minor tweaks to get it to work. Our installation is connecting to a SQL Server cluster and is working successfully.
Here are some of the things I did:
Hopefully this helps you. If not I can send you the details of what I did from a configuration document I put together for our organization.
Thanks for the reply.
Because I am working in the Gov I can't install SQL on the moodle server.
They have to be separated. I also can't install any other software without going through a long and expensive certification process.
I'll try the other things though.
Thanks
FreeDTS is basically a driver, so hopefully it wouldn't be too onerous for you to install it.
By the error message you were getting, it sounds like you may not have the SQL Server driver properly referenced in your php.ini file. Make sure you have these lines at the end of your php.ini:
[PHP_SQLSRV]
extension=php_sqlsrv_53_nts_vc9.dll
[PHP_DBLIB]
extension=php_dblib.dll
and make sure the ddl's they reference are in your ..\php\ext directory.
Let me know if I can be of further help.
Norman, which version of Moodle are you installing? 1.9.x or 2.0.x?
You don't need both those drivers. For Moodle 2.0 you use the SQL Server Driver for PHP (php_sqlsrv_53_nts_vc9.dll) and for Moodle 1.9 you use FreeTDS (php_dblib.dll). They do the same thing - connect to SQL Server, so only one is required.
Use http://docs.moodle.org/en/Using_the_Microsoft_SQL_Server_Driver_for_PHP to setup the SQL Server Driver for PHP in Moodle 2.0.
The sqlsrvextensionisnotpresentinphp error probably means that the SQL Server Driver for PHP has not been installed correctly on your web server. Run PHPInfo() to determine if it has been installed and if PHP has loaded it correctly. You have to make sure that the SQL Server Driver for PHP is installed and that PHP has loaded it BEFORE you start the Moodle installation.
In my opinion changing the NTEXT columns to VARCHAR(max) as Jim suggested is NOT a good idea - and it's certainly not necessary. Making those kinds of changes to the database is just asking for trouble...
Thanks
I think am using Moodle 1.9.X but I need to make sure.
I am only certified for 1.9.X but the It guy put two copies on the server.
One is MoodleWindowsInstaller-latest-19
and One is moodle-2.0.2
The 19 one has a start and stop moodle.exe in it but I need to have it run in IIS and with SQL server 2008.
I think I need to start over. I have to documents the steps I take to get it installed and running so that they can do it in the Production environment.
Don't use the MoodleWindowsInstaller package for production servers - especially if you want to use MSSQL and IIS! On production servers you should install Moodle the manual way by downloading and using the .zip package.
On production servers:
When I select a Database type do I select FreeDTS or the MS SQL?
When I select the Freedts I get this error. How do I recompile PHP? I restarted IIS.
Error: database driver problem detected
The site administrator should verify server configuration
PHP has not been properly configured with the MSSQL extension so that it can communicate with SQL*Server. Please check your php.ini file or recompile PHP.
On Windows you don't ever have to compile PHP.
To connect Moodle 1.9 to SQL Server using FreeTDS you must select mssql_n as the $CFG->dbtype.
For Moodle 2 you use the Microsoft SQL Server Driver for PHP i.e. $CFG->dbtype = 'sqlsrv'
I was pretty sure I put the extension=php_dblib.dll in that file but after checking it's not there.
I did copy the file there though.
I found something new.
When I run PHP.exe I get an error "PHP Startup: Unable to load dynamic library 'C:\php\php_dblib.dll' - The specified module could not be found."
My PHP is installed under D:\Apps\PHP
Can I not have it there? It is policy to install apps to the D:\Apps folder.
Thanks for your help.
It looks like PHP isn't configured correctly. Open your php.ini file and check what path the extension_dir variable is pointing to. It should point to D:\Apps\PHP\ext.
And then make sure that the php_dblib.dll file is in the D:\Apps\PHP\ext folder and that freetds.conf has the right info about your database and database server.
Restart the web server and the error should be fixed and PHP should load FreeTDS. You can check if it does load by running PHPInfo(). If it shows a "mssql" section then FreeTDS is loaded and ready to connect to MSSQL.
I can't find the freetds.conf file.
Is that the file that gets generated when you go through the setup wizard when you first get to the site? That is where I am stuck. The wizard asks for the SQL server info and gives me the error when I click next.
No, you need to create it yourself. I don't think the installer does it for you. But I prefer to avoid the installer!
http://docs.moodle.org/en/Installing_MSSQL_for_PHP has more details about configuring FreeTDS.