alonzvi Posted February 26, 2007 Share Posted February 26, 2007 helloi am trying to install jasper intelligence on xp with the bundled tomacat but with exsisting mysqli pointed to the bin directory used 127.0.0.1 or localhost user name and password of the root but i get all the time the same error : unable to connect to database - any ideas ?thanks: Link to comment Share on other sites More sharing options...
rsilverns.sympatico.ca Posted February 27, 2007 Share Posted February 27, 2007 You've run the sql scripts to create the base database structure in your local mysql? Also try to use the 3306 port number. Just a few things off top of my head. HTH,Robin Link to comment Share on other sites More sharing options...
tkavanagh Posted February 27, 2007 Share Posted February 27, 2007 Yes, using 127.0.0.1 (localhost), the correct mysql port number, username and password should get you connected during the installation. Another thing to try is logging into mysql directly to validate that your information is correct (and mysql is actually up and running). mysql -u <db-username> -p -h 127.0.0.1 --port 3306 I believe that the installer should run fine even if the mysql password is "blank". But I'll double-check this. -Tony Link to comment Share on other sites More sharing options...
kschmitte Posted July 3, 2007 Share Posted July 3, 2007 I just downloaded the JS 2.0 installer to my W2K (as I had the same issue with the not able to connect to DB with the 1.2.1 installer) and tried to install JS on an exosting MySQL db on a foreign machine. Login, IP and Port are correct, and a connection to this DB works.No changes in behaviour - the installer tells me that he cannot connect. Why does this fail? Do I really need to install manually? Or is there any workaround and I was too blind to see the thread? Thanks! Kai Schmitte Link to comment Share on other sites More sharing options...
shija03 Posted July 4, 2007 Share Posted July 4, 2007 If you can connect from your client system to the remote DB using the 'mysql' command line tool, then ignore the comments that follow. MySQL on a remote system requires to have the its user configure to accept connections from a remote (client) system Normally MySQL on a local machine is configured to allow connections for root as followsroot@localhost If you require to allow connections to the MySQL Server from a remote system you will need to configure the root user to also allow for: root@<some_ip_address>orroot@% The root@% states that you are allowing MySQL Server to accept connections for the user root from any system Link to comment Share on other sites More sharing options...
kschmitte Posted July 4, 2007 Share Posted July 4, 2007 Hello Shija03, thanks again for your quick response!Unfortunatly I can access the (remote) DB from my local machine - at least with my SQL client (Aqua Data Studio). May there any incompatibility? Maybe in the MySQL version I use? Thanks for any help! Kai Link to comment Share on other sites More sharing options...
tkavanagh Posted July 5, 2007 Share Posted July 5, 2007 Keep in mind that the installer does not run successfully under Windows 2000. This is due to the environment space limitation (in a cmd shell) in W2K. In order to populate the sample data, the installer runs the jasperserver import utility which is a java app. When all of the jasperserver jars are included on the classpath, it runs out of space and fails. Try installing to any more recent windows systems and that should work. -Tony Link to comment Share on other sites More sharing options...
kschmitte Posted July 5, 2007 Share Posted July 5, 2007 Hello tkavangh, do you mean the path length issue for the sample data? Or are there other restrictions also? I have already read http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=22080.And, I was able to install JasperServer 1.2.1 without the smaple data on the same machine using the embedded MySQL and Tomcat. My current aim is to install JS on the same machine again - but now with a seperate MySQL (which is regularly backed up) and on the tomcat which is running as W2K service. Will there be any compatibility issue, or can I set up & run JS on W2K in this setup? (If I use a manual install) Thanks for your help! Kai Link to comment Share on other sites More sharing options...
kschmitte Posted July 6, 2007 Share Posted July 6, 2007 Needing to step forward, I decided to install JS 2.0 manually.Worked fine after exploding the WAR file to find config issues - although a manual for the manual installation (enhanced chapter 7: "Database Configuration") would be really nice. Thanks for your help! Kai Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now