Hi all,
Sorry for cross posting on otrs list, and this dev list, but maybe on the dev list, you could be more useful on this problem!
I try to migrate our
OTRS database from mysql to
Oracle.
We are using
OTRS 2.3.1, the migration process is done with the
scripts generated by sqldevelopper, the processes are:
1) mysqldump --> dumps data to text file
2) create schema in
oracle using the
otrs-schema.
oracle.sql
3) sqlldr (sql loader) to import data from the text file
4) Recreate sequences
All seems fine, but I have a problem with attachments:
Example on an HTML attachment:
Source :
mysql> select * from article_attachment WHERE article_id = 4633 AND id=2508;
| 2508 | 4633 | file-2 | 28057 | text/html;
charset=\"windows-1258\" |<html
xmlns:v=\"urn:schemas-
microsoft-com:vml\"
xmlns:o=\"urn:schemas-microsoft-com:office:office\"
xmlns:w=\"urn:schemas-microsoft-com:office:word\"
xmlns:st1=\"urn:schemas-microsoft-com:office:smarttags\"
xmlns=\"
http://www.w3.org/TR/REC-html40\">
Target seems well imported:
ADMGNDEV> select * from article_attachment WHERE article_id = 4633 AND id=2508;
2508 4633
file-2
28057
text/html; charset=\"windows-1258\"
<html xmlns:v=\"urn:schemas-microsoft-com:vml\"
xmlns:o=\"urn:schemas-microsoft-com 01/10/08 17:03:03 1 01/10/08
17:03:03 1
:office:office\" xmlns:w=\"urn:schemas-microsoft-com:office:word\"
xmlns:st1=\"urn:s
chemas
But the attachment is not readable, and if i try to add the same
attachment via
OTRS (migrated to
Oracle) I have this :
ADMGNDEV> select * from article_attachment WHERE article_id = 100050;
100058 100050
file-2.html
28057
application/octet-stream
PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy
15/10/08 10:47:07 2 15/10/08 10:47:07 2
bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt
YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6c3QxPSJ1cm46c2NoZW1hcy1taWNy
Do you have any idea, why under
Oracle,
OTRS encodes all attachments
using \"application/octet-stream\", and do you know anyway to convert
text (text/html; charset=\"windows-1258\") to octet
(\"application/octet-stream\")?
Hope this clear, don\'t hesitate to ask details.
Thank for your answer.
Regards,
Bastien.
--
Bastien Leblanc
email:
bastien <at> tribuleblanc.comSite :
http://bastien.tribuleblanc.com
Enfants:
http://www.travisjudith.info
Today we created a cvs branch for OTRS 2.3. That means this branch will have all future bug fixes for OTRS 2.3.x (just bug fixes no new features). To checkout the 2.1 branch use: =============================== "cvs -z3 -d :pserver:<user> <at> cvs.otrs.org:/home/cvs co -r rel-2_3 otrs" To checkout the cvs HEAD use: ============================= "cvs -z3 -d :pserver:<user> <at> cvs.otrs.org:/home/cvs co otrs" Thanks, and happy coding! .-) PS: The current stats about the OTRS framework source code (_without_ all additional modules like WebMail, FAQ, FileManager, SIRIOS, ...) is: ----------------------------------------------------------------- Source code lines (*.sh) : 968 Source code lines (*.pl) : 7344 Source code lines (*.pm) : 207644 Source code lines (*.t) : 24593 Source code lines (*.dtl): 22069 Source code lines (*.xml): 18279 ----------------------------------------------------------------- That means we have totally -->> 280.897 <<-- lines source code in OTRS 2.3. ;) -Martin
RSS Feed