Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DOC and version HG-8.3.1

...

Expand
titleHow can take a manual backup of ProVision?

From the command line in your ProVision instance, you can get a manual SQL backup using the following way:


Code Block
mysqldump -uUSER -pPASSWORD DATABASE > bkup.sql

You can get the values for USER, PASSWORD, and DATABASE by reading them from the following file:

Code Block
[ProVision Root]/data/globals.php

An example of a completed command:

Code Block
mysqldump -uroot -p6connectpSomething_DBPSWD qa_5_1_5 > bkup.sql

You can then use this .sql file to restore the old version should you need to revert the installation.

...

Expand
titleI have already SWIPed subnets to ARIN. What happens if I try to SWIP from ProVision, but the block is already SWIPed?

In the case when a user already has SWIPped blocks to ARIN, 6connect ProVision checks prior to actually performing a SWIP. In the process, if the IP block is already SWIPped, it will check for existing ARIN customer data and update the 6connect ProVision data to reflect what ARIN has on file. Once that is complete, the user can then perform a de-SWIP function using ProVision.

Expand
titleHow does 6connect ProVision avoid duplicate assignments or resolve conflicts?

When you make an API request to assign a block, if the block is already assigned to another resource, you will receive an error. If your process is to search for and then assign blocks, the Smart Assign API call may be very helpful. That call combines the search and assignment into one action.

...

Expand
titleMy DNS zone views aren't working as they should!

In some legacy instances we have seen zone record-view linkages come out of alignment and result in unexpected behavior.

Note
titleBACKUP YOUR DATABASE

Please note that the following mysql commands modify your database! Please take a backup copy of your database before performance any database modifications.

First, verify the error with the following mysql commands:

Code Block
languagephp
SELECT count(*) FROM `zone_server_linkage` as t1
INNER JOIN `records` as t2 ON t1.`zoneid` = t2.`zone_id`
INNER JOIN `dns_views` as t3 ON t1.`serverid` = t3.`server_id` AND 
`name` = '_6connectDefault'
LEFT JOIN `dns_view_record_linkage` as t4 ON t2.`id` = t4.`record_id` 
AND t3.`id` = t4.`view_id`
WHERE t4.`id` IS NULL;

If the reply comes back non-zero, then your database is most likely exhibiting unexpected behavior.

The following mysql commands will re-align all the record-view linkages:

Code Block
languagephp
INSERT INTO `dns_view_record_linkage` SELECT '', t2.`id` as `record_id`, 
t3.`id` as `view_id` FROM `zone_server_linkage` as t1
INNER JOIN `records` as t2 ON t1.`zoneid` = t2.`zone_id`
INNER JOIN `dns_views` as t3 ON t1.`serverid` = t3.`server_id` AND 
`name` = '_6connectDefault'
LEFT JOIN `dns_view_record_linkage` as t4 ON t2.`id` = t4.`record_id` 
AND t3.`id` = t4.`view_id`
WHERE t4.`id` IS NULL;

Contact support (support@6connect.com) if you have any additional questions or this does not resolve the issue.


...

Expand
titleHow do I change the URL of my ProVision instance?

Depending on your version of ProVision, you may need both steps. Edit the file ﹤6connect ﹤ProVision web root﹥/data/globals.php and:

1) Change the $hostname variable to the new value

2) Change the $base_url to the new value

Please note that you may also need to update the SSL certs, httpd settings, etc.

...