After DLing the connector, I placed mysql-connector-java-5.1.21-bin.jar in /usr/local/openmeetings/webapps/openmeetings/WEB-INF/lib/, then ran "export CLASSPATH=/usr/local/openmeetings/webapps/openmeetings/WEB-INF/lib/mysql-connector-java-ver-bin.jar: $CLASSPATH", and then "./admin.sh -i -file backup.zip --db-host localhost --db-type mysql --db-name openmeetings --db-user root --db-pass 0np01ntf --drop". It still failed with the same error as I mentioned below.
I also tried copying the entire mysql-connector-java-5.1.21 directory to /usr/local/openmeetings/webapps/openmeetings/WEB-INF/lib/, re-exporting, running admin.sh, and still no joy. Dimitri On Thursday 02 August 2012 8:25:37 am Maxim Solodovnik wrote: > Maybe this step is missed? > > You need to download the JConnector from mysql > http://www.mysql.com/downloads/connector/j/ and place it into: > $red5/webapps/openmeetings/WEB-INF/lib/ > > On Thu, Aug 2, 2012 at 7:14 PM, 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=10 > >00". 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
