질문 Q #22358
MAC CI MAMP DATABASE 연동관련 질문드립니다[MSSQL]
안단테 2020-04-23 14:33:03

이제막.. CI입문해서 배우고있는 상황인지라 .. 문제해결이 쉽지가 않네요 

MAMP 사용하고 MAC 환경에서 기존 CI프로젝트를 DB연동하려고하는데요 

sqlsrv라이브러리 같은 경우 정상적으로 설치되었고 extension도 잘 걸어놨습니다. 

근데 url로 접속해보면 

" A Database Error Occurred

Unable to connect to your database server using the provided settings.

Filename: core/Loader.php

Line Number: 346 "

해당오류가 뜨네요 ㅠ 아파치 에러로그는 

[Thu Apr 23 14:25:50.541585 2020] [mpm_prefork:notice] [pid 21431] AH00169: caught SIGTERM, shutting down[Thu Apr 23 14:25:54.733514 2020] [ssl:warn] [pid 22468] AH01882: Init: this version of mod_ssl was compiled against a newer library (OpenSSL 1.1.1e  17 Mar 2020, version currently loaded is OpenSSL 1.1.1d  10 Sep 2019) - may result in undefined or erroneous behavior[Thu Apr 23 14:25:54.734281 2020] [ssl:warn] [pid 22468] AH01909: localhost:8443:0 server certificate does NOT include an ID which matches the server name[Thu Apr 23 14:25:54.765799 2020] [ssl:warn] [pid 22469] AH01882: Init: this version of mod_ssl was compiled against a newer library (OpenSSL 1.1.1e  17 Mar 2020, version currently loaded is OpenSSL 1.1.1d  10 Sep 2019) - may result in undefined or erroneous behavior[Thu Apr 23 14:25:54.769436 2020] [ssl:warn] [pid 22469] AH01909: localhost:8443:0 server certificate does NOT include an ID which matches the server name[Thu Apr 23 14:25:54.803208 2020] [mpm_prefork:notice] [pid 22469] AH00163: Apache/2.4.41 (Unix) OpenSSL/1.1.1d PHP/7.3.16 configured -- resuming normal operations[Thu Apr 23 14:25:54.803254 2020] [core:notice] [pid 22469] AH00094: Command line: '/Applications/mampstack-7.3.16-2/apache2/bin/httpd.bin -f /Applications/mampstack-7.3.16-2/apache2/conf/httpd.conf'

openssl 관련 에러로그인거같은데 구글링해도 찾기가쉽지않아서요 ㅠ 도움부탁드립니다.

답변 2
#1 변종원(웅파) 2020-04-23 14:50:36

접속정보 부분을 올려주세요. (아이디, 비번 제거)

ci에서 말고 일반php 파일에서 mssql 접속프로그램 만들어서 테스트해보시구요.

#2 포포탄 2020-04-24 12:57:43

8443포트 사용하셔서 연결시도하신 흔적으로 보아서는 SSL보안연결을 통해 mssql에 연결하고자 하셨던 것 같은데요.

SSL인증서를 만들지 않으셨거나, 아파치에 SSL인증서를 연동해주지 않으신 것 같습니다.