connection with mysql having special characters in password breaks the jasperstarter command

[savankaneriya]

I have connected my Laravel app with jasper report having mysql as connection. Locally it worked fine but in live it shows the error like this After investigating 2 days i found my server had special characters ** at last in mysql password. I changed password and worked fine. hope this issue be fixed soon.

[ryangp]

hi @savankaneriya, did you manage to work with PHPJasper with parameters?

I get error having parameter in me. what do you think the reason ?

            ```

$jasper = new PHPJasper;

            $jasperinput = public_path().'/jasperinputs/EmployeeData.jrxml';
    $jasperoutput = public_path().'/jasperoutputs/'.$bio_num;
    $pdfreports = public_path().'/pdfreports';
    $outputoption = [
        'format' => ['pdf'],
        'locale' => 'en',
        'params' => ['bio_num' => $bio_num],
        'db_connection' => [
            'driver' => 'mysql',
            'username' => 'root',
            'password' => '',
            'host' => 'localhost',
            'database' => 'hris_db',
            'port' => '3306'
        ]
    ];
    $jasper->process(
        $jasperinput,
        $jasperoutput,
        $outputoption
    )->execute();

by the way, what version of laravel and php are you using?
Thanks.