[UrbanSim-Users] from cache to mysql

Hello all,
I'm trying to move data from Eugene cache to a MySQL
database.
Following the reference manual, I have used this tool

C:\myworkspace\eugene\tools>python export_cache_to_mysql.py

The mysql database was created but the “tables” is empty.

In the following the result of the command

----------------------

C:\Python24\lib\site-packages\scipy\__init__.py:18:
UserWarning: Module opus_cor
e was already imported from C:\Python24\lib\site-
packages\opus_core\__init__.pyc
, but c:\python24\lib\site-packages is being added to
sys.path
  import pkg_resources as _pr # activate namespace packages
(manipulates __path_
_)
C:\Python24\lib\site-packages\scipy\misc\__init__.py:25:
DeprecationWarning: Sci
pyTest is now called NumpyTest; please update your code
  test = ScipyTest().test
C:\Python24\lib\site-packages\scipy\ndimage\__init__.py:40:
DeprecationWarning:
ScipyTest is now called NumpyTest; please update your code
  test = ScipyTest().test
WARNING: Test skipped: unable to connect to some particular
instance of MySql.
A common reason for this is that your environment variables
that pertain to MySq
l (for example, MYSQLUSERNAME and MYSQLPASSWORD) are
incorrectly set (for this MySql instance). Another common
reason is that the MySql instance to which the s
ystem is trying to connect is on the 'trondheim' server
(trondheim.cs.washington
.edu) which is at CUSPA Point5 laboratory, within the
University of Washington C
omputer Science network. This exception is expected and
normal when this code i
s being run on a machine outside of that network.
Underlying exception was: (10
45, "Access denied for user 'root'@'host57-172-dynamic.45-
213-r.retail.telecomit
alia.it' (using password: YES)"). This exception happened
in opus_core.store.my
sql_database_server.
WARNING: Test skipped: unable to connect to some particular
instance of MySql.
A common reason for this is that your environment variables
that pertain to MySq
l (for example, MYSQLUSERNAME and MYSQLPASSWORD) are
incorrectly set (for this M
ySql instance). Another common reason is that the MySql
instance to which the s
ystem is trying to connect is on the 'trondheim' server
(trondheim.cs.washington
.edu) which is at CUSPA Point5 laboratory, within the
University of Washington C
omputer Science network. This exception is expected and
normal when this code i
s being run on a machine outside of that network.
Underlying exception was: (10
45, "Access denied for user 'root'@'host57-172-dynamic.45-
213-r.retail.telecomit
alia.it' (using password: YES)"). This exception happened
in opus_core.store.ol
d.mysql_storage.
Invoking command: python C:\Python24\lib\site-
packages\opus_core\tools\do_export
_cache_to_mysql_database.pyc -c
C:\urbansim_cache\eugene_1980_baseyear_cache -d
eugene_prova_07 -o localhost -u root -p chinto
C:\Python24\lib\site-packages\scipy\__init__.py:18:
UserWarning: Module opus_cor
e was already imported from C:\Python24\lib\site-
packages\opus_core\__init__.pyc
, but c:\python24\lib\site-packages is being added to
sys.path
  import pkg_resources as _pr # activate namespace packages
(manipulates __path_
_)
C:\Python24\lib\site-packages\scipy\misc\__init__.py:25:
DeprecationWarning: Sci
pyTest is now called NumpyTest; please update your code
  test = ScipyTest().test
C:\Python24\lib\site-packages\scipy\ndimage\__init__.py:40:
DeprecationWarning:
ScipyTest is now called NumpyTest; please update your code
  test = ScipyTest().test
WARNING: Test skipped: unable to connect to some particular
instance of MySql.
A common reason for this is that your environment variables
that pertain to MySq
l (for example, MYSQLUSERNAME and MYSQLPASSWORD) are
incorrectly set (for this M
ySql instance). Another common reason is that the MySql
instance to which the s
ystem is trying to connect is on the 'trondheim' server
(trondheim.cs.washington
.edu) which is at CUSPA Point5 laboratory, within the
University of Washington C
omputer Science network. This exception is expected and
normal when this code i
s being run on a machine outside of that network.
Underlying exception was: (10
45, "Access denied for user 'root'@'host57-172-dynamic.45-
213-r.retail.telecomit
alia.it' (using password: YES)"). This exception happened
in opus_core.store.my
sql_database_server.
WARNING: Test skipped: unable to connect to some particular
instance of MySql.
A common reason for this is that your environment variables
that pertain to MySq
l (for example, MYSQLUSERNAME and MYSQLPASSWORD) are
incorrectly set (for this M
ySql instance). Another common reason is that the MySql
instance to which the s
ystem is trying to connect is on the 'trondheim' server
(trondheim.cs.washington
.edu) which is at CUSPA Point5 laboratory, within the
University of Washington C
omputer Science network. This exception is expected and
normal when this code i
s being run on a machine outside of that network.
Underlying exception was: (10
45, "Access denied for user 'root'@'host57-172-dynamic.45-
213-r.retail.telecomit
alia.it' (using password: YES)"). This exception happened
in opus_core.store.ol
d.mysql_storage.
Initializing database...
create db
create db end
Exporting cache to mysql...: started on Wed Sep 12 15:03:45
2007.........0.0 sec

----------------------

Can someone please help me?
Thank you in advance,
Simone.

Simone Di Zio
tel. 339.15.13.171
Università G. d'Annunzio
Dipartimento di Economia e Storia del
Territorio
Viale Pindaro, 42
Pescara
Italy
Received on Wed Sep 12 2007 - 06:26:21 PDT