You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

 

The users list includes a "system user" that is only used by ProVision internally in the application.

 

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.


Please make sure that URL rewriting is enabled in your instance (apache mod_rewrite)

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

BACKUP 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:

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:

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.

 

 



  • No labels