Can't migate an App to a new WS2k8R2 box

90 views
Skip to first unread message

Dick Schrauwen

unread,
Nov 28, 2013, 2:21:50 PM11/28/13
to web...@googlegroups.com
I'm trying to migrate a web2py application to a new box.
Source:
 WS2k8 
 web2py: _w2p_246
 using MySQL5.5 

Target:
 WS2k8 R2
 http://37.48.64.183   => welcome
 _web2py281
 mySQL 5.6

What did i do?
 I transferred the database (w2pyopenbrief) from source to target using workbench (export/import)
 Defined the same user /password in target mySQL (web2py / / DBA)
 Downloaded new Web2Py (281)
 Packed openbrief app in source, read it in target

QUESTION: What did i do wrong?????
============================



======== ERROR ==========

Error ticket for "openbrief"
Ticket ID
37.48.64.183.2013-11-28.19-01-02.5f015402-2f6b-4724-a2e8-b82886f49038

<class 'gluon.contrib.pymysql.err.InternalError'> (1071, u'Specified key was too long; max key length is 767 bytes')

Version
web2py™ Version 2.8.1-stable+timestamp.2013.11.27.20.07.10
Traceback
Traceback (most recent call last):
  File "/home/mdipierro/make_web2py/web2py/gluon/restricted.py", line 217, in restricted
  File "S:/_web2py281/web2py/applications/openbrief/models/db.py", line 89, in <module>
    format='%(content)s')     

#NOTE, this error is in this fragment ie the first define_table statement
# TESTIT
# db.define_table('testit',
#  Field('content','string',notnull=True,unique=True),
#  format='%(content)s')

  File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 8139, in define_table
  File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 8176, in lazy_define_table
  File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1086, in create_table
  File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1194, in migrate_table
  File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1916, in execute
  File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1910, in log_execute
  File "/home/mdipierro/make_web2py/web2py/gluon/contrib/pymysql/cursors.py", line 117, in execute
  File "/home/mdipierro/make_web2py/web2py/gluon/contrib/pymysql/connections.py", line 202, in defaulterrorhandler
InternalError: (1071, u'Specified key was too long; max key length is 767 bytes')
In file: S:\_web2py281\web2py\applications\openbrief\models\db.py

# -*- coding: utf-8 -*-

#########################################################################
## This scaffolding model makes your app work on Google App Engine too
## File is released under public domain and you can use without limitations
#########################################################################

## if SSL/HTTPS is properly configured and you want all HTTP requests to
## be redirected to HTTPS, uncomment the line below:
# request.requires_https()

if not request.env.web2py_runtime_gae:
    ## if NOT running on Google App Engine use SQLite or other DB
else:
    ## connect to Google BigTable (optional 'google:datastore://namespace')
    db = DAL('google:datastore')
    ## store sessions and tickets there
    session.connect(request, response, db = db)
    ## or store session in Memcache, Redis, etc.
    ## from gluon.contrib.memdb import MEMDB
    ## from google.appengine.api.memcache import Client
    ## session.connect(request, response, db = MEMDB(Client()))

## by default give a view/generic.extension to all actions from localhost
## none otherwise. a pattern can be 'controller/function.extension'
response.generic_patterns = ['*'] if request.is_local else []
## (optional) optimize handling of static files
# response.optimize_css = 'concat,minify,inline'
# response.optimize_js = 'concat,minify,inline'

#########################################################################
## Here is sample code if you need for
## - email capabilities
## - authentication (registration, login, logout, ... )
## - authorization (role based authorization)
## - services (xml, csv, json, xmlrpc, jsonrpc, amf, rss)
## - old style crud actions
## (more options discussed in gluon/tools.py)
#########################################################################


from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
auth = Auth(db)
crud, service, plugins = Crud(db), Service(), PluginManager()

## create all tables needed by auth if not custom tables
auth.define_tables(username=False, signature=False)

