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
> >
>
Received on Fri Jun 02 2006 - 12:27:34 PDT