You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Michael Wuttke <mw...@beuth-hochschule.de> on 2014/05/02 12:50:57 UTC
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are
missing
Hello Maxim,
ok, I checked the databases (the database before the upgrade und the
database after the upgrade) and the red5 folders (version 2.1.1 and
3.0.1). In both databases are same entries of users, of rooms and of
files (items in the fileexploreritem table). In both red5 folders are
the same number of files (in the upload folder). In the OM installation
I have more than 500 users, more then 200 rooms- all created & managed
via moodle - and more than 750 files uploaded into the
rooms/witheboards. Ok, all the users, rooms and files still exists afte
the upgrade. But the OM rooms are not linked to the right moodle om
activities. They are not in the right order. What can I do. How can I
fix the issue?
Thank you for help or any advice,
Michael
Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
> According to the process only deleted files might be removed ....
> can you check if these files are still in the DB? (fileexploreritem
> table, you can check by filehash and/of filename)
>
> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
> <mw...@beuth-hochschule.de> wrote:
>
>> Hello,
>>
>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>> the
>> CLI. I used the "Detailed steps" how to for that upgrade.
>> http://openmeetings.apache.org/Upgrade.html [1]
>>
>> After the upgrade some uploaded files are not available any longer
>> in
>> the rooms or at the witheboards. In the log files there were no
>> error
>> messages.
>>
>> Has anybody an idea how I can find the missing files? I made a
>> backup of
>> the old database and the red5 folder with all the data and the
>> logs.
>>
>> Greetings,
>> Michael
>
> --
> WBR
> Maxim aka solomax
>
> Links:
> ------
> [1] http://openmeetings.apache.org/Upgrade.html
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Maxim Solodovnik <so...@gmail.com>.
This is already fixed in 3.x
On May 5, 2014 1:22 AM, "Michael Wuttke" <mw...@beuth-hochschule.de>
wrote:
> Hello Maxim,
>
> ok, I will try it.
>
> To open an issue in JIRA for that is not necessary, or?
>
> Thank you,
> Michael
>
> Am 04.05.14 18:32, schrieb Maxim Solodovnik:
> > yes sure
> >
> >
> > On Sun, May 4, 2014 at 11:16 PM, Michael Wuttke <
> mwuttke@beuth-hochschule.de
> >> wrote:
> >
> >> Hello Maxim,
> >>
> >> and after adding ORDER BY, I have to recompile the code?
> >>
> >> Thanks,
> >> Michael
> >>
> >> Am 04.05.14 17:18, schrieb Maxim Solodovnik:
> >>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
> >>>
> >>>
> >>
> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
> >>>
> >>> To this line:
> >>>
> >>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
> >>> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
> >>>
> >>> This might help only partially :( due to deleted rooms will be skipped
> >>> and ids might change
> >>>
> >>>
> >>>
> >>> On Sun, May 4, 2014 at 7:30 PM, Michael Wuttke
> >>> <mw...@beuth-hochschule.de>wrote:
> >>>
> >>>> Hello Maxim,
> >>>>
> >>>> sorry but I don't know how to transform the rooms.xml from the
> >>>> backup.zip to have sorted room ID's. I played arround with libreoffice
> >>>> headless, a xml filter for libreoffice and with xsltproc but could not
> >>>> find a solution.
> >>>>
> >>>> Please could you help me? Or can you give me a hint how to export the
> OM
> >>>> database into the xml files with sorted ID's?
> >>>>
> >>>> Thank you,
> >>>> Michael
> >>>>
> >>>> Am 03.05.14 12:33, schrieb Maxim Solodovnik:
> >>>>> Unfortunately the only option for you is to re-order rooms in xml
> file
> >>>>> (manually or using xsl transformation)
> >>>>> Rooms should be ordered by ID
> >>>>>
> >>>>>
> >>>>> On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke
> >>>>> <mw...@beuth-hochschule.de>wrote:
> >>>>>
> >>>>>> Hello Maxim,
> >>>>>>
> >>>>>> we are backp on OM version 2.1.1 now!
> >>>>>>
> >>>>>> This was the procedure of my upgrade test:
> >>>>>>
> >>>>>> 1. I stoped Openmeetings
> >>>>>> 2. I backuped the red5 folder of the OM 2.1.1 installation
> >>>>>> 3. I made a DB backup for the mysql database of OM
> >>>>>> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
> >>>>>> ../backup_today.zip
> >>>>>> 5. I moved the folder of the OM 2.1.1 installation
> >>>>>> 6. I unziped the 3.0.1 version of OM into the same folder (red5)
> >>>>>> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
> >>>>>> ../backup_today.zip --drop --skip-default-rooms
> >>>>>> 8. I started Openmeetings again
> >>>>>>
> >>>>>> Sorry, but I don't know exactly what do you suggest. How can I
> >> influence
> >>>>>> the export of the OM DB to make sure that the ID's of the rooms are
> in
> >>>>>> the right order after the import? There are no difference between
> the
> >>>>>> admin.sh scripts, logback-config.xml and logback.xsd files of the OM
> >>>>>> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4.
> 2014).
> >>>>>> Or where do I have to look for?
> >>>>>>
> >>>>>> Thank you for help or advice,
> >>>>>> Michael
> >>>>>>
> >>>>>> Am 03.05.14 05:41, schrieb Maxim Solodovnik:
> >>>>>>> you can try to "install from backup" from command line admin
> >>>>>>> in this case no additional users/rooms are creted, so IDs should be
> >> the
> >>>>>>> same.
> >>>>>>>
> >>>>>>> I guess it is export issue (and should be fixed in latest OM, I
> have
> >>>>>> added
> >>>>>>> ORDER BY if I'm not mistaken)
> >>>>>>>
> >>>>>>>
> >>>>>>> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <
> >>>>>> mwuttke@beuth-hochschule.de
> >>>>>>>> wrote:
> >>>>>>>
> >>>>>>>> and how did you solve that problem? ;-)
> >>>>>>>>
> >>>>>>>> Greetings,
> >>>>>>>> Michael
> >>>>>>>>
> >>>>>>>> Am 02.05.14 13:49, schrieb Peter Dähn:
> >>>>>>>>> well.. I just was remembered at my experience...
> >>>>>>>>>
> >>>>>>>>> BR Peter
> >>>>>>>>>
> >>>>>>>>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
> >>>>>>>>>> Hello Peter,
> >>>>>>>>>>
> >>>>>>>>>> sorry, but in this case I am using mysql for both: moodle and
> >>>>>>>>>> openmeetings.
> >>>>>>>>>>
> >>>>>>>>>> But thank you for your quick reply.
> >>>>>>>>>> Michael
> >>>>>>>>>>
> >>>>>>>>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
> >>>>>>>>>>> Hello together,
> >>>>>>>>>>>
> >>>>>>>>>>> could be the problem witht the postgres export...
> >>>>>>>>>>>
> >>>>>>>>>>> What kind o database do you use?
> >>>>>>>>>>>
> >>>>>>>>>>> BR Peter
> >>>>>>>>>>>
> >>>>>>>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
> >>>>>>>>>>>
> >>>>>>>>>>>> Hello Maxim,
> >>>>>>>>>>>>
> >>>>>>>>>>>> ok, I checked the databases (the database before the upgrade
> und
> >>>>>>>>>>>> the database after the upgrade) and the red5 folders (version
> >>>> 2.1.1
> >>>>>>>>>>>> and 3.0.1). In both databases are same entries of users, of
> >> rooms
> >>>>>>>>>>>> and of files (items in the fileexploreritem table). In both
> red5
> >>>>>>>>>>>> folders are the same number of files (in the upload folder).
> In
> >>>> the
> >>>>>>>>>>>> OM installation I have more than 500 users, more then 200
> rooms-
> >>>> all
> >>>>>>>>>>>> created & managed via moodle - and more than 750 files
> uploaded
> >>>> into
> >>>>>>>>>>>> the rooms/witheboards. Ok, all the users, rooms and files
> still
> >>>>>>>>>>>> exists afte the upgrade. But the OM rooms are not linked to
> the
> >>>>>>>>>>>> right moodle om activities. They are not in the right order.
> >> What
> >>>>>>>>>>>> can I do. How can I fix the issue?
> >>>>>>>>>>>>
> >>>>>>>>>>>> Thank you for help or any advice,
> >>>>>>>>>>>> Michael
> >>>>>>>>>>>>
> >>>>>>>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
> >>>>>>>>>>>> According to the process only deleted files might be removed
> >> ....
> >>>>>>>>>>>> can you check if these files are still in the DB?
> >>>> (fileexploreritem
> >>>>>>>>>>>>
> >>>>>>>>>>>> table, you can check by filehash and/of filename)
> >>>>>>>>>>>>
> >>>>>>>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
> >>>>>>>>>>>> <mw...@beuth-hochschule.de> wrote:
> >>>>>>>>>>>>
> >>>>>>>>>>>> Hello,
> >>>>>>>>>>>>
> >>>>>>>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1
> >> via
> >>>>>>>>>>>> the
> >>>>>>>>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
> >>>>>>>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
> >>>>>>>>>>>>
> >>>>>>>>>>>> After the upgrade some uploaded files are not available any
> >> longer
> >>>>>>>>>>>> in
> >>>>>>>>>>>> the rooms or at the witheboards. In the log files there were
> no
> >>>>>>>>>>>> error
> >>>>>>>>>>>> messages.
> >>>>>>>>>>>>
> >>>>>>>>>>>> Has anybody an idea how I can find the missing files? I made a
> >>>>>>>>>>>> backup of
> >>>>>>>>>>>> the old database and the red5 folder with all the data and the
> >>>>>>>>>>>> logs.
> >>>>>>>>>>>>
> >>>>>>>>>>>> Greetings,
> >>>>>>>>>>>> Michael
> >>
> >
> >
> >
>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Maxim,
ok, I will try it.
To open an issue in JIRA for that is not necessary, or?
Thank you,
Michael
Am 04.05.14 18:32, schrieb Maxim Solodovnik:
> yes sure
>
>
> On Sun, May 4, 2014 at 11:16 PM, Michael Wuttke <mwuttke@beuth-hochschule.de
>> wrote:
>
>> Hello Maxim,
>>
>> and after adding ORDER BY, I have to recompile the code?
>>
>> Thanks,
>> Michael
>>
>> Am 04.05.14 17:18, schrieb Maxim Solodovnik:
>>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>>>
>>>
>> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
>>>
>>> To this line:
>>>
>>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
>>> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>>>
>>> This might help only partially :( due to deleted rooms will be skipped
>>> and ids might change
>>>
>>>
>>>
>>> On Sun, May 4, 2014 at 7:30 PM, Michael Wuttke
>>> <mw...@beuth-hochschule.de>wrote:
>>>
>>>> Hello Maxim,
>>>>
>>>> sorry but I don't know how to transform the rooms.xml from the
>>>> backup.zip to have sorted room ID's. I played arround with libreoffice
>>>> headless, a xml filter for libreoffice and with xsltproc but could not
>>>> find a solution.
>>>>
>>>> Please could you help me? Or can you give me a hint how to export the OM
>>>> database into the xml files with sorted ID's?
>>>>
>>>> Thank you,
>>>> Michael
>>>>
>>>> Am 03.05.14 12:33, schrieb Maxim Solodovnik:
>>>>> Unfortunately the only option for you is to re-order rooms in xml file
>>>>> (manually or using xsl transformation)
>>>>> Rooms should be ordered by ID
>>>>>
>>>>>
>>>>> On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke
>>>>> <mw...@beuth-hochschule.de>wrote:
>>>>>
>>>>>> Hello Maxim,
>>>>>>
>>>>>> we are backp on OM version 2.1.1 now!
>>>>>>
>>>>>> This was the procedure of my upgrade test:
>>>>>>
>>>>>> 1. I stoped Openmeetings
>>>>>> 2. I backuped the red5 folder of the OM 2.1.1 installation
>>>>>> 3. I made a DB backup for the mysql database of OM
>>>>>> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
>>>>>> ../backup_today.zip
>>>>>> 5. I moved the folder of the OM 2.1.1 installation
>>>>>> 6. I unziped the 3.0.1 version of OM into the same folder (red5)
>>>>>> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
>>>>>> ../backup_today.zip --drop --skip-default-rooms
>>>>>> 8. I started Openmeetings again
>>>>>>
>>>>>> Sorry, but I don't know exactly what do you suggest. How can I
>> influence
>>>>>> the export of the OM DB to make sure that the ID's of the rooms are in
>>>>>> the right order after the import? There are no difference between the
>>>>>> admin.sh scripts, logback-config.xml and logback.xsd files of the OM
>>>>>> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014).
>>>>>> Or where do I have to look for?
>>>>>>
>>>>>> Thank you for help or advice,
>>>>>> Michael
>>>>>>
>>>>>> Am 03.05.14 05:41, schrieb Maxim Solodovnik:
>>>>>>> you can try to "install from backup" from command line admin
>>>>>>> in this case no additional users/rooms are creted, so IDs should be
>> the
>>>>>>> same.
>>>>>>>
>>>>>>> I guess it is export issue (and should be fixed in latest OM, I have
>>>>>> added
>>>>>>> ORDER BY if I'm not mistaken)
>>>>>>>
>>>>>>>
>>>>>>> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <
>>>>>> mwuttke@beuth-hochschule.de
>>>>>>>> wrote:
>>>>>>>
>>>>>>>> and how did you solve that problem? ;-)
>>>>>>>>
>>>>>>>> Greetings,
>>>>>>>> Michael
>>>>>>>>
>>>>>>>> Am 02.05.14 13:49, schrieb Peter Dähn:
>>>>>>>>> well.. I just was remembered at my experience...
>>>>>>>>>
>>>>>>>>> BR Peter
>>>>>>>>>
>>>>>>>>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
>>>>>>>>>> Hello Peter,
>>>>>>>>>>
>>>>>>>>>> sorry, but in this case I am using mysql for both: moodle and
>>>>>>>>>> openmeetings.
>>>>>>>>>>
>>>>>>>>>> But thank you for your quick reply.
>>>>>>>>>> Michael
>>>>>>>>>>
>>>>>>>>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
>>>>>>>>>>> Hello together,
>>>>>>>>>>>
>>>>>>>>>>> could be the problem witht the postgres export...
>>>>>>>>>>>
>>>>>>>>>>> What kind o database do you use?
>>>>>>>>>>>
>>>>>>>>>>> BR Peter
>>>>>>>>>>>
>>>>>>>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>>>>>>>>>>>
>>>>>>>>>>>> Hello Maxim,
>>>>>>>>>>>>
>>>>>>>>>>>> ok, I checked the databases (the database before the upgrade und
>>>>>>>>>>>> the database after the upgrade) and the red5 folders (version
>>>> 2.1.1
>>>>>>>>>>>> and 3.0.1). In both databases are same entries of users, of
>> rooms
>>>>>>>>>>>> and of files (items in the fileexploreritem table). In both red5
>>>>>>>>>>>> folders are the same number of files (in the upload folder). In
>>>> the
>>>>>>>>>>>> OM installation I have more than 500 users, more then 200 rooms-
>>>> all
>>>>>>>>>>>> created & managed via moodle - and more than 750 files uploaded
>>>> into
>>>>>>>>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
>>>>>>>>>>>> exists afte the upgrade. But the OM rooms are not linked to the
>>>>>>>>>>>> right moodle om activities. They are not in the right order.
>> What
>>>>>>>>>>>> can I do. How can I fix the issue?
>>>>>>>>>>>>
>>>>>>>>>>>> Thank you for help or any advice,
>>>>>>>>>>>> Michael
>>>>>>>>>>>>
>>>>>>>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>>>>>>>>>>>> According to the process only deleted files might be removed
>> ....
>>>>>>>>>>>> can you check if these files are still in the DB?
>>>> (fileexploreritem
>>>>>>>>>>>>
>>>>>>>>>>>> table, you can check by filehash and/of filename)
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>>>>>>>>>>>> <mw...@beuth-hochschule.de> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>> Hello,
>>>>>>>>>>>>
>>>>>>>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1
>> via
>>>>>>>>>>>> the
>>>>>>>>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
>>>>>>>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>>>>>>>>>>>
>>>>>>>>>>>> After the upgrade some uploaded files are not available any
>> longer
>>>>>>>>>>>> in
>>>>>>>>>>>> the rooms or at the witheboards. In the log files there were no
>>>>>>>>>>>> error
>>>>>>>>>>>> messages.
>>>>>>>>>>>>
>>>>>>>>>>>> Has anybody an idea how I can find the missing files? I made a
>>>>>>>>>>>> backup of
>>>>>>>>>>>> the old database and the red5 folder with all the data and the
>>>>>>>>>>>> logs.
>>>>>>>>>>>>
>>>>>>>>>>>> Greetings,
>>>>>>>>>>>> Michael
>>
>
>
>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Maxim Solodovnik <so...@gmail.com>.
yes sure
On Sun, May 4, 2014 at 11:16 PM, Michael Wuttke <mwuttke@beuth-hochschule.de
> wrote:
> Hello Maxim,
>
> and after adding ORDER BY, I have to recompile the code?
>
> Thanks,
> Michael
>
> Am 04.05.14 17:18, schrieb Maxim Solodovnik:
> > The easiest way is to correct 2.1.1 sources and add ORDER BY:
> >
> >
> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
> >
> > To this line:
> >
> > @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
> > LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
> >
> > This might help only partially :( due to deleted rooms will be skipped
> > and ids might change
> >
> >
> >
> > On Sun, May 4, 2014 at 7:30 PM, Michael Wuttke
> > <mw...@beuth-hochschule.de>wrote:
> >
> >> Hello Maxim,
> >>
> >> sorry but I don't know how to transform the rooms.xml from the
> >> backup.zip to have sorted room ID's. I played arround with libreoffice
> >> headless, a xml filter for libreoffice and with xsltproc but could not
> >> find a solution.
> >>
> >> Please could you help me? Or can you give me a hint how to export the OM
> >> database into the xml files with sorted ID's?
> >>
> >> Thank you,
> >> Michael
> >>
> >> Am 03.05.14 12:33, schrieb Maxim Solodovnik:
> >>> Unfortunately the only option for you is to re-order rooms in xml file
> >>> (manually or using xsl transformation)
> >>> Rooms should be ordered by ID
> >>>
> >>>
> >>> On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke
> >>> <mw...@beuth-hochschule.de>wrote:
> >>>
> >>>> Hello Maxim,
> >>>>
> >>>> we are backp on OM version 2.1.1 now!
> >>>>
> >>>> This was the procedure of my upgrade test:
> >>>>
> >>>> 1. I stoped Openmeetings
> >>>> 2. I backuped the red5 folder of the OM 2.1.1 installation
> >>>> 3. I made a DB backup for the mysql database of OM
> >>>> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
> >>>> ../backup_today.zip
> >>>> 5. I moved the folder of the OM 2.1.1 installation
> >>>> 6. I unziped the 3.0.1 version of OM into the same folder (red5)
> >>>> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
> >>>> ../backup_today.zip --drop --skip-default-rooms
> >>>> 8. I started Openmeetings again
> >>>>
> >>>> Sorry, but I don't know exactly what do you suggest. How can I
> influence
> >>>> the export of the OM DB to make sure that the ID's of the rooms are in
> >>>> the right order after the import? There are no difference between the
> >>>> admin.sh scripts, logback-config.xml and logback.xsd files of the OM
> >>>> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014).
> >>>> Or where do I have to look for?
> >>>>
> >>>> Thank you for help or advice,
> >>>> Michael
> >>>>
> >>>> Am 03.05.14 05:41, schrieb Maxim Solodovnik:
> >>>>> you can try to "install from backup" from command line admin
> >>>>> in this case no additional users/rooms are creted, so IDs should be
> the
> >>>>> same.
> >>>>>
> >>>>> I guess it is export issue (and should be fixed in latest OM, I have
> >>>> added
> >>>>> ORDER BY if I'm not mistaken)
> >>>>>
> >>>>>
> >>>>> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <
> >>>> mwuttke@beuth-hochschule.de
> >>>>>> wrote:
> >>>>>
> >>>>>> and how did you solve that problem? ;-)
> >>>>>>
> >>>>>> Greetings,
> >>>>>> Michael
> >>>>>>
> >>>>>> Am 02.05.14 13:49, schrieb Peter Dähn:
> >>>>>>> well.. I just was remembered at my experience...
> >>>>>>>
> >>>>>>> BR Peter
> >>>>>>>
> >>>>>>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
> >>>>>>>> Hello Peter,
> >>>>>>>>
> >>>>>>>> sorry, but in this case I am using mysql for both: moodle and
> >>>>>>>> openmeetings.
> >>>>>>>>
> >>>>>>>> But thank you for your quick reply.
> >>>>>>>> Michael
> >>>>>>>>
> >>>>>>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
> >>>>>>>>> Hello together,
> >>>>>>>>>
> >>>>>>>>> could be the problem witht the postgres export...
> >>>>>>>>>
> >>>>>>>>> What kind o database do you use?
> >>>>>>>>>
> >>>>>>>>> BR Peter
> >>>>>>>>>
> >>>>>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
> >>>>>>>>>
> >>>>>>>>>> Hello Maxim,
> >>>>>>>>>>
> >>>>>>>>>> ok, I checked the databases (the database before the upgrade und
> >>>>>>>>>> the database after the upgrade) and the red5 folders (version
> >> 2.1.1
> >>>>>>>>>> and 3.0.1). In both databases are same entries of users, of
> rooms
> >>>>>>>>>> and of files (items in the fileexploreritem table). In both red5
> >>>>>>>>>> folders are the same number of files (in the upload folder). In
> >> the
> >>>>>>>>>> OM installation I have more than 500 users, more then 200 rooms-
> >> all
> >>>>>>>>>> created & managed via moodle - and more than 750 files uploaded
> >> into
> >>>>>>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
> >>>>>>>>>> exists afte the upgrade. But the OM rooms are not linked to the
> >>>>>>>>>> right moodle om activities. They are not in the right order.
> What
> >>>>>>>>>> can I do. How can I fix the issue?
> >>>>>>>>>>
> >>>>>>>>>> Thank you for help or any advice,
> >>>>>>>>>> Michael
> >>>>>>>>>>
> >>>>>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
> >>>>>>>>>> According to the process only deleted files might be removed
> ....
> >>>>>>>>>> can you check if these files are still in the DB?
> >> (fileexploreritem
> >>>>>>>>>>
> >>>>>>>>>> table, you can check by filehash and/of filename)
> >>>>>>>>>>
> >>>>>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
> >>>>>>>>>> <mw...@beuth-hochschule.de> wrote:
> >>>>>>>>>>
> >>>>>>>>>> Hello,
> >>>>>>>>>>
> >>>>>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1
> via
> >>>>>>>>>> the
> >>>>>>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
> >>>>>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
> >>>>>>>>>>
> >>>>>>>>>> After the upgrade some uploaded files are not available any
> longer
> >>>>>>>>>> in
> >>>>>>>>>> the rooms or at the witheboards. In the log files there were no
> >>>>>>>>>> error
> >>>>>>>>>> messages.
> >>>>>>>>>>
> >>>>>>>>>> Has anybody an idea how I can find the missing files? I made a
> >>>>>>>>>> backup of
> >>>>>>>>>> the old database and the red5 folder with all the data and the
> >>>>>>>>>> logs.
> >>>>>>>>>>
> >>>>>>>>>> Greetings,
> >>>>>>>>>> Michael
>
--
WBR
Maxim aka solomax
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Maxim,
and after adding ORDER BY, I have to recompile the code?
Thanks,
Michael
Am 04.05.14 17:18, schrieb Maxim Solodovnik:
> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>
> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
>
> To this line:
>
> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>
> This might help only partially :( due to deleted rooms will be skipped
> and ids might change
>
>
>
> On Sun, May 4, 2014 at 7:30 PM, Michael Wuttke
> <mw...@beuth-hochschule.de>wrote:
>
>> Hello Maxim,
>>
>> sorry but I don't know how to transform the rooms.xml from the
>> backup.zip to have sorted room ID's. I played arround with libreoffice
>> headless, a xml filter for libreoffice and with xsltproc but could not
>> find a solution.
>>
>> Please could you help me? Or can you give me a hint how to export the OM
>> database into the xml files with sorted ID's?
>>
>> Thank you,
>> Michael
>>
>> Am 03.05.14 12:33, schrieb Maxim Solodovnik:
>>> Unfortunately the only option for you is to re-order rooms in xml file
>>> (manually or using xsl transformation)
>>> Rooms should be ordered by ID
>>>
>>>
>>> On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke
>>> <mw...@beuth-hochschule.de>wrote:
>>>
>>>> Hello Maxim,
>>>>
>>>> we are backp on OM version 2.1.1 now!
>>>>
>>>> This was the procedure of my upgrade test:
>>>>
>>>> 1. I stoped Openmeetings
>>>> 2. I backuped the red5 folder of the OM 2.1.1 installation
>>>> 3. I made a DB backup for the mysql database of OM
>>>> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
>>>> ../backup_today.zip
>>>> 5. I moved the folder of the OM 2.1.1 installation
>>>> 6. I unziped the 3.0.1 version of OM into the same folder (red5)
>>>> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
>>>> ../backup_today.zip --drop --skip-default-rooms
>>>> 8. I started Openmeetings again
>>>>
>>>> Sorry, but I don't know exactly what do you suggest. How can I influence
>>>> the export of the OM DB to make sure that the ID's of the rooms are in
>>>> the right order after the import? There are no difference between the
>>>> admin.sh scripts, logback-config.xml and logback.xsd files of the OM
>>>> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014).
>>>> Or where do I have to look for?
>>>>
>>>> Thank you for help or advice,
>>>> Michael
>>>>
>>>> Am 03.05.14 05:41, schrieb Maxim Solodovnik:
>>>>> you can try to "install from backup" from command line admin
>>>>> in this case no additional users/rooms are creted, so IDs should be the
>>>>> same.
>>>>>
>>>>> I guess it is export issue (and should be fixed in latest OM, I have
>>>> added
>>>>> ORDER BY if I'm not mistaken)
>>>>>
>>>>>
>>>>> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <
>>>> mwuttke@beuth-hochschule.de
>>>>>> wrote:
>>>>>
>>>>>> and how did you solve that problem? ;-)
>>>>>>
>>>>>> Greetings,
>>>>>> Michael
>>>>>>
>>>>>> Am 02.05.14 13:49, schrieb Peter Dähn:
>>>>>>> well.. I just was remembered at my experience...
>>>>>>>
>>>>>>> BR Peter
>>>>>>>
>>>>>>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
>>>>>>>> Hello Peter,
>>>>>>>>
>>>>>>>> sorry, but in this case I am using mysql for both: moodle and
>>>>>>>> openmeetings.
>>>>>>>>
>>>>>>>> But thank you for your quick reply.
>>>>>>>> Michael
>>>>>>>>
>>>>>>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
>>>>>>>>> Hello together,
>>>>>>>>>
>>>>>>>>> could be the problem witht the postgres export...
>>>>>>>>>
>>>>>>>>> What kind o database do you use?
>>>>>>>>>
>>>>>>>>> BR Peter
>>>>>>>>>
>>>>>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>>>>>>>>>
>>>>>>>>>> Hello Maxim,
>>>>>>>>>>
>>>>>>>>>> ok, I checked the databases (the database before the upgrade und
>>>>>>>>>> the database after the upgrade) and the red5 folders (version
>> 2.1.1
>>>>>>>>>> and 3.0.1). In both databases are same entries of users, of rooms
>>>>>>>>>> and of files (items in the fileexploreritem table). In both red5
>>>>>>>>>> folders are the same number of files (in the upload folder). In
>> the
>>>>>>>>>> OM installation I have more than 500 users, more then 200 rooms-
>> all
>>>>>>>>>> created & managed via moodle - and more than 750 files uploaded
>> into
>>>>>>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
>>>>>>>>>> exists afte the upgrade. But the OM rooms are not linked to the
>>>>>>>>>> right moodle om activities. They are not in the right order. What
>>>>>>>>>> can I do. How can I fix the issue?
>>>>>>>>>>
>>>>>>>>>> Thank you for help or any advice,
>>>>>>>>>> Michael
>>>>>>>>>>
>>>>>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>>>>>>>>>> According to the process only deleted files might be removed ....
>>>>>>>>>> can you check if these files are still in the DB?
>> (fileexploreritem
>>>>>>>>>>
>>>>>>>>>> table, you can check by filehash and/of filename)
>>>>>>>>>>
>>>>>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>>>>>>>>>> <mw...@beuth-hochschule.de> wrote:
>>>>>>>>>>
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>>>>>>>>>> the
>>>>>>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
>>>>>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>>>>>>>>>
>>>>>>>>>> After the upgrade some uploaded files are not available any longer
>>>>>>>>>> in
>>>>>>>>>> the rooms or at the witheboards. In the log files there were no
>>>>>>>>>> error
>>>>>>>>>> messages.
>>>>>>>>>>
>>>>>>>>>> Has anybody an idea how I can find the missing files? I made a
>>>>>>>>>> backup of
>>>>>>>>>> the old database and the red5 folder with all the data and the
>>>>>>>>>> logs.
>>>>>>>>>>
>>>>>>>>>> Greetings,
>>>>>>>>>> Michael
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Maxim Solodovnik <so...@gmail.com>.
The easiest way is to correct 2.1.1 sources and add ORDER BY:
https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
To this line:
@NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
This might help only partially :( due to deleted rooms will be skipped
and ids might change
On Sun, May 4, 2014 at 7:30 PM, Michael Wuttke
<mw...@beuth-hochschule.de>wrote:
> Hello Maxim,
>
> sorry but I don't know how to transform the rooms.xml from the
> backup.zip to have sorted room ID's. I played arround with libreoffice
> headless, a xml filter for libreoffice and with xsltproc but could not
> find a solution.
>
> Please could you help me? Or can you give me a hint how to export the OM
> database into the xml files with sorted ID's?
>
> Thank you,
> Michael
>
> Am 03.05.14 12:33, schrieb Maxim Solodovnik:
> > Unfortunately the only option for you is to re-order rooms in xml file
> > (manually or using xsl transformation)
> > Rooms should be ordered by ID
> >
> >
> > On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke
> > <mw...@beuth-hochschule.de>wrote:
> >
> >> Hello Maxim,
> >>
> >> we are backp on OM version 2.1.1 now!
> >>
> >> This was the procedure of my upgrade test:
> >>
> >> 1. I stoped Openmeetings
> >> 2. I backuped the red5 folder of the OM 2.1.1 installation
> >> 3. I made a DB backup for the mysql database of OM
> >> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
> >> ../backup_today.zip
> >> 5. I moved the folder of the OM 2.1.1 installation
> >> 6. I unziped the 3.0.1 version of OM into the same folder (red5)
> >> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
> >> ../backup_today.zip --drop --skip-default-rooms
> >> 8. I started Openmeetings again
> >>
> >> Sorry, but I don't know exactly what do you suggest. How can I influence
> >> the export of the OM DB to make sure that the ID's of the rooms are in
> >> the right order after the import? There are no difference between the
> >> admin.sh scripts, logback-config.xml and logback.xsd files of the OM
> >> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014).
> >> Or where do I have to look for?
> >>
> >> Thank you for help or advice,
> >> Michael
> >>
> >> Am 03.05.14 05:41, schrieb Maxim Solodovnik:
> >>> you can try to "install from backup" from command line admin
> >>> in this case no additional users/rooms are creted, so IDs should be the
> >>> same.
> >>>
> >>> I guess it is export issue (and should be fixed in latest OM, I have
> >> added
> >>> ORDER BY if I'm not mistaken)
> >>>
> >>>
> >>> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <
> >> mwuttke@beuth-hochschule.de
> >>>> wrote:
> >>>
> >>>> and how did you solve that problem? ;-)
> >>>>
> >>>> Greetings,
> >>>> Michael
> >>>>
> >>>> Am 02.05.14 13:49, schrieb Peter Dähn:
> >>>>> well.. I just was remembered at my experience...
> >>>>>
> >>>>> BR Peter
> >>>>>
> >>>>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
> >>>>>> Hello Peter,
> >>>>>>
> >>>>>> sorry, but in this case I am using mysql for both: moodle and
> >>>>>> openmeetings.
> >>>>>>
> >>>>>> But thank you for your quick reply.
> >>>>>> Michael
> >>>>>>
> >>>>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
> >>>>>>> Hello together,
> >>>>>>>
> >>>>>>> could be the problem witht the postgres export...
> >>>>>>>
> >>>>>>> What kind o database do you use?
> >>>>>>>
> >>>>>>> BR Peter
> >>>>>>>
> >>>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
> >>>>>>>
> >>>>>>>> Hello Maxim,
> >>>>>>>>
> >>>>>>>> ok, I checked the databases (the database before the upgrade und
> >>>>>>>> the database after the upgrade) and the red5 folders (version
> 2.1.1
> >>>>>>>> and 3.0.1). In both databases are same entries of users, of rooms
> >>>>>>>> and of files (items in the fileexploreritem table). In both red5
> >>>>>>>> folders are the same number of files (in the upload folder). In
> the
> >>>>>>>> OM installation I have more than 500 users, more then 200 rooms-
> all
> >>>>>>>> created & managed via moodle - and more than 750 files uploaded
> into
> >>>>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
> >>>>>>>> exists afte the upgrade. But the OM rooms are not linked to the
> >>>>>>>> right moodle om activities. They are not in the right order. What
> >>>>>>>> can I do. How can I fix the issue?
> >>>>>>>>
> >>>>>>>> Thank you for help or any advice,
> >>>>>>>> Michael
> >>>>>>>>
> >>>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
> >>>>>>>> According to the process only deleted files might be removed ....
> >>>>>>>> can you check if these files are still in the DB?
> (fileexploreritem
> >>>>>>>>
> >>>>>>>> table, you can check by filehash and/of filename)
> >>>>>>>>
> >>>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
> >>>>>>>> <mw...@beuth-hochschule.de> wrote:
> >>>>>>>>
> >>>>>>>> Hello,
> >>>>>>>>
> >>>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
> >>>>>>>> the
> >>>>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
> >>>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
> >>>>>>>>
> >>>>>>>> After the upgrade some uploaded files are not available any longer
> >>>>>>>> in
> >>>>>>>> the rooms or at the witheboards. In the log files there were no
> >>>>>>>> error
> >>>>>>>> messages.
> >>>>>>>>
> >>>>>>>> Has anybody an idea how I can find the missing files? I made a
> >>>>>>>> backup of
> >>>>>>>> the old database and the red5 folder with all the data and the
> >>>>>>>> logs.
> >>>>>>>>
> >>>>>>>> Greetings,
> >>>>>>>> Michael
>
--
WBR
Maxim aka solomax
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Maxim,
sorry but I don't know how to transform the rooms.xml from the
backup.zip to have sorted room ID's. I played arround with libreoffice
headless, a xml filter for libreoffice and with xsltproc but could not
find a solution.
Please could you help me? Or can you give me a hint how to export the OM
database into the xml files with sorted ID's?
Thank you,
Michael
Am 03.05.14 12:33, schrieb Maxim Solodovnik:
> Unfortunately the only option for you is to re-order rooms in xml file
> (manually or using xsl transformation)
> Rooms should be ordered by ID
>
>
> On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke
> <mw...@beuth-hochschule.de>wrote:
>
>> Hello Maxim,
>>
>> we are backp on OM version 2.1.1 now!
>>
>> This was the procedure of my upgrade test:
>>
>> 1. I stoped Openmeetings
>> 2. I backuped the red5 folder of the OM 2.1.1 installation
>> 3. I made a DB backup for the mysql database of OM
>> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
>> ../backup_today.zip
>> 5. I moved the folder of the OM 2.1.1 installation
>> 6. I unziped the 3.0.1 version of OM into the same folder (red5)
>> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
>> ../backup_today.zip --drop --skip-default-rooms
>> 8. I started Openmeetings again
>>
>> Sorry, but I don't know exactly what do you suggest. How can I influence
>> the export of the OM DB to make sure that the ID's of the rooms are in
>> the right order after the import? There are no difference between the
>> admin.sh scripts, logback-config.xml and logback.xsd files of the OM
>> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014).
>> Or where do I have to look for?
>>
>> Thank you for help or advice,
>> Michael
>>
>> Am 03.05.14 05:41, schrieb Maxim Solodovnik:
>>> you can try to "install from backup" from command line admin
>>> in this case no additional users/rooms are creted, so IDs should be the
>>> same.
>>>
>>> I guess it is export issue (and should be fixed in latest OM, I have
>> added
>>> ORDER BY if I'm not mistaken)
>>>
>>>
>>> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <
>> mwuttke@beuth-hochschule.de
>>>> wrote:
>>>
>>>> and how did you solve that problem? ;-)
>>>>
>>>> Greetings,
>>>> Michael
>>>>
>>>> Am 02.05.14 13:49, schrieb Peter Dähn:
>>>>> well.. I just was remembered at my experience...
>>>>>
>>>>> BR Peter
>>>>>
>>>>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
>>>>>> Hello Peter,
>>>>>>
>>>>>> sorry, but in this case I am using mysql for both: moodle and
>>>>>> openmeetings.
>>>>>>
>>>>>> But thank you for your quick reply.
>>>>>> Michael
>>>>>>
>>>>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
>>>>>>> Hello together,
>>>>>>>
>>>>>>> could be the problem witht the postgres export...
>>>>>>>
>>>>>>> What kind o database do you use?
>>>>>>>
>>>>>>> BR Peter
>>>>>>>
>>>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>>>>>>>
>>>>>>>> Hello Maxim,
>>>>>>>>
>>>>>>>> ok, I checked the databases (the database before the upgrade und
>>>>>>>> the database after the upgrade) and the red5 folders (version 2.1.1
>>>>>>>> and 3.0.1). In both databases are same entries of users, of rooms
>>>>>>>> and of files (items in the fileexploreritem table). In both red5
>>>>>>>> folders are the same number of files (in the upload folder). In the
>>>>>>>> OM installation I have more than 500 users, more then 200 rooms- all
>>>>>>>> created & managed via moodle - and more than 750 files uploaded into
>>>>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
>>>>>>>> exists afte the upgrade. But the OM rooms are not linked to the
>>>>>>>> right moodle om activities. They are not in the right order. What
>>>>>>>> can I do. How can I fix the issue?
>>>>>>>>
>>>>>>>> Thank you for help or any advice,
>>>>>>>> Michael
>>>>>>>>
>>>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>>>>>>>> According to the process only deleted files might be removed ....
>>>>>>>> can you check if these files are still in the DB? (fileexploreritem
>>>>>>>>
>>>>>>>> table, you can check by filehash and/of filename)
>>>>>>>>
>>>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>>>>>>>> <mw...@beuth-hochschule.de> wrote:
>>>>>>>>
>>>>>>>> Hello,
>>>>>>>>
>>>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>>>>>>>> the
>>>>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
>>>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>>>>>>>
>>>>>>>> After the upgrade some uploaded files are not available any longer
>>>>>>>> in
>>>>>>>> the rooms or at the witheboards. In the log files there were no
>>>>>>>> error
>>>>>>>> messages.
>>>>>>>>
>>>>>>>> Has anybody an idea how I can find the missing files? I made a
>>>>>>>> backup of
>>>>>>>> the old database and the red5 folder with all the data and the
>>>>>>>> logs.
>>>>>>>>
>>>>>>>> Greetings,
>>>>>>>> Michael
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Maxim Solodovnik <so...@gmail.com>.
Unfortunately the only option for you is to re-order rooms in xml file
(manually or using xsl transformation)
Rooms should be ordered by ID
On Sat, May 3, 2014 at 3:19 PM, Michael Wuttke
<mw...@beuth-hochschule.de>wrote:
> Hello Maxim,
>
> we are backp on OM version 2.1.1 now!
>
> This was the procedure of my upgrade test:
>
> 1. I stoped Openmeetings
> 2. I backuped the red5 folder of the OM 2.1.1 installation
> 3. I made a DB backup for the mysql database of OM
> 4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
> ../backup_today.zip
> 5. I moved the folder of the OM 2.1.1 installation
> 6. I unziped the 3.0.1 version of OM into the same folder (red5)
> 7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
> ../backup_today.zip --drop --skip-default-rooms
> 8. I started Openmeetings again
>
> Sorry, but I don't know exactly what do you suggest. How can I influence
> the export of the OM DB to make sure that the ID's of the rooms are in
> the right order after the import? There are no difference between the
> admin.sh scripts, logback-config.xml and logback.xsd files of the OM
> versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014).
> Or where do I have to look for?
>
> Thank you for help or advice,
> Michael
>
> Am 03.05.14 05:41, schrieb Maxim Solodovnik:
> > you can try to "install from backup" from command line admin
> > in this case no additional users/rooms are creted, so IDs should be the
> > same.
> >
> > I guess it is export issue (and should be fixed in latest OM, I have
> added
> > ORDER BY if I'm not mistaken)
> >
> >
> > On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <
> mwuttke@beuth-hochschule.de
> >> wrote:
> >
> >> and how did you solve that problem? ;-)
> >>
> >> Greetings,
> >> Michael
> >>
> >> Am 02.05.14 13:49, schrieb Peter Dähn:
> >>> well.. I just was remembered at my experience...
> >>>
> >>> BR Peter
> >>>
> >>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
> >>>> Hello Peter,
> >>>>
> >>>> sorry, but in this case I am using mysql for both: moodle and
> >>>> openmeetings.
> >>>>
> >>>> But thank you for your quick reply.
> >>>> Michael
> >>>>
> >>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
> >>>>> Hello together,
> >>>>>
> >>>>> could be the problem witht the postgres export...
> >>>>>
> >>>>> What kind o database do you use?
> >>>>>
> >>>>> BR Peter
> >>>>>
> >>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
> >>>>>
> >>>>>> Hello Maxim,
> >>>>>>
> >>>>>> ok, I checked the databases (the database before the upgrade und
> >>>>>> the database after the upgrade) and the red5 folders (version 2.1.1
> >>>>>> and 3.0.1). In both databases are same entries of users, of rooms
> >>>>>> and of files (items in the fileexploreritem table). In both red5
> >>>>>> folders are the same number of files (in the upload folder). In the
> >>>>>> OM installation I have more than 500 users, more then 200 rooms- all
> >>>>>> created & managed via moodle - and more than 750 files uploaded into
> >>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
> >>>>>> exists afte the upgrade. But the OM rooms are not linked to the
> >>>>>> right moodle om activities. They are not in the right order. What
> >>>>>> can I do. How can I fix the issue?
> >>>>>>
> >>>>>> Thank you for help or any advice,
> >>>>>> Michael
> >>>>>>
> >>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
> >>>>>> According to the process only deleted files might be removed ....
> >>>>>> can you check if these files are still in the DB? (fileexploreritem
> >>>>>>
> >>>>>> table, you can check by filehash and/of filename)
> >>>>>>
> >>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
> >>>>>> <mw...@beuth-hochschule.de> wrote:
> >>>>>>
> >>>>>> Hello,
> >>>>>>
> >>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
> >>>>>> the
> >>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
> >>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
> >>>>>>
> >>>>>> After the upgrade some uploaded files are not available any longer
> >>>>>> in
> >>>>>> the rooms or at the witheboards. In the log files there were no
> >>>>>> error
> >>>>>> messages.
> >>>>>>
> >>>>>> Has anybody an idea how I can find the missing files? I made a
> >>>>>> backup of
> >>>>>> the old database and the red5 folder with all the data and the
> >>>>>> logs.
> >>>>>>
> >>>>>> Greetings,
> >>>>>> Michael
> >>>>>>
> >>>>>> --
> >>>>>> WBR
> >>>>>> Maxim aka solomax
> >>>>>>
> >>>>>> Links:
> >>>>>> ------
> >>>>>> [1] http://openmeetings.apache.org/Upgrade.html [1]
> >>>>>
> >>>>> --
> >>>>> B.Sc. Peter Dähn
> >>>>> Virtueller Campus Rheinland-Pfalz [2]
> >>>>> Postfach 3049
> >>>>> 67653 Kaiserslautern
> >>>>> Tel: 0631/205-4944
> >>>>> Olat [3]
> >>>>>
> >>>>>
> >>>>> Links:
> >>>>> ------
> >>>>> [1] http://openmeetings.apache.org/Upgrade.html
> >>>>> [2] http://www.vcrp.de/
> >>>>> [3] https://olat.vcrp.de/
> >>>>
> >>>>
> >>>>
> >>
> >
> >
> >
>
--
WBR
Maxim aka solomax
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Maxim,
we are backp on OM version 2.1.1 now!
This was the procedure of my upgrade test:
1. I stoped Openmeetings
2. I backuped the red5 folder of the OM 2.1.1 installation
3. I made a DB backup for the mysql database of OM
4. I executed the admin-scritp of OM 2.1.1: ./admin.sh -v -b -file
../backup_today.zip
5. I moved the folder of the OM 2.1.1 installation
6. I unziped the 3.0.1 version of OM into the same folder (red5)
7. I executed the admin-scritp of OM 3.0.1: ./admin.sh -v -i -file
../backup_today.zip --drop --skip-default-rooms
8. I started Openmeetings again
Sorry, but I don't know exactly what do you suggest. How can I influence
the export of the OM DB to make sure that the ID's of the rooms are in
the right order after the import? There are no difference between the
admin.sh scripts, logback-config.xml and logback.xsd files of the OM
versions 2.1.1, 3.0.1 and 3.1.0 (build 805 r1589918 from 25. 4. 2014).
Or where do I have to look for?
Thank you for help or advice,
Michael
Am 03.05.14 05:41, schrieb Maxim Solodovnik:
> you can try to "install from backup" from command line admin
> in this case no additional users/rooms are creted, so IDs should be the
> same.
>
> I guess it is export issue (and should be fixed in latest OM, I have added
> ORDER BY if I'm not mistaken)
>
>
> On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <mwuttke@beuth-hochschule.de
>> wrote:
>
>> and how did you solve that problem? ;-)
>>
>> Greetings,
>> Michael
>>
>> Am 02.05.14 13:49, schrieb Peter Dähn:
>>> well.. I just was remembered at my experience...
>>>
>>> BR Peter
>>>
>>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
>>>> Hello Peter,
>>>>
>>>> sorry, but in this case I am using mysql for both: moodle and
>>>> openmeetings.
>>>>
>>>> But thank you for your quick reply.
>>>> Michael
>>>>
>>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
>>>>> Hello together,
>>>>>
>>>>> could be the problem witht the postgres export...
>>>>>
>>>>> What kind o database do you use?
>>>>>
>>>>> BR Peter
>>>>>
>>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>>>>>
>>>>>> Hello Maxim,
>>>>>>
>>>>>> ok, I checked the databases (the database before the upgrade und
>>>>>> the database after the upgrade) and the red5 folders (version 2.1.1
>>>>>> and 3.0.1). In both databases are same entries of users, of rooms
>>>>>> and of files (items in the fileexploreritem table). In both red5
>>>>>> folders are the same number of files (in the upload folder). In the
>>>>>> OM installation I have more than 500 users, more then 200 rooms- all
>>>>>> created & managed via moodle - and more than 750 files uploaded into
>>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
>>>>>> exists afte the upgrade. But the OM rooms are not linked to the
>>>>>> right moodle om activities. They are not in the right order. What
>>>>>> can I do. How can I fix the issue?
>>>>>>
>>>>>> Thank you for help or any advice,
>>>>>> Michael
>>>>>>
>>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>>>>>> According to the process only deleted files might be removed ....
>>>>>> can you check if these files are still in the DB? (fileexploreritem
>>>>>>
>>>>>> table, you can check by filehash and/of filename)
>>>>>>
>>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>>>>>> <mw...@beuth-hochschule.de> wrote:
>>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>>>>>> the
>>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
>>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>>>>>
>>>>>> After the upgrade some uploaded files are not available any longer
>>>>>> in
>>>>>> the rooms or at the witheboards. In the log files there were no
>>>>>> error
>>>>>> messages.
>>>>>>
>>>>>> Has anybody an idea how I can find the missing files? I made a
>>>>>> backup of
>>>>>> the old database and the red5 folder with all the data and the
>>>>>> logs.
>>>>>>
>>>>>> Greetings,
>>>>>> Michael
>>>>>>
>>>>>> --
>>>>>> WBR
>>>>>> Maxim aka solomax
>>>>>>
>>>>>> Links:
>>>>>> ------
>>>>>> [1] http://openmeetings.apache.org/Upgrade.html [1]
>>>>>
>>>>> --
>>>>> B.Sc. Peter Dähn
>>>>> Virtueller Campus Rheinland-Pfalz [2]
>>>>> Postfach 3049
>>>>> 67653 Kaiserslautern
>>>>> Tel: 0631/205-4944
>>>>> Olat [3]
>>>>>
>>>>>
>>>>> Links:
>>>>> ------
>>>>> [1] http://openmeetings.apache.org/Upgrade.html
>>>>> [2] http://www.vcrp.de/
>>>>> [3] https://olat.vcrp.de/
>>>>
>>>>
>>>>
>>
>
>
>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Maxim Solodovnik <so...@gmail.com>.
you can try to "install from backup" from command line admin
in this case no additional users/rooms are creted, so IDs should be the
same.
I guess it is export issue (and should be fixed in latest OM, I have added
ORDER BY if I'm not mistaken)
On Sat, May 3, 2014 at 12:06 AM, Michael Wuttke <mwuttke@beuth-hochschule.de
> wrote:
> and how did you solve that problem? ;-)
>
> Greetings,
> Michael
>
> Am 02.05.14 13:49, schrieb Peter Dähn:
> > well.. I just was remembered at my experience...
> >
> > BR Peter
> >
> > Am 02.05.2014 13:29, schrieb Michael Wuttke:
> >> Hello Peter,
> >>
> >> sorry, but in this case I am using mysql for both: moodle and
> >> openmeetings.
> >>
> >> But thank you for your quick reply.
> >> Michael
> >>
> >> Am 2.5.2014 13:09, schrieb Peter Dähn:
> >>> Hello together,
> >>>
> >>> could be the problem witht the postgres export...
> >>>
> >>> What kind o database do you use?
> >>>
> >>> BR Peter
> >>>
> >>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
> >>>
> >>>> Hello Maxim,
> >>>>
> >>>> ok, I checked the databases (the database before the upgrade und
> >>>> the database after the upgrade) and the red5 folders (version 2.1.1
> >>>> and 3.0.1). In both databases are same entries of users, of rooms
> >>>> and of files (items in the fileexploreritem table). In both red5
> >>>> folders are the same number of files (in the upload folder). In the
> >>>> OM installation I have more than 500 users, more then 200 rooms- all
> >>>> created & managed via moodle - and more than 750 files uploaded into
> >>>> the rooms/witheboards. Ok, all the users, rooms and files still
> >>>> exists afte the upgrade. But the OM rooms are not linked to the
> >>>> right moodle om activities. They are not in the right order. What
> >>>> can I do. How can I fix the issue?
> >>>>
> >>>> Thank you for help or any advice,
> >>>> Michael
> >>>>
> >>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
> >>>> According to the process only deleted files might be removed ....
> >>>> can you check if these files are still in the DB? (fileexploreritem
> >>>>
> >>>> table, you can check by filehash and/of filename)
> >>>>
> >>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
> >>>> <mw...@beuth-hochschule.de> wrote:
> >>>>
> >>>> Hello,
> >>>>
> >>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
> >>>> the
> >>>> CLI. I used the "Detailed steps" how to for that upgrade.
> >>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
> >>>>
> >>>> After the upgrade some uploaded files are not available any longer
> >>>> in
> >>>> the rooms or at the witheboards. In the log files there were no
> >>>> error
> >>>> messages.
> >>>>
> >>>> Has anybody an idea how I can find the missing files? I made a
> >>>> backup of
> >>>> the old database and the red5 folder with all the data and the
> >>>> logs.
> >>>>
> >>>> Greetings,
> >>>> Michael
> >>>>
> >>>> --
> >>>> WBR
> >>>> Maxim aka solomax
> >>>>
> >>>> Links:
> >>>> ------
> >>>> [1] http://openmeetings.apache.org/Upgrade.html [1]
> >>>
> >>> --
> >>> B.Sc. Peter Dähn
> >>> Virtueller Campus Rheinland-Pfalz [2]
> >>> Postfach 3049
> >>> 67653 Kaiserslautern
> >>> Tel: 0631/205-4944
> >>> Olat [3]
> >>>
> >>>
> >>> Links:
> >>> ------
> >>> [1] http://openmeetings.apache.org/Upgrade.html
> >>> [2] http://www.vcrp.de/
> >>> [3] https://olat.vcrp.de/
> >>
> >>
> >>
>
--
WBR
Maxim aka solomax
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mi...@beuth-hochschule.de>.
Hi,
Am 05.05.2014 11:23, schrieb Michael Wuttke:
> I am > not sure if these rooms will be marked as deleted and remain in the
> database as well when I delete the so called OM activity in moodle.
Sorry, I am wrong ! The rooms will be marked as deleted and remain in
the database also via moodle!
Thnaks & Greetings,
Michael
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mi...@beuth-hochschule.de>.
Hi Peter,
thanks for your hints. I will have a look at the other xml files too. ;-)
Normaly the OM rooms are created by moodle via the SOAP-Gateway. I am
not sure if these rooms will be marked as deleted and remain in the
databas as well when I delete the so called OM activity in moodle.
Greetings,
Michael
Am 05.05.2014 11:07, schrieb Peter Dähn:
> Hi Michael,
>
> we had also problems with user.xml and a few other files... maybe you
> should have a look at the other files too...
>
> rooms should just be deleted over the admin interface. Then the rooms
> will just be marked as deleted and remain in the database. Then the
> right order will be kept. You run into problems, if you delete something
> in the database.
>
> Greetings Peter
>
>
> Am 05.05.2014 10:52, schrieb Michael Wuttke:
>> Hello Peter,
>>
>> Am 05.05.2014 09:42, schrieb Peter Dähn:
>>> sorry.. was out of office... ;-)
>> no problem. No wonder with so many public holidays. ;-)
>>
>>> We added an orderby to the export functions of the backup-procedure and
>>> make another backup... but we used OM 2.0... so... you need to find the
>>> used functions and add to the sql queries an orderby-part by youtrself...
>>> Therefor you need to change some source-files an recompile om...
>> Maxim suggested it yesterday too:
>>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>>>
>>>
>> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
>>
>>> To this line:
>>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
>> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>>
>>> But with mysql the order shoulb be fine.. as far as I remember... it was
>>> just an issue with postgres... Are the id's mixed in your rooms.xml?
>> Yes the id's of the rooms.xml export file are mixed.
>>
>> I'm curious about, what will be happen with the deleted rooms. Maybe
>> they will be skipped and the id's might change as well.
>>
>> After the next upgrade test I can tell more about it. ;-)
>>
>> Thank you & Greetings,
>> Michael
>>
>>
--
Danke & mit freundlichen Grüßen,
Michael Wuttke
Learning Management System Moodle
http://lms.beuth-hochschule.de
Beuth Hochschule Berlin - Labor Online Learning
http://learn.beuth-hochschule.de
Luxemburger Str. 10
13353 Berlin
Tel: +49 (0)30 45 04 2184
E-Mail: michael.wuttke@beuth-hochschule.de
News: http://lms.beuth-hochschule.de/rss
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Maxim Solodovnik <so...@gmail.com>.
Sorry for this mess ...
currently it should be fixed :)
On Thu, May 8, 2014 at 4:40 PM, Peter Dähn <da...@vcrp.de> wrote:
> Hello Michael,
>
> while we tried to update OM2.0 to OM2.1 we encounter the problem with
> mixed entries in most of the xml-files of the backup. That time we thought
> it was caused by the use of postgres-db... but now..
>
> Anyway... it seems the rest worked somehow also with mixed ids... for
> example: the improrted user-ids where mixed, so the admin user got a
> different ID... so it needed to be changed in the config after the first
> start of the new om..
>
> I don't know if there were other side-effects... but it makes me a bit
> headache.. so we corrected the export of all xml-files, that were mixed
> somehow... btw... we are going to do the same right now for the om2.2
> export... :-(
>
> Greetings Peter
>
> Am 08.05.2014 11:17, schrieb Michael Wuttke:
>
>> Hello Peter,
>>
>> what kind of problems did you have with the users.xml and the other
>> backup files?
>>
>> I changed the backup function 'getBackupRooms' in the source file
>> Rooms.java for 2.1.1 like Maxim did it for OM 3.0.2+ [1] into:
>>
>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r LEFT
>> JOIN FETCH r.moderators ORDER BY r.rooms_id"),
>>
>> Now the upgrade - backup and the reinstall - of OM works as expected for
>> me.
>>
>> Or should I change something else?
>>
>> Links: [1] https://svn.apache.org/repos/asf/openmeetings/branches/3.0.
>> x/src/db/java/org/apache/openmeetings/db/entity/room/Room.java
>>
>> Thanks & Greetings,
>> Michael
>>
>> Am 5.5.2014 11:07, schrieb Peter Dähn:
>>
>>> Hi Michael,
>>>
>>> we had also problems with user.xml and a few other files... maybe you
>>> should have a look at the other files too...
>>>
>>> rooms should just be deleted over the admin interface. Then the rooms
>>> will just be marked as deleted and remain in the database. Then the
>>> right order will be kept. You run into problems, if you delete something
>>> in the database.
>>>
>>> Greetings Peter
>>>
>>>
>>> Am 05.05.2014 10:52, schrieb Michael Wuttke:
>>>
>>>> Hello Peter,
>>>>
>>>> Am 05.05.2014 09:42, schrieb Peter Dähn:
>>>>
>>>>> sorry.. was out of office... ;-)
>>>>>
>>>> no problem. No wonder with so many public holidays. ;-)
>>>>
>>>> We added an orderby to the export functions of the backup-procedure and
>>>>> make another backup... but we used OM 2.0... so... you need to find the
>>>>> used functions and add to the sql queries an orderby-part by
>>>>> youtrself...
>>>>> Therefor you need to change some source-files an recompile om...
>>>>>
>>>> Maxim suggested it yesterday too:
>>>>
>>>>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>>>>>
>>>>>
>>>>> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/
>>>> src/org/apache/openmeetings/persistence/beans/room/Room.java
>>>>
>>>> To this line:
>>>>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
>>>>>
>>>> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>>>>
>>>> But with mysql the order shoulb be fine.. as far as I remember... it
>>>>> was
>>>>> just an issue with postgres... Are the id's mixed in your rooms.xml?
>>>>>
>>>> Yes the id's of the rooms.xml export file are mixed.
>>>>
>>>> I'm curious about, what will be happen with the deleted rooms. Maybe
>>>> they will be skipped and the id's might change as well.
>>>>
>>>> After the next upgrade test I can tell more about it. ;-)
>>>>
>>>> Thank you & Greetings,
>>>> Michael
>>>>
>>>>
>>>>
>>
>>
>
--
WBR
Maxim aka solomax
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are
missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Peter,
I am using mysql as the database server at the moment for OM and in all
the xml backup files created with OM 2.1.1 the entries are in the right
order, except the entries in the rooms.xml. For moodle as an external
system using these OM rooms it is important to have the right id's. ;-)
Thanks for your quick answer & Greetings,
Michael
Am 8.5.2014 11:40, schrieb Peter Dähn:
> Hello Michael,
>
> while we tried to update OM2.0 to OM2.1 we encounter the problem with
> mixed entries in most of the xml-files of the backup. That time we
> thought it was caused by the use of postgres-db... but now..
>
> Anyway... it seems the rest worked somehow also with mixed ids... for
> example: the improrted user-ids where mixed, so the admin user got a
> different ID... so it needed to be changed in the config after the
> first start of the new om..
>
> I don't know if there were other side-effects... but it makes me a bit
> headache.. so we corrected the export of all xml-files, that were
> mixed somehow... btw... we are going to do the same right now for the
> om2.2 export... :-(
>
> Greetings Peter
>
> Am 08.05.2014 11:17, schrieb Michael Wuttke:
>> Hello Peter,
>>
>> what kind of problems did you have with the users.xml and the other
>> backup files?
>>
>> I changed the backup function 'getBackupRooms' in the source file
>> Rooms.java for 2.1.1 like Maxim did it for OM 3.0.2+ [1] into:
>>
>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
>> LEFT JOIN FETCH r.moderators ORDER BY r.rooms_id"),
>>
>> Now the upgrade - backup and the reinstall - of OM works as expected
>> for me.
>>
>> Or should I change something else?
>>
>> Links: [1]
>> https://svn.apache.org/repos/asf/openmeetings/branches/3.0.x/src/db/java/org/apache/openmeetings/db/entity/room/Room.java
>>
>> Thanks & Greetings,
>> Michael
>>
>> Am 5.5.2014 11:07, schrieb Peter Dähn:
>>> Hi Michael,
>>>
>>> we had also problems with user.xml and a few other files... maybe you
>>> should have a look at the other files too...
>>>
>>> rooms should just be deleted over the admin interface. Then the rooms
>>> will just be marked as deleted and remain in the database. Then the
>>> right order will be kept. You run into problems, if you delete
>>> something
>>> in the database.
>>>
>>> Greetings Peter
>>>
>>>
>>> Am 05.05.2014 10:52, schrieb Michael Wuttke:
>>>> Hello Peter,
>>>>
>>>> Am 05.05.2014 09:42, schrieb Peter Dähn:
>>>>> sorry.. was out of office... ;-)
>>>> no problem. No wonder with so many public holidays. ;-)
>>>>
>>>>> We added an orderby to the export functions of the backup-procedure
>>>>> and
>>>>> make another backup... but we used OM 2.0... so... you need to find
>>>>> the
>>>>> used functions and add to the sql queries an orderby-part by
>>>>> youtrself...
>>>>> Therefor you need to change some source-files an recompile om...
>>>> Maxim suggested it yesterday too:
>>>>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>>>>>
>>>>>
>>>> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
>>>>> To this line:
>>>>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
>>>> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>>>>
>>>>> But with mysql the order shoulb be fine.. as far as I remember...
>>>>> it was
>>>>> just an issue with postgres... Are the id's mixed in your
>>>>> rooms.xml?
>>>> Yes the id's of the rooms.xml export file are mixed.
>>>>
>>>> I'm curious about, what will be happen with the deleted rooms. Maybe
>>>> they will be skipped and the id's might change as well.
>>>>
>>>> After the next upgrade test I can tell more about it. ;-)
>>>>
>>>> Thank you & Greetings,
>>>> Michael
>>>>
>>>>
>>
>>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Peter Dähn <da...@vcrp.de>.
Hello Michael,
while we tried to update OM2.0 to OM2.1 we encounter the problem with
mixed entries in most of the xml-files of the backup. That time we
thought it was caused by the use of postgres-db... but now..
Anyway... it seems the rest worked somehow also with mixed ids... for
example: the improrted user-ids where mixed, so the admin user got a
different ID... so it needed to be changed in the config after the first
start of the new om..
I don't know if there were other side-effects... but it makes me a bit
headache.. so we corrected the export of all xml-files, that were mixed
somehow... btw... we are going to do the same right now for the om2.2
export... :-(
Greetings Peter
Am 08.05.2014 11:17, schrieb Michael Wuttke:
> Hello Peter,
>
> what kind of problems did you have with the users.xml and the other
> backup files?
>
> I changed the backup function 'getBackupRooms' in the source file
> Rooms.java for 2.1.1 like Maxim did it for OM 3.0.2+ [1] into:
>
> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
> LEFT JOIN FETCH r.moderators ORDER BY r.rooms_id"),
>
> Now the upgrade - backup and the reinstall - of OM works as expected
> for me.
>
> Or should I change something else?
>
> Links: [1]
> https://svn.apache.org/repos/asf/openmeetings/branches/3.0.x/src/db/java/org/apache/openmeetings/db/entity/room/Room.java
>
> Thanks & Greetings,
> Michael
>
> Am 5.5.2014 11:07, schrieb Peter Dähn:
>> Hi Michael,
>>
>> we had also problems with user.xml and a few other files... maybe you
>> should have a look at the other files too...
>>
>> rooms should just be deleted over the admin interface. Then the rooms
>> will just be marked as deleted and remain in the database. Then the
>> right order will be kept. You run into problems, if you delete something
>> in the database.
>>
>> Greetings Peter
>>
>>
>> Am 05.05.2014 10:52, schrieb Michael Wuttke:
>>> Hello Peter,
>>>
>>> Am 05.05.2014 09:42, schrieb Peter Dähn:
>>>> sorry.. was out of office... ;-)
>>> no problem. No wonder with so many public holidays. ;-)
>>>
>>>> We added an orderby to the export functions of the backup-procedure
>>>> and
>>>> make another backup... but we used OM 2.0... so... you need to find
>>>> the
>>>> used functions and add to the sql queries an orderby-part by
>>>> youtrself...
>>>> Therefor you need to change some source-files an recompile om...
>>> Maxim suggested it yesterday too:
>>>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>>>>
>>>>
>>> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
>>>
>>>
>>>> To this line:
>>>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
>>> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>>>
>>>> But with mysql the order shoulb be fine.. as far as I remember...
>>>> it was
>>>> just an issue with postgres... Are the id's mixed in your rooms.xml?
>>> Yes the id's of the rooms.xml export file are mixed.
>>>
>>> I'm curious about, what will be happen with the deleted rooms. Maybe
>>> they will be skipped and the id's might change as well.
>>>
>>> After the next upgrade test I can tell more about it. ;-)
>>>
>>> Thank you & Greetings,
>>> Michael
>>>
>>>
>
>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are
missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Peter,
what kind of problems did you have with the users.xml and the other
backup files?
I changed the backup function 'getBackupRooms' in the source file
Rooms.java for 2.1.1 like Maxim did it for OM 3.0.2+ [1] into:
@NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r LEFT
JOIN FETCH r.moderators ORDER BY r.rooms_id"),
Now the upgrade - backup and the reinstall - of OM works as expected for
me.
Or should I change something else?
Links: [1]
https://svn.apache.org/repos/asf/openmeetings/branches/3.0.x/src/db/java/org/apache/openmeetings/db/entity/room/Room.java
Thanks & Greetings,
Michael
Am 5.5.2014 11:07, schrieb Peter Dähn:
> Hi Michael,
>
> we had also problems with user.xml and a few other files... maybe you
> should have a look at the other files too...
>
> rooms should just be deleted over the admin interface. Then the rooms
> will just be marked as deleted and remain in the database. Then the
> right order will be kept. You run into problems, if you delete
> something
> in the database.
>
> Greetings Peter
>
>
> Am 05.05.2014 10:52, schrieb Michael Wuttke:
>> Hello Peter,
>>
>> Am 05.05.2014 09:42, schrieb Peter Dähn:
>>> sorry.. was out of office... ;-)
>> no problem. No wonder with so many public holidays. ;-)
>>
>>> We added an orderby to the export functions of the backup-procedure
>>> and
>>> make another backup... but we used OM 2.0... so... you need to find
>>> the
>>> used functions and add to the sql queries an orderby-part by
>>> youtrself...
>>> Therefor you need to change some source-files an recompile om...
>> Maxim suggested it yesterday too:
>>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>>>
>>>
>> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
>>
>>> To this line:
>>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
>> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>>
>>> But with mysql the order shoulb be fine.. as far as I remember... it
>>> was
>>> just an issue with postgres... Are the id's mixed in your rooms.xml?
>> Yes the id's of the rooms.xml export file are mixed.
>>
>> I'm curious about, what will be happen with the deleted rooms. Maybe
>> they will be skipped and the id's might change as well.
>>
>> After the next upgrade test I can tell more about it. ;-)
>>
>> Thank you & Greetings,
>> Michael
>>
>>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Peter Dähn <da...@vcrp.de>.
Hi Michael,
we had also problems with user.xml and a few other files... maybe you
should have a look at the other files too...
rooms should just be deleted over the admin interface. Then the rooms
will just be marked as deleted and remain in the database. Then the
right order will be kept. You run into problems, if you delete something
in the database.
Greetings Peter
Am 05.05.2014 10:52, schrieb Michael Wuttke:
> Hello Peter,
>
> Am 05.05.2014 09:42, schrieb Peter Dähn:
>> sorry.. was out of office... ;-)
> no problem. No wonder with so many public holidays. ;-)
>
>> We added an orderby to the export functions of the backup-procedure and
>> make another backup... but we used OM 2.0... so... you need to find the
>> used functions and add to the sql queries an orderby-part by youtrself...
>> Therefor you need to change some source-files an recompile om...
> Maxim suggested it yesterday too:
>> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>>
>>
> https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
>
>> To this line:
>> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
> LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
>
>> But with mysql the order shoulb be fine.. as far as I remember... it was
>> just an issue with postgres... Are the id's mixed in your rooms.xml?
> Yes the id's of the rooms.xml export file are mixed.
>
> I'm curious about, what will be happen with the deleted rooms. Maybe
> they will be skipped and the id's might change as well.
>
> After the next upgrade test I can tell more about it. ;-)
>
> Thank you & Greetings,
> Michael
>
>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mi...@beuth-hochschule.de>.
Hello Peter,
Am 05.05.2014 09:42, schrieb Peter Dähn:
> sorry.. was out of office... ;-)
no problem. No wonder with so many public holidays. ;-)
> We added an orderby to the export functions of the backup-procedure and
> make another backup... but we used OM 2.0... so... you need to find the
> used functions and add to the sql queries an orderby-part by youtrself...
> Therefor you need to change some source-files an recompile om...
Maxim suggested it yesterday too:
> The easiest way is to correct 2.1.1 sources and add ORDER BY:
>
>
https://svn.apache.org/repos/asf/openmeetings/branches/2.x/src/org/apache/openmeetings/persistence/beans/room/Room.java
> To this line:
> @NamedQuery(name = "getBackupRooms", query = "SELECT r FROM Room r
LEFT JOIN FETCH r.moderators WHERE r.deleted = false "),
> But with mysql the order shoulb be fine.. as far as I remember... it was
> just an issue with postgres... Are the id's mixed in your rooms.xml?
Yes the id's of the rooms.xml export file are mixed.
I'm curious about, what will be happen with the deleted rooms. Maybe
they will be skipped and the id's might change as well.
After the next upgrade test I can tell more about it. ;-)
Thank you & Greetings,
Michael
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Peter Dähn <da...@vcrp.de>.
sorry.. was out of office... ;-)
We added an orderby to the export functions of the backup-procedure and
make another backup... but we used OM 2.0... so... you need to find the
used functions and add to the sql queries an orderby-part by youtrself...
Therefor you need to change some source-files an recompile om...
But with mysql the order shoulb be fine.. as far as I remember... it was
just an issue with postgres... Are the id's mixed in your rooms.xml?
Greetings Peter
Am 02.05.2014 19:06, schrieb Michael Wuttke:
> and how did you solve that problem? ;-)
>
> Greetings,
> Michael
>
> Am 02.05.14 13:49, schrieb Peter Dähn:
>> well.. I just was remembered at my experience...
>>
>> BR Peter
>>
>> Am 02.05.2014 13:29, schrieb Michael Wuttke:
>>> Hello Peter,
>>>
>>> sorry, but in this case I am using mysql for both: moodle and
>>> openmeetings.
>>>
>>> But thank you for your quick reply.
>>> Michael
>>>
>>> Am 2.5.2014 13:09, schrieb Peter Dähn:
>>>> Hello together,
>>>>
>>>> could be the problem witht the postgres export...
>>>>
>>>> What kind o database do you use?
>>>>
>>>> BR Peter
>>>>
>>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>>>>
>>>>> Hello Maxim,
>>>>>
>>>>> ok, I checked the databases (the database before the upgrade und
>>>>> the database after the upgrade) and the red5 folders (version 2.1.1
>>>>> and 3.0.1). In both databases are same entries of users, of rooms
>>>>> and of files (items in the fileexploreritem table). In both red5
>>>>> folders are the same number of files (in the upload folder). In the
>>>>> OM installation I have more than 500 users, more then 200 rooms- all
>>>>> created & managed via moodle - and more than 750 files uploaded into
>>>>> the rooms/witheboards. Ok, all the users, rooms and files still
>>>>> exists afte the upgrade. But the OM rooms are not linked to the
>>>>> right moodle om activities. They are not in the right order. What
>>>>> can I do. How can I fix the issue?
>>>>>
>>>>> Thank you for help or any advice,
>>>>> Michael
>>>>>
>>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>>>>> According to the process only deleted files might be removed ....
>>>>> can you check if these files are still in the DB? (fileexploreritem
>>>>>
>>>>> table, you can check by filehash and/of filename)
>>>>>
>>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>>>>> <mw...@beuth-hochschule.de> wrote:
>>>>>
>>>>> Hello,
>>>>>
>>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>>>>> the
>>>>> CLI. I used the "Detailed steps" how to for that upgrade.
>>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>>>>
>>>>> After the upgrade some uploaded files are not available any longer
>>>>> in
>>>>> the rooms or at the witheboards. In the log files there were no
>>>>> error
>>>>> messages.
>>>>>
>>>>> Has anybody an idea how I can find the missing files? I made a
>>>>> backup of
>>>>> the old database and the red5 folder with all the data and the
>>>>> logs.
>>>>>
>>>>> Greetings,
>>>>> Michael
>>>>>
>>>>> --
>>>>> WBR
>>>>> Maxim aka solomax
>>>>>
>>>>> Links:
>>>>> ------
>>>>> [1] http://openmeetings.apache.org/Upgrade.html [1]
>>>> --
>>>> B.Sc. Peter Dähn
>>>> Virtueller Campus Rheinland-Pfalz [2]
>>>> Postfach 3049
>>>> 67653 Kaiserslautern
>>>> Tel: 0631/205-4944
>>>> Olat [3]
>>>>
>>>>
>>>> Links:
>>>> ------
>>>> [1] http://openmeetings.apache.org/Upgrade.html
>>>> [2] http://www.vcrp.de/
>>>> [3] https://olat.vcrp.de/
>>>
>>>
>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
and how did you solve that problem? ;-)
Greetings,
Michael
Am 02.05.14 13:49, schrieb Peter Dähn:
> well.. I just was remembered at my experience...
>
> BR Peter
>
> Am 02.05.2014 13:29, schrieb Michael Wuttke:
>> Hello Peter,
>>
>> sorry, but in this case I am using mysql for both: moodle and
>> openmeetings.
>>
>> But thank you for your quick reply.
>> Michael
>>
>> Am 2.5.2014 13:09, schrieb Peter Dähn:
>>> Hello together,
>>>
>>> could be the problem witht the postgres export...
>>>
>>> What kind o database do you use?
>>>
>>> BR Peter
>>>
>>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>>>
>>>> Hello Maxim,
>>>>
>>>> ok, I checked the databases (the database before the upgrade und
>>>> the database after the upgrade) and the red5 folders (version 2.1.1
>>>> and 3.0.1). In both databases are same entries of users, of rooms
>>>> and of files (items in the fileexploreritem table). In both red5
>>>> folders are the same number of files (in the upload folder). In the
>>>> OM installation I have more than 500 users, more then 200 rooms- all
>>>> created & managed via moodle - and more than 750 files uploaded into
>>>> the rooms/witheboards. Ok, all the users, rooms and files still
>>>> exists afte the upgrade. But the OM rooms are not linked to the
>>>> right moodle om activities. They are not in the right order. What
>>>> can I do. How can I fix the issue?
>>>>
>>>> Thank you for help or any advice,
>>>> Michael
>>>>
>>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>>>> According to the process only deleted files might be removed ....
>>>> can you check if these files are still in the DB? (fileexploreritem
>>>>
>>>> table, you can check by filehash and/of filename)
>>>>
>>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>>>> <mw...@beuth-hochschule.de> wrote:
>>>>
>>>> Hello,
>>>>
>>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>>>> the
>>>> CLI. I used the "Detailed steps" how to for that upgrade.
>>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>>>
>>>> After the upgrade some uploaded files are not available any longer
>>>> in
>>>> the rooms or at the witheboards. In the log files there were no
>>>> error
>>>> messages.
>>>>
>>>> Has anybody an idea how I can find the missing files? I made a
>>>> backup of
>>>> the old database and the red5 folder with all the data and the
>>>> logs.
>>>>
>>>> Greetings,
>>>> Michael
>>>>
>>>> --
>>>> WBR
>>>> Maxim aka solomax
>>>>
>>>> Links:
>>>> ------
>>>> [1] http://openmeetings.apache.org/Upgrade.html [1]
>>>
>>> --
>>> B.Sc. Peter Dähn
>>> Virtueller Campus Rheinland-Pfalz [2]
>>> Postfach 3049
>>> 67653 Kaiserslautern
>>> Tel: 0631/205-4944
>>> Olat [3]
>>>
>>>
>>> Links:
>>> ------
>>> [1] http://openmeetings.apache.org/Upgrade.html
>>> [2] http://www.vcrp.de/
>>> [3] https://olat.vcrp.de/
>>
>>
>>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are missing
Posted by Peter Dähn <da...@vcrp.de>.
well.. I just was remembered at my experience...
BR Peter
Am 02.05.2014 13:29, schrieb Michael Wuttke:
> Hello Peter,
>
> sorry, but in this case I am using mysql for both: moodle and
> openmeetings.
>
> But thank you for your quick reply.
> Michael
>
> Am 2.5.2014 13:09, schrieb Peter Dähn:
>> Hello together,
>>
>> could be the problem witht the postgres export...
>>
>> What kind o database do you use?
>>
>> BR Peter
>>
>> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>>
>>> Hello Maxim,
>>>
>>> ok, I checked the databases (the database before the upgrade und
>>> the database after the upgrade) and the red5 folders (version 2.1.1
>>> and 3.0.1). In both databases are same entries of users, of rooms
>>> and of files (items in the fileexploreritem table). In both red5
>>> folders are the same number of files (in the upload folder). In the
>>> OM installation I have more than 500 users, more then 200 rooms- all
>>> created & managed via moodle - and more than 750 files uploaded into
>>> the rooms/witheboards. Ok, all the users, rooms and files still
>>> exists afte the upgrade. But the OM rooms are not linked to the
>>> right moodle om activities. They are not in the right order. What
>>> can I do. How can I fix the issue?
>>>
>>> Thank you for help or any advice,
>>> Michael
>>>
>>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>>> According to the process only deleted files might be removed ....
>>> can you check if these files are still in the DB? (fileexploreritem
>>>
>>> table, you can check by filehash and/of filename)
>>>
>>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>>> <mw...@beuth-hochschule.de> wrote:
>>>
>>> Hello,
>>>
>>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>>> the
>>> CLI. I used the "Detailed steps" how to for that upgrade.
>>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>>
>>> After the upgrade some uploaded files are not available any longer
>>> in
>>> the rooms or at the witheboards. In the log files there were no
>>> error
>>> messages.
>>>
>>> Has anybody an idea how I can find the missing files? I made a
>>> backup of
>>> the old database and the red5 folder with all the data and the
>>> logs.
>>>
>>> Greetings,
>>> Michael
>>>
>>> --
>>> WBR
>>> Maxim aka solomax
>>>
>>> Links:
>>> ------
>>> [1] http://openmeetings.apache.org/Upgrade.html [1]
>>
>> --
>> B.Sc. Peter Dähn
>> Virtueller Campus Rheinland-Pfalz [2]
>> Postfach 3049
>> 67653 Kaiserslautern
>> Tel: 0631/205-4944
>> Olat [3]
>>
>>
>> Links:
>> ------
>> [1] http://openmeetings.apache.org/Upgrade.html
>> [2] http://www.vcrp.de/
>> [3] https://olat.vcrp.de/
>
>
>
Re: after upgrade of OM (version 2.1.1 to 3.0.1) some files are
missing
Posted by Michael Wuttke <mw...@beuth-hochschule.de>.
Hello Peter,
sorry, but in this case I am using mysql for both: moodle and
openmeetings.
But thank you for your quick reply.
Michael
Am 2.5.2014 13:09, schrieb Peter Dähn:
> Hello together,
>
> could be the problem witht the postgres export...
>
> What kind o database do you use?
>
> BR Peter
>
> Am 02.05.2014 12:50, schrieb Michael Wuttke:
>
>> Hello Maxim,
>>
>> ok, I checked the databases (the database before the upgrade und
>> the database after the upgrade) and the red5 folders (version 2.1.1
>> and 3.0.1). In both databases are same entries of users, of rooms
>> and of files (items in the fileexploreritem table). In both red5
>> folders are the same number of files (in the upload folder). In the
>> OM installation I have more than 500 users, more then 200 rooms- all
>> created & managed via moodle - and more than 750 files uploaded into
>> the rooms/witheboards. Ok, all the users, rooms and files still
>> exists afte the upgrade. But the OM rooms are not linked to the
>> right moodle om activities. They are not in the right order. What
>> can I do. How can I fix the issue?
>>
>> Thank you for help or any advice,
>> Michael
>>
>> Am 30.4.2014 04:19, schrieb Maxim Solodovnik:
>> According to the process only deleted files might be removed ....
>> can you check if these files are still in the DB? (fileexploreritem
>>
>> table, you can check by filehash and/of filename)
>>
>> On Wed, Apr 30, 2014 at 2:50 AM, Michael Wuttke
>> <mw...@beuth-hochschule.de> wrote:
>>
>> Hello,
>>
>> I've upgraded an OM Server from version 2.1.1 to version 3.0.1 via
>> the
>> CLI. I used the "Detailed steps" how to for that upgrade.
>> http://openmeetings.apache.org/Upgrade.html [1] [1]
>>
>> After the upgrade some uploaded files are not available any longer
>> in
>> the rooms or at the witheboards. In the log files there were no
>> error
>> messages.
>>
>> Has anybody an idea how I can find the missing files? I made a
>> backup of
>> the old database and the red5 folder with all the data and the
>> logs.
>>
>> Greetings,
>> Michael
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>> Links:
>> ------
>> [1] http://openmeetings.apache.org/Upgrade.html [1]
>
> --
> B.Sc. Peter Dähn
> Virtueller Campus Rheinland-Pfalz [2]
> Postfach 3049
> 67653 Kaiserslautern
> Tel: 0631/205-4944
> Olat [3]
>
>
> Links:
> ------
> [1] http://openmeetings.apache.org/Upgrade.html
> [2] http://www.vcrp.de/
> [3] https://olat.vcrp.de/