Protean and GreEd Installer Now Available

» Back to forum topics
  16 posts   Feedicon  
Replies: 15 - Last Post: November 23, 2009 13:44
by: Hemant Shah
« Older Topic » Newer Topic
showing 1 - 16 of 16
 
Hemant Shah
Hemantshah-0_small
Posted: October 19, 2009 19:13 by Hemant Shah
» Permalink
We are now making available our installer, fresh off the oven.

Download and Install Protean and GreEd using our new installer (beta)

Please note that if you have saved previously created Proteus Guidelines or Knowledge Components from a previous installation, you will lose them when you run this installer. To avoid loss of your work, please save the guidelines and KCs to a suitable location by using the 'export' feature of Protean and once the installation is complete, please restore them by using 'import' function.

We will be addressing this issue in the next release of the installer.

As always, we look forward to your feedback.

Enjoy!!
 
gkris
Defaultpersonimage
Posted: October 20, 2009 18:46 by gkris
» Permalink
I downloaded the installer and it was so easy to set up the application. Just I forgot to save the guidelines and lost them. Great work!!!
 
Hemant Shah
Hemantshah-0_small
Posted: October 21, 2009 22:16 by Hemant Shah
» Permalink
Thanks for your inputs.
 
Brian Armstrong
Brianarmstrong_small
Posted: November 06, 2009 03:24 by Brian Armstrong
» Permalink
I installed on Mac OSX, and the install went through fine, except when I try to run using "java -jar pip.jar" I get errors and he application doesn't run. The specific error is:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied for user ''@'localhost' to database 'proteus'


I'm assuming that the username is missing before '@localhost'. Where is this stored?

Thanks,
Brian Armstrong

P.S. I just heard about Proteus yesterday and am a first time user. Very cool software!
 
Hemant Shah
Hemantshah-0_small
Posted: November 08, 2009 19:45 by Hemant Shah
» Permalink

Brian, I apologize for not seeing your message earlier. I am not fully familiar with KenaI yet.

There is a SQL script that the installer runs to provide all privileges to the anonymous user for the Proteus and GreEd related databases. It appears that for some reason this script didn't run as expected on Mac. We will investigate this when we come back to updating the installer again.

Meanwhile, can you provide the privileges yourself by going into MySQL administration and checking if there is an anonymous account. If not, then create one. For the anonymous account, go to the schema privileges section and move all privileges to the "Assigned Privileges" section for the following databases:
proteus, dataelements, jessrules and rules

Please let me know if you can then start the application.

Regards,

Hemant
 
Brian Armstrong
Brianarmstrong_small
Posted: November 12, 2009 21:20 by Brian Armstrong
» Permalink
Hi Hemant,

Just checking back and tried your suggestion, but the same effect occurs. Doesn't seem like there is a user being passed in the call and the error is:

Access denied for user ''@'localhost' to database 'proteus'

You will notice there is no user between the single quotes before the @ sign.

Thanks,
Brian

P.S. if the installer is now fixed should I just try it again?
 
Brian Armstrong
Brianarmstrong_small
Posted: November 12, 2009 21:29 by Brian Armstrong
» Permalink
Just re-tried the installer (sorry couldn't wait for a reply), and it doesn't work still.

Is anybody else experiencing this problem, or is it just me?

Thanks,
Brian
 
Hemant Shah
Hemantshah-0_small
Posted: November 13, 2009 15:50 by Hemant Shah
» Permalink
Sorry about the problem, Brian.

This seems to be due to the fact that we have used blank user (i.e. '') in the code and had assumed that all installations of MySQL servers will accept that as anonymous user. Apparently it is not so.

On the other hand you can create a new user (e.g., ProteanUser) in MySQL set up, with all privileges to the said databases, and in org.proteme.protean.PpcDb.java and org.proteme.greed.greedapp.RulesDb.java change the username field where it is initialized, as follows:

private String username = "ProteanUser"; //most likely to be line 52 in PpcDb and line 47 in RulesDb


Compile and execute. Let us know if it works. Or please give us a few days and we will address this.

- Hemant
 
Hemant Shah
Hemantshah-0_small
Posted: November 20, 2009 14:34 by Hemant Shah
» Permalink
Brian,
I have made the changes and uploaded the new installer.

You can download it from here: http://www.proteme.org/download3.html


Please let me know if it works.

- Hemant
 
Andrew Fielden
Afielden_small
Posted: November 21, 2009 19:47 by Andrew Fielden
» Permalink
Sorry Hemant, but the problem still exists with this installer.
 
Andrew Fielden
Afielden_small
Posted: November 21, 2009 21:10 by Andrew Fielden
» Permalink
I checked out the code from svn for the 'protean' project.
I fixed the username/password problem as you suggested, but still run into errors. Engine.java is trying to do the following -

ResultSet rs = PrGlobals.getDb().executeQry("select max(version) from proteusweb.executionstatuses where executionId = '" + executionId + "'");

which results in this error

java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
at com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:817)
at com.mysql.jdbc.UpdatableResultSet.checkRowPos(UpdatableResultSet.java:230)
at com.mysql.jdbc.ResultSetImpl.getInt(ResultSetImpl.java:2578)
at org.proteme.engine.Engine.resumeExecution(Engine.java:221)
at org.proteme.engine.Engine.main(Engine.java:587)

Database 'proteusweb' does not appear to have been created as part of my installation.
 
Hemant Shah
Hemantshah-0_small
Posted: November 22, 2009 10:41 by Hemant Shah
» Permalink
Andrew,

You have to execute org.proteme.protean.Protean and not Engine class. Set Protean to be the main class for your project.

- Hemant
 
Hemant Shah
Hemantshah-0_small
Posted: November 22, 2009 10:37 by Hemant Shah
» Permalink
Andrew,
Can you please download the installer again from http://www.proteme.org/download3.html and run it. I have given the installer a new name so that one in your cache is not used.

Run Protean, after installation, from the command line using:

java -jar pip.jar

If you run into problems again, please provide the exceptions you are getting. Along with the exception you should see the url, user name and password information. Please provide that to me.

Thanks for helping to debug this problem.

- Hemant
 
Andrew Fielden
Afielden_small
Posted: November 22, 2009 14:09 by Andrew Fielden
» Permalink
Hemant I've got it running from Eclipse now by executing the Protean class.

However I can't access the installer download page using your URL. I get redirected to http://proteme.org/temp/Proteaninstall.jar, which gives me a 404: Not found error.
 
Hemant Shah
Hemantshah-0_small
Posted: November 23, 2009 13:44 by Hemant Shah
» Permalink
Andrew,

It appears you are still accessing the older version of the page from your browser's cache. Try purging the cache and then visiting the link.

- Hemant
 
Andrew Fielden
Afielden_small
Posted: November 22, 2009 16:46 by Andrew Fielden
» Permalink
Regarding username/password problems. I also had to change the hibernate config file Protean/src/org/hibernate.cfg.xml.
Change the following properties to reflect your MySQL database login details -

<property name="hibernate.connection.username">xxxxxx</property>
<property name="hibernate.connection.password">xxxxxx</property>
showing 1 - 16 of 16
Replies: 15 - Last Post: November 23, 2009 13:44
by: Hemant Shah
« Older Topic » Newer Topic
  • Mysql
  • Glassfish
  • Jruby
  • Rails
  • Nblogo
Terms of Use; Privacy Policy;
© 2010, Oracle Corporation and/or its affiliates
(revision 20120518.3c65429)
 
 
Close
loading
Please Confirm
Close