Copy from an environment to another: user admin doesn't exist anymore

[Guillaume Lucazeau <gl...@gmail.com>]

Hello,

I would like to know the procedure to duplicate a whole Sling environment,
with data stored in an Oracle DB.

I thought a copy of the database, and a copy of the Jackrabbit folder in
Sling home was enough (with an update on the DB connections in
repository.xml file), but told my client that I had no real knowledge about
this and we would need to test with a sample environment. Unfortunately,
they did not and directly tried to load production data into a test
environment, following this method.

They quickly realized that when they deleted a node on the newly created
test environment, the same node had been actually deleted on prodution too.

That leads to another issue : they then reloaded a backup of the production
database (more like rollbacked latest queries apparently), without stopping
the JBoss containing the Sling server... now the data are back with just
one problem: it is no longer possible to log in as "admin" user, as I can
see that in the logs:

org.apache.jackrabbit.core.security.user.UserManagerImpl Admin user
does not exist.
org.apache.jackrabbit.core.security.authentication.DefaultLoginModule
Error while retrieving principal.
org.apache.sling.extensions.webconsolesecurityprovider.internal.SlingWebConsoleSecurityProvider
authenticate: User admin failed to authenticate with the repository
for Web Console access
javax.jcr.LoginException: LoginModule ignored Credentials

So if you could please tell me :

- what configuration needs to be updated when you're duplicating an environment

- how to fix or what to investigate for this "admin user" issue

I would really grateful

Thank you for your help!

Regards,

Guillaume

Re: Copy from an environment to another: user admin doesn't exist anymore

[Guillaume Lucazeau <gl...@gmail.com>]

Thank you Robert for these information,

From quick tests, backuping the Sling home directory (we're using Sling war
in JBoss and not the launchpad), changing DB connexion information in every
Jackrabbit config file and then reloading a DB dump seems to work.

Regards,
Guillaume

On Sat, Oct 15, 2016 at 4:03 PM, Robert Munteanu <ro...@apache.org> wrote:

> Hi Guillaume,
>
> On Fri, 2016-10-14 at 15:09 +0200, Guillaume Lucazeau wrote:
> > Reindexing everything fixed the issue with admin user.
> >
> > Now I'm very curious to get information about backuping and reloading
> > JCR
> > content (only) from an environment to another, and also on full
> > environment
> > backup/restore. I'm going to try on sample environments but would be
> > interested in any experience you could have on this topic.
>
> For a standard Sling setup it should be enough to back up everything
> under sling.home. The persistence is something else though, as you
> noticed.
>
>
> For Jackrabbit 2.x there isn't a single tool. The documentation entry
> point is [1] .
>
> For Jackrabbit Oak you should use oak-run [2].
>
> Hope this helps,
>
> Robert
>
> [1]: http://wiki.apache.org/jackrabbit/BackupAndMigration
> [2]: http://jackrabbit.apache.org/oak/docs/command_line.html
> >
> > Thank you
> > Guillaume
> >
> > On Fri, Oct 14, 2016 at 2:01 PM, Guillaume Lucazeau <glucazeau@gmail.
> > com>
> > wrote:
> >
> > > Hello,
> > >
> > > I would like to know the procedure to duplicate a whole Sling
> > > environment,
> > > with data stored in an Oracle DB.
> > >
> > > I thought a copy of the database, and a copy of the Jackrabbit
> > > folder in
> > > Sling home was enough (with an update on the DB connections in
> > > repository.xml file), but told my client that I had no real
> > > knowledge about
> > > this and we would need to test with a sample environment.
> > > Unfortunately,
> > > they did not and directly tried to load production data into a test
> > > environment, following this method.
> > >
> > > They quickly realized that when they deleted a node on the newly
> > > created
> > > test environment, the same node had been actually deleted on
> > > prodution too.
> > >
> > > That leads to another issue : they then reloaded a backup of the
> > > production database (more like rollbacked latest queries
> > > apparently),
> > > without stopping the JBoss containing the Sling server... now the
> > > data are
> > > back with just one problem: it is no longer possible to log in as
> > > "admin"
> > > user, as I can see that in the logs:
> > >
> > > org.apache.jackrabbit.core.security.user.UserManagerImpl Admin user
> > > does not exist.
> > > org.apache.jackrabbit.core.security.authentication.DefaultLoginModu
> > > le Error while retrieving principal.
> > > org.apache.sling.extensions.webconsolesecurityprovider.internal.Sli
> > > ngWebConsoleSecurityProvider authenticate: User admin failed to
> > > authenticate with the repository for Web Console access
> > > javax.jcr.LoginException: LoginModule ignored Credentials
> > >
> > > So if you could please tell me :
> > >
> > > - what configuration needs to be updated when you're duplicating an
> > > environment
> > >
> > > - how to fix or what to investigate for this "admin user" issue
> > >
> > > I would really grateful
> > >
> > > Thank you for your help!
> > >
> > > Regards,
> > >
> > > Guillaume
> > >
> > >
>
>

