HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Setup info for Sql Server + PHP 5


#1

The notes for setting up Helpspot on Windows using SQL Server need a few extra bits to be added for clarification, specifically with configuring PHP.

The modules for imap, graphs, and sql server need to be enabled in the php.ini file.

If you get the latest install of php, all the modules are installed by default (and don’t need to be downloaded as stated). However they do need to be uncommented (and apache restarted) for it to work. We had a problem connecting to sqlserver on the initial config page because

extension=php_mssql.dll

was commented out in php.ini. It was easily solved, but I think you should mention it on your install guide.

How our php.ini looks (part of it anyways)

; Directory in which the loadable extensions (modules) reside.
extension_dir = “c:\php\ext” !<or whereever, needs to be changed from default>!

;Windows Extensions

;Note that MySQL and ODBC support is now built in, so no dll is needed for it.

;
;extension=php_bz2.dll
;extension=php_cpdf.dll
;extension=php_crack.dll
;extension=php_curl.dll
;extension=php_db.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_dbx.dll
;extension=php_domxml.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_hyperwave.dll
;extension=php_iconv.dll
;extension=php_ifx.dll
;extension=php_iisfunc.dll
extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_java.dll
;extension=php_ldap.dll
;extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pdf.dll
;extension=php_pgsql.dll
;extension=php_printer.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
;extension=php_sybase_ct.dll
;extension=php_w32api.dll
;extension=php_xmlrpc.dll
;extension=php_xslt.dll
;extension=php_yaz.dll
;extension=php_zip.dll


#2

Thanks for posting this Tomas. I’ve updated the instructions, but this is good to have here in the forums where I can point folks to it.