I am updating Connect on a server that does not have internet access. In this particular case Connect is using a Microsoft SQL server database instead of the MySQL database. I have two questions:
1 - the install/update seems to want to update MySQL. It is asking for a MySQL username and password and will not let me proceed without it. How do I get past this point?
2 - Are there database updates or changes that will have to be applied to the MS SQL server?
Thanks!
It sounds like, even though you’re using MS SQL, you’ve left mySQL installed as a dependency of Connect. You should remove mySQL, otherwise the upgrade is always going to try to update mySQL as well.
More about uninstalling mySQL and removing the dependency here: PlanetPress Connect 1.6.1 User Guide
Do I have to be concerned with any database changes?
Obviously always take backups before you make changes like this to a production environement. But if Connect isn’t using mySQL, there is no harm in removing it. You’re just freeing up system resources.
AHHH. I meant changes to the MS SQL database. Will any updates happen directly to it?
To my knowledge, the Connect installer doesn’t do anything to the database at install time other than to verify connectivity and to initialize the schema if it doesn’t already exist.
It certainly isn’t going to modify your MS SQL installation, if that’s what you’re getting at. You should ensure that your MS SQL instance is kept updated / patched on your own. Also be aware of the minimum requirements listed in the link above.
Thank You. I was not refering to the MS SQL installation in general. I was referring to the Connect specific tables. I did not know if the update from 1.5 to 1.7 would need to update/change/ add/delete any of the connect tables or structures.
Thanks again!
Your Connect data will be fine and remain untouched. No need to worry in that regard.