You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Lee Saunders <le...@gmail.com> on 2014/02/22 14:13:25 UTC
Are side-by-side installations possible?
Hello,
I am running OM 2.1.1, but would like to see how 2.2 compares.
If I unpack 2.2 into a new folder on my drive (windows desktop), will OM
create a new MySQL database or overwrite the existing one?
Thanks,
Lee.
Re: Are side-by-side installations possible?
Posted by Lee Saunders <le...@gmail.com>.
Thank you for trying, though. :)
On Sun, Mar 2, 2014 at 3:17 PM, Lee Saunders
<le...@gmail.com>wrote:
> Hello George,
>
> I just saw your reply. I've been battling with this.
> Maxim has been trying to help with an OM3 installation. All I'm getting
> after changing the persistence file and adding a new DB is an internal
> error.
>
>
> On Mon, Feb 24, 2014 at 12:19 AM, George Kirkham <gk...@co2crc.com.au>wrote:
>
>> Lee,
>>
>>
>>
>> Openmeetings will use the current database, which you need to DROP if you
>> are going to keep the same database name.
>>
>>
>>
>> If you want to have two installations so you can compare between them,
>> when you are installing the second instance you can easily change the name
>> of the "openmeetings database that you are creating and the name of the
>> database in the persistence.xml file. Of course you would have to install
>> openmeetings into folder by another name, this is not something that I have
>> ever bothered to do, but I believe would work.
>>
>>
>>
>> *Step 4 - Install MySQL and configure OpenMeetings database*
>>
>> apt-get install mysql-server
>>
>> mysql -u root -p
>>
>> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>>
>> GRANT ALL PRIVILEGES ON openmeetings. * TO 'openmeetings'@'localhost'
>> IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
>>
>>
>>
>> vi
>> /usr/lib/red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>>
>> Change the Username and Password to those you created in MySQL.
>>
>> *Note*: if you want OpenMeetings to use an external database or your
>> MySQL is listening to a network address and not 127.0.0.1, then you can
>> replace "localhost" with your MySQL Server's IP address.
>>
>> , Url=jdbc:mysql://localhost:3306/openmeetings?...
>>
>> , Username=*openmeetings*
>>
>> , Password=*yourpassword*"/>
>>
>>
>>
>> ============================================
>>
>> *Step 4 - Install MySQL and configure OpenMeetings database*
>>
>> apt-get install mysql-server
>>
>> mysql -u root -p
>>
>> CREATE DATABASE openmeetings2 DEFAULT CHARACTER SET 'utf8';
>>
>> GRANT ALL PRIVILEGES ON openmeetings2. * TO 'openmeetings'@'localhost'
>> IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
>>
>>
>>
>> vi /usr/lib/red5/webapps/openmeetings2
>> /WEB-INF/classes/META-INF/persistence.xml
>>
>> Change the Username and Password to those you created in MySQL.
>>
>> *Note*: if you want OpenMeetings to use an external database or your
>> MySQL is listening to a network address and not 127.0.0.1, then you can
>> replace "localhost" with your MySQL Server's IP address.
>>
>> , Url=jdbc:mysql://localhost:3306/openmeetings2?...
>>
>> , Username=*openmeetings*
>>
>> , Password=*yourpassword*"/>
>>
>>
>>
>> Thanks,
>>
>>
>>
>> George Kirkham
>>
>>
>>
>>
>>
>> *From:* Lee Saunders [mailto:leesenglishlessons@gmail.com]
>> *Sent:* Sunday, 23 February 2014 12:13 AM
>> *To:* user@openmeetings.apache.org
>> *Subject:* Are side-by-side installations possible?
>>
>>
>>
>> Hello,
>>
>>
>>
>> I am running OM 2.1.1, but would like to see how 2.2 compares.
>>
>> If I unpack 2.2 into a new folder on my drive (windows desktop), will OM
>> create a new MySQL database or overwrite the existing one?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Lee.
>>
>
>
Re: Are side-by-side installations possible?
Posted by Lee Saunders <le...@gmail.com>.
Hello George,
I just saw your reply. I've been battling with this.
Maxim has been trying to help with an OM3 installation. All I'm getting
after changing the persistence file and adding a new DB is an internal
error.
On Mon, Feb 24, 2014 at 12:19 AM, George Kirkham <gk...@co2crc.com.au>wrote:
> Lee,
>
>
>
> Openmeetings will use the current database, which you need to DROP if you
> are going to keep the same database name.
>
>
>
> If you want to have two installations so you can compare between them,
> when you are installing the second instance you can easily change the name
> of the "openmeetings database that you are creating and the name of the
> database in the persistence.xml file. Of course you would have to install
> openmeetings into folder by another name, this is not something that I have
> ever bothered to do, but I believe would work.
>
>
>
> *Step 4 - Install MySQL and configure OpenMeetings database*
>
> apt-get install mysql-server
>
> mysql -u root -p
>
> CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
>
> GRANT ALL PRIVILEGES ON openmeetings. * TO 'openmeetings'@'localhost'
> IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
>
>
>
> vi
> /usr/lib/red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.xml
>
> Change the Username and Password to those you created in MySQL.
>
> *Note*: if you want OpenMeetings to use an external database or your
> MySQL is listening to a network address and not 127.0.0.1, then you can
> replace "localhost" with your MySQL Server's IP address.
>
> , Url=jdbc:mysql://localhost:3306/openmeetings?...
>
> , Username=*openmeetings*
>
> , Password=*yourpassword*"/>
>
>
>
> ============================================
>
> *Step 4 - Install MySQL and configure OpenMeetings database*
>
> apt-get install mysql-server
>
> mysql -u root -p
>
> CREATE DATABASE openmeetings2 DEFAULT CHARACTER SET 'utf8';
>
> GRANT ALL PRIVILEGES ON openmeetings2. * TO 'openmeetings'@'localhost'
> IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
>
>
>
> vi /usr/lib/red5/webapps/openmeetings2
> /WEB-INF/classes/META-INF/persistence.xml
>
> Change the Username and Password to those you created in MySQL.
>
> *Note*: if you want OpenMeetings to use an external database or your
> MySQL is listening to a network address and not 127.0.0.1, then you can
> replace "localhost" with your MySQL Server's IP address.
>
> , Url=jdbc:mysql://localhost:3306/openmeetings2?...
>
> , Username=*openmeetings*
>
> , Password=*yourpassword*"/>
>
>
>
> Thanks,
>
>
>
> George Kirkham
>
>
>
>
>
> *From:* Lee Saunders [mailto:leesenglishlessons@gmail.com]
> *Sent:* Sunday, 23 February 2014 12:13 AM
> *To:* user@openmeetings.apache.org
> *Subject:* Are side-by-side installations possible?
>
>
>
> Hello,
>
>
>
> I am running OM 2.1.1, but would like to see how 2.2 compares.
>
> If I unpack 2.2 into a new folder on my drive (windows desktop), will OM
> create a new MySQL database or overwrite the existing one?
>
>
>
> Thanks,
>
>
>
> Lee.
>
RE: Are side-by-side installations possible?
Posted by George Kirkham <gk...@co2crc.com.au>.
Lee,
Openmeetings will use the current database, which you need to DROP if
you are going to keep the same database name.
If you want to have two installations so you can compare between them,
when you are installing the second instance you can easily change the
name of the "openmeetings database that you are creating and the name of
the database in the persistence.xml file. Of course you would have to
install openmeetings into folder by another name, this is not something
that I have ever bothered to do, but I believe would work.
Step 4 - Install MySQL and configure OpenMeetings database
apt-get install mysql-server
mysql -u root -p
CREATE DATABASE openmeetings DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings. * TO 'openmeetings'@'localhost'
IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
vi
/usr/lib/red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistence.
xml
Change the Username and Password to those you created in MySQL.
Note: if you want OpenMeetings to use an external database or your MySQL
is listening to a network address and not 127.0.0.1, then you can
replace "localhost" with your MySQL Server's IP address.
, Url=jdbc:mysql://localhost:3306/openmeetings?...
, Username=openmeetings
, Password=yourpassword"/>
============================================
Step 4 - Install MySQL and configure OpenMeetings database
apt-get install mysql-server
mysql -u root -p
CREATE DATABASE openmeetings2 DEFAULT CHARACTER SET 'utf8';
GRANT ALL PRIVILEGES ON openmeetings2. * TO 'openmeetings'@'localhost'
IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
vi
/usr/lib/red5/webapps/openmeetings2/WEB-INF/classes/META-INF/persistence
.xml
Change the Username and Password to those you created in MySQL.
Note: if you want OpenMeetings to use an external database or your MySQL
is listening to a network address and not 127.0.0.1, then you can
replace "localhost" with your MySQL Server's IP address.
, Url=jdbc:mysql://localhost:3306/openmeetings2?...
, Username=openmeetings
, Password=yourpassword"/>
Thanks,
George Kirkham
From: Lee Saunders [mailto:leesenglishlessons@gmail.com]
Sent: Sunday, 23 February 2014 12:13 AM
To: user@openmeetings.apache.org
Subject: Are side-by-side installations possible?
Hello,
I am running OM 2.1.1, but would like to see how 2.2 compares.
If I unpack 2.2 into a new folder on my drive (windows desktop), will OM
create a new MySQL database or overwrite the existing one?
Thanks,
Lee.
Re: Are side-by-side installations possible?
Posted by Maxim Solodovnik <so...@gmail.com>.
It's up to you. Just update persistence.XML file and set desired db name.
Also you need to change ports in red5.properties
On Feb 22, 2014 8:14 PM, "Lee Saunders" <le...@gmail.com>
wrote:
> Hello,
>
> I am running OM 2.1.1, but would like to see how 2.2 compares.
> If I unpack 2.2 into a new folder on my drive (windows desktop), will OM
> create a new MySQL database or overwrite the existing one?
>
> Thanks,
>
> Lee.
>