N/A

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

Specifically SQL Server from Microsoft

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

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

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

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

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

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!

hey @ethan - let me know if this template meets your needs

@Brody Thank you! I got it to deploy

Much appreciated

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

Like a volume?

I was just gonna ask that lol

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

Haha okay

but that's not what I meant

Well whatchya mean by the database part

Just like CREATE DATABASE _?

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

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

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

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

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

Sorry I meant delete and re-create the service

ah okay then you are good to go

Appreciate it!

happy to help

thanks for the train, much appreciated!!

<:salute:1137099685417451530>

@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.

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

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

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

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.

screenshot please

can you switch back to the v2 runtime and then download your logs with this -

are they still garbage when downloaded?

They still seem to be improperly formatted

1265364830777245768

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

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!

cloned the template?

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