Re: Copy from an environment to another: user admin doesn't exist anymore

[Robert Munteanu <ro...@apache.org>]

Hi Guillaume,

On Fri, 2016-10-14 at 15:09 +0200, Guillaume Lucazeau wrote:
> Reindexing everything fixed the issue with admin user.
> 
> Now I'm very curious to get information about backuping and reloading
> JCR
> content (only) from an environment to another, and also on full
> environment
> backup/restore. I'm going to try on sample environments but would be
> interested in any experience you could have on this topic.

For a standard Sling setup it should be enough to back up everything
under sling.home. The persistence is something else though, as you
noticed.


For Jackrabbit 2.x there isn't a single tool. The documentation entry
point is [1] .

For Jackrabbit Oak you should use oak-run [2].

Hope this helps,

Robert

[1]:�http://wiki.apache.org/jackrabbit/BackupAndMigration
[2]:�http://jackrabbit.apache.org/oak/docs/command_line.html
> 
> Thank you
> Guillaume
> 
> On Fri, Oct 14, 2016 at 2:01 PM, Guillaume Lucazeau <glucazeau@gmail.
> com>
> wrote:
> 
> > Hello,
> > 
> > I would like to know the procedure to duplicate a whole Sling
> > environment,
> > with data stored in an Oracle DB.
> > 
> > I thought a copy of the database, and a copy of the Jackrabbit
> > folder in
> > Sling home was enough (with an update on the DB connections in
> > repository.xml file), but told my client that I had no real
> > knowledge about
> > this and we would need to test with a sample environment.
> > Unfortunately,
> > they did not and directly tried to load production data into a test
> > environment, following this method.
> > 
> > They quickly realized that when they deleted a node on the newly
> > created
> > test environment, the same node had been actually deleted on
> > prodution too.
> > 
> > That leads to another issue : they then reloaded a backup of the
> > production database (more like rollbacked latest queries
> > apparently),
> > without stopping the JBoss containing the Sling server... now the
> > data are
> > back with just one problem: it is no longer possible to log in as
> > "admin"
> > user, as I can see that in the logs:
> > 
> > org.apache.jackrabbit.core.security.user.UserManagerImpl Admin user
> > does not exist.
> > org.apache.jackrabbit.core.security.authentication.DefaultLoginModu
> > le Error while retrieving principal.
> > org.apache.sling.extensions.webconsolesecurityprovider.internal.Sli
> > ngWebConsoleSecurityProvider authenticate: User admin failed to
> > authenticate with the repository for Web Console access
> > javax.jcr.LoginException: LoginModule ignored Credentials
> > 
> > So if you could please tell me :
> > 
> > - what configuration needs to be updated when you're duplicating an
> > environment
> > 
> > - how to fix or what to investigate for this "admin user" issue
> > 
> > I would really grateful
> > 
> > Thank you for your help!
> > 
> > Regards,
> > 
> > Guillaume
> > 
> > 

Re: Copy from an environment to another: user admin doesn't exist anymore

[Guillaume Lucazeau <gl...@gmail.com>]

Reindexing everything fixed the issue with admin user.

Now I'm very curious to get information about backuping and reloading JCR
content (only) from an environment to another, and also on full environment
backup/restore. I'm going to try on sample environments but would be
interested in any experience you could have on this topic.

Thank you
Guillaume

On Fri, Oct 14, 2016 at 2:01 PM, Guillaume Lucazeau <gl...@gmail.com>
wrote:

> Hello,
>
> I would like to know the procedure to duplicate a whole Sling environment,
> with data stored in an Oracle DB.
>
> I thought a copy of the database, and a copy of the Jackrabbit folder in
> Sling home was enough (with an update on the DB connections in
> repository.xml file), but told my client that I had no real knowledge about
> this and we would need to test with a sample environment. Unfortunately,
> they did not and directly tried to load production data into a test
> environment, following this method.
>
> They quickly realized that when they deleted a node on the newly created
> test environment, the same node had been actually deleted on prodution too.
>
> That leads to another issue : they then reloaded a backup of the
> production database (more like rollbacked latest queries apparently),
> without stopping the JBoss containing the Sling server... now the data are
> back with just one problem: it is no longer possible to log in as "admin"
> user, as I can see that in the logs:
>
> org.apache.jackrabbit.core.security.user.UserManagerImpl Admin user does not exist.
> org.apache.jackrabbit.core.security.authentication.DefaultLoginModule Error while retrieving principal.
> org.apache.sling.extensions.webconsolesecurityprovider.internal.SlingWebConsoleSecurityProvider authenticate: User admin failed to authenticate with the repository for Web Console access
> javax.jcr.LoginException: LoginModule ignored Credentials
>
> So if you could please tell me :
>
> - what configuration needs to be updated when you're duplicating an environment
>
> - how to fix or what to investigate for this "admin user" issue
>
> I would really grateful
>
> Thank you for your help!
>
> Regards,
>
> Guillaume
>
>
>