You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by aa...@gmail.com on 2018/09/21 19:25:04 UTC

Imports with different databases

I just stood up a new "official Release" server to do some testing.  But
since I am doing this on a local Windows box I just used the built in Derby
database.  Well I have back-up from my production box which uses MySQL.
Upon importing from my running server I notice that it imported the "purged"
data as well.  Was this just due to the different databases, or is this a
bug?

 

Reason for the testing is the move to my new CSM frontend but decided that
using invitation links is not the best choice being you can delete and purge
the user but if the invitation was endless it stays functioning.  So I
decided to try creating the links via REST but now having issues trying to
create the room hash(s) from the previous email thread Dhanashree posted.  I
can obtain the sid but I am not able to create a hash.  I would say it is me
having he issue as not very proficient in this area so if anyone if more
versed in that area and would want to lend some information it would be
helpful.

 

 

 

 

 

 


Re: Imports with different databases

Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks Aaron,

I got notification :)
Will take a look ASAP :)

On Sun, 23 Sep 2018 at 16:30, Aaron H <aa...@gmail.com> wrote:

> Jira created - 1938
>
>
>
> *From:* Maxim Solodovnik <so...@gmail.com>
> *Sent:* Saturday, September 22, 2018 10:33 PM
> *To:* Openmeetings user-list <us...@openmeetings.apache.org>
> *Subject:* Re: Imports with different databases
>
>
>
> Hello Aaron,
>
>
>
> historically all possible records are being restored, later on I've added
> some filtering
>
> Can you please create JIRA and provide some test backup?
>
> I'll try to handle it ASAP
>
>
>
>
>
> On Sat, 22 Sep 2018 at 03:13, <aa...@gmail.com> wrote:
>
> Just checked with my production system using MySQL and a new install and
> the purged data was imported.  So it was not due to different database
> types.  It imports purged data.
>
>
>
> *From:* aaron.hepp@gmail.com <aa...@gmail.com>
> *Sent:* Friday, September 21, 2018 3:25 PM
> *To:* user@openmeetings.apache.org
> *Subject:* Imports with different databases
>
>
>
> I just stood up a new “official Release” server to do some testing.  But
> since I am doing this on a local Windows box I just used the built in Derby
> database.  Well I have back-up from my production box which uses MySQL.
> Upon importing from my running server I notice that it imported the
> “purged” data as well.  Was this just due to the different databases, or is
> this a bug?
>
>
>
> Reason for the testing is the move to my new CSM frontend but decided that
> using invitation links is not the best choice being you can delete and
> purge the user but if the invitation was endless it stays functioning.  So
> I decided to try creating the links via REST but now having issues trying
> to create the room hash(s) from the previous email thread Dhanashree
> posted.  I can obtain the sid but I am not able to create a hash.  I would
> say it is me having he issue as not very proficient in this area so if
> anyone if more versed in that area and would want to lend some information
> it would be helpful.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>


-- 
WBR
Maxim aka solomax

RE: Imports with different databases

Posted by Aaron H <aa...@gmail.com>.
Jira created - 1938

 

From: Maxim Solodovnik <so...@gmail.com> 
Sent: Saturday, September 22, 2018 10:33 PM
To: Openmeetings user-list <us...@openmeetings.apache.org>
Subject: Re: Imports with different databases

 

Hello Aaron,

 

historically all possible records are being restored, later on I've added some filtering

Can you please create JIRA and provide some test backup?

I'll try to handle it ASAP

 

 

On Sat, 22 Sep 2018 at 03:13, <aaron.hepp@gmail.com <ma...@gmail.com> > wrote:

Just checked with my production system using MySQL and a new install and the purged data was imported.  So it was not due to different database types.  It imports purged data.

 

From: aaron.hepp@gmail.com <ma...@gmail.com>  <aaron.hepp@gmail.com <ma...@gmail.com> > 
Sent: Friday, September 21, 2018 3:25 PM
To: user@openmeetings.apache.org <ma...@openmeetings.apache.org> 
Subject: Imports with different databases

 

I just stood up a new “official Release” server to do some testing.  But since I am doing this on a local Windows box I just used the built in Derby database.  Well I have back-up from my production box which uses MySQL.  Upon importing from my running server I notice that it imported the “purged” data as well.  Was this just due to the different databases, or is this a bug?

 

Reason for the testing is the move to my new CSM frontend but decided that using invitation links is not the best choice being you can delete and purge the user but if the invitation was endless it stays functioning.  So I decided to try creating the links via REST but now having issues trying to create the room hash(s) from the previous email thread Dhanashree posted.  I can obtain the sid but I am not able to create a hash.  I would say it is me having he issue as not very proficient in this area so if anyone if more versed in that area and would want to lend some information it would be helpful.

 

 

 

 

 

 




 

-- 

WBR
Maxim aka solomax


Re: Imports with different databases

Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Aaron,

historically all possible records are being restored, later on I've added
some filtering
Can you please create JIRA and provide some test backup?
I'll try to handle it ASAP


On Sat, 22 Sep 2018 at 03:13, <aa...@gmail.com> wrote:

> Just checked with my production system using MySQL and a new install and
> the purged data was imported.  So it was not due to different database
> types.  It imports purged data.
>
>
>
> *From:* aaron.hepp@gmail.com <aa...@gmail.com>
> *Sent:* Friday, September 21, 2018 3:25 PM
> *To:* user@openmeetings.apache.org
> *Subject:* Imports with different databases
>
>
>
> I just stood up a new “official Release” server to do some testing.  But
> since I am doing this on a local Windows box I just used the built in Derby
> database.  Well I have back-up from my production box which uses MySQL.
> Upon importing from my running server I notice that it imported the
> “purged” data as well.  Was this just due to the different databases, or is
> this a bug?
>
>
>
> Reason for the testing is the move to my new CSM frontend but decided that
> using invitation links is not the best choice being you can delete and
> purge the user but if the invitation was endless it stays functioning.  So
> I decided to try creating the links via REST but now having issues trying
> to create the room hash(s) from the previous email thread Dhanashree
> posted.  I can obtain the sid but I am not able to create a hash.  I would
> say it is me having he issue as not very proficient in this area so if
> anyone if more versed in that area and would want to lend some information
> it would be helpful.
>
>
>
>
>
>
>
>
>
>
>
>
>


-- 
WBR
Maxim aka solomax

RE: Imports with different databases

Posted by aa...@gmail.com.
Just checked with my production system using MySQL and a new install and the
purged data was imported.  So it was not due to different database types.
It imports purged data.

 

From: aaron.hepp@gmail.com <aa...@gmail.com> 
Sent: Friday, September 21, 2018 3:25 PM
To: user@openmeetings.apache.org
Subject: Imports with different databases

 

I just stood up a new "official Release" server to do some testing.  But
since I am doing this on a local Windows box I just used the built in Derby
database.  Well I have back-up from my production box which uses MySQL.
Upon importing from my running server I notice that it imported the "purged"
data as well.  Was this just due to the different databases, or is this a
bug?

 

Reason for the testing is the move to my new CSM frontend but decided that
using invitation links is not the best choice being you can delete and purge
the user but if the invitation was endless it stays functioning.  So I
decided to try creating the links via REST but now having issues trying to
create the room hash(s) from the previous email thread Dhanashree posted.  I
can obtain the sid but I am not able to create a hash.  I would say it is me
having he issue as not very proficient in this area so if anyone if more
versed in that area and would want to lend some information it would be
helpful.