Does anyone know if there is a simple way to get two versions of Servoy running on the same machine. I am currently using port 80 and the primary http port and 1099 as the RMI. Would I be correct in thinking both of these need to be changed along with the Repository server address, Also as this is a headless install would this be best done by editing the properties file ?
Secondly I am thinking of using MySQL as a repository server as I am not sure how to configure a second version in PostgreSQL and also have very limited experience of PG. Can I confirm what database format MySQL should be set to MyISAM or INODB - I vaguely remember it should be INODB
Gordon:
Does anyone know if there is a simple way to get two versions of Servoy running on the same machine. I am currently using port 80 and the primary http port and 1099 as the RMI. Would I be correct in thinking both of these need to be changed along with the Repository server address, Also as this is a headless install would this be best done by editing the properties file ?
Yes you need to set both port numbers to one that is not in use yet on your system.
Gordon:
Secondly I am thinking of using MySQL as a repository server as I am not sure how to configure a second version in PostgreSQL and also have very limited experience of PG. Can I confirm what database format MySQL should be set to MyISAM or INODB - I vaguely remember it should be INODB
In PostgreSQL you simply create a new database (or a new schema in your existing repository database) using any DBA tool (psql, PgAdmin, Navicat, etc) and you point your connections to that.
As for MySQL, yes INNODB is needed for supporting database transactions. Apart from that it’s also the better choice if you value your data. INNODB is ACID compliant where MyISAM is not.
Having made the various changes and upgraded the repository, servoy is refusing to start. Having looked at the database the directly with Navicat it would appear that the ./servoy_server -upgraderep… has not run correctly i.e. there are no tables present. The configuration is correct in the properties file is this something that is actually triggered at the time of load or similar, I am not seeing why the upgrade would no configure this immediately ?