Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
Ah. Once again, thank you very much for all your help! Dimitri On Thursday 02 August 2012 1:31:25 pm Maxim Solodovnik wrote: > to have more options in this list you need to configure LDAP and maybe > something else. > > On Fri, Aug 3, 2012 at 12:27 AM, Dimitri Yioulos wrote: > > "grep mysql pe

Re: MySQL back-end after-the-fact

2012-08-02 Thread Maxim Solodovnik
to have more options in this list you need to configure LDAP and maybe something else. On Fri, Aug 3, 2012 at 12:27 AM, Dimitri Yioulos wrote: > "grep mysql persistence.xml" returns info that MySQL is being used. > > I understand why one wouldn't want OM to be running when executing > admin.sh. >

Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
"grep mysql persistence.xml" returns info that MySQL is being used. I understand why one wouldn't want OM to be running when executing admin.sh. That said, I don't know if the fact that OM was running when I executed the script had anything to do with my success. Wish I knew, but the bottom li

Re: MySQL back-end after-the-fact

2012-08-02 Thread Maxim Solodovnik
OM should be shut down while running command line admin. You can grep mysql persistence.xml On Fri, Aug 3, 2012 at 12:08 AM, Dimitri Yioulos wrote: > Huh, this last go-round worked: > > mysql> show tables; > +-+ > | Tables_in_openmeetings | > +-+

Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
Huh, this last go-round worked: mysql> show tables; +-+ | Tables_in_openmeetings | +-+ | OPENJPA_SEQUENCE_TABLE | | adresses| | appointmentcategory | | appointmentremindertyps | | appointments| | conferencelog

Re: MySQL back-end after-the-fact

2012-08-02 Thread Maxim Solodovnik
OK lets check admin command then As I can understand you have standard mysql installation on local host and connect as root with password? so lets simplify things: ./admin.sh -v -i -file backup.zip --db-user "root" --db-type "mysql" --db-pass "your_password" --drop any useful stacktrace as a res

Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
Yes: mysql> show databases; ++ | Database | ++ | information_schema | | mysql | | openmeetings | | test | ++ 4 rows in set (0.00 sec) mysql> use openmeetings; Database changed I strictly follow

Re: MySQL back-end after-the-fact

2012-08-02 Thread Maxim Solodovnik
have you created DB table openmeetings in your MySQL DB? are you able to connect to mysql using command line? mysql -u -p openmeetings On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos wrote: > Thanks, Rubens. > > Ran netstat to confirm that MySQL is listening on port 3306. After moving > the >

Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
Thanks, Rubens. Ran netstat to confirm that MySQL is listening on port 3306. After moving the original persistence.xml to persistence.xml.orig, I then copied mysql_persistence.xml to persistence.xml (even though I think that Maxim said that admin.sh should create a usable persistence.xml). In

Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
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 ba

Re: MySQL back-end after-the-fact

2012-08-02 Thread Maxim Solodovnik
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

Re: MySQL back-end after-the-fact

2012-08-02 Thread Maxim Solodovnik
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 wrote: > Ran the below steps. The last step produced the following er

Re: MySQL back-end after-the-fact

2012-08-02 Thread Rubens Queiroz de Almeida
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

Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
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&createDat

Re: MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
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

Re: MySQL back-end after-the-fact

2012-08-02 Thread Maxim Solodovnik
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 --drop please check the admin syntax by running ./admin.sh with no params On Thu, Aug 2, 2012 at 6:40 PM, Dimitri Yioulos wrote: > All, > > I'm moving along v

MySQL back-end after-the-fact

2012-08-02 Thread Dimitri Yioulos
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?)