Bonjour, j’ai un serveur mail, et j’aimerai que lorsque je reçois un
mail, le serveur exécute une commande ruby, j’ai trouvé, il exécute bien
la commande, mais un des champs n’est pas bien traduit.
En fait, j’ai un message d’erreur :
Dec 5 12:29:02 ns000 postfix/local[19911]: B41B750006B:
to=[email protected], relay=local, delay=1, status=bounced
(Command died with status 1: “/usr/bin/ruby
/root/dossier_de_l_appli/script/runner ‘Mailman.receive(STDIN.read)’”.
Command output:
/usr/lib/ruby/gems/1.8/gems/rails-1.1.6/lib/commands/runner.rb:27:
/usr/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in
log': Mysql::Error: You have an error in your SQL syntax near ''73757065722073757065720a0a0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2' at line 1: INSERT INTO messages (email_to, email_body, email_from, email_subject`) VALUES(‘[email protected]’,
x’73757065722073757065720a0a0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d0a6d61696c32776562202d20436865636b20796f757220656d61696c2066726f6d20746865207765622061740a687474703a2f2f6d61696c327765622e636f6d2f202e0a0a0a’,
'— \n- [email protected])
En fait je pense que cela vient de :
x’73757065722073757065720a0a0a2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d2d0a6d61696c32776562202d20436865636b20796f757220656d61696c2066726f6d20746865207765622061740a687474703a2f2f6d61696c327765622e636f6d2f202e0a0a0a’, >
Puisque il me met un x devant la chaine et d’ailleurs la chaine est
completement bizzarre, puis j’avai tapé ‘test super’ dans le champ bod
de mon mail…
J’espere que quelqu’un pourra m’aider !
Merci d’avance !