JasperReports authentication fails :(

[ditman]

Hi there, I'm following the documentation to install JasperReports, and I've stomped against a wall of bricks I cannot get past.

The problem is that I cannot login with my sugar credentials; it always says:

Error: You must specify a valid username and password.


I've double-checked that my user/pass is correct. Also in server.xml, my user/pass corresponds to the MySQL database that I'm trying to access.

When I have a look at "catalina.out" log file, i can see this line:

29-ago-07 5:57:46 net.sf.jasperreports.sugarcrm.realm.SugarDataSourc eRealm open
SEVERE: Excepción realizando autenticación

Wich means roughly: SEVERE: Exception while authenticating

I don't know where to go from here... Any suggestions? If you need XMLs or anything, just ask for it

Thanks!!

[bklawans]

It looks like you are using the JasperReports for SugarCRM project - is that correct? If so, what vesion of Tomcat are you using - is it the version bundled with JasperReports for SugarCRM or a newer version? Finally, is SugarCRM using a database for authentication, or is it using an external system like LDAP?

-Barry Klawans

[ditman]

Hi Barry, thanks for your answer. I didn't notice until now... I was supposed to be monitoring this, but apparently it didn't work. Anyway...

It looks like you are using the JasperReports for SugarCRM project - is that correct?

Correct, I'm using the JasperReports that can be found here:

http://www.sugarforge.org/frs/?group_id=193

If so, what vesion of Tomcat are you using - is it the version bundled with JasperReports for SugarCRM or a newer version?

I've tried with the bundled "catalina" server, but I didn't manage for it to start correctly, so finally I decided to stick with my Fedora Core 5's tomcat5, which is this one:

[ditman@localhost ~]# tomcat5 version
Using CATALINA_BASE: /usr/share/tomcat5
Using CATALINA_HOME: /usr/share/tomcat5
Using CATALINA_TMPDIR: /usr/share/tomcat5/temp
Using JRE_HOME:
Server version: Apache Tomcat/5.5.15
Server built: Mar 6 2006 06:17:44
Server number: 5.5.15.0
OS Name: Linux
OS Version: 2.6.20-1.2320.fc5smp
Architecture: i386
JVM Version: 1.4.2
JVM Vendor: Free Software Foundation, Inc.

Finally, is SugarCRM using a database for authentication, or is it using an external system like LDAP?

It's authenticating against a "localhost" MySQL database, which I've included in the server.xml file. Have a look:

<Resource name="jdbc/jasperreports-sugarcrm" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="XXXXXXXXXX" password="XXXXXXXXXX"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/gdtic_crm" />

The only thing that I didn't know how to do, is to tell my tomcat5 to use another JVM, instead of "gij" wich seems too generic for my taste. Might this be related?

Thanks!!

[ditman]

No clues on this? Anybody?

[cfuentes]

i have the same problem, I cant fix please help me

a follow the instuctions how to install jasperreports and when tried to log on it says
error You must specify a valid username and password.
i have download the jasperreports-sugarcrm.zip