mirror of
https://github.com/community-scripts/ProxmoxVE.git
synced 2026-02-04 20:33:24 +01:00
Compare commits
2 Commits
feat/sqlse
...
github-act
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
c0dccd6335 | ||
|
|
5f31954d91 |
@@ -429,6 +429,10 @@ Exercise vigilance regarding copycat or coat-tailing sites that seek to exploit
|
||||
|
||||
- fix(frontend): implement weighted search scoring for command menu [@ls-root](https://github.com/ls-root) ([#11534](https://github.com/community-scripts/ProxmoxVE/pull/11534))
|
||||
|
||||
### ❔ Uncategorized
|
||||
|
||||
- [FIX] Immich Public Proxy docs link [@vhsdream](https://github.com/vhsdream) ([#11543](https://github.com/community-scripts/ProxmoxVE/pull/11543))
|
||||
|
||||
## 2026-02-03
|
||||
|
||||
### 🆕 New Scripts
|
||||
|
||||
@@ -27,8 +27,7 @@ function update_script() {
|
||||
msg_error "No ${APP} Installation Found!"
|
||||
exit
|
||||
fi
|
||||
msg_info "Updating SQL Server 2022"
|
||||
rm -f /etc/profile.d/debuginfod.sh /etc/profile.d/debuginfod.csh
|
||||
msg_info "Updating ${APP} LXC"
|
||||
$STD apt update
|
||||
$STD apt -y upgrade
|
||||
msg_ok "Updated successfully!"
|
||||
|
||||
@@ -1,45 +0,0 @@
|
||||
#!/usr/bin/env bash
|
||||
source <(curl -fsSL https://raw.githubusercontent.com/community-scripts/ProxmoxVE/main/misc/build.func)
|
||||
# Copyright (c) 2021-2026 community-scripts ORG
|
||||
# Author: MickLesk (CanbiZ)
|
||||
# License: MIT | https://github.com/community-scripts/ProxmoxVE/raw/main/LICENSE
|
||||
# Source: https://www.microsoft.com/en-us/sql-server/sql-server-2025
|
||||
|
||||
APP="SQL Server 2025"
|
||||
var_tags="${var_tags:-sql;database}"
|
||||
var_cpu="${var_cpu:-2}"
|
||||
var_ram="${var_ram:-2048}"
|
||||
var_disk="${var_disk:-10}"
|
||||
var_os="${var_os:-ubuntu}"
|
||||
var_version="${var_version:-24.04}"
|
||||
var_unprivileged="${var_unprivileged:-0}"
|
||||
|
||||
header_info "$APP"
|
||||
variables
|
||||
color
|
||||
catch_errors
|
||||
|
||||
function update_script() {
|
||||
header_info
|
||||
check_container_storage
|
||||
check_container_resources
|
||||
if [[ ! -d /opt/mssql ]]; then
|
||||
msg_error "No ${APP} Installation Found!"
|
||||
exit
|
||||
fi
|
||||
msg_info "Updating SQL Server 2025"
|
||||
rm -f /etc/profile.d/debuginfod.sh /etc/profile.d/debuginfod.csh
|
||||
$STD apt update
|
||||
$STD apt -y upgrade
|
||||
msg_ok "Updated successfully!"
|
||||
exit
|
||||
}
|
||||
|
||||
start
|
||||
build_container
|
||||
description
|
||||
|
||||
msg_ok "Completed successfully!\n"
|
||||
echo -e "${CREATING}${GN}${APP} setup has been successfully initialized!${CL}"
|
||||
echo -e "${INFO}${YW} Access it using the following IP:${CL}"
|
||||
echo -e "${TAB}${GATEWAY}${BGN}${IP}:1433${CL}"
|
||||
@@ -9,7 +9,7 @@
|
||||
"updateable": true,
|
||||
"privileged": false,
|
||||
"interface_port": 3000,
|
||||
"documentation": "https://github.com/alangrainger/immich-public-proxy/docs",
|
||||
"documentation": "https://github.com/alangrainger/immich-public-proxy/tree/main/docs",
|
||||
"website": "https://github.com/alangrainger/immich-public-proxy",
|
||||
"logo": "https://cdn.jsdelivr.net/gh/selfhst/icons@main/webp/immich-public-proxy.webp",
|
||||
"config_path": "/opt/immich-proxy/app/.env",
|
||||
|
||||
@@ -1,52 +0,0 @@
|
||||
{
|
||||
"name": "SQL Server 2025",
|
||||
"slug": "sqlserver2025",
|
||||
"categories": [
|
||||
8
|
||||
],
|
||||
"date_created": "2026-02-04",
|
||||
"type": "ct",
|
||||
"updateable": true,
|
||||
"privileged": true,
|
||||
"interface_port": 1433,
|
||||
"documentation": "https://learn.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver17",
|
||||
"website": "https://www.microsoft.com/en-us/sql-server/sql-server-2025",
|
||||
"logo": "https://cdn.jsdelivr.net/gh/selfhst/icons@main/webp/microsoft-sql-server.webp",
|
||||
"config_path": "",
|
||||
"description": "Script to automatically set up a SQL Server 2025 installation with Ubuntu 24.04 support.",
|
||||
"install_methods": [
|
||||
{
|
||||
"type": "default",
|
||||
"script": "ct/sqlserver2025.sh",
|
||||
"resources": {
|
||||
"cpu": 2,
|
||||
"ram": 2048,
|
||||
"hdd": 10,
|
||||
"os": "Ubuntu",
|
||||
"version": "24.04"
|
||||
}
|
||||
}
|
||||
],
|
||||
"default_credentials": {
|
||||
"username": null,
|
||||
"password": null
|
||||
},
|
||||
"notes": [
|
||||
{
|
||||
"text": "If you choose not to run the installation setup, execute: `/opt/mssql/bin/mssql-conf setup` in LXC shell.",
|
||||
"type": "info"
|
||||
},
|
||||
{
|
||||
"text": "You can setup the admin account 'SA' during installation",
|
||||
"type": "info"
|
||||
},
|
||||
{
|
||||
"text": "Make sure you disable the SA account if you intend to use this in production!",
|
||||
"type": "warning"
|
||||
},
|
||||
{
|
||||
"text": "Ubuntu 24.04 support requires SQL Server 2025 CU1 or later",
|
||||
"type": "info"
|
||||
}
|
||||
]
|
||||
}
|
||||
@@ -14,32 +14,24 @@ network_check
|
||||
update_os
|
||||
|
||||
msg_info "Installing Dependencies"
|
||||
$STD apt install -y coreutils
|
||||
$STD apt install -y \
|
||||
coreutils
|
||||
msg_ok "Installed Dependencies"
|
||||
|
||||
msg_info "Setting up SQL Server 2022 Repository"
|
||||
setup_deb822_repo \
|
||||
"mssql-server-2022" \
|
||||
"https://packages.microsoft.com/keys/microsoft.asc" \
|
||||
"https://packages.microsoft.com/ubuntu/22.04/mssql-server-2022" \
|
||||
"./" \
|
||||
""
|
||||
msg_ok "Repository configured"
|
||||
|
||||
msg_info "Installing SQL Server 2022"
|
||||
$STD apt install -y mssql-server
|
||||
msg_ok "Installed SQL Server 2022"
|
||||
msg_info "Setup SQL Server 2022"
|
||||
curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | sudo tee /etc/apt/trusted.gpg.d/microsoft.asc >/dev/null
|
||||
curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/mssql-server-2022.list | tee /etc/apt/sources.list.d/mssql-server-2022.list >/dev/null
|
||||
$STD apt-get update -y
|
||||
$STD apt-get install -y mssql-server
|
||||
msg_ok "Setup Server 2022"
|
||||
|
||||
msg_info "Installing SQL Server Tools"
|
||||
export DEBIAN_FRONTEND=noninteractive
|
||||
export ACCEPT_EULA=Y
|
||||
setup_deb822_repo \
|
||||
"mssql-release" \
|
||||
"https://packages.microsoft.com/keys/microsoft.asc" \
|
||||
"https://packages.microsoft.com/ubuntu/22.04/prod" \
|
||||
"jammy" \
|
||||
"main"
|
||||
$STD apt-get install -y \
|
||||
curl -fsSL https://packages.microsoft.com/keys/microsoft.asc | tee /etc/apt/trusted.gpg.d/microsoft.asc >/dev/null
|
||||
curl -fsSL https://packages.microsoft.com/config/ubuntu/22.04/prod.list | tee /etc/apt/sources.list.d/mssql-release.list >/dev/null
|
||||
$STD apt-get update
|
||||
$STD apt-get install -y -qq \
|
||||
mssql-tools18 \
|
||||
unixodbc-dev
|
||||
echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >>~/.bash_profile
|
||||
@@ -57,11 +49,6 @@ msg_info "Start Service"
|
||||
systemctl enable -q --now mssql-server
|
||||
msg_ok "Service started"
|
||||
|
||||
msg_info "Cleaning up"
|
||||
rm -f /etc/profile.d/debuginfod.sh
|
||||
rm -f /etc/profile.d/debuginfod.csh
|
||||
msg_ok "Cleaned up"
|
||||
|
||||
motd_ssh
|
||||
customize
|
||||
cleanup_lxc
|
||||
|
||||
@@ -1,66 +0,0 @@
|
||||
#!/usr/bin/env bash
|
||||
|
||||
# Copyright (c) 2021-2026 community-scripts ORG
|
||||
# Author: MickLesk (CanbiZ)
|
||||
# License: MIT | https://github.com/community-scripts/ProxmoxVE/raw/main/LICENSE
|
||||
# Source: https://www.microsoft.com/en-us/sql-server/sql-server-2025
|
||||
|
||||
source /dev/stdin <<<"$FUNCTIONS_FILE_PATH"
|
||||
color
|
||||
verb_ip6
|
||||
catch_errors
|
||||
setting_up_container
|
||||
network_check
|
||||
update_os
|
||||
|
||||
msg_info "Installing Dependencies"
|
||||
$STD apt install -y coreutils
|
||||
msg_ok "Installed Dependencies"
|
||||
|
||||
msg_info "Setting up SQL Server 2025 Repository"
|
||||
setup_deb822_repo \
|
||||
"mssql-server-2025" \
|
||||
"https://packages.microsoft.com/keys/microsoft.asc" \
|
||||
"https://packages.microsoft.com/ubuntu/24.04/mssql-server-2025" \
|
||||
"./" \
|
||||
""
|
||||
msg_ok "Repository configured"
|
||||
|
||||
msg_info "Installing SQL Server 2025"
|
||||
$STD apt install -y mssql-server
|
||||
msg_ok "Installed SQL Server 2025"
|
||||
|
||||
msg_info "Installing SQL Server Tools"
|
||||
export DEBIAN_FRONTEND=noninteractive
|
||||
export ACCEPT_EULA=Y
|
||||
setup_deb822_repo \
|
||||
"mssql-release" \
|
||||
"https://packages.microsoft.com/keys/microsoft.asc" \
|
||||
"https://packages.microsoft.com/ubuntu/24.04/prod" \
|
||||
"noble" \
|
||||
"main"
|
||||
$STD apt-get install -y \
|
||||
mssql-tools18 \
|
||||
unixodbc-dev
|
||||
echo 'export PATH="$PATH:/opt/mssql-tools18/bin"' >>~/.bash_profile
|
||||
source ~/.bash_profile
|
||||
msg_ok "Installed SQL Server Tools"
|
||||
|
||||
read -r -p "${TAB3}Do you want to run the SQL Server setup now? (Later is also possible) <y/N>" prompt
|
||||
if [[ "${prompt,,}" =~ ^(y|yes)$ ]]; then
|
||||
/opt/mssql/bin/mssql-conf setup
|
||||
else
|
||||
msg_ok "Skipping SQL Server setup. You can run it later with '/opt/mssql/bin/mssql-conf setup'."
|
||||
fi
|
||||
|
||||
msg_info "Starting SQL Server Service"
|
||||
systemctl enable -q --now mssql-server
|
||||
msg_ok "Service started"
|
||||
|
||||
msg_info "Cleaning up"
|
||||
rm -f /etc/profile.d/debuginfod.sh /etc/profile.d/debuginfod.csh
|
||||
msg_ok "Cleaned up"
|
||||
|
||||
motd_ssh
|
||||
customize
|
||||
cleanup_lxc
|
||||
Reference in New Issue
Block a user