ZuckerReports Output Failure

[pmcgovern]

Below I have pasted the "Output" of a ZuckerReport to a Sony Vaio w/ Windows XP installed. On every other machine I've tested this report on many other machines in the building and it has worked flawlessly. Anyone have an idea as to what's going on?



cmdline: javaw -classpath "modules/ZuckerReports/resources/;modules/ZuckerReports/resources/Opportunity_by_Product_Division.jasper_files/;modules/ZuckerReports/jasper/antlr-2.7.5H3.jar;modules/ZuckerReports/jasper/asm-attrs.jar;modules/ZuckerReports/jasper/asm.jar;modules/ZuckerReports/jasper/barbecue-1.1.jar;modules/ZuckerReports/jasper/bsh-1.3.0.jar;modules/ZuckerReports/jasper/cglib-2.1.jar;modules/ZuckerReports/jasper/commons-beanutils-1.5.jar;modules/ZuckerReports/jasper/commons-collections-2.1.jar;modules/ZuckerReports/jasper/commons-digester-1.7.jar;modules/ZuckerReports/jasper/commons-javaflow-20060411.jar;modules/ZuckerReports/jasper/commons-logging-1.0.2.jar;modules/ZuckerReports/jasper/commons-logging-api-1.0.2.jar;modules/ZuckerReports/jasper/dom4j-1.6.jar;modules/ZuckerReports/jasper/ehcache-1.1.jar;modules/ZuckerReports/jasper/groovy-all-1.0-beta-10.jar;modules/ZuckerReports/jasper/hibernate3.jar;modules/ZuckerReports/jasper/hsqldb-1.7.1.jar;modules/ZuckerReports/jasper/itext-1.3.1.jar;modules/ZuckerReports/jasper/jasperreports-1.2.2.jar;modules/ZuckerReports/jasper/jcmdline-1.0.2.jar;modules/ZuckerReports/jasper/jcommon-1.0.0.jar;modules/ZuckerReports/jasper/jdt-compiler.jar;modules/ZuckerReports/jasper/jfreechart-1.0.0.jar;modules/ZuckerReports/jasper/jr-bsh-compiler.jar;modules/ZuckerReports/jasper/jsmoothgen-ant-0.9.7.jar;modules/ZuckerReports/jasper/jta.jar;modules/ZuckerReports/jasper/jxl.jar;modules/ZuckerReports/jasper/log4j-1.2.8.jar;modules/ZuckerReports/jasper/looks-2.0-rc.jar;modules/ZuckerReports/jasper/mysql-connector-java-3.1.13-bin.jar;modules/ZuckerReports/jasper/nsisant-1.1.jar;modules/ZuckerReports/jasper/png-encoder-1.5.jar;modules/ZuckerReports/jasper/poi-2.0-final-20040126.jar;modules/ZuckerReports/jasper/tinylaf.jar;modules/ZuckerReports/jasper/toniclf.jar;modules/ZuckerReports/jasper/xalan.jar;modules/ZuckerReports/jasper/xercesImpl.jar;modules/ZuckerReports/jasper/xml-apis.jar;modules/ZuckerReports/jasper/zuckerreports-1.0.jar;" at.go_mobile.zuckerreports.JasperBatchMain modules/ZuckerReports/temp/19896990-75b3-7e1d-3135-44e090ed78b1/cmd.properties 2>&1

[pmcgovern]

Hi again,

I've actually narrowed this down to a permissions error. However I find it highly odd.

I'm running...

SugarCRM 4.2
MySQL 5
ZuckerReports with latest patch (g or f)
PHP 5

Our administrators are the only ones that actually get reports from ZuckerReports. Everyone else gets the errors seen above. What I don't understand is, why they are getting these errors and why domain permissions are being read on these accounts?

Any help is greatly appreciated. Thanks.

[ftreml]

when running this report as Sugar admin, it works ? and if not, it doesn't ? rather strange. does this only happen for this report, or also for others ? do the listings and queries work ?

[pmcgovern]

when running this report as Sugar admin, it works ? and if not, it doesn't ? rather strange. does this only happen for this report, or also for others ? do the listings and queries work ?

This happens on all reports and it isn't a sugar "admin" problem. It's a Domain problem. Actual Active Directory accounts.

Example:

I log in as myself (Admin/Domain Admin) and login to Sugar as me (admin). Report Successful.
I log in as myself (Admin/Domain Admin) and login to Sugar as an employees (user). Report Successful.
I log in as employee(Domain user) and login to Sugar as admin or employee. Report fails.

Same thing happens when the rest of the IT department logs in (all admins), it works just fine. If you log on to the machine as a non-admin user, you recieve the error in first post reguardless of your "permissions" in SugarCRM.

[lmausz]

I suppose you use Internet Information Server with Windows 2000 or older.

It seems that the server uses the permissions of the impersonated client user.
Check your security settings in IIS, if every user can access the path of the java installation and that every user is allowed to start the program.

[pmcgovern]

I suppose you use Internet Information Server with Windows 2000 or older.

It seems that the server uses the permissions of the impersonated client user.
Check your security settings in IIS, if every user can access the path of the java installation and that every user is allowed to start the program.

I'm using IIS 6.0 on Windows 2003 Server.. but I'm checking all the permissions and adding all users to the directories for Java and it just isn't doing the trick.

[pmcgovern]

For all those doing searches and stumbling upon this thread...

With Windows 2003 Server & IIS 6.0, in order to run an EXEC() command via PHP, c:\windows\system32\cmd.exe needs to be setup that the proper users can Execute it. This is a security risk, so be weary of who is allowed to access it.

[ftreml]

thanks for your feedback. will include a hint in the installation manual.