Welcome Guest, Not a member yet? Register   Sign In
sqlsrv error on apache2
#1

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 = [
        'DSN'      => '',
        'hostname' => 'db-sql',
        'username' => 'myuser',
        'password' => 'mypassword',
        'database' => 'mydatabase',
        'DBDriver' => 'sqlsrv',
        'DBPrefix' => '',
        'pConnect' => false,
        'DBDebug'  => (ENVIRONMENT !== 'production'),
        'charset'  => 'latin1',
        'DBCollat' => 'latin1_general_ci_as',
        'swapPre'  => '',
        'encrypt'  => false,
        'compress' => false,
        'strictOn' => false,
        'failover' => [],
        'port'    => 1433,
    ];

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?
Reply


Messages In This Thread
sqlsrv error on apache2 - by SpeedOfRound - 04-19-2023, 10:29 AM
RE: sqlsrv error on apache2 - by kenjis - 04-24-2023, 09:20 PM



Theme © iAndrew 2016 - Forum software by © MyBB