RE: Issue with the output database.

Aaron,

Glad to hear this fixed your database problem.

David

> -----Original Message-----
> From: Aaran Stent [mailto:aaran.stent_at_nieir.com.au]
> Sent: Friday, June 02, 2006 6:12 PM
> To: David Socha
> Subject: RE: Issue with the output database.
>
> Hi David,
>
> Thanks for the hint. That was the problem. I simply deleted
> the database I had created to try and test the database and
> also gave the urbansim user full access to the database
> called "mysql" whola! I now have UrbanSim working on my laptop.
>
> I am now of course faced with a dilema. Continue on with
> UrbanSim 3 or be at the curring edge of UrbanSim 4. I will
> let you know how I go over the weekend.
>
> Thanks for the assistance. And congratulations to the
> development team on the pre release of UrbanSim 4 and more
> importantly OPUS.
>
> Aaran
>
>
>
> -----Original Message-----
> From: "David Socha" <socha_at_cs.washington.edu>
> To: "Aaran Stent" <aaran.stent_at_nieir.com.au>, "Paul Waddell"
> <pwaddell_at_u.washington.edu>
> Cc: users_at_urbansim.org
> Date: Fri, 2 Jun 2006 12:27:10 -0700
> Subject: RE: Issue with the output database.
>
> > Aaron,
> >
> > I took a look at your error message, and it is not clear what the
> > problem is. Perhaps your permissions do not allow the
> urbansim MySQL
> > user to create a database?
> >
> > As you may have just seen, we have a pre-release of UrbanSim 4
> > available. Perhaps you can switch to using that version. (Yes, I
> > know that we have not finished the documentation on how to
> change an
> > UrbanSim
> > 3 database to be UrbanSim 4 compliant.)
> >
> > Note that UrbanSim 4 still contains hard-coded references
> to the CUSPA
> > database server (trondheim.cs.washington.edu). Some of the
> unit-tests
> > will fail for non-CUSPA users, since they require this access :-(.
> > Clearly, we are working to fix that.
> >
> > David
> >
> > Center for Urban Simulation and Policy Analysis University of
> > Washington www.urbansim.org
> > 206 616-4495
> >
> >
> > > -----Original Message-----
> > > From: users-bounces_at_urbansim.org
> > > [mailto:users-bounces_at_urbansim.org] On Behalf Of Aaran Stent
> > > Sent: Friday, June 02, 2006 6:38 AM
> > > To: Paul Waddell
> > > Cc: users_at_urbansim.org
> > > Subject: Re: Issue with the output database.
> > >
> > > Hi Paul,
> > >
> > > Thanks for the reply, I can appreciate you are very busy at the
> > > moment preparing for the release.
> > >
> > > Yes I did want to start using OPUS. I am patiently
> waiting until it
> > > is available (i.e. 30th June). Having said that I need
> to keep our
> > > UrbanSim moving so I find no alternative but to press on
> trying to
> > > resolve my issue. It appears that UrbanSim has been degraed in
> > > BugZilla and hasn't had any new Bugs since Feb of this year so I
> > > will continue to post to the mailing list in desperation.
> > >
> > > I downloaded the urbansim.java source file and can see where the
> > > exeption is being thrown. But without access to the CVS
> (it appears
> > > you need a University of Washinton account to gain access from
> > > eclipse?) I can't debug the error. My error log and indeed the
> > > checker.bat validate that I can connect from UrbanSim to
> the MySQL
> > > Server using JDBC as the checker works and connects to
> the database
> > > OK. It seems to be specifically related to the output database
> > > only. I have replicated the access so it matches exactly
> with the
> > > Eugene_1980_baseyear.
> > >
> > > Since my first email I have downgraded from MySQL 5.0 to 4.1 but
> > > with no success.
> > >
> > > I found Bug 1321 mentions that the checker should now check the
> > > output database. Yet examining the output file of the
> checker shows
> > > no check taking place.
> > >
> > > I have also changed my scenario file so it now looks almost
> > > identical to the one fond here
> > > (http://www.urbansim.org/docs/data/parameters.html) yet I
> still have
> > > the same error. I have attached the checker output,
> scenario file
> > > and the urbansim output (error.txt)
> > >
> > > I would greatly appreciate if you or anyone else could
> point me in
> > > the right direction.
> > >
> > > Regards,
> > >
> > > Aaran
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: Paul Waddell <pwaddell_at_u.washington.edu>
> > > To: Aaran Stent <aaran.stent_at_nieir.com.au>
> > > Cc: "'users_at_urbansim.org'" <users_at_urbansim.org>
> > > Date: Tue, 30 May 2006 10:49:27 +1000
> > > Subject: Re: Issue with the output database.
> > >
> > > > Aaron
> > > >
> > > > You are installing UrbanSim3, the Java version, rather than
> > > OPUS and
> > > > UrbanSim4, which is what I think you wanted. We are going
> > > to post a
> > > > pre-release version shortly that is not quite finished
> in terms of
> > > > documentation and finishing touches, and will not be providing
> > > > much support as we get the release and documentation ready for
> > > the June 30
> > > > release. Having said this, the error in your log below
> > > appears to be
> > > > because you have not yet set the MySQL account name and
> password
> > > > according to the documentation. Check this again in the
> > > > documentation, or wait a while for the OPUS/UrbanSim4
> > > release and documentation...
> > > >
> > > > Paul
> > > >
> > > > Aaran Stent wrote:
> > > > > Hi,
> > > > >
> > > > > Thought I would try out this mailing list before reporting to
> > > > BugZilla.
> > > > > I am trying to run UrbanSim on my laptop after having
> > > success on my
> > > > > desktop but am having trouble.
> > > > >
> > > > > My System is as follows.
> > > > >
> > > > > Windows XP (with latest service packs from Microsoft
> > > Update service)
> > > > > Python 2.4.2
> > > > > Java(TM) 2 Runtime Environment, Standard Edition (build
> > > > > 1.5.0_06-b05) MySQL 5.0.18-nt UrbanSim 2.8 (installed under
> > > > > d:\urbansim)
> > > > >
> > > > > I have downloaded the Eugene_1980_baseyear database
> and run the
> > > > > checker against the my.scenario file I downloaded
> from the user
> > > > manual
> > > > > section of urbansim.org. The checker reports that it
> > > completes with
> > > > > "great success" (there are some warnings). Hence the
> jdbc driver
> > > > > appears to connect to the database OK.
> > > > >
> > > > > When I run UrbanSim.bat on the same scenario file I
> get an error
> > > > > that includes the following text
> > > > >
> > > > > org.urbansim.application.UrbanSimEarlyTerminationError: Error
> > > > > connecting to output database server at
> > > > > jdbc:mysql://localhost/urbansim_output: Error Connecting
> > > to Database:
> > > > > Access Denied.
> > > > > I have attached a copy of both the scenario file and
> the error
> > > > > message. I have created the database urbansim_output
> > > with IDENTICAL
> > > > > permissions to the base year database. Can anyone
> > > suggest something
> > > > > for me to try?
> > > > >
> > > > > I have tried renaming the output database and have used the
> > > > hyphenated
> > > > > and non hyphenated versions of output-data in the
> scenario file.
> > > > >
> > > > > Regards,
> > > > >
> > > > > Aaran Stent
> > > > > National Economics
> > > > > aaran.stent_at_nieir.com.au <mailto:aaran.stent_at_nieir.com.au>
> > > > > 416 Queens Parade
> > > > > Clifton Hill VIC 3068
> > > > > Ph: 0419 227 262
> > > > >
> > > > >
> > > >
> > >
> >
> ----------------------------------------------------------------------
> > > > -
> > > > -
> > > > >
> > > > >
> > > > > D:\urbansim>runapp.bat org.urbansim.application.UrbanSim
> > > my.scenario
> > > >
> > > > > Running UrbanSim 2.8
> > > > > checking DTD completed:
> > > > ............................................ 0.891 s
> > > > > Checking Python Build Number completed:
> > > > ............................ 0.120 s
> > > > > Using parameters file: D:\urbansim\my.scenario
> > > > > test point available at http://NIEIR001:1887/M5A7R4/
> > > > > loading dataset and scenario
> > > > > using scenario:
> > > jdbc:mysql://localhost/Eugene_1980_baseyear
> > > > > loading dataset and scenario completed:
> > > > ............................ 0.551 s
> > > > > org.urbansim.application.UrbanSimEarlyTerminationError:
> > > > > Error
> > > > connecting to output database server at
> > > > jdbc:mysql://localhost/urbansim_output: Error Connecting to
> > > Database:
> > > > Access Denied.
> > > > > at
> org.urbansim.application.UrbanSim.simulate(UrbanSim.java:190)
> > > > > at
> > > org.urbansim.application.UrbanSim.run_urbansim(UrbanSim.java:96)
> > > > > at
> > > org.urbansim.application.UrbanSim.inner_main(UrbanSim.java:68)
> > > > > at
> > > >
> > >
> >
> org.urbansim.application.UrbanSimApplication.application_entry_point(U
> > > > r
> > > > banSimApplication.java:57)
> > > > > at
> org.urbansim.application.UrbanSim.main(UrbanSim.java:57)
> > > > >
> > > > > Error[us_17]: internal error
> > > > org.urbansim.application.UrbanSimEarlyTerminationError: Error
> > > > connecting to output database server at
> > > > jdbc:mysql://localhost/urbansim_output: Error Connecting to
> > > Database:
> > > > Access Denied.
> > > > > NOTE: Use the Input Data Consistency Checker
> before running
> > > > UrbanSim
> > > > > Running UrbanSim 2.8 stopped with errors:
> > > > .............................. 1.702 s
> > > > > org.urbansim.application.UrbanSimEarlyTerminationError: NOTE:
> > > > > Use the
> > > > Input Data Consistency Checker before running UrbanSim
> > > > >
> > > > >
> > > >
> > >
> >
> ----------------------------------------------------------------------
> > > > -
> > > > -
> > > > >
> > > > > _______________________________________________
> > > > > Users mailing list
> > > > > Users_at_urbansim.org
> > > > > http://www.urbansim.org/mailman/listinfo/users
> > > > >
> > > >
> > > > _______________________________________________
> > > > Users mailing list
> > > > Users_at_urbansim.org
> > > > http://www.urbansim.org/mailman/listinfo/users
> > > >
> > >
> >
> > _______________________________________________
> > Users mailing list
> > Users_at_urbansim.org
> > http://www.urbansim.org/mailman/listinfo/users
>
>
>
Received on Sat Jun 03 2006 - 22:13:57 PDT