You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Robert Chalmers <ra...@gmail.com> on 2013/03/30 15:52:43 UTC
backup/import - found the problem
Sorry guys - in fact - it did import the data, but now I have two admin
users.
So I'll have to get rid of one I suppose. Somehow.
But yes, it does appear to have imported the data ok.
--
<https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>*Pin
Point Xtra*
*Your Navigation and Geocaching Companion*
Re: backup/import - found the problem
Posted by Maxim Solodovnik <so...@gmail.com>.
I would vote for adding option to install: install using backup file (for
GUI users) this will resolve all possible issues except for DB drop (which
currently is not working)
On Sun, Mar 31, 2013 at 3:29 PM, Alexei Fedotov <al...@gmail.com>wrote:
> +1 for renaming
> 31.03.2013 1:13 пользователь "seba.wagner@gmail.com" <
> seba.wagner@gmail.com> написал:
>
> The consequence will be that all uploaded files, recordings and private
>> messages for that user will be also skipped.
>> And all other imported data has to be scanned if this userId is set
>> somewhere else as a foreign key to make sure that data is skipped too.
>> So you really think its better to loose some of the data of your backup?
>> I would not magically skip data of the backup. Cause the next complaint
>> on this user mailing list will then be:
>> "I have imported a backup but I lost some data by the import process."
>>
>> I would rather rename the imported user login. For example with the
>> pattern:
>> user.login += "_x" .Where x is the number of duplicates that exist with
>> that name.
>> So a user admin will become admin_1, if admin_1 also exists it will
>> become admin_2, admin_3, et cetera.
>> Some for the email as emails are unique.
>> But email and login are only unique if the externalUserId is null (or in
>> other words: A SOAP login / user created through SOAP login can be
>> duplicated a 1000 times. They are unique by their externalUserId. But they
>> can't login via the general UI because of that.).
>> So the rule would be:
>> if (user.externalUserId == null) {
>> //check user.login => unique
>> //check user.address.email => unique
>> //this check has always to happen on the basis if already imported data
>> in the database,
>> //as you can potentially create a duplicate by importing
>> //two users with already duplicated credentials.
>> }
>>
>> Sebastian
>>
>>
>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>
>>> Maybe that particular user admin should be skipped during backup.
>>> 31.03.2013 0:37 пользователь "seba.wagner@gmail.com" <
>>> seba.wagner@gmail.com> написал:
>>>
>>> how do you suggest to resolve that?
>>>>
>>>>
>>>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>>>
>>>>> Imagine a guy who have just set his admin password via install
>>>>> interface. Then he imports backup, restarts the page... and can no longer
>>>>> login.
>>>>> 31.03.2013 0:18 пользователь "seba.wagner@gmail.com" <
>>>>> seba.wagner@gmail.com> написал:
>>>>>
>>>>> That is not a bug from my point of view. How should that exactly be
>>>>>> resolved?
>>>>>> If you create a user and then import the backup where this user
>>>>>> exists, which one will "win" ?
>>>>>> There will be simply two users with the same name currently.
>>>>>> So either you make sure you do your installation with a user that
>>>>>> does not exist in the backup and delete it after the backup. Or you use the
>>>>>> command line to import without duplicates.
>>>>>>
>>>>>> @Robert: Try the command line to do the import.
>>>>>>
>>>>>> Sebastian
>>>>>>
>>>>>>
>>>>>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>>>>>
>>>>>>> Robert, this is known issue, please file a bug
>>>>>>> 30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com>
>>>>>>> написал:
>>>>>>>
>>>>>>> Sorry guys - in fact - it did import the data, but now I have two
>>>>>>>> admin users.
>>>>>>>> So I'll have to get rid of one I suppose. Somehow.
>>>>>>>>
>>>>>>>> But yes, it does appear to have imported the data ok.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>
>>>>>>>> *Pin Point Xtra*
>>>>>>>> *Your Navigation and Geocaching Companion*
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Sebastian Wagner
>>>>>> https://twitter.com/#!/dead_lock
>>>>>> http://www.webbase-design.de
>>>>>> http://www.wagner-sebastian.com
>>>>>> seba.wagner@gmail.com
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Sebastian Wagner
>>>> https://twitter.com/#!/dead_lock
>>>> http://www.webbase-design.de
>>>> http://www.wagner-sebastian.com
>>>> seba.wagner@gmail.com
>>>>
>>>
>>
>>
>> --
>> Sebastian Wagner
>> https://twitter.com/#!/dead_lock
>> http://www.webbase-design.de
>> http://www.wagner-sebastian.com
>> seba.wagner@gmail.com
>>
>
--
WBR
Maxim aka solomax
Re: backup/import - found the problem
Posted by Alexei Fedotov <al...@gmail.com>.
+1 for renaming
31.03.2013 1:13 пользователь "seba.wagner@gmail.com" <se...@gmail.com>
написал:
> The consequence will be that all uploaded files, recordings and private
> messages for that user will be also skipped.
> And all other imported data has to be scanned if this userId is set
> somewhere else as a foreign key to make sure that data is skipped too.
> So you really think its better to loose some of the data of your backup?
> I would not magically skip data of the backup. Cause the next complaint on
> this user mailing list will then be:
> "I have imported a backup but I lost some data by the import process."
>
> I would rather rename the imported user login. For example with the
> pattern:
> user.login += "_x" .Where x is the number of duplicates that exist with
> that name.
> So a user admin will become admin_1, if admin_1 also exists it will become
> admin_2, admin_3, et cetera.
> Some for the email as emails are unique.
> But email and login are only unique if the externalUserId is null (or in
> other words: A SOAP login / user created through SOAP login can be
> duplicated a 1000 times. They are unique by their externalUserId. But they
> can't login via the general UI because of that.).
> So the rule would be:
> if (user.externalUserId == null) {
> //check user.login => unique
> //check user.address.email => unique
> //this check has always to happen on the basis if already imported data
> in the database,
> //as you can potentially create a duplicate by importing
> //two users with already duplicated credentials.
> }
>
> Sebastian
>
>
> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>
>> Maybe that particular user admin should be skipped during backup.
>> 31.03.2013 0:37 пользователь "seba.wagner@gmail.com" <
>> seba.wagner@gmail.com> написал:
>>
>> how do you suggest to resolve that?
>>>
>>>
>>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>>
>>>> Imagine a guy who have just set his admin password via install
>>>> interface. Then he imports backup, restarts the page... and can no longer
>>>> login.
>>>> 31.03.2013 0:18 пользователь "seba.wagner@gmail.com" <
>>>> seba.wagner@gmail.com> написал:
>>>>
>>>> That is not a bug from my point of view. How should that exactly be
>>>>> resolved?
>>>>> If you create a user and then import the backup where this user
>>>>> exists, which one will "win" ?
>>>>> There will be simply two users with the same name currently.
>>>>> So either you make sure you do your installation with a user that does
>>>>> not exist in the backup and delete it after the backup. Or you use the
>>>>> command line to import without duplicates.
>>>>>
>>>>> @Robert: Try the command line to do the import.
>>>>>
>>>>> Sebastian
>>>>>
>>>>>
>>>>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>>>>
>>>>>> Robert, this is known issue, please file a bug
>>>>>> 30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com>
>>>>>> написал:
>>>>>>
>>>>>> Sorry guys - in fact - it did import the data, but now I have two
>>>>>>> admin users.
>>>>>>> So I'll have to get rid of one I suppose. Somehow.
>>>>>>>
>>>>>>> But yes, it does appear to have imported the data ok.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>
>>>>>>> *Pin Point Xtra*
>>>>>>> *Your Navigation and Geocaching Companion*
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Sebastian Wagner
>>>>> https://twitter.com/#!/dead_lock
>>>>> http://www.webbase-design.de
>>>>> http://www.wagner-sebastian.com
>>>>> seba.wagner@gmail.com
>>>>>
>>>>
>>>
>>>
>>> --
>>> Sebastian Wagner
>>> https://twitter.com/#!/dead_lock
>>> http://www.webbase-design.de
>>> http://www.wagner-sebastian.com
>>> seba.wagner@gmail.com
>>>
>>
>
>
> --
> Sebastian Wagner
> https://twitter.com/#!/dead_lock
> http://www.webbase-design.de
> http://www.wagner-sebastian.com
> seba.wagner@gmail.com
>
Re: backup/import - found the problem
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
The consequence will be that all uploaded files, recordings and private
messages for that user will be also skipped.
And all other imported data has to be scanned if this userId is set
somewhere else as a foreign key to make sure that data is skipped too.
So you really think its better to loose some of the data of your backup?
I would not magically skip data of the backup. Cause the next complaint on
this user mailing list will then be:
"I have imported a backup but I lost some data by the import process."
I would rather rename the imported user login. For example with the pattern:
user.login += "_x" .Where x is the number of duplicates that exist with
that name.
So a user admin will become admin_1, if admin_1 also exists it will become
admin_2, admin_3, et cetera.
Some for the email as emails are unique.
But email and login are only unique if the externalUserId is null (or in
other words: A SOAP login / user created through SOAP login can be
duplicated a 1000 times. They are unique by their externalUserId. But they
can't login via the general UI because of that.).
So the rule would be:
if (user.externalUserId == null) {
//check user.login => unique
//check user.address.email => unique
//this check has always to happen on the basis if already imported data
in the database,
//as you can potentially create a duplicate by importing
//two users with already duplicated credentials.
}
Sebastian
2013/3/31 Alexei Fedotov <al...@gmail.com>
> Maybe that particular user admin should be skipped during backup.
> 31.03.2013 0:37 пользователь "seba.wagner@gmail.com" <
> seba.wagner@gmail.com> написал:
>
> how do you suggest to resolve that?
>>
>>
>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>
>>> Imagine a guy who have just set his admin password via install
>>> interface. Then he imports backup, restarts the page... and can no longer
>>> login.
>>> 31.03.2013 0:18 пользователь "seba.wagner@gmail.com" <
>>> seba.wagner@gmail.com> написал:
>>>
>>> That is not a bug from my point of view. How should that exactly be
>>>> resolved?
>>>> If you create a user and then import the backup where this user exists,
>>>> which one will "win" ?
>>>> There will be simply two users with the same name currently.
>>>> So either you make sure you do your installation with a user that does
>>>> not exist in the backup and delete it after the backup. Or you use the
>>>> command line to import without duplicates.
>>>>
>>>> @Robert: Try the command line to do the import.
>>>>
>>>> Sebastian
>>>>
>>>>
>>>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>>>
>>>>> Robert, this is known issue, please file a bug
>>>>> 30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com>
>>>>> написал:
>>>>>
>>>>> Sorry guys - in fact - it did import the data, but now I have two
>>>>>> admin users.
>>>>>> So I'll have to get rid of one I suppose. Somehow.
>>>>>>
>>>>>> But yes, it does appear to have imported the data ok.
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>*Pin
>>>>>> Point Xtra*
>>>>>> *Your Navigation and Geocaching Companion*
>>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Sebastian Wagner
>>>> https://twitter.com/#!/dead_lock
>>>> http://www.webbase-design.de
>>>> http://www.wagner-sebastian.com
>>>> seba.wagner@gmail.com
>>>>
>>>
>>
>>
>> --
>> Sebastian Wagner
>> https://twitter.com/#!/dead_lock
>> http://www.webbase-design.de
>> http://www.wagner-sebastian.com
>> seba.wagner@gmail.com
>>
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Re: backup/import - found the problem
Posted by Alexei Fedotov <al...@gmail.com>.
Maybe that particular user admin should be skipped during backup.
31.03.2013 0:37 пользователь "seba.wagner@gmail.com" <se...@gmail.com>
написал:
> how do you suggest to resolve that?
>
>
> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>
>> Imagine a guy who have just set his admin password via install interface.
>> Then he imports backup, restarts the page... and can no longer login.
>> 31.03.2013 0:18 пользователь "seba.wagner@gmail.com" <
>> seba.wagner@gmail.com> написал:
>>
>> That is not a bug from my point of view. How should that exactly be
>>> resolved?
>>> If you create a user and then import the backup where this user exists,
>>> which one will "win" ?
>>> There will be simply two users with the same name currently.
>>> So either you make sure you do your installation with a user that does
>>> not exist in the backup and delete it after the backup. Or you use the
>>> command line to import without duplicates.
>>>
>>> @Robert: Try the command line to do the import.
>>>
>>> Sebastian
>>>
>>>
>>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>>
>>>> Robert, this is known issue, please file a bug
>>>> 30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com>
>>>> написал:
>>>>
>>>> Sorry guys - in fact - it did import the data, but now I have two admin
>>>>> users.
>>>>> So I'll have to get rid of one I suppose. Somehow.
>>>>>
>>>>> But yes, it does appear to have imported the data ok.
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>*Pin
>>>>> Point Xtra*
>>>>> *Your Navigation and Geocaching Companion*
>>>>>
>>>>
>>>
>>>
>>> --
>>> Sebastian Wagner
>>> https://twitter.com/#!/dead_lock
>>> http://www.webbase-design.de
>>> http://www.wagner-sebastian.com
>>> seba.wagner@gmail.com
>>>
>>
>
>
> --
> Sebastian Wagner
> https://twitter.com/#!/dead_lock
> http://www.webbase-design.de
> http://www.wagner-sebastian.com
> seba.wagner@gmail.com
>
Re: backup/import - found the problem
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
how do you suggest to resolve that?
2013/3/31 Alexei Fedotov <al...@gmail.com>
> Imagine a guy who have just set his admin password via install interface.
> Then he imports backup, restarts the page... and can no longer login.
> 31.03.2013 0:18 пользователь "seba.wagner@gmail.com" <
> seba.wagner@gmail.com> написал:
>
> That is not a bug from my point of view. How should that exactly be
>> resolved?
>> If you create a user and then import the backup where this user exists,
>> which one will "win" ?
>> There will be simply two users with the same name currently.
>> So either you make sure you do your installation with a user that does
>> not exist in the backup and delete it after the backup. Or you use the
>> command line to import without duplicates.
>>
>> @Robert: Try the command line to do the import.
>>
>> Sebastian
>>
>>
>> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>>
>>> Robert, this is known issue, please file a bug
>>> 30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com>
>>> написал:
>>>
>>> Sorry guys - in fact - it did import the data, but now I have two admin
>>>> users.
>>>> So I'll have to get rid of one I suppose. Somehow.
>>>>
>>>> But yes, it does appear to have imported the data ok.
>>>>
>>>>
>>>>
>>>> --
>>>> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>*Pin
>>>> Point Xtra*
>>>> *Your Navigation and Geocaching Companion*
>>>>
>>>
>>
>>
>> --
>> Sebastian Wagner
>> https://twitter.com/#!/dead_lock
>> http://www.webbase-design.de
>> http://www.wagner-sebastian.com
>> seba.wagner@gmail.com
>>
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Re: backup/import - found the problem
Posted by Alexei Fedotov <al...@gmail.com>.
Imagine a guy who have just set his admin password via install interface.
Then he imports backup, restarts the page... and can no longer login.
31.03.2013 0:18 пользователь "seba.wagner@gmail.com" <se...@gmail.com>
написал:
> That is not a bug from my point of view. How should that exactly be
> resolved?
> If you create a user and then import the backup where this user exists,
> which one will "win" ?
> There will be simply two users with the same name currently.
> So either you make sure you do your installation with a user that does not
> exist in the backup and delete it after the backup. Or you use the command
> line to import without duplicates.
>
> @Robert: Try the command line to do the import.
>
> Sebastian
>
>
> 2013/3/31 Alexei Fedotov <al...@gmail.com>
>
>> Robert, this is known issue, please file a bug
>> 30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com>
>> написал:
>>
>> Sorry guys - in fact - it did import the data, but now I have two admin
>>> users.
>>> So I'll have to get rid of one I suppose. Somehow.
>>>
>>> But yes, it does appear to have imported the data ok.
>>>
>>>
>>>
>>> --
>>> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>*Pin
>>> Point Xtra*
>>> *Your Navigation and Geocaching Companion*
>>>
>>
>
>
> --
> Sebastian Wagner
> https://twitter.com/#!/dead_lock
> http://www.webbase-design.de
> http://www.wagner-sebastian.com
> seba.wagner@gmail.com
>
Re: backup/import - found the problem
Posted by "seba.wagner@gmail.com" <se...@gmail.com>.
That is not a bug from my point of view. How should that exactly be
resolved?
If you create a user and then import the backup where this user exists,
which one will "win" ?
There will be simply two users with the same name currently.
So either you make sure you do your installation with a user that does not
exist in the backup and delete it after the backup. Or you use the command
line to import without duplicates.
@Robert: Try the command line to do the import.
Sebastian
2013/3/31 Alexei Fedotov <al...@gmail.com>
> Robert, this is known issue, please file a bug
> 30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com>
> написал:
>
> Sorry guys - in fact - it did import the data, but now I have two admin
>> users.
>> So I'll have to get rid of one I suppose. Somehow.
>>
>> But yes, it does appear to have imported the data ok.
>>
>>
>>
>> --
>> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>*Pin
>> Point Xtra*
>> *Your Navigation and Geocaching Companion*
>>
>
--
Sebastian Wagner
https://twitter.com/#!/dead_lock
http://www.webbase-design.de
http://www.wagner-sebastian.com
seba.wagner@gmail.com
Re: backup/import - found the problem
Posted by Alexei Fedotov <al...@gmail.com>.
Robert, this is known issue, please file a bug
30.03.2013 18:53 пользователь "Robert Chalmers" <ra...@gmail.com> написал:
> Sorry guys - in fact - it did import the data, but now I have two admin
> users.
> So I'll have to get rid of one I suppose. Somehow.
>
> But yes, it does appear to have imported the data ok.
>
>
>
> --
> <https://itunes.apple.com/us/app/pin-point-premium/id467970377?mt=8>*Pin
> Point Xtra*
> *Your Navigation and Geocaching Companion*
>