sqlsrv error on apache2 |
I've recently switch to CI4 and am also deploying to a apache2 server instead of IIS like I have in the past.
I have a simple boilerplate app that I converted to CI4 that connects to a database on my domain. Here is my config: Code: public array $default = [ All of this works on my local xampp webserver, the page loads and connects to the database. When moving this to my remote apache2 server, my page will load but an api call that gets data from the database fails. I am getting this error: Code: Class \"CodeIgniter\\Database\\sqlsrv\\Connection\" not found I have php 8.1 installed on this machine, as well as the relevant sqlsrv driver. Here is some data from my phpinfo() System Linux my-webserver 5.15.0-69-generic #76-Ubuntu SMP Fri Mar 17 17:19:29 UTC 2023 x86_64 Build Date Apr 14 2023 04:39:44 Build System Linux Server API Apache 2.0 Handler Virtual Directory Support disabled Configuration File (php.ini) Path /etc/php/8.1/apache2 Loaded Configuration File /etc/php/8.1/apache2/php.ini Scan this dir for additional .ini files /etc/php/8.1/apache2/conf.d Additional .ini files parsed /etc/php/8.1/apache2/conf.d/10-opcache.ini, /etc/php/8.1/apache2/conf.d/10-pdo.ini, /etc/php/8.1/apache2/conf.d/15-xml.ini, /etc/php/8.1/apache2/conf.d/20-calendar.ini, /etc/php/8.1/apache2/conf.d/20-ctype.ini, /etc/php/8.1/apache2/conf.d/20-curl.ini, /etc/php/8.1/apache2/conf.d/20-dom.ini, /etc/php/8.1/apache2/conf.d/20-exif.ini, /etc/php/8.1/apache2/conf.d/20-ffi.ini, /etc/php/8.1/apache2/conf.d/20-fileinfo.ini, /etc/php/8.1/apache2/conf.d/20-ftp.ini, /etc/php/8.1/apache2/conf.d/20-gd.ini, /etc/php/8.1/apache2/conf.d/20-gettext.ini, /etc/php/8.1/apache2/conf.d/20-iconv.ini, /etc/php/8.1/apache2/conf.d/20-intl.ini, /etc/php/8.1/apache2/conf.d/20-ldap.ini, /etc/php/8.1/apache2/conf.d/20-mbstring.ini, /etc/php/8.1/apache2/conf.d/20-pdo_sqlsrv.ini, /etc/php/8.1/apache2/conf.d/20-phar.ini, /etc/php/8.1/apache2/conf.d/20-posix.ini, /etc/php/8.1/apache2/conf.d/20-readline.ini, /etc/php/8.1/apache2/conf.d/20-shmop.ini, /etc/php/8.1/apache2/conf.d/20-simplexml.ini, /etc/php/8.1/apache2/conf.d/20-sockets.ini, /etc/php/8.1/apache2/conf.d/20-sqlsrv.ini, /etc/php/8.1/apache2/conf.d/20-sysvmsg.ini, /etc/php/8.1/apache2/conf.d/20-sysvsem.ini, /etc/php/8.1/apache2/conf.d/20-sysvshm.ini, /etc/php/8.1/apache2/conf.d/20-tokenizer.ini, /etc/php/8.1/apache2/conf.d/20-xmlreader.ini, /etc/php/8.1/apache2/conf.d/20-xmlwriter.ini, /etc/php/8.1/apache2/conf.d/20-xsl.ini, /etc/php/8.1/apache2/conf.d/30-pdo_sqlsrv.ini PHP API 20210902 PHP Extension 20210902 Zend Extension 420210902 Zend Extension Build API420210902,NTS PHP Extension Build API20210902,NTS Debug Build no Thread Safety disabled Zend Signal Handling enabled Zend Memory Manager enabled Zend Multibyte Support provided by mbstring Zend Max Execution Timers disabled IPv6 Support enabled DTrace Support available, disabled Registered PHP Streams https, ftps, compress.zlib, php, file, glob, data, http, ftp, sqlsrv, phar Registered Stream Socket Transports tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2, tlsv1.3 Registered Stream Filters zlib.*, string.rot13, string.toupper, string.tolower, convert.*, consumed, dechunk, convert.iconv.* --------------------------------------------------------------- pdo_sqlsrv pdo_sqlsrv support enabled ExtensionVer 5.11.0 Directive Local Value Master Value pdo_sqlsrv.client_buffer_max_kb_size 10240 10240 pdo_sqlsrv.log_severity 0 0 pdo_sqlsrv.report_additional_errors 1 1 pdo_sqlsrv.set_locale_info 2 2 --------------------------------------------------------------- Everything looks setup to me, but it's my first time. Is there something I'm missing?
Your database config DBDriver is invalid.
It should be SQLSRV, not sqlsrv. See https://codeigniter4.github.io/CodeIgnit...-databases |
Welcome Guest, Not a member yet? Register Sign In |