VoiceOfSoftware
VoiceOfSoftware
RRailway
Created by VoiceOfSoftware on 11/11/2023 in #✋|help
After migration to MySQL v2, want to restart MySQL service
Sweet, thanks!
8 replies
RRailway
Created by VoiceOfSoftware on 11/11/2023 in #✋|help
After migration to MySQL v2, want to restart MySQL service
N/A
8 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
OK, I think it worked that time. MySQL queries seem faster, too, although I don't recall reading that would be one of the benefits
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Anyway, as long as the right people get the message. I was just trying to not leave them hanging on read
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Oh that's weird. I figured we were in the middle of a conversation, but some time had passed, so I wanted to give a status update and make sure jr heard about it
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
That's almost literally what I tried to send before, but automod denied it
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
I'll try migrating again in a few minutes
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
@jr why is automod preventing me from writing simple replies?
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Yes, I manually set the variables. I have an hypothesis about what happened: 1. I migrated, but the old script broke things because it did not copy MySQL stored procedures (you helped me with this) 2. During first migration, my old "MySQL" plugin was renamed "MySQL Legacy", and a new v2 service was added named "MySQL" 3. My viariables used {{MySQL.MYSQLHOST}} macro expansion values 4. After you fixed the scripts, and had me try migration a 2nd time, I ended up with two services both named "MySQL Legacy" -- I'm guessing it renamed the v2 MySQL service to MySQL Legacy? 5. Perhaps the macro variables got confused at this point? They all looked like {{MySQL Legacy-SOME_BIG_GUID}} 6. I deleted the v2 MySQL service. Attempts to rollback failed 7. I renamed my old plugin back to "MySQL", but perhaps the variables got confused at this point? -- now all of my variables are empty 8. Now that I was back to a v1 plugin named "MySQL" I manually went into each variable and cleaned up the macro to look like {{MySQL.MYSQLHOST}} 9. I redeployed my app from my laptop, because at this point, even rollback to 24-hour-old prior functioning builds was failing. Variables seemed very unhappy at this point
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Rollback failed. Variables like MYSQLHOST are empty string now
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Thx, I'm going to get some sleep now, so I'll roll back, and reconnect @jr tomorrow
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Last time I migrated, the credentials were copied for me, and my deployed app was using them. As for TablePlus, I thought I copied the connection string from here https://railway.app/project/b855592c-9156-4020-9543-d41a4e939fde/service/5c25a5b4-ad96-491a-85d8-44f79fc1c618/variables These variables are quite different from my previous working credentials
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
I can't open the database using TablePlus from my local machine, and logs show this from within my deployed app: [0] Authentication failed against database server at roundhouse.proxy.rlwy.net, the provided database credentials for root are not valid. [0] [0] Please make sure to provide valid database credentials for the database server at roundhouse.proxy.rlwy.net.
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
@jr it seems like the MySQL credentials are wrong now
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Migrating now...
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Seems to be back up now
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
@jr hmm, my prod environment came back up, but dev crashed after rollback. I'm re-deploying with sleep 2 && to see if that helps
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
I'd rather migrate now, than wait until the last day in 2024
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
Thanks for being available on short notice...
56 replies
RRailway
Created by VoiceOfSoftware on 11/8/2023 in #✋|help
I see a message "Migrate your plugin to a V2 database", but don't know what that is
OK, phew, that was terrifying. Rolling back now...
56 replies