Facebook
Twitter
R
RickR
Guest
I'm not able to register domains through ResellOne API. I've contacted ResellOne but the problem resides in Plesk CBM. I'm using Windows Server 2008 R2, Plesk 10.4.4. I attempted create the domain myself through the store front functionality. The customer and domains were created in Plesk but the domains were not created on the Registrar's site through the Pleks / ResellOne API. I have set debugging to true and the results of re-running the event to register the domain has yielded the following results. I'm not seeing what I need to do to resolve this issue. Any help is appreciated very much.
Debug results - ( I can provide more... )
Calling: resellers.resellone.net on port: 52443 Connected to resellone The result: HTTP/1.1 200 OK Date: Thu, 19 Apr 2012 19:04:39 GMT Server: OpenSRS/XML-RSA Server Content-Length: 546 Content-Type: text/xml 0.9 XCP DOMAIN Data conversion error. Check the command 'sw_register' syntax REPLY 465 0 resellone ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["success"][0] = 0 ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errorCount"][0] = 2 ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][0]["title"][0] = Resellone Error: ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][0]["message"][0] = Data conversion error. Check the command 'sw_register' syntax ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][1]["title"][0] = Customer & Business Manager Module Error ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][1]["message"][0] = resellone: The MB Module Resellone failed to return data. ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["timestamp"][0] = 1334861625 found errors MBAPI 'ProcessRegistrar' command output: [0] = 0 3 ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data. ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module 1334861625 0 0 0 -1 1 -1 0 1 0 1 0 0 1 0 [MBAPI_ProcessRegistrarCommand:1]->xmlData = -1 1 -1 0 1 0 1 0 0 1 0 [MBAPI_ProcessRegistrarCommand:1]->input["mbapi"][0]["command"][0] = ProcessRegistrar [MBAPI_ProcessRegistrarCommand:1]->input["mbapi"][0]["subCommand"][0] = registerDomain ......
.....
[MBAPI_ProcessRegistrarCommand:1]->params["tldSettings"]["tldWhoisServer"] = [MBAPI_ProcessRegistrarCommand:1]->params["tldSettings"]["tldWhoisResp"] = [MBAPI_ProcessRegistrarCommand:1]->params["tldSettings"]["tldRenewType"] = 0 [MBAPI_ProcessRegistrarCommand:1]->numResults = 0 [MBAPI_ProcessRegistrarCommand:1]->totalRecords = 0 [MBAPI_ProcessRegistrarCommand:1]->hasExecuted = 1 [MBAPI_ProcessRegistrarCommand:1]->lastInsertID = [MBAPI_ProcessRegistrarCommand:1]->numAffectedRows = 0 [MBAPI_ProcessRegistrarCommand:1]->showXMLHeader = 0 [MBAPI_ProcessRegistrarCommand:1]->numRecords = -1 [MBAPI_ProcessRegistrarCommand:1]->recordOffset = 0 [MBAPI_ProcessRegistrarCommand:1]->sortColumn = [MBAPI_ProcessRegistrarCommand:1]->sortDir = [MBAPI_ProcessRegistrarCommand:1]->defaultSortColumn = [MBAPI_ProcessRegistrarCommand:1]->subCommand = registerdomain [MBAPI_ProcessRegistrarCommand:1]->result = [MBAPI_ProcessRegistrarCommand:1]->resultBuf = [MBAPI_ProcessRegistrarCommand:1]->paramContext = [MBAPI_ProcessRegistrarCommand:1]->key = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["success"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errorCount"] = 3 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][0]["title"] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][0]["message"] = ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][1]["title"] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][1]["message"] = ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data. [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][2]["title"] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][2]["message"] = ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["timestamp"] = 1334861625 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["numResults"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["numTotalRecords"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["numAffectedRows"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["sortColumnName"] = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["sortColumn"] = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["sortDir"] = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["rowsPerPage"] = -1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["startingRowNum"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["stoppingRowNum"] = -1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["totalRows"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["totalPages"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["prevNextLinks"]["previousLinkOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["pages"][0]["pageNumber"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["pages"][0]["pageOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["beginningLinkOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["currentPageNumber"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["endLinkOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->stringRep = ProcessRegistrarCommand [MBAPI_ProcessRegistrarCommand:1]->timestamp = 1334861625 [MBAPI_ProcessRegistrarCommand:1]->errors[0][0] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->errors[0][1] = ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax [MBAPI_ProcessRegistrarCommand:1]->errors[1][0] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->errors[1][1] = ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data. [MBAPI_ProcessRegistrarCommand:1]->errors[2][0] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->errors[2][1] = ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module [MBAPI_ProcessRegistrarCommand:1]->numErrors = 3 [MBAPI_ProcessRegistrarCommand:1]->done = 1 found object! MBAPI ProcessSystemQueue log check: SELECT system_queue_log.system_queue_log_id FROM system_queue_log WHERE (system_queue_log.system_queue_id = 37) ORDER BY system_queue_log.system_queue_log_id ASC MBAPI_Command::runDeleteQuery: DELETE FROM system_queue_log WHERE (system_queue_log_id = 33237) MBAPI command input: SetSystemQueue update 37 1334861625 1 <log><mbapi> <header> <success>0</success> <errorCount>3</errorCount> <errors> <error> <title>Registrar Error</title> <message>ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax</message> </error> <error> <title>Registrar Error</title> <message>ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data.</message> </error> <error> <title>Registrar Error</title> <message>ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module</message> </error> </errors> <timestamp>1334861625</timestamp> <numResults>0</numResults> <numTotalRecords>0</numTotalRecords> <numAffectedRows>......
<willItRun>yes</willItRun> <queueMessage>Active client this invoice is paid, going to run registrar call.</queueMessage> </queueRules></log> 3 13348616255661 ############################### DEBUG BLOCK ################################### TITLE: function::getDBCol(system_queue) Block: Message: Invalid XML column name or missing database column: system_queue ############################### DEBUG BLOCK ################################### TITLE: function::getDBCol(system_queue) Block: Message: Invalid XML column name or missing database column: system_queue UPDATE system_queue SET system_queue_status_reason = '', system_queue_date_finished = 1334861625, system_queue_status = 1 WHERE (system_queue_id = 37) MBAPI 'SetSystemQueue' command output: ["mbapi"][0]["header"][0]["success"][0] = 1 ["mbapi"][0]["header"][0]["errorCount"][0] = 0 ["mbapi"][0]["header"][0]["errors"][0] = ["mbapi"][0]["header"][0]["timestamp"][0] = 1334861625 ["mbapi"][0]["header"][0]["numResults"][0] = 0 ["mbapi"][0]["header"][0]["numTotalRecords"][0] = 0 ["mbapi"][0]["header"][0]["numAffectedRows"][0] = 0 ["mbapi"][0]["header"][0]["sortColumnName"][0] = ["mbapi"][0]["header"][0]["sortColumn"][0] = ["mbapi"][0]["header"][0]["sortDir"][0] = ["mbapi"]
Debug results - ( I can provide more... )
Calling: resellers.resellone.net on port: 52443 Connected to resellone The result: HTTP/1.1 200 OK Date: Thu, 19 Apr 2012 19:04:39 GMT Server: OpenSRS/XML-RSA Server Content-Length: 546 Content-Type: text/xml 0.9 XCP DOMAIN Data conversion error. Check the command 'sw_register' syntax REPLY 465 0 resellone ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["success"][0] = 0 ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errorCount"][0] = 2 ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][0]["title"][0] = Resellone Error: ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][0]["message"][0] = Data conversion error. Check the command 'sw_register' syntax ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][1]["title"][0] = Customer & Business Manager Module Error ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["errors"][0]["error"][1]["message"][0] = resellone: The MB Module Resellone failed to return data. ["module"][0]["registrar"][0]["resellone"][0]["header"][0]["timestamp"][0] = 1334861625 found errors MBAPI 'ProcessRegistrar' command output: [0] = 0 3 ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data. ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module 1334861625 0 0 0 -1 1 -1 0 1 0 1 0 0 1 0 [MBAPI_ProcessRegistrarCommand:1]->xmlData = -1 1 -1 0 1 0 1 0 0 1 0 [MBAPI_ProcessRegistrarCommand:1]->input["mbapi"][0]["command"][0] = ProcessRegistrar [MBAPI_ProcessRegistrarCommand:1]->input["mbapi"][0]["subCommand"][0] = registerDomain ......
.....
[MBAPI_ProcessRegistrarCommand:1]->params["tldSettings"]["tldWhoisServer"] = [MBAPI_ProcessRegistrarCommand:1]->params["tldSettings"]["tldWhoisResp"] = [MBAPI_ProcessRegistrarCommand:1]->params["tldSettings"]["tldRenewType"] = 0 [MBAPI_ProcessRegistrarCommand:1]->numResults = 0 [MBAPI_ProcessRegistrarCommand:1]->totalRecords = 0 [MBAPI_ProcessRegistrarCommand:1]->hasExecuted = 1 [MBAPI_ProcessRegistrarCommand:1]->lastInsertID = [MBAPI_ProcessRegistrarCommand:1]->numAffectedRows = 0 [MBAPI_ProcessRegistrarCommand:1]->showXMLHeader = 0 [MBAPI_ProcessRegistrarCommand:1]->numRecords = -1 [MBAPI_ProcessRegistrarCommand:1]->recordOffset = 0 [MBAPI_ProcessRegistrarCommand:1]->sortColumn = [MBAPI_ProcessRegistrarCommand:1]->sortDir = [MBAPI_ProcessRegistrarCommand:1]->defaultSortColumn = [MBAPI_ProcessRegistrarCommand:1]->subCommand = registerdomain [MBAPI_ProcessRegistrarCommand:1]->result = [MBAPI_ProcessRegistrarCommand:1]->resultBuf = [MBAPI_ProcessRegistrarCommand:1]->paramContext = [MBAPI_ProcessRegistrarCommand:1]->key = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["success"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errorCount"] = 3 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][0]["title"] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][0]["message"] = ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][1]["title"] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][1]["message"] = ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data. [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][2]["title"] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["errors"]["error"][2]["message"] = ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["timestamp"] = 1334861625 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["numResults"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["numTotalRecords"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["numAffectedRows"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["sortColumnName"] = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["sortColumn"] = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["header"]["sortDir"] = [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["rowsPerPage"] = -1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["startingRowNum"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["stoppingRowNum"] = -1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["totalRows"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["paginationStats"]["totalPages"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["prevNextLinks"]["previousLinkOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["pages"][0]["pageNumber"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["pages"][0]["pageOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["beginningLinkOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["currentPageNumber"] = 1 [MBAPI_ProcessRegistrarCommand:1]->xmlDataArray["mbapi"]["results"]["paginationLinks"]["pageLinks"]["endLinkOffset"] = 0 [MBAPI_ProcessRegistrarCommand:1]->stringRep = ProcessRegistrarCommand [MBAPI_ProcessRegistrarCommand:1]->timestamp = 1334861625 [MBAPI_ProcessRegistrarCommand:1]->errors[0][0] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->errors[0][1] = ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax [MBAPI_ProcessRegistrarCommand:1]->errors[1][0] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->errors[1][1] = ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data. [MBAPI_ProcessRegistrarCommand:1]->errors[2][0] = Registrar Error [MBAPI_ProcessRegistrarCommand:1]->errors[2][1] = ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module [MBAPI_ProcessRegistrarCommand:1]->numErrors = 3 [MBAPI_ProcessRegistrarCommand:1]->done = 1 found object! MBAPI ProcessSystemQueue log check: SELECT system_queue_log.system_queue_log_id FROM system_queue_log WHERE (system_queue_log.system_queue_id = 37) ORDER BY system_queue_log.system_queue_log_id ASC MBAPI_Command::runDeleteQuery: DELETE FROM system_queue_log WHERE (system_queue_log_id = 33237) MBAPI command input: SetSystemQueue update 37 1334861625 1 <log><mbapi> <header> <success>0</success> <errorCount>3</errorCount> <errors> <error> <title>Registrar Error</title> <message>ProcessRegistrarCommand: Resellone Error: Data conversion error. Check the command 'sw_register' syntax</message> </error> <error> <title>Registrar Error</title> <message>ProcessRegistrarCommand: Customer & Business Manager Module Error resellone: The MB Module Resellone failed to return data.</message> </error> <error> <title>Registrar Error</title> <message>ProcessRegistrarCommand: Unknown errors appeared while processing the "resellone" module</message> </error> </errors> <timestamp>1334861625</timestamp> <numResults>0</numResults> <numTotalRecords>0</numTotalRecords> <numAffectedRows>......
<willItRun>yes</willItRun> <queueMessage>Active client this invoice is paid, going to run registrar call.</queueMessage> </queueRules></log> 3 13348616255661 ############################### DEBUG BLOCK ################################### TITLE: function::getDBCol(system_queue) Block: Message: Invalid XML column name or missing database column: system_queue ############################### DEBUG BLOCK ################################### TITLE: function::getDBCol(system_queue) Block: Message: Invalid XML column name or missing database column: system_queue UPDATE system_queue SET system_queue_status_reason = '', system_queue_date_finished = 1334861625, system_queue_status = 1 WHERE (system_queue_id = 37) MBAPI 'SetSystemQueue' command output: ["mbapi"][0]["header"][0]["success"][0] = 1 ["mbapi"][0]["header"][0]["errorCount"][0] = 0 ["mbapi"][0]["header"][0]["errors"][0] = ["mbapi"][0]["header"][0]["timestamp"][0] = 1334861625 ["mbapi"][0]["header"][0]["numResults"][0] = 0 ["mbapi"][0]["header"][0]["numTotalRecords"][0] = 0 ["mbapi"][0]["header"][0]["numAffectedRows"][0] = 0 ["mbapi"][0]["header"][0]["sortColumnName"][0] = ["mbapi"][0]["header"][0]["sortColumn"][0] = ["mbapi"][0]["header"][0]["sortDir"][0] = ["mbapi"]
