I’m trying to use JasperStarter to create pdf files.
I created an execution string that works perfectly with a standard user example: myuser
/opt/JasperStarter/bin/jasperstarter pr /home/myuser/JasperReport/Anagrafica_A4_1.jrxml -f pdf -H localhost -u myuser -p ‘mypassword’ -n jl4rhhsc_spr0000 -o /home/myuser --db-driver org .mariadb.jdbc.Driver --db-url jdbc:mysql://localhost -t generic --jdbc-dir /opt/JasperStarter/jdbc --db-port 3306 >>/home/myuser/log.txt
I tried to use a blank application in Scriptcase where an exec($cmd, $output, $retval) command executes the jasperstarter string
$cmd="/opt/JasperStarter/bin/jasperstarter pr /tmp/report/Anagrafica_A4_1.jrxml -f pdf -H localhost -u jd_myuser -p ‘mypassword’ -n jl4rhhsc_spr0000 -o /tmp/report --db-driver org .mariadb.jdbc.Driver --db-url jdbc:mysql://localhost -t generic --jdbc-dir /opt/JasperStarter/jdbc --db-port 3306 >>/tmp/log.txt ";
/tmp and /tmp/report have 777 rights
The application does not work, probably due to a rights problem and in the /tmp/log.txt file it displays the message at the last line:
Unable to connect to database: No suitable driver found for jdbc.mariadb://localhost:3306
The user under which it is run is in fact a daemon and creates problems for the execution of jasperstarter.
Is there a way to execute an exec($cmd, $output, $retval) command from a blank application with a standard user? Or a proper way to run JasperStarter from
I apologize, but my knowledge of Linux Ubuntu is quite poor.