Security

 View Only
  • 1.  ClearPass 6.11 Insight db migration

    Posted Jul 13, 2023 06:44 AM
      |   view attached

    Hopefully this post is in the right place.

    I'm currently in the progress of creating a 6.11 ClearPass cluster and attempting to migrate the existing db's across from a. 6.10 node. I have already successfully moved across the tipsdb containing the configuration. 

    I am now trying to migrate the Insight db and not having much luck. I have the file and have uploaded it using the restore option (with restore insight db checked - see picture). However, the node just hangs with the message show below and the Insight data does not seem to be carried across. Any suggestions. 



  • 2.  RE: ClearPass 6.11 Insight db migration

    Posted Jul 13, 2023 11:53 AM

    I've not yet before restored only the Insight database, just as part of a restore and just assumed it would be good (so not checked). Is your database/backup large? With this screen it looks if the backup doesn't even finish uploading.

    With 'developer tools' in your browser you may follow what's happening and if the upload does complete.

    If there are no other people that have seen this, asking TAC to have a look may be worth trying.



    ------------------------------
    Herman Robers
    ------------------------
    If you have urgent issues, always contact your Aruba partner, distributor, or Aruba TAC Support. Check https://www.arubanetworks.com/support-services/contact-support/ for how to contact Aruba TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or Aruba Networks.

    In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.
    ------------------------------



  • 3.  RE: ClearPass 6.11 Insight db migration

    Posted Jul 14, 2023 04:38 AM
      |   view attached

    I've not yet before restored only the Insight database, just as part of a restore and just assumed it would be good (so not checked). Is your database/backup large? With this screen it looks if the backup doesn't even finish uploading.

    -Ok so you just do everything at once with the tipsdb (300MB), sessionlogdb (3GB) and Insightdb (3GB) as shown in the attached screenshot?

    -The backup doesn't even finish uploading, correct. I don't know if this is due to its size or another factor. I've left it for hours so I'm not convinced anything is happening. 

    With 'developer tools' in your browser you may follow what's happening and if the upload does complete.

    -Ok I'll try this, thanks. 

    If there are no other people that have seen this, asking TAC to have a look may be worth trying.

    -Thanks. 




  • 4.  RE: ClearPass 6.11 Insight db migration

    Posted Jul 17, 2023 08:37 AM

    Hi Herman, 

    I'm not having any luck using Chrome developer tools or using the inspect feature when using Safari/Chrome to monitor the upload progress. The page eventually just times out and nothing happens, no message of a successful upload etc. (which I do see when uploading the config file). 

    I haven't yet tried to backup everything all at once including tipsdb, session and Insight - that file would be roughly 7-8GB so may experience the same issue when restoring one of the nodes - as I suspect the size of the sessiondb alone (3-5GB) may be the issue?

    Thanks, Adam




  • 5.  RE: ClearPass 6.11 Insight db migration

    Posted Jul 20, 2023 12:39 PM

    Just migrated to 6.11 [from 6.9]  I had taken separate insight backup -  mine was ~ 2GB - but was signifigant time without feedback - assuming upload - but taking longer than I would expect - suspecting local network issue - but maybe it is "normal?"   Downloading the backup took 30 minutes....

    anyway the restore dialog progressed - but errored out - saying it needed to be uploaded to the node it was taken from....  insight is not running on my publisher - and only the publisher has "restore" option....

    then thought it might be since the backup was from 6.9 - so I attempted again with the "Ignore version mismatch" option checked - same error

    sorry no solution for you - but perhaps more details for aruba to look more seriously at this

    more concerned that appears insigthdb is not available to appexternal account?  insight is running - did I forget to turn a nob to activate it for appexternal access?




  • 6.  RE: ClearPass 6.11 Insight db migration

    Posted Jan 06, 2025 04:57 AM

    Old thread I know, but this may be useful to others:

    We had what sounds like the same issue when trying to restore Insight data - what we found was that if you use a password when taking the backup then you get a .zip file (which contains a .tar.gz). Uploading the .zip file failed, but creating the backup without password and uploading the tar.gz worked fine. Presumably we could have just unzipped the password protected file and used the tar.gz in that as well.

    Guy