[Spacewalk-list] Please help with Oracle to PostgreSQL migration
James Fillman
jfillman at central1.com
Tue Dec 20 00:05:43 UTC 2011
Hi Jan,
Thanks for getting back to me. I'm amazed at how you manage to reply to just about every posting on the spacewalk-list.
I put VI to work and edited my 4.5 GB dump file. I did find 2 illegal chars on line 136452. Not sure how they got past the code mentioned in the email but all was well after I deleted the unwanted chars.
Like many others, I am dealing with config file issues since upgrading to 1.5. I couldn't find a patch anywhere. Is there a fix for it that I couldn't find? Here's an email that I submitted a week ago with details of the issue:
I've recently upgraded from 1.2 to 1.5 and then migrated from Oracle to PostgreSQL. Ever since the migration, this regularly scheduled action is failing on 21 of my 135 servers.
The daily action in question is: 'Show differences between profiled config files and deployed config files scheduled by (none)'
The output of this action is:
This action will be executed after 12/12/11 11:00:04 PM PST.
This action's status is: Failed.
The client picked up this action on 12/13/11 3:36:25 AM PST.
The client completed this action on 12/13/11 4:33:48 AM PST.
Client execution returned "This action has been picked up multiple times without a successful transaction; this action is now failed for this system." (code )
Config Files:
/etc/logrotate.d/snmpd (rev. 1)
/etc/ntp.conf (rev. 1)
/etc/postfix/main.cf (rev. 1)
/etc/resolv.conf (rev. 6)
/etc/snmp/snmpd.conf (rev. 1)
/etc/ssh/banner (rev. 1)
/etc/ssh/sshd_config (rev. 2)
/etc/sudoers (rev. 4)
/etc/sysconfig/network-scripts/network-functions (rev. 1)
/etc/sysconfig/ntpd (rev. 1)
/etc/sysconfig/snmpd.options (rev. 1)
/home/mdauth/scripts/failXxxxxx.sh (rev. 1)
/home/mdauth/scripts/importConfigToDB.sh (rev. 4)
/opt/rsaAuth/server.xml (rev. 4)
/opt/rsa/configs/c-config-challenge_fr.xml (rev. 1)
/opt/rsa/configs/c-config-challenge.xml (rev. 2)
/opt/rsa/custom_provider/configs/customProviders.xml (rev. 4)
/opt/rsaScheduler/server.xml (rev. 4)
/opt/rsaTools/server.xml (rev. 4)
/usr/local/bin/cmdline-jmxclient-0.10.3.jar (rev. 1)
/usr/local/sbin/kbytesRead (rev. 1)
/usr/local/sbin/kbytesWritten (rev. 1)
Spacewalk send out an TRACEBACK email for each failure. I'll tack the email onto the end of this email. Has anyone else seen this issue? I'm at a loss as to what's causing the problem.
Cheers,
--james
Error Email:
Exception reported from vacslp01spacewalk.xxxxxx
Time: Tue Dec 13 03:40:31 2011
Exception type psycopg2.DataError
Exception while handling function queue.submit Request object information:
URI: /XMLRPC
Remote Host: tohclp02mdauth.oss.xxxxxx Server Name: vacslp01spacewalk.xxxxxx:443 Headers passed in:
Accept-Encoding: identity
Content-Length: 6713
Host: vacslp01spacewalk.xxxxxx:443
content-type: text/xml
user-agent: rhn.rpclib.py/$Revision$
x-client-version: 1
x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
x-rhn-client-capability: packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1
x-rhn-transport-capability: follow-redirects=2
x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc (version $Revision$)
x-up2date-version: 0.4.24-1.el5
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py", line 123, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 470, in submit
action_type=action_type)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 515, in process_extra_data
result = method(self.server_id, action_id, data=data)
File "/usr/lib/python2.4/site-packages/spacewalk/server/action_extra_data/configfiles.py", line 156, in diff
_process_diffs(server_id, action_id, diffs)
File "/usr/lib/python2.4/site-packages/spacewalk/server/action_extra_data/configfiles.py", line 241, in _process_diffs
_add_result(action_config_revision_id, diff)
File "/usr/lib/python2.4/site-packages/spacewalk/server/action_extra_data/configfiles.py", line 280, in _add_result
result=diff)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
return apply(self._execute_wrapper, (self._execute, ) + p, kw)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 264, in _execute_wrapper
retval = apply(function, p, kw)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
return self._execute_(args, kwargs)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 277, in _execute_
self._real_cursor.execute(self.sql, params)
DataError: invalid input syntax for type bytea at character 115
Local variables by frame
Frame _execute_ in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py at line 277
self = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ef4501b8>
args = <type 'tuple'> ()
params = <type 'instance'> {'result': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', 'action_config_revision_id': 554813}
kwargs = <type 'dict'> {'result': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', 'action_config_revision_id': 554813}
Frame _execute in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py at line 217
self = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ef4501b8>
args = <type 'tuple'> ()
val = <type 'str'> --- /opt/rsaAuth/server.xml 2011-10-23 01:37:51.000000000 -0700
+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602 2011-12-13 03:40:30.000000000 -0800
@@ -47,7 +47,7 @@
logAbandoned="true"
name="jdbc/Xxxxxx"
type="javax.sql.DataSource"
- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
username="xxxxxx" password="xxxxxx" />
@@ -394,4 +394,4 @@
</Service>
-</Server>
+</Server>
\ No newline at end of file
kwargs = <type 'dict'> {'result': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', 'action_config_revision_id': 554813}
Frame _execute_wrapper in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py at line 269
function = <type 'instancemethod'> <bound method Cursor._execute of <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ef4501b8>>
self = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ef4501b8>
value = <type 'int'> 554813
p = <type 'tuple'> ()
kw = <type 'dict'> {'result': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', 'action_config_revision_id': 554813}
key = <type 'str'> action_config_revision_id
params = <type 'str'> result: --- /opt/rsaAuth/server.xml 2011-10-23 01:37:51.000000000 -0700
+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602 2011-12-13 03:40:30.000000000 -0800
@@ -47,7 +47,7 @@
logAbandoned="true"
name="jdbc/Xxxxxx"
type="javax.sql.DataSource"
- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
username="xxxxxx" password="xxxxxx" />
@@ -394,4 +394,4 @@
</Service>
-</Server>
+</Server>
\ No newline at end of file
,action_config_revision_id: 554813
Frame execute in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py at line 163
p = <type 'tuple'> ()
self = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ef4501b8>
kw = <type 'dict'> {'result': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', 'action_config_revision_id': 554813}
Frame _add_result in /usr/lib/python2.4/site-packages/spacewalk/server/action_extra_data/configfiles.py at line 280
h = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ef4501b8>
action_config_revision_id = <type 'int'> 554813
blob_map = <type 'dict'> {'result': 'result'}
diff = <type 'str'> --- /opt/rsaAuth/server.xml 2011-10-23 01:37:51.000000000 -0700
+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602 2011-12-13 03:40:30.000000000 -0800
@@ -47,7 +47,7 @@
logAbandoned="true"
name="jdbc/Xxxxxx"
type="javax.sql.DataSource"
- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
username="xxxxxx" password="xxxxxx" />
@@ -394,4 +394,4 @@
</Service>
-</Server>
+</Server>
\ No newline at end of file
Frame _process_diffs in /usr/lib/python2.4/site-packages/spacewalk/server/action_extra_data/configfiles.py at line 241
diffs = <type 'dict'> {'/etc/sudoers': '--- /etc/sudoers\t2011-11-10 14:37:42.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311\t2011-12-13 03:40:30.000000000 -0800\n@@ -93,19 +93,3 @@\n # %users localhost=/sbin/shutdown -h now\n \n build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync\n-\n-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth\n-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *\n-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check\n-\n-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpdump *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *\n-%dtrace\tALL=(ALL) NOPASSWD: /bin/su - dtrace\n-\n-cpopescu ALL=(root) NOPASSWD: /usr/sbin/dmidecode\n-\n-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl *\n-%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/patches/*\n
-%l2support ALL=NOPASSWD: /sbin/init 6\n', '/opt/rsaScheduler/server.xml': '', '/home/mdauth/scripts/failXxxxxx.sh': '', '/usr/local/bin/cmdline-jmxclient-0.10.3.jar': '', '/etc/sysconfig/ntpd': '', '/etc/ssh/sshd_config': '', '/opt/rsa/configs/c-config-challenge.xml': '', '/usr/local/sbin/kbytesWritten': '', '/opt/rsa/custom_provider/configs/customProviders.xml': '', '/etc/postfix/main.cf': '', '/opt/rsa/configs/c-config-challenge_fr.xml': '', '/sbin/ifup-local': '', '/etc/ntp.conf': '', '/etc/sysconfig/snmpd.options': '', '/opt/rsaTools/server.xml': '', '/etc/resolv.conf': '--- /etc/resolv.conf\t2011-03-03 11:42:10.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106\t2011-12-13 03:40:30.000000000 -0800\n@@ -1,7 +1,6 @@\n+# default resolver\n+search oss.xxxxxx cs.ad.xxxxxx xxxxxx\n options timeout:3 attempts:2\n-; generated by /sbin/dhclient-script\n-search xxxxxx\n-nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n+nameserver xxxxxx.
130.254\n+nameserver xxxxxx.130.253\n nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n', '/home/mdauth/scripts/importConfigToDB.sh': '', '/etc/logrotate.d/snmpd': '', '/etc/snmp/snmpd.conf': '', '/usr/local/sbin/kbytesRead': '', '/etc/ssh/banner': '', '/opt/rsaAuth/server.xml': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', '/etc/sysconfig/netwo
rk-scripts/network-functions': ''}
server_id = <type 'int'> 1000012809
action_config_revision_id = <type 'int'> 554813
diff = <type 'str'> --- /opt/rsaAuth/server.xml 2011-10-23 01:37:51.000000000 -0700
+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602 2011-12-13 03:40:30.000000000 -0800
@@ -47,7 +47,7 @@
logAbandoned="true"
name="jdbc/Xxxxxx"
type="javax.sql.DataSource"
- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"
username="xxxxxx" password="xxxxxx" />
@@ -394,4 +394,4 @@
</Service>
-</Server>
+</Server>
\ No newline at end of file
file_path = <type 'str'> /opt/rsaAuth/server.xml
action_id = <type 'int'> 55440
Frame diff in /usr/lib/python2.4/site-packages/spacewalk/server/action_extra_data/configfiles.py at line 156
status = <type 'int'> 2
diffs = <type 'dict'> {'/etc/sudoers': '--- /etc/sudoers\t2011-11-10 14:37:42.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311\t2011-12-13 03:40:30.000000000 -0800\n@@ -93,19 +93,3 @@\n # %users localhost=/sbin/shutdown -h now\n \n build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync\n-\n-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth\n-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *\n-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check\n-\n-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpdump *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *\n-%dtrace\tALL=(ALL) NOPASSWD: /bin/su - dtrace\n-\n-cpopescu ALL=(root) NOPASSWD: /usr/sbin/dmidecode\n-\n-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl *\n-%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/patches/*\n
-%l2support ALL=NOPASSWD: /sbin/init 6\n', '/opt/rsaScheduler/server.xml': '', '/home/mdauth/scripts/failXxxxxx.sh': '', '/usr/local/bin/cmdline-jmxclient-0.10.3.jar': '', '/etc/sysconfig/ntpd': '', '/etc/ssh/sshd_config': '', '/opt/rsa/configs/c-config-challenge.xml': '', '/usr/local/sbin/kbytesWritten': '', '/opt/rsa/custom_provider/configs/customProviders.xml': '', '/etc/postfix/main.cf': '', '/opt/rsa/configs/c-config-challenge_fr.xml': '', '/sbin/ifup-local': '', '/etc/ntp.conf': '', '/etc/sysconfig/snmpd.options': '', '/opt/rsaTools/server.xml': '', '/etc/resolv.conf': '--- /etc/resolv.conf\t2011-03-03 11:42:10.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106\t2011-12-13 03:40:30.000000000 -0800\n@@ -1,7 +1,6 @@\n+# default resolver\n+search oss.xxxxxx cs.ad.xxxxxx xxxxxx\n options timeout:3 attempts:2\n-; generated by /sbin/dhclient-script\n-search xxxxxx\n-nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n+nameserver xxxxxx.
130.254\n+nameserver xxxxxx.130.253\n nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n', '/home/mdauth/scripts/importConfigToDB.sh': '', '/etc/logrotate.d/snmpd': '', '/etc/snmp/snmpd.conf': '', '/usr/local/sbin/kbytesRead': '', '/etc/ssh/banner': '', '/opt/rsaAuth/server.xml': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', '/etc/sysconfig/netwo
rk-scripts/network-functions': ''}
server_id = <type 'int'> 1000012809
missing_files = <type 'list'> []
data = <type 'dict'> {'diffs': {'/etc/sudoers': '--- /etc/sudoers\t2011-11-10 14:37:42.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311\t2011-12-13 03:40:30.000000000 -0800\n@@ -93,19 +93,3 @@\n # %users localhost=/sbin/shutdown -h now\n \n build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync\n-\n-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth\n-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *\n-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check\n-\n-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpdump *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *\n-%dtrace\tALL=(ALL) NOPASSWD: /bin/su - dtrace\n-\n-cpopescu ALL=(root) NOPASSWD: /usr/sbin/dmidecode\n-\n-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl *\n-%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/p
atches/*\n-%l2support ALL=NOPASSWD: /sbin/init 6\n', '/opt/rsaScheduler/server.xml': '', '/home/mdauth/scripts/failXxxxxx.sh': '', '/usr/local/bin/cmdline-jmxclient-0.10.3.jar': '', '/etc/sysconfig/ntpd': '', '/etc/ssh/sshd_config': '', '/opt/rsa/configs/c-config-challenge.xml': '', '/usr/local/sbin/kbytesWritten': '', '/opt/rsa/custom_provider/configs/customProviders.xml': '', '/etc/postfix/main.cf': '', '/opt/rsa/configs/c-config-challenge_fr.xml': '', '/sbin/ifup-local': '', '/etc/ntp.conf': '', '/etc/sysconfig/snmpd.options': '', '/opt/rsaTools/server.xml': '', '/etc/resolv.conf': '--- /etc/resolv.conf\t2011-03-03 11:42:10.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106\t2011-12-13 03:40:30.000000000 -0800\n@@ -1,7 +1,6 @@\n+# default resolver\n+search oss.xxxxxx cs.ad.xxxxxx xxxxxx\n options timeout:3 attempts:2\n-; generated by /sbin/dhclient-script\n-search xxxxxx\n-nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n+nameserv
er xxxxxx.130.254\n+nameserver xxxxxx.130.253\n nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n', '/home/mdauth/scripts/importConfigToDB.sh': '', '/etc/logrotate.d/snmpd': '', '/etc/snmp/snmpd.conf': '', '/usr/local/sbin/kbytesRead': '', '/etc/ssh/banner': '', '/opt/rsaAuth/server.xml': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=Xxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', '/etc/sysco
nfig/network-scripts/network-functions': ''}}
action_id = <type 'int'> 55440
Frame process_extra_data in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 515
server_id = <type 'int'> 1000012809
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b12ef33e368>
action_type = <type 'str'> configfiles.diff
data = <type 'dict'> {'diffs': {'/etc/sudoers': '--- /etc/sudoers\t2011-11-10 14:37:42.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311\t2011-12-13 03:40:30.000000000 -0800\n@@ -93,19 +93,3 @@\n # %users localhost=/sbin/shutdown -h now\n \n build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync\n-\n-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth\n-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *\n-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check\n-\n-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpdump *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *\n-%dtrace\tALL=(ALL) NOPASSWD: /bin/su - dtrace\n-\n-cpopescu ALL=(root) NOPASSWD: /usr/sbin/dmidecode\n-\n-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl *\n-%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/p
atches/*\n-%l2support ALL=NOPASSWD: /sbin/init 6\n', '/opt/rsaScheduler/server.xml': '', '/home/mdauth/scripts/failXxxxxx.sh': '', '/usr/local/bin/cmdline-jmxclient-0.10.3.jar': '', '/etc/sysconfig/ntpd': '', '/etc/ssh/sshd_config': '', '/opt/rsa/configs/c-config-challenge.xml': '', '/usr/local/sbin/kbytesWritten': '', '/opt/rsa/custom_provider/configs/customProviders.xml': '', '/etc/postfix/main.cf': '', '/opt/rsa/configs/c-config-challenge_fr.xml': '', '/sbin/ifup-local': '', '/etc/ntp.conf': '', '/etc/sysconfig/snmpd.options': '', '/opt/rsaTools/server.xml': '', '/etc/resolv.conf': '--- /etc/resolv.conf\t2011-03-03 11:42:10.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106\t2011-12-13 03:40:30.000000000 -0800\n@@ -1,7 +1,6 @@\n+# default resolver\n+search oss.xxxxxx cs.ad.xxxxxx xxxxxx\n options timeout:3 attempts:2\n-; generated by /sbin/dhclient-script\n-search xxxxxx\n-nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n+nameserv
er xxxxxx.130.254\n+nameserver xxxxxx.130.253\n nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n', '/home/mdauth/scripts/importConfigToDB.sh': '', '/etc/logrotate.d/snmpd': '', '/etc/snmp/snmpd.conf': '', '/usr/local/sbin/kbytesRead': '', '/etc/ssh/banner': '', '/opt/rsaAuth/server.xml': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxxxxxxxxxx:1433;databaseName=xxxxxxxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxxxx:1433;databaseName=xxxxxxxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', '/etc/sysco
nfig/network-scripts/network-functions': ''}}
method = <type 'function'> <function diff at 0x2b12ef220410>
action_id = <type 'int'> 55440
Frame submit in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 470
status = <type 'int'> 2
trigger_snapshot = <type 'bool'> False
rmsg = <type 'str'> Files successfully diffed
h = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ef4580e0>
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b12ef33e368>
data = <type 'dict'> {'diffs': {'/etc/sudoers': '--- /etc/sudoers\t2011-11-10 14:37:42.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311\t2011-12-13 03:40:30.000000000 -0800\n@@ -93,19 +93,3 @@\n # %users localhost=/sbin/shutdown -h now\n \n build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync\n-\n-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth\n-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *\n-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check\n-\n-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpdump *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *\n-%dtrace\tALL=(ALL) NOPASSWD: /bin/su - dtrace\n-\n-cpopescu ALL=(root) NOPASSWD: /usr/sbin/dmidecode\n-\n-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl *\n-%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/p
atches/*\n-%l2support ALL=NOPASSWD: /sbin/init 6\n', '/opt/rsaScheduler/server.xml': '', '/home/mdauth/scripts/failXxxxxx.sh': '', '/usr/local/bin/cmdline-jmxclient-0.10.3.jar': '', '/etc/sysconfig/ntpd': '', '/etc/ssh/sshd_config': '', '/opt/rsa/configs/c-config-challenge.xml': '', '/usr/local/sbin/kbytesWritten': '', '/opt/rsa/custom_provider/configs/customProviders.xml': '', '/etc/postfix/main.cf': '', '/opt/rsa/configs/c-config-challenge_fr.xml': '', '/sbin/ifup-local': '', '/etc/ntp.conf': '', '/etc/sysconfig/snmpd.options': '', '/opt/rsaTools/server.xml': '', '/etc/resolv.conf': '--- /etc/resolv.conf\t2011-03-03 11:42:10.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106\t2011-12-13 03:40:30.000000000 -0800\n@@ -1,7 +1,6 @@\n+# default resolver\n+xxxxxxxxxxxxx\n options timeout:3 attempts:2\n-; generated by /sbin/dhclient-script\n-search xxxxxx\n-nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n+nameserv
er xxxxxx.130.254\n+nameserver xxxxxx.130.253\n nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n', '/home/mdauth/scripts/importConfigToDB.sh': '', '/etc/logrotate.d/snmpd': '', '/etc/snmp/snmpd.conf': '', '/usr/local/sbin/kbytesRead': '', '/etc/ssh/banner': '', '/opt/rsaAuth/server.xml': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.DataSource"\n- url="jdbc:sqlserver://xxxxxxxxxxxxxx:1433;databaseName=xxxxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxxxxxxxxxxxx:1433;databaseName=xxxxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', '/etc/sysco
nfig/network-scripts/network-functions': ''}}
system_id = <type 'str'> <?xml version="1.0"?> <params> <param> <value><struct> <member> <name>username</name> <value><string>server-admin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: x86_64-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>d7a03f420bbbb4d9c11b6b1c8507a29e</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>tohclp02mdauth</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000012809</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>5</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>
result = <type 'int'> 0
action_type = <type 'str'> configfiles.diff
message = <type 'str'> Files successfully diffed
action_id = <type 'int'> 55440
rcode = <type 'int'> 0
row = <type 'dict'> {'trigger_snapshot': 'N', 'name': 'Show differences between profiled config files and deployed config files', 'action_type': 'configfiles.diff'}
Frame call_function in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 174
self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2b12ef44def0>
params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>server-admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>d7a03f420bbbb4d9c11b6b1c8507a29e</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>tohclp02mdauth</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000012809</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array
><data>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', 55440, 0, 'Files successfully diffed', {'diffs': {'/etc/sudoers': '--- /etc/sudoers\t2011-11-10 14:37:42.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311\t2011-12-13 03:40:30.000000000 -0800\n@@ -93,19 +93,3 @@\n # %users localhost=/sbin/shutdown -h now\n \n build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync\n-\n-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth\n-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *\n-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check\n-\n-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpd
ump *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *\n-%dtrace\tALL=(ALL) NOPASSWD: /bin/su - dtrace\n-\n-cpopescu ALL=(root) NOPASSWD: /usr/sbin/dmidecode\n-\n-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl *\n-%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/patches/*\n-%l2support ALL=NOPASSWD: /sbin/init 6\n', '/opt/rsaScheduler/server.xml': '', '/home/mdauth/scripts/failXxxxxx.sh': '', '/usr/local/bin/cmdline-jmxclient-0.10.3.jar': '', '/etc/sysconfig/ntpd': '', '/etc/ssh/sshd_config': '', '/opt/rsa/configs/c-config-challenge.xml': '', '/usr/local/sbin/kbytesWritten': '', '/opt/rsa/custom_provider/configs/customProviders.xml': '', '/etc/postfix/main.cf': '', '/opt/rsa/configs/c-config-challenge_fr.xml': '', '/sbin/ifup-local': '', '/etc/ntp.conf': '', '/etc/sysconfig/snmpd.options': '', '/opt/rsaTools
/server.xml': '', '/etc/resolv.conf': '--- /etc/resolv.conf\t2011-03-03 11:42:10.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106\t2011-12-13 03:40:30.000000000 -0800\n@@ -1,7 +1,6 @@\n+# default resolver\n+xxxxx\n options timeout:3 attempts:2\n-; generated by /sbin/dhclient-script\n-search xxxxxx\n-nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n+nameserver xxxxxx.130.254\n+nameserver xxxxxx.130.253\n nameserver xxxxxx.130.254\n-nameserver xxxxxx.130.253\n', '/home/mdauth/scripts/importConfigToDB.sh': '', '/etc/logrotate.d/snmpd': '', '/etc/snmp/snmpd.conf': '', '/usr/local/sbin/kbytesRead': '', '/etc/ssh/banner': '', '/opt/rsaAuth/server.xml': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.Da
taSource"\n- url="jdbc:sqlserver://xxxxxxxxxxxxxxxx:1433;databaseName=xxxxxxxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxxxxxxxxx:1433;databaseName=xxxxxxxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxx" password="xxxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', '/etc/sysconfig/network-scripts/network-functions': ''}})
force_rollback = <type 'int'> 1
func = <type 'instancemethod'> <bound method Queue.submit of <server.handlers.xmlrpc.queue.Queue instance at 0x2b12ef33e368>>
method = <type 'str'> queue.submit
Frame process in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 476
fd = <type 'instance'> <cStringIO.StringO object at 0x2b12e76d1788>
_body = <type 'str'> <?xml version='1.0'?> <methodCall> <methodName>queue.submit</methodName>
<params>
<param>
<value><string><?xml version="1.0"?> <params> <param> <value><struct> <member> <name>username</name> <value><string>server-admin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: x86_64-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>d7a03f420bbbb4d9c11b6b1c8507a29e</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>tohclp02mdauth</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000012809</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>5</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>
</string></value>
</param>
<param>
<value><int>55440</int></value>
</param>
<param>
<value><int>0</int></value>
</param>
<param>
<value><string>Files successfully diffed</string></value> </param> <param> <value><struct> <member> <name>diffs</name> <value><struct> <member> <name>/etc/sudoers</name>
<value><string>--- /etc/sudoers 2011-11-10 14:37:42.000000000 -0800
+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311 2011-12-13 03:40:30.000000000 -0800
@@ -93,19 +93,3 @@
# %users localhost=/sbin/shutdown -h now
build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync
-
-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth
-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *
-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check
-
-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpdump *
-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *
-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *
-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *
-%dtrace ALL=(ALL) NOPASSWD: /bin/su - dtrace
-
-cpopescu ALL=(root) NOPASSWD: /usr/sbin/dmidecode
-
-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl * -%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/patches/* -%l2support ALL=NOPASSWD: /sbin/init 6 </string></value> </member> <member> <name>/etc/sysconfig/ntpd</name> <value><string></string></value> </member> <member> <name>/usr/local/bin/cmdline-jmxclient-0.10.3.jar</name>
<value><string></string></value>
</member>
<member>
<name>/opt/rsaScheduler/server.xml</name>
<value><string></string></value>
</member>
<member>
<name>/etc/ssh/sshd_config</name>
<value><string></string></value>
</member>
<member>
<name>/opt/rsa/configs/c-config-challenge.xml</name>
<value><string></string></value>
</member>
<member>
<name>/usr/local/sbin/kbytesWritten</name>
<value><string></string></value>
</member>
<member>
<name>/opt/rsa/custom_provider/configs/customProviders.xml</name>
<value><string></string></value>
</member>
<member>
<name>/etc/postfix/main.cf</name>
<value><string></string></value>
</member>
<member>
<name>/opt/rsa/configs/c-config-challenge_fr.xml</name>
<value><string></string></value>
</member>
<member>
<name>/sbin/ifup-local</name>
<value><string></string></value>
</member>
<member>
<name>/etc/ntp.conf</name>
<value><string></string></value>
</member>
<member>
<name>/etc/sysconfig/snmpd.options</name>
<value><string></string></value>
</member>
<member>
<name>/opt/rsaTools/server.xml</name>
<value><string></string></value>
</member>
<member>
<name>/etc/resolv.conf</name>
<value><string>--- /etc/resolv.conf 2011-03-03 11:42:10.000000000 -0800
+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106 2011-12-13 03:40:30.000000000 -0800
@@ -1,7 +1,6 @@
+# default resolver
+search x.x.x.x
options timeout:3 attempts:2
-; generated by /sbin/dhclient-script
-x.x.x.x
-nameserver x.x.x.x
-nameserver x.x.x.x
+nameserver x.x.x.x
+nameserver x.x.x.x
nameserver x.x.x.x
-nameserver x.x.x.x
</string></value>
</member>
<member>
<name>/home/mdauth/scripts/failXxxxxx.sh</name>
<value><string></string></value>
</member>
<member>
<name>/home/mdauth/scripts/importConfigToDB.sh</name>
<value><string></string></value>
</member>
<member>
<name>/etc/logrotate.d/snmpd</name>
<value><string></string></value>
</member>
<member>
<name>/etc/snmp/snmpd.conf</name>
<value><string></string></value>
</member>
<member>
<name>/usr/local/sbin/kbytesRead</name>
<value><string></string></value>
</member>
<member>
<name>/etc/ssh/banner</name>
<value><string></string></value>
</member>
<member>
<name>/opt/rsaAuth/server.xml</name>
<value><string>--- /opt/rsaAuth/server.xml 2011-10-23 01:37:51.000000000 -0700
+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602 2011-12-13 03:40:30.000000000 -0800
@@ -47,7 +47,7 @@
logAbandoned="true"
name="jdbc/Xxxxxx"
type="javax.sql.DataSource"
- url="jdbc:sqlserver://xxxxxx:1433;databaseName=xxxxxxx;selectMethod=cursor;encrypt=false"
+ url="jdbc:sqlserver://xxxxxx:1433;databaseName=xxxxxxx;selectMethod=cursor;encrypt=false"
username="xxxxxx" password="xxxxxx" />
@@ -394,4 +394,4 @@
</Service>
-</Server>
+</Server>
\ No newline at end of file
</string></value>
</member>
<member>
<name>/etc/sysconfig/network-scripts/network-functions</name>
<value><string></string></value>
</member>
</struct></value>
</member>
</struct></value>
</param>
</params>
</methodCall>
params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>server-admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>d7a03f420bbbb4d9c11b6b1c8507a29e</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>tohclp02mdauth</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000012809</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array
><data>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', 55440, 0, 'Files successfully diffed', {'diffs': {'/etc/sudoers': '--- /etc/sudoers\t2011-11-10 14:37:42.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.68400311\t2011-12-13 03:40:30.000000000 -0800\n@@ -93,19 +93,3 @@\n # %users localhost=/sbin/shutdown -h now\n \n build ALL=NOPASSWD: /bin/rpm -Uvh *, /usr/sbin/rhn-profile-sync\n-\n-%mdauth ALL=(root) NOPASSWD: /bin/su - mdauth\n-%mdauth ALL=(root) NOPASSWD: /sbin/service tomcat5-* *\n-%mdauth ALL=(root) NOPASSWD: /usr/sbin/rhn_check\n-\n-%tcpdump ALL=(root) NOPASSWD: /usr/sbin/tcpd
ump *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtanalysisserver *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtcollector *\n-%dtrace ALL=(root) NOPASSWD: /sbin/service dtserver *\n-%dtrace\tALL=(ALL) NOPASSWD: /bin/su - dtrace\n-\n-xxxx ALL=(root) NOPASSWD: /usr/sbin/dmidecode\n-\n-%l2support ALL=NOPASSWD: /usr/local/bin/cucbc_patch.pl *\n-%l2support ALL=NOPASSWD: /usr/bin/yum -y localinstall /var/tmp/patches/*\n-%l2support ALL=NOPASSWD: /sbin/init 6\n', '/opt/rsaScheduler/server.xml': '', '/home/mdauth/scripts/failXxxxxx.sh': '', '/usr/local/bin/cmdline-jmxclient-0.10.3.jar': '', '/etc/sysconfig/ntpd': '', '/etc/ssh/sshd_config': '', '/opt/rsa/configs/c-config-challenge.xml': '', '/usr/local/sbin/kbytesWritten': '', '/opt/rsa/custom_provider/configs/customProviders.xml': '', '/etc/postfix/main.cf': '', '/opt/rsa/configs/c-config-challenge_fr.xml': '', '/sbin/ifup-local': '', '/etc/ntp.conf': '', '/etc/sysconfig/snmpd.options': '', '/opt/rsaTools
/server.xml': '', '/etc/resolv.conf': '--- /etc/resolv.conf\t2011-03-03 11:42:10.000000000 -0800\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.72901106\t2011-12-13 03:40:30.000000000 -0800\n@@ -1,7 +1,6 @@\n+# default resolver\n+search oss.xxxxxx cs.ad.xxxxxx xxxxxx\n options timeout:3 attempts:2\n-; generated by /sbin/dhclient-script\n-search xxxxxx\n-nameserver x.x.x.x\n-nameserver x.x.x.x\n+nameserver x.x.x.x\n+nameserver x.x.x.x\n nameserver x.x.x.x\n-nameserver x.x.x.xx\n', '/home/mdauth/scripts/importConfigToDB.sh': '', '/etc/logrotate.d/snmpd': '', '/etc/snmp/snmpd.conf': '', '/usr/local/sbin/kbytesRead': '', '/etc/ssh/banner': '', '/opt/rsaAuth/server.xml': '--- /opt/rsaAuth/server.xml\t2011-10-23 01:37:51.000000000 -0700\n+++ /tmp/.rhn-cfg-tmp-29332-1323776430.73723602\t2011-12-13 03:40:30.000000000 -0800\n@@ -47,7 +47,7 @@\n logAbandoned="true"\n name="jdbc/Xxxxxx"\n type="javax.sql.Da
taSource"\n- url="jdbc:sqlserver://xxxxxxxxx:1433;databaseName=xxx;selectMethod=cursor;encrypt=false"\n+ url="jdbc:sqlserver://xxxxxxxx:1433;databaseName=xxxxx;selectMethod=cursor;encrypt=false"\n username="xxxxxxx" password="xxxxx" />\n \n \n@@ -394,4 +394,4 @@\n \n </Service>\n \n-</Server>\n+</Server>\n\\ No newline at end of file\n', '/etc/sysconfig/network-scripts/network-functions': ''}})
method = <type 'str'> queue.submit
self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2b12ef44def0>
Frame handler in /usr/lib/python2.4/site-packages/spacewalk/server/apacheHandler.py at line 195
h = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at 0x2b12ec824998>
self = <type 'instance'> <spacewalk.server.apacheHandler.apacheHandler instance at 0x2b12ec84b9e0>
req = <type 'mp_request'> <mp_request object at 0x2b12eaa94050>
ret = <type 'int'> 0
templateStrings = <type 'dict'> {'email_account_info': '\nAccount Information:\n Your Spacewalk login: <login />\n Your Spacewalk email address: <email-address />', 'email_footer': '--the Spacewalk Team', 'hostname': 'clxd01spacewalk.xxxxxx'}
row = <type 'NoneType'> None
Frame HandlerDispatch in /usr/lib64/python2.4/site-packages/mod_python/apache.py at line 299
req = <type 'mp_request'> <mp_request object at 0x2b12eaa94050>
self = <type 'instance'> <mod_python.apache.CallBack instance at 0x2b12eaa8cb90>
object = <type 'instancemethod'> <bound method apacheHandler.handler of <spacewalk.server.apacheHandler.apacheHandler instance at 0x2b12ec84b9e0>>
l = <type 'list'> ['spacewalk.server.apacheServer', 'Handler']
module = <type 'module'> <module 'spacewalk.server.apacheServer' from '/usr/lib/python2.4/site-packages/spacewalk/server/apacheServer.pyc'>
hlist = <type 'mp_hlist'> {'handler:'spacewalk.server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}
object_str = <type 'str'> Handler
debug = <type 'int'> 0
module_name = <type 'str'> spacewalk.server.apacheServer
config = <type 'mp_table'> {'PythonInterpreter': 'rhn.server'}
dir = <type 'str'> /XMLRPC/
result = <type 'int'> 500
Environment for PID=7688 on exception:
CONSOLE = /dev/console
HOME = /
INIT_VERSION = sysvinit-2.86
LANG = C
NLS_LANG = english.AL32UTF8
ORACLE_HOME = /opt/oracle
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PREVLEVEL = N
PWD = /
RUNLEVEL = 3
SELINUX_INIT = YES
SHLVL = 3
TERM = linux
_ = /usr/sbin/httpd
previous = N
runlevel = 3
-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
Sent: Monday, December 19, 2011 1:02 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Please help with Oracle to PostgreSQL migration
On Wed, Nov 30, 2011 at 11:53:53AM -0800, James Fillman wrote:
>
> I've just gotten a chance to try and export the oracle db after applying the patch you provided. I was able to successfully output a full dump of the oracle database. Thanks!
>
> I am, however, running into another problem. This time it's with the postgresql import. It bombs out with this error message:
>
> ERROR: invalid byte sequence for encoding "UTF8": 0xeda080
> HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
> CONTEXT: COPY rhnpackagechangelogdata, line 136452
Actually, I would kinda expect that patch
> diff --git a/utils/spacewalk-dump-schema b/utils/spacewalk-dump-schema index 0068ed4..b40593b 100755
> --- a/utils/spacewalk-dump-schema
> +++ b/utils/spacewalk-dump-schema
> @@ -118,8 +118,9 @@ sub process_table {
> } elsif ($types[$i] eq 'unknown' or $types[$i] eq 'BLOB') { # blobs
> $row->[$i] =~ s!(.)! sprintf "\\\\%03o", ord($1) !seg;
> } else {
> + utf8::encode($row->[$i]);
> $row->[$i] =~ s!([\x00-\x1f\x5c])! sprintf "\\x%02x", ord($1) !seg;
> - utf8::encode($row->[$i]); utf8::decode($row->[$i]);
> + utf8::decode($row->[$i]);
> }
> print $row->[$i];
> } else {
to address this issue.
What is on that line 136452?
--
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
More information about the Spacewalk-list
mailing list