Actually command line admin tool can edit persistence.xml for you. But for sure you need to know all the parameters
On Thu, Aug 2, 2012 at 7:24 PM, Rubens Queiroz de Almeida < rubens.quei...@gmail.com> wrote: > I had this very same problem yesterday. In my case, what happened, is that > mysql was listening on another port, so I had to change the default mysql > port number (3306) for the number of the port actually used. You should > also check whether the user defined in the persistence.xml file is allowed > to create databases, should this be the case. > > The file persistence.xml is located at > $OPENMEETINGS_HOME/webapps/openmeetings/WEB-INF/classes/META-INF/ > The directory META-INF/ contains several files, you should select the > database you're using and do the following: > > mv persistence.xml persistence.xml.backup > cp mysql_persistence.xml persistence.xml > (if you're using mysql. Jaime said that it works much better with > postgresql) > Also, if you're using mysql you should download the jdbc driver from the > MySQL site, it does not come with the openmeetings file, due to licensing > issues. > > You should then edit the file persistence.xml and change the information > regarding the database and connections: > > , Username=openmeetings > , Password=xxxxxx"/> > > I hope this helps, > > Best regards, > > Rubens > > > > > On Thu, Aug 2, 2012 at 9:14 AM, Dimitri Yioulos <dyiou...@onpointfc.com>wrote: > >> Ran the below steps. The last step produced the following error: >> >> [ERROR] [main] org.openmeetings.cli.Admin - Install failed A connection >> could >> not be obtained for driver class "com.mysql.jdbc.Driver" and >> URL "jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true& >> useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8& >> connectionCollation=utf8_general_ci&cachePrepStmts=true& >> cacheCallableStatements=true&cacheServerConfiguration=true& >> >> useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false& >> >> enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000". >> You may have specified an invalid URL. >> >> What am I missing? >> >> Dimitri >> >> >> On Thursday 02 August 2012 7:49:41 am Dimitri Yioulos wrote: >> > Thanks, Maxim. I'll give that a try in a while. I owe you a beer or >> > three :-) . >> > >> > Dimitri >> > >> > On Thursday 02 August 2012 7:44:37 am Maxim Solodovnik wrote: >> > > 1) cd OM folder >> > > 2) stop OM >> > > 3) ./admin.sh -b -file backup.zip >> > > 4) ./admin.sh -i -file backup.zip --db-type mysql --db-user root >> > > --db-pass <pass> --drop >> > > >> > > please check the admin syntax by running ./admin.sh with no params >> > > >> > > On Thu, Aug 2, 2012 at 6:40 PM, Dimitri Yioulos >> <dyiou...@onpointfc.com>wrote: >> > > > All, >> > > > >> > > > I'm moving along very nicely with my OM 2.0 installation. But, I >> was >> > > > wondering >> > > > if I can do this: >> > > > >> > > > I initially set up OM to use the internal database. I'd like to >> move >> > > > to MySQL. >> > > > Can it be done now that OM is already installed and, if so, how (is >> > > > there a how-to, or some-such, available?)? >> > > > >> > > > As always, thanks. >> > > > >> > > > Dimitri >> > > > >> > > > -- >> > > > This message has been scanned for viruses and >> > > > dangerous content by MailScanner, and is >> > > > believed to be clean. >> > > >> > > -- >> > > WBR >> > > Maxim aka solomax >> >> >> >> -- >> This message has been scanned for viruses and >> dangerous content by MailScanner, and is >> believed to be clean. >> >> > -- WBR Maxim aka solomax
