Railway•8mo ago

sqlserver on railway?

Any way to create a SQL server DB on railway?

Solution:

hey @ethan - let me know if this template meets your needs https://railway.app/template/wcAazg

Jump to solution

42 Replies

Percy•8mo ago

Project ID: N/A

ethanOP•8mo ago

N/A

Brody•8mo ago

I mean postgres is SQL, could you be more specific?

ethanOP•8mo ago

Specifically SQL Server from Microsoft

Brody•8mo ago

I think so, they have public images for their database right?

ethanOP•8mo ago

Yeah, I think so. But when I create a new service, I can specifically provision a PostgresSQL or MySQL. Wasn’t sure if there was a reason why SQL Server was missing

Brody•8mo ago

Railway only maintains those select few database templates, anything else would need to made by a community member, and with that said I will look into making a Microsoft SQL server template for you later today

ethanOP•8mo ago

Oh sweet thanks, I found the image but it’s on the Microsoft Artifact Registry which also isn’t supported I was attempting to create a new service from a docker image

ethanOP•8mo ago

https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver16&tabs=cli&pivots=cs1-bash

Docker: Install containers for SQL Server on Linux - SQL Server

This quickstart shows how to use Docker to run the SQL Server Linux container images. You connect to a database and run a query.

Brody•8mo ago

Yep indeed, that registry is not supported natively but there are work arounds, so sit tight and hopefully I'll have a template for you later in the day!

Solution

Brody•8mo ago

hey @ethan - let me know if this template meets your needs https://railway.app/template/wcAazg

ethanOP•8mo ago

@Brody Thank you! I got it to deploy Much appreciated

Brody•8mo ago

just keep it mind it doesn't come with a database like postgres does, so you will have to create one yourself.

ethanOP•8mo ago

Like a volume? I was just gonna ask that lol

Brody•8mo ago

lmao it doesn't come with a volume, I forgot that

ethanOP•8mo ago

Haha okay

Brody•8mo ago

but that's not what I meant

ethanOP•8mo ago

Well whatchya mean by the database part Just like CREATE DATABASE _?

Brody•8mo ago

yeah it doesn't create a default database for you, you have to do that yourself

ethanOP•8mo ago

Oh okay that’s fine I’ll look into the volume stuff tomorrow I was able to connect to the DB and it had some DBs already probably created my microsoft

Brody•8mo ago

yeah those are system databases you would want to mount a volume to /var/opt/mssql I had simply forgotten to do it in the template and will do that shortly

ethanOP•8mo ago

Oh okay, I’ll wait till you update the template then 😂 I didn’t get very far with any configuration

Brody•8mo ago

I have already updated the template, but that doesn't do anything for you, you need to mount the volume to your already deployed mssql server

ethanOP•8mo ago

Sorry I meant delete and re-create the service

Brody•8mo ago

ah okay then you are good to go

ethanOP•8mo ago

Appreciate it!

Brody•8mo ago

happy to help thanks for the train, much appreciated!!

ethanOP•8mo ago

:salute:

volcanicislander•5mo ago

@Brody thanks for making the SQL Server template! I just deployed it and wanted to report an issue: The logs seem to come out with an early newline like so:

2024-07-18 21:47:09.35 s

pid53      U

sing 'dbgh

elp.dll' versio

n '4.0.5'



2024-07-18 21:55:21.

71 spid53      

XE session 'tel

emetry_xev

ents' stoppin

g.


2024-07-18 21

:55:21.72 

spid53     

 XE sessio

n 'telemet

ry_xevents' s

tarted.

2024-07-18 21:47:09.35 s

pid53      U

sing 'dbgh

elp.dll' versio

n '4.0.5'



2024-07-18 21:55:21.

71 spid53      

XE session 'tel

emetry_xev

ents' stoppin

g.


2024-07-18 21

:55:21.72 

spid53     

 XE sessio

n 'telemet

ry_xevents' s

tarted.

Is this an error on my part? The logging seems to persist in this fashion even after restart.

Brody•5mo ago

that looks like garbage, does it improve if you switch back to the legacy runtime?

volcanicislander•5mo ago

It does improve when switched to Legacy runtime, interesting. Any ideas why and if I can fix the template to work with runtime v2?

Brody•5mo ago

just like to clarify that this is not an issue with the template. please show me what the logs look like on the legacy runtime.

volcanicislander•5mo ago

2024-07-23 17:25:54.24 spid45s     Recovery is complete. This is an informational message only. No user action is required.


2024-07-23 17:30:44.53 spid53      XE session 'telemetry_xevents' stopping.


2024-07-23 17:30:44.55 spid53      XE session 'telemetry_xevents' started.

2024-07-23 17:25:54.24 spid45s     Recovery is complete. This is an informational message only. No user action is required.


2024-07-23 17:30:44.53 spid53      XE session 'telemetry_xevents' stopping.


2024-07-23 17:30:44.55 spid53      XE session 'telemetry_xevents' started.

Brody•5mo ago

screenshot please

volcanicislander•5mo ago

Brody•5mo ago

can you switch back to the v2 runtime and then download your logs with this - https://bookmarklets.up.railway.app/log-downloader/ are they still garbage when downloaded?

volcanicislander•5mo ago

They still seem to be improperly formatted

deployment_logs_rms_...

Brody•5mo ago

very interesting okay, I'll see if I can come up with a minimal reproducible example @volcanicislander - i cant reporduce this, without a reproduction the team wont be able to fix this, and fwiw no one else has reported anything similar

volcanicislander•4mo ago

Thats interesting. I wonder what the issue is. I don't think I did anything out of the ordinary. I cloned the template and thats about it. In any case, thanks for looking into it. It isn't really a big deal right now. I do appreciate you creating the template very much!

Brody•4mo ago

cloned the template?

volcanicislander•4mo ago

selected the template when deploying a new service. sorry, might not be using the right terminology

Brody•4mo ago

ah gotcha

Gaming

Programming

sqlserver on railway?