Hi,
I have alfresco-5.0.a installed on a Ubuntu VPS. Now I want to transform various documents (e.g. docx, .xlsx) to PDF, but I get errors like
Transformer for 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' source mime type and 'application/pdf' target mime type was not found. Operation can't be performed
When I look at Available transform options | Alfresco Documentation it says application/vnd.openxmlformats-officedocument.spreadsheetml.sheet should be convertible to application/pdf.
/opt/alfresco-5.0.a/libreoffice/program/.soffice.bin is running on the VPS.
alfresco-global.properties contains following:
###############################
## Common Alfresco Properties #
###############################dir.root=/opt/Alfresco/alf_data
alfresco.context=alfresco
alfresco.host=127.0.0.1
alfresco.port=8080
alfresco.protocol=httpshare.context=share
share.host=127.0.0.1
share.port=8080
share.protocol=http### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=XXX
db.name=alfresco
db.url=jdbcostgresql://localhost:5432/${db.name}
# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN### FTP Server Configuration ###
ftp.enabled=true
ftp.port=23### RMI service ports ###
alfresco.rmi.services.port=50500
avm.rmi.service.port=0
avmsync.rmi.service.port=0
attribute.rmi.service.port=0
authentication.rmi.service.port=0
repo.rmi.service.port=0
action.rmi.service.port=0
deployment.rmi.service.port=0### External executable locations ###
ooo.exe=/opt/Alfresco/libreoffice/program/soffice.bin
ooo.enabled=true
ooo.port=8100
img.root=/opt/alfresco-5.0.a/common
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
swf.exe=/opt/Alfresco/common/bin/pdf2swf
swf.languagedir=/opt/Alfresco/common/japanesejodconverter.enabled=true
jodconverter.officeHome=/opt/Alfresco/libreoffice
jodconverter.portNumbers=8100### Initial admin password ###
alfresco_user_store.adminpassword=XXX### E-mail site invitation setting ###
notification.email.siteinvite=false### License location ###
dir.license.external=/opt/alfresco-5.0.a### Solr indexing ###
index.subsystem.name=solr
dir.keystore=${dir.root}/keystore
solr.port.ssl=8443### BPM Engine ###
system.workflow.engine.jbpm.enabled=false### Allow extended ResultSet processing
security.anyDenyDenies=false
Thanks for your help!
1 ACCEPTED ANSWER
I wanted to send this in private but it appears there is no option of doing that, so I have trimmed some information from this post (think script kiddies).
If you are only using this server for proof of concept development and testing, then you can probably stop reading and ignore the rest of this post.
But if there is *any* chance of this machine becoming a live production system in future (or being used as the basis for one), then I would strongly recommend some security work and post edits are performed sooner rather than later (in my experience, later never happens, because security costs money).
1) Suggest remove your public IP address from your post - that information is 'need to know' generally.
2) Having 8080 on the end infers direct tomcat access since that is the default for alfresco (not to mention what you see if you go to the bare hostnameort - the default tomcat page). However, Tomcat is not a robust web server - not like apache or nginx - suggest you proxy through either of those as soon as possible. You can solve this and #3 and #4 below with a proxy web server config. [No flame wars, thanks - tomcat is fine as the app server but it definitely is not a robust web server in the security sense]
3) It appears that solr is enabled on that public interface (it prompted me to login and gave me access to your solr instance with the default client certificate...). Solr should be limited to localhost connections (tunnelling over ssh works fine, I do it often). Unless you have a cluster, I am not aware of any reason for solr to accept connections from anywhere but the local machine itself.
4) 'Plain text' (not SSL encrypted) port 8080 logins will expose the userid and password to every device between you and that server - suggest switch to forced https to limit who can see the logon details. In some countries the ISP may store this information indefinitely. In some (possible the same) countries, the ISP's are required by Law to store it *and* provide it to government upon request (and yes Australia is one of them, and yes, they share it).
5) Hopefully a firewall (at worst, ufw) is protecting the 'other tomcat ports', and/or you have changed the shutdown command to something new. If your alfresco instance stops 'randomly', this may explain why - it is trivial to do.
6) Maybe copy the service mimetype information here rather than provide a link directly to your alfresco server. I see there is Basic Auth logon in front of it so we are not able to see what is there anyway.
