Ubuntu 18.04에 MS SQL 서버를 설치하려고 합니다. 달릴 때까지 모든 게 괜찮았어
sudo /opt/mssql/bin/mssql-conf setup
먼저 내가 얻은 것 :
usermod: no changes
Choose an edition of SQL Server:
1) Evaluation (free, no production use rights, 180-day limit)
2) Developer (free, no production use rights)
3) Express (free)
4) Web (PAID)
5) Standard (PAID)
6) Enterprise (PAID)
7) Enterprise Core (PAID)
8) I bought a license through a retail sales channel and have a product key to enter.
Details about editions can be found at
https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409
Use of PAID editions of this software requires separate licensing through a
Microsoft Volume Licensing program.
By choosing a PAID edition, you are verifying that you have the appropriate
number of licenses in place to install and run this software.
Enter your edition(1-8): 2
The license terms for this product can be found in
/usr/share/doc/mssql-server or downloaded from:
https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409
The privacy statement can be viewed at:
https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409
Enter the SQL Server system administrator password:
나는 다음 메시지를 받은 후 2) 개발자, SA 비밀번호 설정(및 확인)을 선택했습니다.
Configuring SQL Server...
This is an evaluation version. There are [155] days left in the evaluation period.
This program has encountered a fatal error and cannot continue running at
Sun Mar 24 18:42:36 2019
The following diagnostic information is available:
Reason: 0x00000007
Message: Cannot open or read the persistent registry: \SystemRoot\security.hiv.
Process: 5172 - sqlservr
Thread: 5176 (application thread 0x4)
Instance Id: c5829295-47bb-4e81-9889-5a20fd444087
Crash Id: c2863467-bd75-467c-b954-3ae7f2474296
Build stamp: c086a7e8c128fab0a270cb245183bad3f01b6afc6e38b5bc449a12e8fedc1cd1
Distribution: Ubuntu 18.04.2 LTS
Processors: 4
Total Memory: 3296792576 bytes
Timestamp: Sun Mar 24 18:42:36 2019
Ubuntu 18.04.2 LTS
Capturing core dump and information to /var/opt/mssql/log...
Hint: You are currently not seeing messages from other users and the system.
Users in groups 'adm', 'systemd-journal' can see all messages.
Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
Hint: You are currently not seeing messages from other users and the system.
Users in groups 'adm', 'systemd-journal' can see all messages.
Pass -q to turn off this notice.
No journal files were opened due to insufficient permissions.
/usr/bin/tail: cannot open '/var/log/syslog' for reading: Permission denied
Attempting to capture a dump with paldumper
Captured a dump with paldumper
Core dump and information are being compressed in the background. When
complete, they can be found in the following location:
/var/opt/mssql/log/core.sqlservr.03_24_2019_18_42_37.5172.tbz2
Initial setup of Microsoft SQL Server failed. Please consult the ERRORLOG
in /var/opt/mssql/log for more information.
어디서 문제가 발생했는지 알 수 없습니다.
답변1
자세한 내용은 다음에서 확인하세요.
/var/opt/mssql/log
내 말은 다음과 같았습니다.
{
"reason": "0x00000007",
"processName": "sqlservr",
"pid": "5773",
"instanceId": "d7df749c-50e6-4f3b-b894-2aa7c743f33d",
"crashId": "281e772a-5946-4349-aa9e-671cd0a3772c",
"threadId": "5777",
"libosThreadId": "0x4",
"buildStamp": "70437f6583b8ef39b1ef70539ef84690980315dc7a4436c9c40015f28610e4aa",
"message": "Cannot open or read the persistent registry: \\SystemRoot\\lsa.hiv.",
"last_errno": "13",
"last_errno_text": "Permission denied",
"distribution": "Ubuntu 16.04.6 LTS",
"processors": "4",
"total_memory": "16732037120",
"timestamp": "Fri Apr 12 22:02:44 2019"
}
그래서 위치를 확인하여 위치를 확인했습니다 systemroot.
locate security.hiv
/var/opt/mssql/.system/system/security.hiv
어떤 권한을 적용해야 할지 몰라서 그냥 읽기, 쓰기 권한을 주었습니다 others.
그런 다음에도 마찬가지입니다.
lsa.hiv
licensing.hiv
재실행:
sudo /opt/mssql/bin/mssql-conf setup
그런 다음 SQL 서버가 시작되고 다른 사용자의 권한이 다시 사라집니다.
그런데 서비스 없이 SQL Server를 실행할 수 있으며 서비스가 실패하더라도 작동합니다.
/opt/mssql/bin/sqlservr