Created
December 29, 2011 18:32
-
-
Save bjhaid/1535462 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 = '54973'</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 = '54973'</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 = '00536'</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 = '00536'</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 = '56305'</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 = '56305'</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 = '00566'</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 = '00566'</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 = '00570'</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 = '00570'</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 = '00570'</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 = '00570'</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 = '00570'</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 = '00570'</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 = '00570'</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 = '00570'</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 = '56305'</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 = '56305'</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 = '00571'</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 = '00571'</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