You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Dimitri Yioulos <dy...@onpointfc.com> on 2012/08/02 13:40:53 UTC
MySQL back-end after-the-fact
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.
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
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
<dy...@onpointfc.com>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.
> > 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 line is
> > that OM is working with MySQL.
> >
> > One last question: when I log into OM, the "Domain" is listed as local DB
> > [internal]. That's the only choice. Is that to be expected?
> >
> > Dimitri
> >
> > On Thursday 02 August 2012 1:14:42 pm Maxim Solodovnik wrote:
> > > 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
> >
> > <dy...@onpointfc.com>wrote:
> > > > Huh, this last go-round worked:
> > > >
> > > > mysql> show tables;
> > > > +-------------------------+
> > > >
> > > > | Tables_in_openmeetings |
> > > >
> > > > +-------------------------+
> > > >
> > > > | OPENJPA_SEQUENCE_TABLE |
> > > > | adresses |
> > > > | appointmentcategory |
> > > > | appointmentremindertyps |
> > > > | appointments |
> > > > | conferencelog |
> > > > | conferencelogtype |
> > > > | configuration |
> > > > | errortypes |
> > > > | errorvalues |
> > > > | extensions |
> > > > | fieldlanguage |
> > > > | fieldlanguagesvalues |
> > > > | fieldvalues |
> > > > | fileexploreritem |
> > > > | flvrecording |
> > > > | flvrecording_log |
> > > > | flvrecording_meta_delta |
> > > > | flvrecording_metadata |
> > > > | invitations |
> > > > | ldapconfig |
> > > > | meeting_members |
> > > > | meetme |
> > > > | naviglobal |
> > > > | navimain |
> > > > | om_timezone |
> > > > | open_xg_return_object |
> > > > | organisation |
> > > > | organisation_users |
> > > > | poll_types |
> > > > | private_messages |
> > > > | private_messages_folder |
> > > > | room_poll_answers |
> > > > | room_polls |
> > > > | rooms |
> > > > | rooms_moderator |
> > > > | rooms_organisation |
> > > > | roomtypes |
> > > > | salutations |
> > > > | sessiondata |
> > > > | sipusers |
> > > > | soaplogin |
> > > > | states |
> > > > | user_contacts |
> > > > | user_sip_data |
> > > > | userdata |
> > > > | userlevel |
> > > > | users |
> > > >
> > > > +-------------------------+
> > > > 48 rows in set (0.00 sec)
> > > >
> > > > The only difference in what I did this time was that OM was running
> > > > (restarting
> > > > OM after db backup wasn't in the how-to). I checked
> > > > persistence.xml's timestamp and, sure enough, it was set at
> > > > approximately the time I ran admin.sh, so I'm assuming proper changes
> > > > were made to it by admin.sh.
> >
> > I
> >
> > > > then
> > > > restarted OM. How do I verify that MySQL is being used as the
> >
> > back-end?
> >
> > > > Dimitri
> > > >
> > > > On Thursday 02 August 2012 12:51:49 pm Maxim Solodovnik wrote:
> > > > > 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 result?
> > > > >
> > > > > On Thu, Aug 2, 2012 at 11:12 PM, Dimitri Yioulos
> > > >
> > > > <dy...@onpointfc.com>wrote:
> > > > > > Yes:
> > > > > >
> > > > > > mysql> show databases;
> > > > > > +--------------------+
> > > > > >
> > > > > > | Database |
> > > > > >
> > > > > > +--------------------+
> > > > > >
> > > > > > | information_schema |
> > > > > > | mysql |
> > > > > > | openmeetings |
> > > > > > | test |
> > > > > >
> > > > > > +--------------------+
> > > > > > 4 rows in set (0.00 sec)
> > > > > >
> > > > > > mysql> use openmeetings;
> > > > > > Database changed
> > > > > >
> > > > > > I strictly followed your how-to. But, must I have OM running
> >
> > before
> >
> > > > > > I issue the
> > > > > > admin.sh command?
> > > > > >
> > > > > > Dimitri
> > > > > >
> > > > > > On Thursday 02 August 2012 12:03:38 pm Maxim Solodovnik wrote:
> > > > > > > have you created DB table openmeetings in your MySQL DB?
> > > > > > > are you able to connect to mysql using command line?
> > > > > > >
> > > > > > > mysql -u <user> -p openmeetings
> > > > > > >
> > > > > > > On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <
> > > >
> > > > dyioulos@onpointfc.com
> > > >
> > > > > > >wrote:
> > > > > > > > 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).
> > > > > > > > Interestingly, when I
> > > > > > > > look at persistence.xml, the MySQL username and password were
> > > > > > > > correct. Despite
> > > > > > > > all that, I still get:
> > > > > > > >
> > > > > > > > [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=t
> >
> > > > > > > >rue& createDatabaseIfNotExist=true&characterEncoding=utf-8&
> >
> > connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStat
> >
> > > > > > > >ements=true&
> >
> > cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommi
> >
> > > > > > > >ts=true&
> >
> > alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=
> >
> > > > > > > >3000&prepStmtCacheSqlLimit=1000". You may have specified an
> > > > > > > > invalid URL.
> > > > > > > >
> > > > > > > > Hmmm.
> > > > > > > >
> > > > > > > > Dimitri
> > > > > > > >
> > > > > > > > On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de
> > > > > > > > Almeida
> > > >
> > > > 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 <
> > > > > >
> > > > > > dyioulos@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=tru
> > > > > > > > > >e&
> >
> > 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
> > > > > > > > > >
> > > > > > > > > > <dy...@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.
> > > > > > > >
> > > > > > > > --
> > > > > > > > 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.
> > >
> > > --
> > > 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.
Re: MySQL back-end after-the-fact
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <dy...@onpointfc.com>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.
> 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
> line is
> that OM is working with MySQL.
>
> One last question: when I log into OM, the "Domain" is listed as local DB
> [internal]. That's the only choice. Is that to be expected?
>
> Dimitri
>
>
> On Thursday 02 August 2012 1:14:42 pm Maxim Solodovnik wrote:
> > 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
> <dy...@onpointfc.com>wrote:
> > > Huh, this last go-round worked:
> > >
> > > mysql> show tables;
> > > +-------------------------+
> > >
> > > | Tables_in_openmeetings |
> > >
> > > +-------------------------+
> > >
> > > | OPENJPA_SEQUENCE_TABLE |
> > > | adresses |
> > > | appointmentcategory |
> > > | appointmentremindertyps |
> > > | appointments |
> > > | conferencelog |
> > > | conferencelogtype |
> > > | configuration |
> > > | errortypes |
> > > | errorvalues |
> > > | extensions |
> > > | fieldlanguage |
> > > | fieldlanguagesvalues |
> > > | fieldvalues |
> > > | fileexploreritem |
> > > | flvrecording |
> > > | flvrecording_log |
> > > | flvrecording_meta_delta |
> > > | flvrecording_metadata |
> > > | invitations |
> > > | ldapconfig |
> > > | meeting_members |
> > > | meetme |
> > > | naviglobal |
> > > | navimain |
> > > | om_timezone |
> > > | open_xg_return_object |
> > > | organisation |
> > > | organisation_users |
> > > | poll_types |
> > > | private_messages |
> > > | private_messages_folder |
> > > | room_poll_answers |
> > > | room_polls |
> > > | rooms |
> > > | rooms_moderator |
> > > | rooms_organisation |
> > > | roomtypes |
> > > | salutations |
> > > | sessiondata |
> > > | sipusers |
> > > | soaplogin |
> > > | states |
> > > | user_contacts |
> > > | user_sip_data |
> > > | userdata |
> > > | userlevel |
> > > | users |
> > >
> > > +-------------------------+
> > > 48 rows in set (0.00 sec)
> > >
> > > The only difference in what I did this time was that OM was running
> > > (restarting
> > > OM after db backup wasn't in the how-to). I checked persistence.xml's
> > > timestamp and, sure enough, it was set at approximately the time I ran
> > > admin.sh, so I'm assuming proper changes were made to it by admin.sh.
> I
> > > then
> > > restarted OM. How do I verify that MySQL is being used as the
> back-end?
> > >
> > > Dimitri
> > >
> > > On Thursday 02 August 2012 12:51:49 pm Maxim Solodovnik wrote:
> > > > 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 result?
> > > >
> > > > On Thu, Aug 2, 2012 at 11:12 PM, Dimitri Yioulos
> > >
> > > <dy...@onpointfc.com>wrote:
> > > > > Yes:
> > > > >
> > > > > mysql> show databases;
> > > > > +--------------------+
> > > > >
> > > > > | Database |
> > > > >
> > > > > +--------------------+
> > > > >
> > > > > | information_schema |
> > > > > | mysql |
> > > > > | openmeetings |
> > > > > | test |
> > > > >
> > > > > +--------------------+
> > > > > 4 rows in set (0.00 sec)
> > > > >
> > > > > mysql> use openmeetings;
> > > > > Database changed
> > > > >
> > > > > I strictly followed your how-to. But, must I have OM running
> before
> > > > > I issue the
> > > > > admin.sh command?
> > > > >
> > > > > Dimitri
> > > > >
> > > > > On Thursday 02 August 2012 12:03:38 pm Maxim Solodovnik wrote:
> > > > > > have you created DB table openmeetings in your MySQL DB?
> > > > > > are you able to connect to mysql using command line?
> > > > > >
> > > > > > mysql -u <user> -p openmeetings
> > > > > >
> > > > > > On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <
> > >
> > > dyioulos@onpointfc.com
> > >
> > > > > >wrote:
> > > > > > > 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).
> > > > > > > Interestingly, when I
> > > > > > > look at persistence.xml, the MySQL username and password were
> > > > > > > correct. Despite
> > > > > > > all that, I still get:
> > > > > > >
> > > > > > > [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=t
> > >
> > > > > > >rue& createDatabaseIfNotExist=true&characterEncoding=utf-8&
> > >
> > >
> connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStat
> > >
> > > > > > >ements=true&
> > >
> > >
> cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommi
> > >
> > > > > > >ts=true&
> > >
> > >
> alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=
> > >
> > > > > > >3000&prepStmtCacheSqlLimit=1000". You may have specified an
> > > > > > > invalid URL.
> > > > > > >
> > > > > > > Hmmm.
> > > > > > >
> > > > > > > Dimitri
> > > > > > >
> > > > > > > On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida
> > >
> > > 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 <
> > > > >
> > > > > dyioulos@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
> > > > > > > > >
> > > > > > > > > <dy...@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.
> > > > > > >
> > > > > > > --
> > > > > > > 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.
> >
> > --
> > 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
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
"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 line is
that OM is working with MySQL.
One last question: when I log into OM, the "Domain" is listed as local DB
[internal]. That's the only choice. Is that to be expected?
Dimitri
On Thursday 02 August 2012 1:14:42 pm Maxim Solodovnik wrote:
> 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
<dy...@onpointfc.com>wrote:
> > Huh, this last go-round worked:
> >
> > mysql> show tables;
> > +-------------------------+
> >
> > | Tables_in_openmeetings |
> >
> > +-------------------------+
> >
> > | OPENJPA_SEQUENCE_TABLE |
> > | adresses |
> > | appointmentcategory |
> > | appointmentremindertyps |
> > | appointments |
> > | conferencelog |
> > | conferencelogtype |
> > | configuration |
> > | errortypes |
> > | errorvalues |
> > | extensions |
> > | fieldlanguage |
> > | fieldlanguagesvalues |
> > | fieldvalues |
> > | fileexploreritem |
> > | flvrecording |
> > | flvrecording_log |
> > | flvrecording_meta_delta |
> > | flvrecording_metadata |
> > | invitations |
> > | ldapconfig |
> > | meeting_members |
> > | meetme |
> > | naviglobal |
> > | navimain |
> > | om_timezone |
> > | open_xg_return_object |
> > | organisation |
> > | organisation_users |
> > | poll_types |
> > | private_messages |
> > | private_messages_folder |
> > | room_poll_answers |
> > | room_polls |
> > | rooms |
> > | rooms_moderator |
> > | rooms_organisation |
> > | roomtypes |
> > | salutations |
> > | sessiondata |
> > | sipusers |
> > | soaplogin |
> > | states |
> > | user_contacts |
> > | user_sip_data |
> > | userdata |
> > | userlevel |
> > | users |
> >
> > +-------------------------+
> > 48 rows in set (0.00 sec)
> >
> > The only difference in what I did this time was that OM was running
> > (restarting
> > OM after db backup wasn't in the how-to). I checked persistence.xml's
> > timestamp and, sure enough, it was set at approximately the time I ran
> > admin.sh, so I'm assuming proper changes were made to it by admin.sh. I
> > then
> > restarted OM. How do I verify that MySQL is being used as the back-end?
> >
> > Dimitri
> >
> > On Thursday 02 August 2012 12:51:49 pm Maxim Solodovnik wrote:
> > > 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 result?
> > >
> > > On Thu, Aug 2, 2012 at 11:12 PM, Dimitri Yioulos
> >
> > <dy...@onpointfc.com>wrote:
> > > > Yes:
> > > >
> > > > mysql> show databases;
> > > > +--------------------+
> > > >
> > > > | Database |
> > > >
> > > > +--------------------+
> > > >
> > > > | information_schema |
> > > > | mysql |
> > > > | openmeetings |
> > > > | test |
> > > >
> > > > +--------------------+
> > > > 4 rows in set (0.00 sec)
> > > >
> > > > mysql> use openmeetings;
> > > > Database changed
> > > >
> > > > I strictly followed your how-to. But, must I have OM running before
> > > > I issue the
> > > > admin.sh command?
> > > >
> > > > Dimitri
> > > >
> > > > On Thursday 02 August 2012 12:03:38 pm Maxim Solodovnik wrote:
> > > > > have you created DB table openmeetings in your MySQL DB?
> > > > > are you able to connect to mysql using command line?
> > > > >
> > > > > mysql -u <user> -p openmeetings
> > > > >
> > > > > On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <
> >
> > dyioulos@onpointfc.com
> >
> > > > >wrote:
> > > > > > 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).
> > > > > > Interestingly, when I
> > > > > > look at persistence.xml, the MySQL username and password were
> > > > > > correct. Despite
> > > > > > all that, I still get:
> > > > > >
> > > > > > [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=t
> >
> > > > > >rue& createDatabaseIfNotExist=true&characterEncoding=utf-8&
> >
> > connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStat
> >
> > > > > >ements=true&
> >
> > cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommi
> >
> > > > > >ts=true&
> >
> > alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=
> >
> > > > > >3000&prepStmtCacheSqlLimit=1000". You may have specified an
> > > > > > invalid URL.
> > > > > >
> > > > > > Hmmm.
> > > > > >
> > > > > > Dimitri
> > > > > >
> > > > > > On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida
> >
> > 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 <
> > > >
> > > > dyioulos@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
> > > > > > > >
> > > > > > > > <dy...@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.
> > > > > >
> > > > > > --
> > > > > > 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.
>
> --
> WBR
> Maxim aka solomax
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: MySQL back-end after-the-fact
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <dy...@onpointfc.com>wrote:
> Huh, this last go-round worked:
>
> mysql> show tables;
> +-------------------------+
> | Tables_in_openmeetings |
> +-------------------------+
> | OPENJPA_SEQUENCE_TABLE |
> | adresses |
> | appointmentcategory |
> | appointmentremindertyps |
> | appointments |
> | conferencelog |
> | conferencelogtype |
> | configuration |
> | errortypes |
> | errorvalues |
> | extensions |
> | fieldlanguage |
> | fieldlanguagesvalues |
> | fieldvalues |
> | fileexploreritem |
> | flvrecording |
> | flvrecording_log |
> | flvrecording_meta_delta |
> | flvrecording_metadata |
> | invitations |
> | ldapconfig |
> | meeting_members |
> | meetme |
> | naviglobal |
> | navimain |
> | om_timezone |
> | open_xg_return_object |
> | organisation |
> | organisation_users |
> | poll_types |
> | private_messages |
> | private_messages_folder |
> | room_poll_answers |
> | room_polls |
> | rooms |
> | rooms_moderator |
> | rooms_organisation |
> | roomtypes |
> | salutations |
> | sessiondata |
> | sipusers |
> | soaplogin |
> | states |
> | user_contacts |
> | user_sip_data |
> | userdata |
> | userlevel |
> | users |
> +-------------------------+
> 48 rows in set (0.00 sec)
>
> The only difference in what I did this time was that OM was running
> (restarting
> OM after db backup wasn't in the how-to). I checked persistence.xml's
> timestamp and, sure enough, it was set at approximately the time I ran
> admin.sh, so I'm assuming proper changes were made to it by admin.sh. I
> then
> restarted OM. How do I verify that MySQL is being used as the back-end?
>
> Dimitri
>
>
> On Thursday 02 August 2012 12:51:49 pm Maxim Solodovnik wrote:
> > 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 result?
> >
> > On Thu, Aug 2, 2012 at 11:12 PM, Dimitri Yioulos
> <dy...@onpointfc.com>wrote:
> > > Yes:
> > >
> > > mysql> show databases;
> > > +--------------------+
> > >
> > > | Database |
> > >
> > > +--------------------+
> > >
> > > | information_schema |
> > > | mysql |
> > > | openmeetings |
> > > | test |
> > >
> > > +--------------------+
> > > 4 rows in set (0.00 sec)
> > >
> > > mysql> use openmeetings;
> > > Database changed
> > >
> > > I strictly followed your how-to. But, must I have OM running before I
> > > issue the
> > > admin.sh command?
> > >
> > > Dimitri
> > >
> > > On Thursday 02 August 2012 12:03:38 pm Maxim Solodovnik wrote:
> > > > have you created DB table openmeetings in your MySQL DB?
> > > > are you able to connect to mysql using command line?
> > > >
> > > > mysql -u <user> -p openmeetings
> > > >
> > > > On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <
> dyioulos@onpointfc.com
> > > >
> > > >wrote:
> > > > > 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).
> > > > > Interestingly, when I
> > > > > look at persistence.xml, the MySQL username and password were
> > > > > correct. Despite
> > > > > all that, I still get:
> > > > >
> > > > > [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=t
> > >
> > > > >rue& createDatabaseIfNotExist=true&characterEncoding=utf-8&
> > >
> > >
> connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStat
> > >
> > > > >ements=true&
> > >
> > >
> cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommi
> > >
> > > > >ts=true&
> > >
> > >
> alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=
> > >
> > > > >3000&prepStmtCacheSqlLimit=1000". You may have specified an invalid
> > > > > URL.
> > > > >
> > > > > Hmmm.
> > > > >
> > > > > Dimitri
> > > > >
> > > > > On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida
> 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 <
> > >
> > > dyioulos@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
> > > > > > >
> > > > > > > <dy...@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.
> > > > >
> > > > > --
> > > > > 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.
>
>
--
WBR
Maxim aka solomax
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
Huh, this last go-round worked:
mysql> show tables;
+-------------------------+
| Tables_in_openmeetings |
+-------------------------+
| OPENJPA_SEQUENCE_TABLE |
| adresses |
| appointmentcategory |
| appointmentremindertyps |
| appointments |
| conferencelog |
| conferencelogtype |
| configuration |
| errortypes |
| errorvalues |
| extensions |
| fieldlanguage |
| fieldlanguagesvalues |
| fieldvalues |
| fileexploreritem |
| flvrecording |
| flvrecording_log |
| flvrecording_meta_delta |
| flvrecording_metadata |
| invitations |
| ldapconfig |
| meeting_members |
| meetme |
| naviglobal |
| navimain |
| om_timezone |
| open_xg_return_object |
| organisation |
| organisation_users |
| poll_types |
| private_messages |
| private_messages_folder |
| room_poll_answers |
| room_polls |
| rooms |
| rooms_moderator |
| rooms_organisation |
| roomtypes |
| salutations |
| sessiondata |
| sipusers |
| soaplogin |
| states |
| user_contacts |
| user_sip_data |
| userdata |
| userlevel |
| users |
+-------------------------+
48 rows in set (0.00 sec)
The only difference in what I did this time was that OM was running (restarting
OM after db backup wasn't in the how-to). I checked persistence.xml's
timestamp and, sure enough, it was set at approximately the time I ran
admin.sh, so I'm assuming proper changes were made to it by admin.sh. I then
restarted OM. How do I verify that MySQL is being used as the back-end?
Dimitri
On Thursday 02 August 2012 12:51:49 pm Maxim Solodovnik wrote:
> 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 result?
>
> On Thu, Aug 2, 2012 at 11:12 PM, Dimitri Yioulos
<dy...@onpointfc.com>wrote:
> > Yes:
> >
> > mysql> show databases;
> > +--------------------+
> >
> > | Database |
> >
> > +--------------------+
> >
> > | information_schema |
> > | mysql |
> > | openmeetings |
> > | test |
> >
> > +--------------------+
> > 4 rows in set (0.00 sec)
> >
> > mysql> use openmeetings;
> > Database changed
> >
> > I strictly followed your how-to. But, must I have OM running before I
> > issue the
> > admin.sh command?
> >
> > Dimitri
> >
> > On Thursday 02 August 2012 12:03:38 pm Maxim Solodovnik wrote:
> > > have you created DB table openmeetings in your MySQL DB?
> > > are you able to connect to mysql using command line?
> > >
> > > mysql -u <user> -p openmeetings
> > >
> > > On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <dyioulos@onpointfc.com
> > >
> > >wrote:
> > > > 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).
> > > > Interestingly, when I
> > > > look at persistence.xml, the MySQL username and password were
> > > > correct. Despite
> > > > all that, I still get:
> > > >
> > > > [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=t
> >
> > > >rue& createDatabaseIfNotExist=true&characterEncoding=utf-8&
> >
> > connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStat
> >
> > > >ements=true&
> >
> > cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommi
> >
> > > >ts=true&
> >
> > alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=
> >
> > > >3000&prepStmtCacheSqlLimit=1000". You may have specified an invalid
> > > > URL.
> > > >
> > > > Hmmm.
> > > >
> > > > Dimitri
> > > >
> > > > On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida 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 <
> >
> > dyioulos@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
> > > > > >
> > > > > > <dy...@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.
> > > >
> > > > --
> > > > 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.
Re: MySQL back-end after-the-fact
Posted by Maxim Solodovnik <so...@gmail.com>.
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 result?
On Thu, Aug 2, 2012 at 11:12 PM, Dimitri Yioulos <dy...@onpointfc.com>wrote:
> Yes:
>
> mysql> show databases;
> +--------------------+
> | Database |
> +--------------------+
> | information_schema |
> | mysql |
> | openmeetings |
> | test |
> +--------------------+
> 4 rows in set (0.00 sec)
>
> mysql> use openmeetings;
> Database changed
>
> I strictly followed your how-to. But, must I have OM running before I
> issue the
> admin.sh command?
>
> Dimitri
>
>
> On Thursday 02 August 2012 12:03:38 pm Maxim Solodovnik wrote:
> > have you created DB table openmeetings in your MySQL DB?
> > are you able to connect to mysql using command line?
> >
> > mysql -u <user> -p openmeetings
> >
> > On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <dyioulos@onpointfc.com
> >wrote:
> > > 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). Interestingly,
> > > when I
> > > look at persistence.xml, the MySQL username and password were correct.
> > > Despite
> > > all that, I still get:
> > >
> > > [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=t
> > >rue& createDatabaseIfNotExist=true&characterEncoding=utf-8&
> > >
> > >
> connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStat
> > >ements=true&
> > >
> > >
> cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommi
> > >ts=true&
> > >
> > >
> alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=
> > >3000&prepStmtCacheSqlLimit=1000". You may have specified an invalid URL.
> > >
> > > Hmmm.
> > >
> > > Dimitri
> > >
> > > On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida 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 <
> dyioulos@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
> > > > >
> > > > > <dy...@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.
> > >
> > > --
> > > 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
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
Yes:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| openmeetings |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use openmeetings;
Database changed
I strictly followed your how-to. But, must I have OM running before I issue the
admin.sh command?
Dimitri
On Thursday 02 August 2012 12:03:38 pm Maxim Solodovnik wrote:
> have you created DB table openmeetings in your MySQL DB?
> are you able to connect to mysql using command line?
>
> mysql -u <user> -p openmeetings
>
> On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <dy...@onpointfc.com>wrote:
> > 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). Interestingly,
> > when I
> > look at persistence.xml, the MySQL username and password were correct.
> > Despite
> > all that, I still get:
> >
> > [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=t
> >rue& createDatabaseIfNotExist=true&characterEncoding=utf-8&
> >
> > connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStat
> >ements=true&
> >
> > cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommi
> >ts=true&
> >
> > alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=
> >3000&prepStmtCacheSqlLimit=1000". You may have specified an invalid URL.
> >
> > Hmmm.
> >
> > Dimitri
> >
> > On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida 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 <dyioulos@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
> > > >
> > > > <dy...@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.
> >
> > --
> > 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.
Re: MySQL back-end after-the-fact
Posted by Maxim Solodovnik <so...@gmail.com>.
have you created DB table openmeetings in your MySQL DB?
are you able to connect to mysql using command line?
mysql -u <user> -p openmeetings
On Thu, Aug 2, 2012 at 8:24 PM, Dimitri Yioulos <dy...@onpointfc.com>wrote:
> 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). Interestingly,
> when I
> look at persistence.xml, the MySQL username and password were correct.
> Despite
> all that, I still get:
>
> [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.
>
> Hmmm.
>
> Dimitri
>
>
> On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida 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 <dyioulos@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
> > >
> > > <dy...@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.
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
--
WBR
Maxim aka solomax
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
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). Interestingly, when I
look at persistence.xml, the MySQL username and password were correct. Despite
all that, I still get:
[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.
Hmmm.
Dimitri
On Thursday 02 August 2012 8:24:24 am Rubens Queiroz de Almeida 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 <dy...@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
> >
> > <dy...@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.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Re: MySQL back-end after-the-fact
Posted by Maxim Solodovnik <so...@gmail.com>.
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.queiroz@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 <dy...@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
>> <dy...@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
Re: MySQL back-end after-the-fact
Posted by Rubens Queiroz de Almeida <ru...@gmail.com>.
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 <dy...@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
> <dy...@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.
>
>
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
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 <dy...@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
> >
> > <dy...@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.
Re: MySQL back-end after-the-fact
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <dy...@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
> <dy...@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
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
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
<dy...@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.
Re: MySQL back-end after-the-fact
Posted by Dimitri Yioulos <dy...@onpointfc.com>.
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 <dy...@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.
Re: MySQL back-end after-the-fact
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <dy...@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