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(Ur
> 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
>