Re: [UrbanSim-Users] from cache to mysql

Hi,

If this can help you :
First point, your Db connection seams to be OK because new database created
and we can see in Opus traces :
C:\urbansim_cache\eugene_1980_baseyear_cache -d eugene_prova_07 -o
localhost -u root -p chinto
I think root have full rights.

Perhaps, you have the last version installed (3 July 2007 - version 4.1)
under an existing old version ?
We can see "DeprecationWarning: ScipyTest" in traces.

Perhaps this notes can help you at
http://www.urbansim.org/docs/installation/release_notes.html :
19 June 2007
If you have an existing Opus/Urbansim installation in Python site-packages,
please delete it first, and then install the new version in a workspace.

10 April 2007 - Converting from numarray to numpy"

Regards,
Philippe.

-----Message d'origine-----
De : users-bounces_at_urbansim.org [mailto:users-bounces_at_urbansim.org]De la
part de simone.dizio
Envoyé : mercredi 12 septembre 2007 13:26
À : users
Cc : MD3046
Objet : [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

_______________________________________________
Users mailing list
Users_at_urbansim.org
http://www.urbansim.org/mailman/listinfo/users
Received on Wed Sep 12 2007 - 08:25:39 PDT