after installation no known user Â

[ktrinad]

By: Georg Joo - joogeorg

after installation no known user Â

2006-05-10 02:24

But I have a little problem with the database (MySQL).Â

I didn't install the server with the installer, but only with the zip file by hand.Â

Â

So everything works fine, but in the jasperserver database I have no user to login. I didn't found the tomcat user, not the joeuser.Â

Â

Now I have 13 users. (admin, jim, emil, vital, sarah, sally, max, will, chris, beth, kristen, jaime, matt).Â

What are the login information for my installation? How can I insert a user ?Â

Â

I created the database with the db-dump-113005.sql dump.Â

The other scripts didn't work.Â

Â

Have someone information.Â

Â

regardsÂ

Â

Ing. Georg Joo

 

 

 

 

By: T Kavanagh - tkavanagh

RE: after installation no known user Â

2006-05-10 14:24

Hi Georg,Â

Â

I just finished getting the most current docs on-line for the "stand-alone" war file installation.Â

Â

Please take a look at the Documents section of the web site. You should find a link (and a PDF) at "Stand-alone War Install Guide". (The download file zips will not get updated until our next release at the end of May).Â

Â

This install document has a couple of sections that deal with database configuration.Â

Â

But, just to give you a short idea about how things are setup:Â

Â

There are two databases:Â

Â

jasperserver Â

sugarcrmÂ

Â

sugarcrm holds sample data and should be populated using the db-dump sql script. Â

Â

All the other scripts should be run against the jasperserver database. The jasperserver database holds the metadata that JasperServer needs to run.Â

Â

The jasperserverTestMetadata.sql is the one that creates the tomcat user and the joeuser user.Â

Â

The users you mention (sally, max, will, etc) are from the sugarcrm sample data (data used to "fill" the sample reports). JasperServer only references a small sub-set of the tables found in sugarcrm. The sugarcrm.user table is only used for display (ie. not for logging in).Â

Â

Let me know if this helps.Â

Â

-TonyÂ

Â

 

 

 

 

By: Georg Joo - joogeorg

RE: after installation no known user Â

2006-05-10 23:24

Hi TonyÂ

Â

Thanks for your answer.Â

Â

I was a little confused with the scripts. I read the docs a second time and nowÂ

a have 2 databases - jasperserver and sugarcrm.Â

All user are now available. (jasperadmin, joeuser)Â

Â

All works fine.Â

Â

thanksÂ

Â

GeorgÂ