Skip to content

Instantly share code, notes, and snippets.

@bjhaid
Created December 29, 2011 18:32
Show Gist options
  • Save bjhaid/1535462 to your computer and use it in GitHub Desktop.
Save bjhaid/1535462 to your computer and use it in GitHub Desktop.
There are 10 CNUM
The CNUM value is 54973
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:26:53 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=r6und882qu2svp0k4c3chbt3f1; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">r6und882qu2svp0k4c3chbt3f1</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">r6und882qu2svp0k4c3chbt3f1</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;54973&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;54973&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:26:53 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=97bs01mh6gdvmm8o6leap15c70; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 00536
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:26:56 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=spvv7fhe23vbq19o11hvgak4n4; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">spvv7fhe23vbq19o11hvgak4n4</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">spvv7fhe23vbq19o11hvgak4n4</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;00536&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;00536&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:26:56 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=kn79tccbvg1u1kms2u7prq9lu2; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 56305
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:26:59 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=j5n8v3k2hfr2k214nfp3edasn0; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">j5n8v3k2hfr2k214nfp3edasn0</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">j5n8v3k2hfr2k214nfp3edasn0</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;56305&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;56305&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:26:59 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=m50coqae1u7q376jv3rimhl5g3; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 00566
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:02 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=kf9tsf7hhr1b3unulfu2o6t0r7; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">kf9tsf7hhr1b3unulfu2o6t0r7</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">kf9tsf7hhr1b3unulfu2o6t0r7</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;00566&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;00566&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:02 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=kq2bfbl1j7kqt4vu0d74qgf9u2; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 00570
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:05 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=unbbphl7ehrgpv6h0pckmrdvo2; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">unbbphl7ehrgpv6h0pckmrdvo2</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">unbbphl7ehrgpv6h0pckmrdvo2</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;00570&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;00570&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:05 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=sl2qg959rnkga23ts0hna626l5; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 00570
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:08 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=u9mq92btfg0feemuq76c773tt1; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">u9mq92btfg0feemuq76c773tt1</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">u9mq92btfg0feemuq76c773tt1</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;00570&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;00570&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:08 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=anlm4hnujl2ovr96l05l8v7at0; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 00570
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:10 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=jrv38dvg3hqe06due5c9nflvd6; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">jrv38dvg3hqe06due5c9nflvd6</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">jrv38dvg3hqe06due5c9nflvd6</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;00570&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;00570&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:11 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=53i2v37umrv367tjc81bq632t6; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 00570
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:13 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=8eckkipinleemanvmtidf75f85; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">8eckkipinleemanvmtidf75f85</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">8eckkipinleemanvmtidf75f85</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;00570&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;00570&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:14 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=8eofuqbkfjpdlg1cjof7mggif1; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 56305
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:16 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=525qv9upc7cb67s2pdbvd7c104; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">525qv9upc7cb67s2pdbvd7c104</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">525qv9upc7cb67s2pdbvd7c104</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;56305&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;56305&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:17 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=tugu4df8sqhaaf8a2a2hbem8b4; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
The CNUM value is 00571
#<SOAP::RPC::Driver:#<SOAP::RPC::Proxy:http://172.18.100.13/KakawaCRM/soap.php>>
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:login env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<user_auth xsi:type="n1:user_auth">
<user_name xsi:type="xsd:string">admin</user_name>
<password xsi:type="xsd:string">5f4dcc3b5aa765d61d8327deb882cf99</password>
<version xsi:type="xsd:string">1</version>
</user_auth>
<application_name xsi:type="xsd:string"></application_name>
</n1:login>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/login\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 724\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:login env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <user_auth xsi:type=\"n1:user_auth\">\n <user_name xsi:type=\"xsd:string\">admin</user_name>\n <password xsi:type=\"xsd:string\">5f4dcc3b5aa765d61d8327deb882cf99</password>\n <version xsi:type=\"xsd:string\">1</version>\n </user_auth>\n <application_name xsi:type=\"xsd:string\"></application_name>\n </n1:login>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:19 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=dohescmd3oj2rb24uje6skjge2; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 809\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 809 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:set_entry_result\"><id xsi:type=\"xsd:string\">dohescmd3oj2rb24uje6skjge2</id><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">0</number><name xsi:type=\"xsd:string\">No Error</name><description xsi:type=\"xsd:string\">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 809 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:loginResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:set_entry_result"><id xsi:type="xsd:string">dohescmd3oj2rb24uje6skjge2</id><error xsi:type="tns:error_value"><number xsi:type="xsd:string">0</number><name xsi:type="xsd:string">No Error</name><description xsi:type="xsd:string">No Error</description></error></return></ns1:loginResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
#<NoMethodError: undefined method `[]' for nil:NilClass>
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/baseparser.rb:341:in `pull'
C:/Ruby192/lib/ruby/1.9.1/rexml/parsers/streamparser.rb:16:in `parse'
C:/Ruby192/lib/ruby/1.9.1/rexml/document.rb:204:in `parse_stream'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/xsd/xmlparser/rexmlparser.rb:27:in `do_parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/parser.rb:102:in `parse'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/processor.rb:39:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:291:in `unmarshal'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:190:in `route'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/proxy.rb:149:in `call'
C:/Ruby192/lib/ruby/site_ruby/1.9.1/soap/rpc/driver.rb:151:in `call'
(eval):6:in `login'
C:/kakawa_updater/sugartest.rb:31:in `sugar_connect'
C:/kakawa_updater/sugartest.rb:93:in `sugar_id_query'
C:/kakawa_updater/sugartest.rb:127:in `sugar_insert'
C:/kakawa_updater/sqlservertest.rb:115:in `block in mssql_query'
C:/kakawa_updater/sqlservertest.rb:27:in `times'
C:/kakawa_updater/sqlservertest.rb:27:in `mssql_query'
runner.rb:4:in `<main>'
...
Exception parsing
Line: 1
Position: 809
Last 80 unconsumed characters:
</SOAP-ENV:Envelo
Wire dump:
opening connection to 172.18.100.13...
opened
= Request
<?xml version="1.0" encoding="utf-8" ?>
<env:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
<env:Body>
<n1:get_entry_list env:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:n1="http://www.sugarcrm.com/sugarcrm">
<session xsi:nil="true"></session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<query xsi:type="xsd:string">cnum_c = &apos;00571&apos;</query>
<order_by xsi:type="xsd:string"></order_by>
<offset xsi:type="xsd:int">0</offset>
<select_fields xmlns:n2="http://schemas.xmlsoap.org/soap/encoding/"
n2:arrayType="xsd:string[1]"
xsi:type="n2:Array">
<item>id</item>
</select_fields>
<max_results xsi:type="xsd:int">1</max_results>
<deleted xsi:type="xsd:int">0</deleted>
</n1:get_entry_list>
</env:Body>
</env:Envelope>
<- "POST /KakawaCRM/soap.php HTTP/1.1\r\nContent-Type: text/xml; charset=utf-8\r\nSoapaction: \"http://172.18.100.13/kakawacrm/soap.php/get_entry_list\"\r\nUser-Agent: SOAP4R/1.6.1-SNAPSHOT\r\nAccept: */*\r\nHost: 172.18.100.13\r\nContent-Length: 981\r\n\r\n"
<- "<?xml version=\"1.0\" encoding=\"utf-8\" ?>\n<env:Envelope xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"\n xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"\n xmlns:env=\"http://schemas.xmlsoap.org/soap/envelope/\">\n <env:Body>\n <n1:get_entry_list env:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"\n xmlns:n1=\"http://www.sugarcrm.com/sugarcrm\">\n <session xsi:nil=\"true\"></session>\n <module_name xsi:type=\"xsd:string\">Accounts</module_name>\n <query xsi:type=\"xsd:string\">cnum_c = &apos;00571&apos;</query>\n <order_by xsi:type=\"xsd:string\"></order_by>\n <offset xsi:type=\"xsd:int\">0</offset>\n <select_fields xmlns:n2=\"http://schemas.xmlsoap.org/soap/encoding/\"\n n2:arrayType=\"xsd:string[1]\"\n xsi:type=\"n2:Array\">\n <item>id</item>\n </select_fields>\n <max_results xsi:type=\"xsd:int\">1</max_results>\n <deleted xsi:type=\"xsd:int\">0</deleted>\n </n1:get_entry_list>\n </env:Body>\n</env:Envelope>"
-> "HTTP/1.1 200 OK\r\n"
-> "Date: Thu, 29 Dec 2011 18:27:20 GMT\r\n"
-> "Server: Apache/2.2.21 (Win32) PHP/5.2.17\r\n"
-> "X-Powered-By: PHP/5.2.17\r\n"
-> "Set-Cookie: PHPSESSID=si0tajnq2bhdtbtlhn6u6jml72; path=/\r\n"
-> "Expires: Thu, 19 Nov 1981 08:52:00 GMT\r\n"
-> "Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0\r\n"
-> "Pragma: no-cache\r\n"
-> "X-SOAP-Server: NuSOAP/0.7.2 (15787)\r\n"
-> "Content-Length: 973\r\n"
-> "Content-Type: text/xml; charset=UTF-8\r\n"
-> "\r\n"
reading 973 bytes...
-> ""
-> "\xEF\xBB\xBF<?xml version=\"1.0\" encoding=\"UTF-8\"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:tns=\"http://www.sugarcrm.com/sugarcrm\"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1=\"http://www.sugarcrm.com/sugarcrm\"><return xsi:type=\"tns:get_entry_list_result\"><result_count xsi:type=\"xsd:int\">-1</result_count><entry_list xsi:type=\"SOAP-ENC:Array\" SOAP-ENC:arrayType=\"tns:entry_value[0]\"></entry_list><error xsi:type=\"tns:error_value\"><number xsi:type=\"xsd:string\">10</number><name xsi:type=\"xsd:string\">Invalid Login</name><description xsi:type=\"xsd:string\">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo"
read 973 bytes
Conn keep-alive
= Response
<?xml version="1.0" encoding="UTF-8"?><SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="http://www.sugarcrm.com/sugarcrm"><SOAP-ENV:Body><ns1:get_entry_listResponse xmlns:ns1="http://www.sugarcrm.com/sugarcrm"><return xsi:type="tns:get_entry_list_result"><result_count xsi:type="xsd:int">-1</result_count><entry_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:entry_value[0]"></entry_list><error xsi:type="tns:error_value"><number xsi:type="xsd:string">10</number><name xsi:type="xsd:string">Invalid Login</name><description xsi:type="xsd:string">Login attempt failed please check the username and password</description></error></return></ns1:get_entry_listResponse></SOAP-ENV:Body></SOAP-ENV:Envelo
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment