[Spacewalk-list] ISE Executing Remote Commands via SSM

[Wojtak, Greg (Superfly)]

On 2012-08-20 9:40 AM, "Michael Mraka" <michael.mraka at redhat.com> wrote:

>Wojtak, Greg (Superfly) wrote:
>% I changed the script around slightly and got it to work.  The failing
>line
>% was the 
>% 
>% SPACEHOST=$(awk -F= '/^serverURL=/ {print $2}'
>% /etc/sysconfig/rhn/up2date|sed 's+.*//\(.*\)/XMLRPC+\1+')
>% 
>% 
>% I removed the pipe to sed and modified my awk statement a bit.  Getting
>% rid of the sed cleared it up completely, so scheduling a remote command
>on
>% one or many servers results in an ISE with something in the following:
>% 
>% sed 's+.*//\(.*\)/XMLRPC+\1+'
>% 
>% I'm guessing one or more characters is not getting escaped properly
>% (perhaps the backslashes)?
>
>Is there any error in /var/log/up2date on the client?
>
>You may also schedule remote action and then run 'rhn_check -vvv' on
>the client manually to see some more verbose output.
>
>% Greg Wojtak
>
>Regards,
>
>--
>Michael Mráka
>Satellite Engineering, Red Hat
>
>_______________________________________________
>Spacewalk-list mailing list
>Spacewalk-list at redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list

No, nothing on the client.  The job is not getting scheduled (ie, the ISE
and traceback I posted in my original email was complaining about what
looked like a SQL error.

[Fri Aug 17 10:45:29 2012] [error] Execution of
/var/www/html/network/systems/details/remote_commands.pxt failed at Fri
Aug 17 10:45:29 2012: RHN::Exception: DBD::Pg::st execute failed: ERROR:
invalid input syntax for type bytea\n  RHN::DB
/usr/share/perl5/vendor_perl/RHN/DB.pm 228 RHN::Exception::DB::throw\n
RHN::DB::st /usr/share/perl5/vendor_perl/RHN/DB.pm 564
RHN::DB::handle_error\n  RHN::DB::Scheduler
/usr/share/perl5/vendor_perl/RHN/DB/Scheduler.pm 1564
RHN::DB::st::execute_h\n  Sniglets::Servers
/usr/share/perl5/vendor_perl/Sniglets/Servers.pm 836
RHN::DB::Scheduler::schedule_remote_command\n  PXT::ApacheHandler
/usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 493
Sniglets::Servers::remote_command_cb\n  PXT::ApacheHandler
/usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103
PXT::ApacheHandler::pxt_parse_data\n  PXT::ApacheHandler
/usr/share/perl5/vendor_perl/PXT/ApacheHandler.pm 103 (eval)\n  main -e 0
PXT::ApacheHandler::handler\n  main -e 0 (eval)


The "invalid input syntax for type bytea" caught my eye.

Greg Wojtak
Sr. Unix Systems Engineer
Office: (313) 373-4306
Cell: (734) 718-8472