On Sat, Aug 4, 2012 at 1:56 PM, Alexei Vinidiktov <
alexei.vinidik...@gmail.com> wrote:
> Hello,
>
> I'm need hep figuring out how to set up a local GAE development server
> with MySQL.
>
> MySQL connection parameters are specified via App Launcher application
> settings: --mysql_user=root --mysql_password=xxxxxx --mysql_host=localhost
> --mysql_port=3306
>
> When I launch my web2py app with GAE Launcher on my local Windows box I
> get this erorr message:
>
> ############
> ERROR 2012-08-04 06:28:43,515 dal.py:5962] DEBUG: connect attempt 0,
> connection error:
> Traceback (most recent call last):
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line
> 5955, in __init__
> self._adapter = ADAPTERS[self._dbname](*args)
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line
> 3310, in __init__
> self.folder = folder or
> '$HOME/'+thread.folder.split('/applications/',1)[1]
> IndexError: list index out of range
> #############
>
> What does the following line do?
>
> self.folder = folder or '$HOME/'+thread.folder.split('/applications/',1)[1]
>
> If I comment out "or '$HOME/'+thread.folder.split('/applications/',1)[1]"
> in DAL.py and relaunch the dev server, the application appears to be able
> to connect to MySQL but then I get a different error message:
>
> ########
> INFO 2012-08-04 06:42:35,142 rdbms_mysqldb.py:102] Connecting to MySQL
> with kwargs {'passwd': 'xxxxxx', 'unix_socket': '', 'host': 'localhost',
> 'port': 3306, 'user': 'root'}
> ERROR 2012-08-04 06:42:35,153 warnings.py:29]
> C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py:1386: Warning:
> Can't create database 'vocabilis'; database exists
> ret = self.cursor.execute(*a, **b)
>
> ERROR 2012-08-04 06:42:35,575 restricted.py:155] Traceback (most recent
> call last):
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\main.py", line
> 510, in wsgibase
> session._try_store_in_db(request, response)
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\globals.py", line
> 561, in _try_store_in_db
> record_id = table.insert(**dd)
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line
> 6829, in insert
> return self._db._adapter.insert(self,self._listify(fields))
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line 928,
> in insert
> raise e
> ProgrammingError: (1146, "Table 'vocabilis.web2py_session_vocabilis'
> doesn't exist")
> #########
>
> The vocabilis database does exist. It was created earlier when I connected
> to MySQL from a non GAE environment.
>
> If I specify a different non-existent database in the connection string,
> then after relaunching the application vith the GAE Launcher I get this
> error message:
>
> #######
> INFO 2012-08-04 06:44:45,415 rdbms_mysqldb.py:102] Connecting to MySQL
> with kwargs {'passwd': 'xxxxxx', 'unix_socket': '', 'host': 'localhost',
> 'port': 3306, 'user': 'root'}
> ERROR 2012-08-04 06:44:45,828 restricted.py:155] Traceback (most recent
> call last):
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\main.py", line
> 510, in wsgibase
> session._try_store_in_db(request, response)
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\globals.py", line
> 561, in _try_store_in_db
> record_id = table.insert(**dd)
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line
> 6829, in insert
> return self._db._adapter.insert(self,self._listify(fields))
> File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line 928,
> in insert
> raise e
> ProgrammingError: (1146, "Table 'vocabilis3.web2py_session_vocabilis'
> doesn't exist")
> #######
>
> So the application appears to be unable to create the session table.
>
> I'm running Windows, Python 2.7, web2py 1.99.7, MySQL 5.5
>
>
>
I had a connection string with "migrate_enabled=False". I tried removing
it, then I got this error message:
###########################
ERROR 2012-08-04 07:07:40,513 restricted.py:155] Traceback (most recent
call last):
File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\restricted.py", line
205, in restricted
exec ccode in environment
File
"C:\Users\alexei\Dev\web2py\vocabilis.net\applications\vocabilis\models\db.py",
line 23, in <module>
session.connect(request, response, db = db)
File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\globals.py", line
488, in connect
migrate=table_migrate,
File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line 6320,
in define_table
polymodel=polymodel)
File "C:\Users\alexei\Dev\web2py\vocabilis.net\gluon\dal.py", line 707,
in create_table
% (table._db._uri_hash, tablename))
File "C:\Python27\lib\ntpath.py", line 96, in join
assert len(path) > 0
TypeError: object of type 'NoneType' has no len()
###########################
--
Alexei Vinidiktov
--
