Page 1 of 2

scalix and excel files attachment

Posted: Mon May 28, 2007 2:54 pm
by jpinder70
No users usign the Scalix version 11 and the latest update of Outlook Connector or SWA cannot view excel files, (csv, xls) all show up as garble-goo:

e.g.

(DE414T@(R(L(D1%4T-225!424].(BPB0TQ!4U,B+")/3BU(04Y$(BPB4$5.
M1"!2+T$B+")"04-+3U)$15(B+")!5D%)3$%"3$4B+")"549&15(B+"(P+3,@
M5T5%2R(L(C0@5T5%2U,B+"(U(%=%14M3(BPB-B!7145+4R(L(C<@5T5%2U,B
M+"(X(%=%14M3("LB+")0+D\N)U,B"B(C,35+5$Q83#5"6"`B+")+24-+5$%)
M3"!83"`U($)/6"(L(E!'(BPR-C`Y+#`L,3`L,C4Y.2PP+#$L,"PP+#(L,BPU
M+#`*(C`P,4=,0E!222`@("(L(D=,3T)!3"!04DE/4DE462!-04E,(BPB4E,B

Posted: Tue May 29, 2007 3:43 am
by ScalixSupport
Hi!

What version of Scalix you are using, what is the OS where the Scalix Server in installed?
Do you get any error in /var/opt/scalix/??/s/logs/fatal log file when you try to read the Excel
file?

Thanks,
Subir

Posted: Tue May 29, 2007 6:04 am
by Axel
After update from 11.02 to 11.04 we are unable to recieve most types of attachments (pdf, doc, xls). Message is displayed that it contains an attachment but you are unable to open it with Outlook (IMAP) or SWA. Binary attachments like zip or exe files work.

Please help

Posted: Tue May 29, 2007 6:28 am
by ScalixSupport
Hi!

Send me the uncommented contents of /var/opt/scalix/??/s/sys/general.cfg file. Is this
happening with all users or a few. Can you check if you get any error/serious error in the
fatal log that could be found at /var/opt/scalix/??/s/logs/fatal.

Thanks,
Subir

Posted: Tue May 29, 2007 6:40 am
by Axel
ScalixSupport wrote:Hi!

Send me the uncommented contents of /var/opt/scalix/??/s/sys/general.cfg file. Is this
happening with all users or a few. Can you check if you get any error/serious error in the
fatal log that could be found at /var/opt/scalix/??/s/logs/fatal.

Thanks,
Subir


It happens to all users.

Content of general.cfg (all other line are comments):

Code: Select all

USRL_AUTO_GEN_SGI_2_CN=S G
USRL_AUTO_GEN_AUTHID=G.S@mydomain.eu
INET_AUTO_GEN_DOMAIN=mydomain.eu
UAL_SIGNON_ALIAS=YES
UAL_SIGNON_ALIAS_CONFIG=SYS
UAL_USE_SIGNON_ALIAS=FALSE
CDA_USE_CHANGE_LOG=TRUE
IMAP_CONNECTION_LIMIT=500
IMAP_CONNRATE_LIMIT=10
IMAP_IDLE_TIMEOUT=31
LD_CREATE_MESSAGE_STORE=TRUE
LD_AUTOREPLY_EXPIRY_TIME=2d
OMLIMIT_MIN_WARN_INTERVAL=3d
UAL_SIZE_ON_RECEIPT=TRUE
UAL_SIZE_MSG_TO_USER=TRUE
UAL_MSTORE_SIZE_LIMIT=100000
RECOVERY_FOLDER_EXPIRY_TIME=7d
NDN_EM_SERIOUS_ONLY=TRUE
IDX_MAXLOAD=0.5
IDX_MINLOAD=0.2


fatal contains:

Code: Select all

ERROR                                 (Service 14    ) Tue May 29 08:32:53 2007
[OM 0]
Pid of logging process: 32512
  Last Msg Id: 21383661.981180420365128.JavaMail.root(a)webmail.t-s-r.com
  Last Msg DirectRef: 00012fcfd16e7391


If I "play" with mime.types and comment out the lines for doc-files (type 2150) we will receive the files.

Posted: Tue May 29, 2007 8:02 am
by ScalixSupport
Hi!

Last Msg DirectRef: 00012fcfd16e7391

The message direct reference above would tell the message details and the user whose
mailbox might be troublesome, to know the details use the command:

Code: Select all

omdref 00012fcfd16e7391

see what result you get.

Thanks,
Subir

Posted: Tue May 29, 2007 8:14 am
by Axel

Code: Select all

Can't resolve DirectRef: 00012fcfd16e7391

Posted: Tue May 29, 2007 8:19 am
by ScalixSupport
Hi!

I would request you to omscan for all users to fix mailbox inconsistencies if any.

Run omscan as below:

Code: Select all

omoff -d0 omscan
omscan -Z     
omon omscan     

You need to watch the status of the omscan process using the command:

Code: Select all

omscan -t

Wait until you get a message that says "Current server cycle not started; service reset
or delayed".

Now try to fix the mailstore related issues in active mode using the below given
command:

Code: Select all

omscan -Aavfx


Thanks,
Subir

Posted: Tue May 29, 2007 8:25 am
by Axel
Is in progress.

What do you think will a fresh install (complete deinstall and reinstall) of Scalix 11.04 fix it? What files/directories need to be saved to keep userdata?

Posted: Tue May 29, 2007 8:31 am
by Axel
Done.
But nothing changed. If I send a pdf-doc to myself I receive a message that is marked "with attachment" but if I open the message no attachment is visible.
With Outlook (IMAP) the attachment sign is gone when you open the message.

Posted: Tue May 29, 2007 8:47 am
by mikethebike
Axel,

something that does look strange to me is your entry from your fatal file.

ERROR (Service 14 ) Tue May 29 08:32:53 2007
[OM 0]
Pid of logging process: 32512
Last Msg Id: 21383661.981180420365128.JavaMail.root(a)webmail.t-s-r.com
Last Msg DirectRef: 00012fcfd16e7391

rather than displaying the service name, its displaying the service number rather than the name. It would almost suggest that the config has not been completed, and may explain why filetypes are not being mapped correctly.

I wonder if you have run omcnvinst after upgrading?

Mick

Posted: Tue May 29, 2007 8:55 am
by Axel
scalix-installer finished the update process without any error.

I did not run omcnvinst.

Posted: Tue May 29, 2007 9:24 am
by mikethebike
Is there a line like:

1167 q application/* csv

in your ~instance/sys/mime.types file?

if there is, comment that line out and restart Scalix.

Mick

Posted: Tue May 29, 2007 9:37 am
by ScalixSupport
Hi!

You can try a re-install, the user data is in /var/opt/scalix folder, when you take backup
make sure you restore the ownership, order and permissions.

Try following these steps:
* Stop Scalix Server using omshut
* take backup of /var/opt/scalix restoring ownership, order and permissions.
* uninstall all RPMs returned for rpm -qa | grep scalix
* rm -rf /var/opt/scalix* /etc/opt/scalix* /opt/scalix*
* untar the backup created earlier at /var/opt/scalix
* Run scalix-installer, let it pick the existing message store

Thanks,
Subir

Posted: Tue May 29, 2007 10:36 am
by Axel
Thank you.

It seems that only POP/IMAP and SWA show the problem. If I access my mailbox with outlook-connect I can see/read attachtments