## configure email
mail=auth.settings.mailer
mail.settings.server = 'logging' or 'smtp.gmail.com:587'
mail.settings.sender = 'y...@gmail.com'
mail.settings.login = 'username:password'

## configure auth policy
auth.settings.registration_requires_verification = False
auth.settings.registration_requires_approval = False
auth.settings.reset_password_requires_verification = True

## if you need to use OpenID, Facebook, MySpace, Twitter, Linkedin, etc.
## register with janrain.com, write your domain:api_key in private/janrain.key
from gluon.contrib.login_methods.rpx_account import use_janrain
use_janrain(auth,filename='private/janrain.key')

#########################################################################
## Define your tables below (or better in another model file) for example
##
## >>> db.define_table('mytable',Field('myfield','string'))
##
## Fields can be 'string','text','password','integer','double','boolean'
##       'date','time','datetime','blob','upload', 'reference TABLENAME'
## There is an implicit 'id integer autoincrement' field
## Consult manual for more options, validators, etc.
##
## More API examples for controllers:
##
## >>> db.mytable.insert(myfield='value')
## >>> rows=db(db.mytable.myfield=='value').select(db.mytable.ALL)
## >>> for row in rows: print row.id, row.myfield
#########################################################################
# coding: utf8
# tables for openbrief
# in file: OPENBRIEF/MODELS/DB_OPENBRIEF.PY

# TESTIT
db.define_table('testit',
  Field('content','string',notnull=True,unique=True),
  format='%(content)s')

# CATEGORY
db.define_table('category',
  Field('name','string',notnull=True,unique=True),
  format='%(name)s')

# LETTER
db.define_table('letter',
  Field('addressee','string',notnull=True),
  Field('title','string',notnull=True),
  Field('category','reference category',readable=False,writable=False),
  Field('body','text',notnull=True),
  Field('link',requires=IS_URL()),
  Field('votes','integer',readable=False,writable=False),
  Field('posted_by','reference auth_user',readable=False,writable=False),
  Field('posted_on','datetime',readable=False,writable=False),
  format='%(title)s')

# COMMENT
db.define_table('comment',
  Field('body','text',notnull=True),
  Field('letter','reference letter',readable=False,writable=False),
  Field('posted_by','reference auth_user',readable=False,writable=False),
  Field('posted_on','datetime',readable=False,writable=False))
  
# VOTE
db.define_table('vote',
  Field('value','integer'),
  Field('letter','reference letter',readable=False,writable=False),
  Field('posted_by','reference auth_user',readable=False,writable=False),
  Field('posted_on','datetime',readable=False,writable=False),
  format='%(value)s')


## after defining tables, uncomment below to enable auditing
auth.enable_record_versioning(db)

mail.settings.server = settings.email_server
mail.settings.sender = settings.email_sender
mail.settings.login = settings.email_login

 


 
 

 
:

Niphlod

unread,
Nov 29, 2013, 3:30:34 AM11/29/13
to web...@googlegroups.com
an excerpt from the changelog of 2.6.0

Attention MySQL users: The length of string fields changed from 255 to 512 bytes. If you have migrations enabled this will trigger a large migration. To prevent it, first set migrate_enabled=False, upgrade, check everything is ok, then add length=255 to your string Fields, then re-enable migrations with migrate_enabled=True if needed.

Dick Schrauwen

unread,
Nov 29, 2013, 9:27:36 AM11/29/13
to
Thanx Simone, it worked!!,
Dick

Ron Chatterjee

unread,
Jul 26, 2016, 5:29:35 PM7/26/16
to web2py-users
Few clarifications:
Migrating to mysql.

Field('search_string', 'string',  label='', length = 255))

The above is needed to prevent 
InternalError: (1071, u'Specified key was too long; max key length is 767 bytes'). Am I correct?

      
Field("your_name", "string", length=64),

This will be okay? 

How about the field list:string? Do we need to add a length to that?

Text fields are not needed to be sized. please confirm. 
Reply all
Reply to author
Forward
0 new messages