Plone

On Fri, Jan 2, 2009 at 4:48 PM, kphigh <kevin.high@...:

>
> Hi,
> I installed SQLAlchemy Easy_install installed it in the following location:
>
> /opt/Plone-3.1/Python-2.4/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy
> I have also installed mysql-python.
>
> My question is: how do I get the adapter to show in the ZMI?(I have
> restared
> plone and zope)


Either you use an Zope old-style DA like MySQLDA (appearing in the ZMI) or
you go with something SQLAlchemy-based (like zope.sqlalchemy or
z3c.sqlalchemy or collective.lead).

Andreas

Thanks Andreas.. 

I tried MySQLDA(Installed
in/opt/Plone-3.1/zinstance/parts/instance/Products) and it does not appear
in the ZMI drop downs..  



Andreas Jung-5 wrote:
> 
> On Fri, Jan 2, 2009 at 4:48 PM, kphigh
> <kevin.high@...:
> 
>>
>> Hi,
>> I installed SQLAlchemy Easy_install installed it in the following
>> location:
>>
>> /opt/Plone-3.1/Python-2.4/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy
>> I have also installed mysql-python.
>>
>> My question is: how do I get the adapter to show in the ZMI?(I have
>> restared
>> plone and zope)
> 
> 
> Either you use an Zope old-style DA like MySQLDA (appearing in the ZMI) or
> you go with something SQLAlchemy-based (like zope.sqlalchemy or
> z3c.sqlalchemy or collective.lead).
> 
> Andreas
> 
> ------------------------------------------------------------------------------
> 
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2102189.html
Sent from the General Questions mailing list archive at Nabble.com.

On 02.01.2009 17:06 Uhr, kphigh wrote:
> Thanks Andreas..
>
> I tried MySQLDA(Installed
> in/opt/Plone-3.1/zinstance/parts/instance/Products) and it does not appear
> in the ZMI drop downs..
>

Then your installation is broken. Start Zope in the foreground and check 
  for console messages.

-aj

Andreas Jung wrote:

> On Fri, Jan 2, 2009 at 4:48 PM, kphigh
> <kevin.high@...:
> 
>> I installed SQLAlchemy Easy_install installed it in the following
>> location:

You don't want to install SQLAlchemy, directly.
 
> Either you use an Zope old-style DA like MySQLDA (appearing in the ZMI) or
> you go with something SQLAlchemy-based (like zope.sqlalchemy or
> z3c.sqlalchemy or collective.lead).

I'm surprised that Andreas failed to mention Products.SQLAlchemyDA, which he 
wrote.

SQLAlchemy is much lower level than you want (and so are his suggestions).  

Install Products.SQLAlchemyDA (either via easy-install or buildout) and it 
relies on z3c.sqlalchemy and sqlalchemy.  The buildout method will get them 
automatically - it's so long since I used a straight easy-install I don't 
recall if it grabs the dependencies.
-- 
derek

You are correct Andreas, there is an error with the install.. It appear
MySQLDA cannot be imported because of where the Python egg cache is located. 
I checke and there is no .python-eggs in /root/  I read in one of the posts
that the python cache can be pointed to another directory.. How is this
done?

thanks
kevin


2009-01-05 07:21:40 ERROR Application Could not import Products.ZMySQLDA
Traceback (most recent call last):
  File "/opt/Plone-3.1/zinstance/parts/zope2/lib/python/OFS/Application.py",
line 709, in import_product
    product=__import__(pname, global_dict, global_dict, silly)
  File "/opt/Plone-3.1/zinstance/products/ZMySQLDA/__init__.py", line 90, in
?
    import DA
  File "/opt/Plone-3.1/zinstance/products/ZMySQLDA/DA.py", line 92, in ?
    from db import DBPool, DB
  File "/opt/Plone-3.1/zinstance/products/ZMySQLDA/db.py", line 89, in ?
    import _mysql
  File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
  File "build/bdist.linux-i686/egg/_mysql.py", line 4, in __bootstrap__
  File
"/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
line 840, in resource_filename
    return get_provider(package_or_requirement).get_resource_filename(
  File
"/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
line 1310, in get_resource_filename
    self._extract_resource(manager, self._eager_to_zip(name))
  File
"/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
line 1331, in _extract_resource
    real_path = manager.get_cache_path(
  File
"/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
line 921, in get_cache_path
    self.extraction_error()
  File
"/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
line 887, in extraction_error
    raise err
ExtractionError: Can't extract file(s) to egg cache

The following error occurred while trying to extract file(s) to the Python
egg
cache:

  [Errno 13] Permission denied: '/root/.python-eggs'

The Python egg cache directory is currently set to:

  /root/.python-eggs

Perhaps your account does not have write access to this directory?  You can
change the cache directory by setting the PYTHON_EGG_CACHE environment
variable to point to an accessible directory.



Andreas Jung-5 wrote:
> 
> On 02.01.2009 17:06 Uhr, kphigh wrote:
>> Thanks Andreas..
>>
>> I tried MySQLDA(Installed
>> in/opt/Plone-3.1/zinstance/parts/instance/Products) and it does not
>> appear
>> in the ZMI drop downs..
>>
> 
> Then your installation is broken. Start Zope in the foreground and check 
>   for console messages.
> 
> -aj
> 
> begin:vcard
> fn:Andreas Jung
> n:Jung;Andreas
> org:ZOPYX Ltd. & Co. KG
> adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
> email;internet:info@...
> title:CEO
> tel;work:+49-7071-793376
> tel;fax:+49-7071-7936840
> tel;home:+49-7071-793257
> x-mozilla-html:FALSE
> url:www.zopyx.com
> version:2.1
> end:vcard
> 
> 
> ------------------------------------------------------------------------------
> 
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2112681.html
Sent from the General Questions mailing list archive at Nabble.com.

On 05.01.2009 13:31 Uhr, kphigh wrote:
> You are correct Andreas, there is an error with the install.. It appear
> MySQLDA cannot be imported because of where the Python egg cache is located.
> I checke and there is no .python-eggs in /root/  I read in one of the posts
> that the python cache can be pointed to another directory.. How is this
> done?

Perhaps you should not play around if root if you don't know about the 
side-effect? There is basically little need for playing root within the 
context of Zope and Plone. If you have file permissions issues: use
chmod/chown for fixing the ownership or permissions.

-aj


> thanks
> kevin
>
>
> 2009-01-05 07:21:40 ERROR Application Could not import Products.ZMySQLDA
> Traceback (most recent call last):
>    File "/opt/Plone-3.1/zinstance/parts/zope2/lib/python/OFS/Application.py",
> line 709, in import_product
>      product=__import__(pname, global_dict, global_dict, silly)
>    File "/opt/Plone-3.1/zinstance/products/ZMySQLDA/__init__.py", line 90, in
> ?
>      import DA
>    File "/opt/Plone-3.1/zinstance/products/ZMySQLDA/DA.py", line 92, in ?
>      from db import DBPool, DB
>    File "/opt/Plone-3.1/zinstance/products/ZMySQLDA/db.py", line 89, in ?
>      import _mysql
>    File "build/bdist.linux-i686/egg/_mysql.py", line 7, in ?
>    File "build/bdist.linux-i686/egg/_mysql.py", line 4, in __bootstrap__
>    File
> "/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
> line 840, in resource_filename
>      return get_provider(package_or_requirement).get_resource_filename(
>    File
> "/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
> line 1310, in get_resource_filename
>      self._extract_resource(manager, self._eager_to_zip(name))
>    File
> "/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
> line 1331, in _extract_resource
>      real_path = manager.get_cache_path(
>    File
> "/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
> line 921, in get_cache_path
>      self.extraction_error()
>    File
> "/home/steve/Plone-3.1/buildout-cache/eggs/setuptools-0.6c9-py2.4.egg/pkg_resources.py",
> line 887, in extraction_error
>      raise err
> ExtractionError: Can't extract file(s) to egg cache
>
> The following error occurred while trying to extract file(s) to the Python
> egg
> cache:
>
>    [Errno 13] Permission denied: '/root/.python-eggs'
>
> The Python egg cache directory is currently set to:
>
>    /root/.python-eggs
>
> Perhaps your account does not have write access to this directory?  You can
> change the cache directory by setting the PYTHON_EGG_CACHE environment
> variable to point to an accessible directory.
>
>
>
> Andreas Jung-5 wrote:
>> On 02.01.2009 17:06 Uhr, kphigh wrote:
>>> Thanks Andreas..
>>>
>>> I tried MySQLDA(Installed
>>> in/opt/Plone-3.1/zinstance/parts/instance/Products) and it does not
>>> appear
>>> in the ZMI drop downs..
>>>
>> Then your installation is broken. Start Zope in the foreground and check
>>    for console messages.
>>
>> -aj
>>
>> begin:vcard
>> fn:Andreas Jung
>> n:Jung;Andreas
>> org:ZOPYX Ltd.&  Co. KG
>> adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
>> email;internet:info@...
>> title:CEO
>> tel;work:+49-7071-793376
>> tel;fax:+49-7071-7936840
>> tel;home:+49-7071-793257
>> x-mozilla-html:FALSE
>> url:www.zopyx.com
>> version:2.1
>> end:vcard
>>
>>
>> ------------------------------------------------------------------------------
>>
>> _______________________________________________
>> Plone-Users mailing list
>> Plone-Users@...
>> https://lists.sourceforge.net/lists/listinfo/plone-users
>>
>>
>


-- 
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: http://www.zopyx.com - Email: info@... - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting

I followed the install instructions for SQLAlchemyDA
- download and install SQLAlchemy as egg or from the sources
  from Cheeseshop (easy_install sqlalchemy). See
    
    http://www.sqlalchemy.org

    for details

- download and install z3c.sqlalchemy as egg or from the sources 
  from Cheeseshop (easy_install z3c.sqlalchemy). See

    http://cheeseshop.python.org/pypi/z3c.sqlalchemy/

  for details.

- unpack the archive containing SQLAlchemyDA inside the "Products"
  directory of your Zope instance home.

- after restarting Zope you go to the ZMI and create an instance of
  "SQLAlchemyDA" (as you would create some DA instance)

The SQLAlchemyDA does not appear in the ZMI.. I saw in another post about
not have the Pyton db driver installed and I do have them installed
(MySql-pyton1.2.2)

Any ideas on why the option does not appear in the ZMI?

thanks
kevn[



Derek Broughton wrote:
> 
> Andreas Jung wrote:
> 
>> On Fri, Jan 2, 2009 at 4:48 PM, kphigh
>> <kevin.high@...:
>> 
>>> I installed SQLAlchemy Easy_install installed it in the following
>>> location:
> 
> You don't want to install SQLAlchemy, directly.
>  
>> Either you use an Zope old-style DA like MySQLDA (appearing in the ZMI)
>> or
>> you go with something SQLAlchemy-based (like zope.sqlalchemy or
>> z3c.sqlalchemy or collective.lead).
> 
> I'm surprised that Andreas failed to mention Products.SQLAlchemyDA, which
> he 
> wrote.
> 
> SQLAlchemy is much lower level than you want (and so are his suggestions).  
> 
> Install Products.SQLAlchemyDA (either via easy-install or buildout) and it 
> relies on z3c.sqlalchemy and sqlalchemy.  The buildout method will get
> them 
> automatically - it's so long since I used a straight easy-install I don't 
> recall if it grabs the dependencies.
> -- 
> derek
> 
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2117513.html
Sent from the General Questions mailing list archive at Nabble.com.

kphigh wrote:

> 
> I followed the install instructions for SQLAlchemyDA
... 
> The SQLAlchemyDA does not appear in the ZMI.. I saw in another post about
> not have the Pyton db driver installed and I do have them installed
> (MySql-pyton1.2.2)
> 
> Any ideas on why the option does not appear in the ZMI?

I have this problem often with Oracle, and never with Postgres, and it 
basically comes down to the fact that the DB driver has to work...

Use a Zope debug instance, like:

   $ bin/instance debug

You might get lucky and see exactly why it doesn't work in the messages it 
displays before the first prompt.  Otherwise...

Try to import the MySql driver.  If it doesn't work, then it's not installed 
in the right place.  If it does work, try to create a connection with the 
MySQL driver (I don't know how you do that in MySql, so I can't give an 
example).

If you can get a connection directly, then try:
> from Products.SQLAlchemyDA import *
> x=da.createSAWrapper(dsn='mysql:///database')

By that point you should know the problem
-- 
derek

Thanks Derek.. I didnt' see any error messages.. Stupid question though...
which Products folder should  SQLAlchemyDA exist?  There is:
/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Products>  and
/opt/Plone-3.1/zinstance/parts/instance/Products

thanks
kevin




Derek Broughton wrote:
> 
> kphigh wrote:
> 
>> 
>> I followed the install instructions for SQLAlchemyDA
> ... 
>> The SQLAlchemyDA does not appear in the ZMI.. I saw in another post about
>> not have the Pyton db driver installed and I do have them installed
>> (MySql-pyton1.2.2)
>> 
>> Any ideas on why the option does not appear in the ZMI?
> 
> I have this problem often with Oracle, and never with Postgres, and it 
> basically comes down to the fact that the DB driver has to work...
> 
> Use a Zope debug instance, like:
> 
>    $ bin/instance debug
> 
> You might get lucky and see exactly why it doesn't work in the messages it 
> displays before the first prompt.  Otherwise...
> 
> Try to import the MySql driver.  If it doesn't work, then it's not
> installed 
> in the right place.  If it does work, try to create a connection with the 
> MySQL driver (I don't know how you do that in MySql, so I can't give an 
> example).
> 
> If you can get a connection directly, then try:
>> from Products.SQLAlchemyDA import *
>> x=da.createSAWrapper(dsn='mysql:///database')
> 
> By that point you should know the problem
> -- 
> derek
> 
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2118239.html
Sent from the General Questions mailing list archive at Nabble.com.

kphigh wrote:

> 
> Thanks Derek.. I didnt' see any error messages.. 

What _did_ you see?   If you get nothing back from the import statements, 
then you have at least got everything in the correct paths (or you'd get 
import errors).

After:

x=da.createSAWrapper(dsn='mysql:///database')

I would expect to see an SADeprecationWarning, but perhaps not all of your 
products are as recent as mine.  

If you got that far without any messages, then it should be good to go.  I 
hope you're looking for the right thing in the ZMI - it should show up as 
type=SQLAlchemyDA, not as a "Z ... Database Connection" like Gadfly.

> Stupid question though...
> which Products folder should  SQLAlchemyDA exist?  There is:
> /opt/Plone-3.1/zinstance/parts/zope2/lib/python/Products>  and
> /opt/Plone-3.1/zinstance/parts/instance/Products

I haven't a clue - it's all so much easier if you just use buildout.  Since 
you easy_installed it, I doubt it should be in either one - easy_install 
products are usually found from the python libraries and .pth files.
-- 
derek

On 06.01.2009 17:29 Uhr, kphigh wrote:
> Thanks Derek.. I didnt' see any error messages.. Stupid question though...
> which Products folder should  SQLAlchemyDA exist?  There is:
> /opt/Plone-3.1/zinstance/parts/zope2/lib/python/Products>   and
> /opt/Plone-3.1/zinstance/parts/instance/Products
>

Possibly you are making the mistake that Products.XXX is usually a 
Products namespace package *packaged* for buildout. It is not directly 
suitable for manually installation - or you make sure that 
Products/XXXXX exists (move or link the package).

-aj

This is what I saw..
Starting debugger (the name "app" is bound to the top-level Zope object)
/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Products/__init__.py:17:
UserWarning: Module transaction was already imported from
/opt/Plone-3.1/zinstance/parts/zope2/lib/python/transaction/__init__.pyc,
but
/opt/Plone-3.1/Python-2.4/lib/python2.4/site-packages/transaction-1.0a1-py2.4.egg
is being added to sys.path
  __import__('pkg_resources').declare_namespace(__name__)
Traceback (most recent call last):
  File "<string>", line 1, in ?
  File "/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Zope2/__init__.py",
line 51, in app
    startup()
  File "/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Zope2/__init__.py",
line 47, in startup
    _startup()
  File
"/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Zope2/App/startup.py", line
59, in startup
    DB = dbtab.getDatabase('/', is_root=1)
  File
"/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Zope2/Startup/datatypes.py",
line 280, in getDatabase
    db = factory.open(name, self.databases)
  File
"/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Zope2/Startup/datatypes.py",
line 178, in open
    DB = self.createDB(database_name, databases)
  File
"/opt/Plone-3.1/zinstance/parts/zope2/lib/python/Zope2/Startup/datatypes.py",
line 175, in createDB
    return ZODBDatabase.open(self, databases)
  File "/opt/Plone-3.1/zinstance/parts/zope2/lib/python/ZODB/config.py",
line 97, in open
    storage = section.storage.open()
  File "/opt/Plone-3.1/zinstance/parts/zope2/lib/python/ZODB/config.py",
line 135, in open
    quota=self.config.quota)
  File
"/opt/Plone-3.1/zinstance/parts/zope2/lib/python/ZODB/FileStorage/FileStorage.py",
line 112, in __init__
    self._lock_file = LockFile(file_name + '.lock')
  File "/opt/Plone-3.1/zinstance/parts/zope2/lib/python/ZODB/lock_file.py",
line 57, in __init__
    self._fp = open(path, 'r+')
IOError: [Errno 13] Permission denied:
'/opt/Plone-3.1/zinstance/var/filestorage/Data.fs.lock'

I haven't used buildout but I'll give it a try and see what happens..  Look
for more posts ...I'm not a developer so I may ask some stupid questions
about buildout...  :-)

Thanks again for all your help Derek

kevin



Derek Broughton wrote:
> 
> kphigh wrote:
> 
>> 
>> Thanks Derek.. I didnt' see any error messages.. 
> 
> What _did_ you see?   If you get nothing back from the import statements, 
> then you have at least got everything in the correct paths (or you'd get 
> import errors).
> 
> After:
> 
> x=da.createSAWrapper(dsn='mysql:///database')
> 
> I would expect to see an SADeprecationWarning, but perhaps not all of your 
> products are as recent as mine.  
> 
> If you got that far without any messages, then it should be good to go.  I 
> hope you're looking for the right thing in the ZMI - it should show up as 
> type=SQLAlchemyDA, not as a "Z ... Database Connection" like Gadfly.
> 
>> Stupid question though...
>> which Products folder should  SQLAlchemyDA exist?  There is:
>> /opt/Plone-3.1/zinstance/parts/zope2/lib/python/Products>  and
>> /opt/Plone-3.1/zinstance/parts/instance/Products
> 
> I haven't a clue - it's all so much easier if you just use buildout. 
> Since 
> you easy_installed it, I doubt it should be in either one - easy_install 
> products are usually found from the python libraries and .pth files.
> -- 
> derek
> 
> 
> ------------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2118781.html
Sent from the General Questions mailing list archive at Nabble.com.

Hey Derek,

I used buildout to get mysql-python and sqlalchemda.  Do these results look
ok? I still don't the sqlalchemyda in the ZMI



Updating plone.
Updating zope2.
Updating productdistros.
Installing instance.
Couldn't find index page for 'products.sqlalchemyda' (maybe misspelled?)
Getting distribution for 'products.sqlalchemyda'.
Got Products.SQLAlchemyDA 0.4.1.
Getting distribution for 'mysql-python'.
zip_safe flag not set; analyzing archive contents...
Got MySQL-python 1.2.2.
Getting distribution for 'z3c.sqlalchemy'.
Got z3c.sqlalchemy 1.3.9.
Getting distribution for 'zope.testing'.
Got zope.testing 3.7.1.
Getting distribution for 'zope.schema'.
Got zope.schema 3.5.0a2.
Getting distribution for 'zope.interface'.
Got zope.interface 3.5.0.
Getting distribution for 'zope.component'.
Got zope.component 3.5.1.
Getting distribution for 'zope.sqlalchemy'.
Got zope.sqlalchemy 0.3.
Getting distribution for 'SQLAlchemy'.
no previously-included directories found matching 'doc/build/output'
zip_safe flag not set; analyzing archive contents...
sqlalchemy.util: module MAY be using inspect.stack
sqlalchemy.databases.mysql: module MAY be using inspect.stack
Got SQLAlchemy 0.5.0.
Getting distribution for 'zope.event'.
Got zope.event 3.4.0.
Getting distribution for 'zope.i18nmessageid'.
Got zope.i18nmessageid 3.4.3.
Getting distribution for 'zope.deferredimport'.
Got zope.deferredimport 3.4.0.
Getting distribution for 'zope.deprecation'.
Got zope.deprecation 3.4.0.
Getting distribution for 'transaction'.
Got transaction 1.0a1.
Getting distribution for 'zope.proxy'.
Got zope.proxy 3.4.2.
Generated script '/opt/Plone-3.1/zinstance/bin/bin/instance'.
Installing zopepy.
Generated interpreter '/opt/Plone-3.1/zinstance/bin/bin/zopepy'.
Updating chown.
chown: Running 
chmod 600 .installed.cfg
find /opt/Plone-3.1/zinstance/bin -type d -name var -exec chown -R plone
\{\} \;
find /opt/Plone-3.1/zinstance/bin -type d -name LC_MESSAGES -exec chown -R
plone \{\} \;
find /opt/Plone-3.1/zinstance/bin -name runzope -exec chown plone \{\} \;
Updating unifiedinstaller.
Updating precompile.
  precompiling python scripts in /opt/Plone-3.1/zinstance/bin/products
Can't list /opt/Plone-3.1/zinstance/bin/products
Can't list /opt/Plone-3.1/zinstance/bin/products
  precompiling python scripts in
/opt/Plone-3.1/zinstance/bin/parts/productdistros
  precompiling python scripts in /opt/Plone-3.1/zinstance/bin/parts/plone


kphigh wrote:
> 
> I followed the install instructions for SQLAlchemyDA
> - download and install SQLAlchemy as egg or from the sources
>   from Cheeseshop (easy_install sqlalchemy). See
>     
>     http://www.sqlalchemy.org
> 
>     for details
> 
> - download and install z3c.sqlalchemy as egg or from the sources 
>   from Cheeseshop (easy_install z3c.sqlalchemy). See
> 
>     http://cheeseshop.python.org/pypi/z3c.sqlalchemy/
> 
>   for details.
> 
> - unpack the archive containing SQLAlchemyDA inside the "Products"
>   directory of your Zope instance home.
> 
> - after restarting Zope you go to the ZMI and create an instance of
>   "SQLAlchemyDA" (as you would create some DA instance)
> 
> The SQLAlchemyDA does not appear in the ZMI.. I saw in another post about
> not have the Pyton db driver installed and I do have them installed
> (MySql-pyton1.2.2)
> 
> Any ideas on why the option does not appear in the ZMI?
> 
> thanks
> kevn[
> 
> 
> 
> Derek Broughton wrote:
>> 
>> Andreas Jung wrote:
>> 
>>> On Fri, Jan 2, 2009 at 4:48 PM, kphigh
>>> <kevin.high@...:
>>> 
>>>> I installed SQLAlchemy Easy_install installed it in the following
>>>> location:
>> 
>> You don't want to install SQLAlchemy, directly.
>>  
>>> Either you use an Zope old-style DA like MySQLDA (appearing in the ZMI)
>>> or
>>> you go with something SQLAlchemy-based (like zope.sqlalchemy or
>>> z3c.sqlalchemy or collective.lead).
>> 
>> I'm surprised that Andreas failed to mention Products.SQLAlchemyDA, which
>> he 
>> wrote.
>> 
>> SQLAlchemy is much lower level than you want (and so are his
>> suggestions).  
>> 
>> Install Products.SQLAlchemyDA (either via easy-install or buildout) and
>> it 
>> relies on z3c.sqlalchemy and sqlalchemy.  The buildout method will get
>> them 
>> automatically - it's so long since I used a straight easy-install I don't 
>> recall if it grabs the dependencies.
>> -- 
>> derek
>> 
>> 
>> ------------------------------------------------------------------------------
>> _______________________________________________
>> Plone-Users mailing list
>> Plone-Users@...
>> https://lists.sourceforge.net/lists/listinfo/plone-users
>> 
>> 
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2129954.html
Sent from the General Questions mailing list archive at Nabble.com.

Are *any* messages on the console when you start Zope in the foreground?

-aj

On 08.01.2009 21:34 Uhr, kphigh wrote:
> Hey Derek,
>
> I used buildout to get mysql-python and sqlalchemda.  Do these results look
> ok? I still don't the sqlalchemyda in the ZMI
>
>
>
> Updating plone.
> Updating zope2.
> Updating productdistros.
> Installing instance.
> Couldn't find index page for 'products.sqlalchemyda' (maybe misspelled?)
> Getting distribution for 'products.sqlalchemyda'.
> Got Products.SQLAlchemyDA 0.4.1.
> Getting distribution for 'mysql-python'.
> zip_safe flag not set; analyzing archive contents...
> Got MySQL-python 1.2.2.
> Getting distribution for 'z3c.sqlalchemy'.
> Got z3c.sqlalchemy 1.3.9.
> Getting distribution for 'zope.testing'.
> Got zope.testing 3.7.1.
> Getting distribution for 'zope.schema'.
> Got zope.schema 3.5.0a2.
> Getting distribution for 'zope.interface'.
> Got zope.interface 3.5.0.
> Getting distribution for 'zope.component'.
> Got zope.component 3.5.1.
> Getting distribution for 'zope.sqlalchemy'.
> Got zope.sqlalchemy 0.3.
> Getting distribution for 'SQLAlchemy'.
> no previously-included directories found matching 'doc/build/output'
> zip_safe flag not set; analyzing archive contents...
> sqlalchemy.util: module MAY be using inspect.stack
> sqlalchemy.databases.mysql: module MAY be using inspect.stack
> Got SQLAlchemy 0.5.0.
> Getting distribution for 'zope.event'.
> Got zope.event 3.4.0.
> Getting distribution for 'zope.i18nmessageid'.
> Got zope.i18nmessageid 3.4.3.
> Getting distribution for 'zope.deferredimport'.
> Got zope.deferredimport 3.4.0.
> Getting distribution for 'zope.deprecation'.
> Got zope.deprecation 3.4.0.
> Getting distribution for 'transaction'.
> Got transaction 1.0a1.
> Getting distribution for 'zope.proxy'.
> Got zope.proxy 3.4.2.
> Generated script '/opt/Plone-3.1/zinstance/bin/bin/instance'.
> Installing zopepy.
> Generated interpreter '/opt/Plone-3.1/zinstance/bin/bin/zopepy'.
> Updating chown.
> chown: Running
> chmod 600 .installed.cfg
> find /opt/Plone-3.1/zinstance/bin -type d -name var -exec chown -R plone
> \{\} \;
> find /opt/Plone-3.1/zinstance/bin -type d -name LC_MESSAGES -exec chown -R
> plone \{\} \;
> find /opt/Plone-3.1/zinstance/bin -name runzope -exec chown plone \{\} \;
> Updating unifiedinstaller.
> Updating precompile.
>    precompiling python scripts in /opt/Plone-3.1/zinstance/bin/products
> Can't list /opt/Plone-3.1/zinstance/bin/products
> Can't list /opt/Plone-3.1/zinstance/bin/products
>    precompiling python scripts in
> /opt/Plone-3.1/zinstance/bin/parts/productdistros
>    precompiling python scripts in /opt/Plone-3.1/zinstance/bin/parts/plone
>
>
> kphigh wrote:
>> I followed the install instructions for SQLAlchemyDA
>> - download and install SQLAlchemy as egg or from the sources
>>    from Cheeseshop (easy_install sqlalchemy). See
>>
>>      http://www.sqlalchemy.org
>>
>>      for details
>>
>> - download and install z3c.sqlalchemy as egg or from the sources
>>    from Cheeseshop (easy_install z3c.sqlalchemy). See
>>
>>      http://cheeseshop.python.org/pypi/z3c.sqlalchemy/
>>
>>    for details.
>>
>> - unpack the archive containing SQLAlchemyDA inside the "Products"
>>    directory of your Zope instance home.
>>
>> - after restarting Zope you go to the ZMI and create an instance of
>>    "SQLAlchemyDA" (as you would create some DA instance)
>>
>> The SQLAlchemyDA does not appear in the ZMI.. I saw in another post about
>> not have the Pyton db driver installed and I do have them installed
>> (MySql-pyton1.2.2)
>>
>> Any ideas on why the option does not appear in the ZMI?
>>
>> thanks
>> kevn[
>>
>>
>>
>> Derek Broughton wrote:
>>> Andreas Jung wrote:
>>>
>>>> On Fri, Jan 2, 2009 at 4:48 PM, kphigh
>>>> <kevin.high@...:
>>>>
>>>>> I installed SQLAlchemy Easy_install installed it in the following
>>>>> location:
>>> You don't want to install SQLAlchemy, directly.
>>>
>>>> Either you use an Zope old-style DA like MySQLDA (appearing in the ZMI)
>>>> or
>>>> you go with something SQLAlchemy-based (like zope.sqlalchemy or
>>>> z3c.sqlalchemy or collective.lead).
>>> I'm surprised that Andreas failed to mention Products.SQLAlchemyDA, which
>>> he
>>> wrote.
>>>
>>> SQLAlchemy is much lower level than you want (and so are his
>>> suggestions).
>>>
>>> Install Products.SQLAlchemyDA (either via easy-install or buildout) and
>>> it
>>> relies on z3c.sqlalchemy and sqlalchemy.  The buildout method will get
>>> them
>>> automatically - it's so long since I used a straight easy-install I don't
>>> recall if it grabs the dependencies.
>>> --
>>> derek
>>>
>>>
>>> ------------------------------------------------------------------------------
>>> _______________________________________________
>>> Plone-Users mailing list
>>> Plone-Users@...
>>> https://lists.sourceforge.net/lists/listinfo/plone-users
>>>
>>>
>>
>


-- 
ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
Web: http://www.zopyx.com - Email: info@... - Phone +49 - 7071 - 793376
Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
------------------------------------------------------------------------
E-Publishing, Python, Zope & Plone development, Consulting

Hi Andreas,
Here is the message(s) from the console..
2009-01-09 07:28:39 INFO ZServer HTTP server started at Fri Jan  9 07:28:39
2009
	Hostname: 0.0.0.0
	Port: 8080
2009-01-09 07:28:39 INFO Zope Set effective user to "plone"
2009-01-09 07:28:47 INFO Marshall libxml2-python not available. Unable to
register libxml2 based marshallers.
/opt/Plone-3.1/zinstance/parts/zope2/lib/python/zope/configuration/xmlconfig.py:323:
DeprecationWarning: zope.app.annotation has moved to zope.annotation. Import
of zope.app.annotation will become unsupported in Zope 3.5
  __import__(arguments[0])
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFActionIcons:actionicons
taken from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFCalendar:default taken
from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFCalendar:skins_support
taken from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFDefault:default taken
from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFDefault:views_support
taken from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFDefault:sample_content
taken from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFTopic:default taken from
version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.CMFUid:default taken from
version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile Products.DCWorkflow:revision2 taken
from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile
Products.MimetypesRegistry:MimetypesRegistry taken from version.txt. This is
deprecated behaviour and will be removed in GenericSetup 1.5: please specify
the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile
Products.PortalTransforms:PortalTransforms taken from version.txt. This is
deprecated behaviour and will be removed in GenericSetup 1.5: please specify
the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile PluggableAuthService:simple taken
from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
/opt/Plone-3.1/zinstance/parts/plone/GenericSetup/registry.py:744:
DeprecationWarning: Version for profile PluggableAuthService:empty taken
from version.txt. This is deprecated behaviour and will be removed in
GenericSetup 1.5: please specify the version in metadata.xml.
  DeprecationWarning)
2009-01-09 07:29:14 INFO Zope Ready to handle requests







Andreas Jung-5 wrote:
> 
> Are *any* messages on the console when you start Zope in the foreground?
> 
> -aj
> 
> On 08.01.2009 21:34 Uhr, kphigh wrote:
>> Hey Derek,
>>
>> I used buildout to get mysql-python and sqlalchemda.  Do these results
>> look
>> ok? I still don't the sqlalchemyda in the ZMI
>>
>>
>>
>> Updating plone.
>> Updating zope2.
>> Updating productdistros.
>> Installing instance.
>> Couldn't find index page for 'products.sqlalchemyda' (maybe misspelled?)
>> Getting distribution for 'products.sqlalchemyda'.
>> Got Products.SQLAlchemyDA 0.4.1.
>> Getting distribution for 'mysql-python'.
>> zip_safe flag not set; analyzing archive contents...
>> Got MySQL-python 1.2.2.
>> Getting distribution for 'z3c.sqlalchemy'.
>> Got z3c.sqlalchemy 1.3.9.
>> Getting distribution for 'zope.testing'.
>> Got zope.testing 3.7.1.
>> Getting distribution for 'zope.schema'.
>> Got zope.schema 3.5.0a2.
>> Getting distribution for 'zope.interface'.
>> Got zope.interface 3.5.0.
>> Getting distribution for 'zope.component'.
>> Got zope.component 3.5.1.
>> Getting distribution for 'zope.sqlalchemy'.
>> Got zope.sqlalchemy 0.3.
>> Getting distribution for 'SQLAlchemy'.
>> no previously-included directories found matching 'doc/build/output'
>> zip_safe flag not set; analyzing archive contents...
>> sqlalchemy.util: module MAY be using inspect.stack
>> sqlalchemy.databases.mysql: module MAY be using inspect.stack
>> Got SQLAlchemy 0.5.0.
>> Getting distribution for 'zope.event'.
>> Got zope.event 3.4.0.
>> Getting distribution for 'zope.i18nmessageid'.
>> Got zope.i18nmessageid 3.4.3.
>> Getting distribution for 'zope.deferredimport'.
>> Got zope.deferredimport 3.4.0.
>> Getting distribution for 'zope.deprecation'.
>> Got zope.deprecation 3.4.0.
>> Getting distribution for 'transaction'.
>> Got transaction 1.0a1.
>> Getting distribution for 'zope.proxy'.
>> Got zope.proxy 3.4.2.
>> Generated script '/opt/Plone-3.1/zinstance/bin/bin/instance'.
>> Installing zopepy.
>> Generated interpreter '/opt/Plone-3.1/zinstance/bin/bin/zopepy'.
>> Updating chown.
>> chown: Running
>> chmod 600 .installed.cfg
>> find /opt/Plone-3.1/zinstance/bin -type d -name var -exec chown -R plone
>> \{\} \;
>> find /opt/Plone-3.1/zinstance/bin -type d -name LC_MESSAGES -exec chown
>> -R
>> plone \{\} \;
>> find /opt/Plone-3.1/zinstance/bin -name runzope -exec chown plone \{\} \;
>> Updating unifiedinstaller.
>> Updating precompile.
>>    precompiling python scripts in /opt/Plone-3.1/zinstance/bin/products
>> Can't list /opt/Plone-3.1/zinstance/bin/products
>> Can't list /opt/Plone-3.1/zinstance/bin/products
>>    precompiling python scripts in
>> /opt/Plone-3.1/zinstance/bin/parts/productdistros
>>    precompiling python scripts in
>> /opt/Plone-3.1/zinstance/bin/parts/plone
>>
>>
>> kphigh wrote:
>>> I followed the install instructions for SQLAlchemyDA
>>> - download and install SQLAlchemy as egg or from the sources
>>>    from Cheeseshop (easy_install sqlalchemy). See
>>>
>>>      http://www.sqlalchemy.org
>>>
>>>      for details
>>>
>>> - download and install z3c.sqlalchemy as egg or from the sources
>>>    from Cheeseshop (easy_install z3c.sqlalchemy). See
>>>
>>>      http://cheeseshop.python.org/pypi/z3c.sqlalchemy/
>>>
>>>    for details.
>>>
>>> - unpack the archive containing SQLAlchemyDA inside the "Products"
>>>    directory of your Zope instance home.
>>>
>>> - after restarting Zope you go to the ZMI and create an instance of
>>>    "SQLAlchemyDA" (as you would create some DA instance)
>>>
>>> The SQLAlchemyDA does not appear in the ZMI.. I saw in another post
>>> about
>>> not have the Pyton db driver installed and I do have them installed
>>> (MySql-pyton1.2.2)
>>>
>>> Any ideas on why the option does not appear in the ZMI?
>>>
>>> thanks
>>> kevn[
>>>
>>>
>>>
>>> Derek Broughton wrote:
>>>> Andreas Jung wrote:
>>>>
>>>>> On Fri, Jan 2, 2009 at 4:48 PM, kphigh
>>>>> <kevin.high@...:
>>>>>
>>>>>> I installed SQLAlchemy Easy_install installed it in the following
>>>>>> location:
>>>> You don't want to install SQLAlchemy, directly.
>>>>
>>>>> Either you use an Zope old-style DA like MySQLDA (appearing in the
>>>>> ZMI)
>>>>> or
>>>>> you go with something SQLAlchemy-based (like zope.sqlalchemy or
>>>>> z3c.sqlalchemy or collective.lead).
>>>> I'm surprised that Andreas failed to mention Products.SQLAlchemyDA,
>>>> which
>>>> he
>>>> wrote.
>>>>
>>>> SQLAlchemy is much lower level than you want (and so are his
>>>> suggestions).
>>>>
>>>> Install Products.SQLAlchemyDA (either via easy-install or buildout) and
>>>> it
>>>> relies on z3c.sqlalchemy and sqlalchemy.  The buildout method will get
>>>> them
>>>> automatically - it's so long since I used a straight easy-install I
>>>> don't
>>>> recall if it grabs the dependencies.
>>>> --
>>>> derek
>>>>
>>>>
>>>> ------------------------------------------------------------------------------
>>>> _______________________________________________
>>>> Plone-Users mailing list
>>>> Plone-Users@...
>>>> https://lists.sourceforge.net/lists/listinfo/plone-users
>>>>
>>>>
>>>
>>
> 
> 
> -- 
> ZOPYX Ltd. & Co. KG - Charlottenstr. 37/1 - 72070 Tübingen - Germany
> Web: http://www.zopyx.com - Email: info@... - Phone +49 - 7071 - 793376
> Registergericht: Amtsgericht Stuttgart, Handelsregister A 381535
> Geschäftsführer/Gesellschafter: ZOPYX Limited, Birmingham, UK
> ------------------------------------------------------------------------
> E-Publishing, Python, Zope & Plone development, Consulting
> 
> 
> begin:vcard
> fn:Andreas Jung
> n:Jung;Andreas
> org:ZOPYX Ltd. & Co. KG
> adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
> email;internet:info@...
> title:CEO
> tel;work:+49-7071-793376
> tel;fax:+49-7071-7936840
> tel;home:+49-7071-793257
> x-mozilla-html:FALSE
> url:www.zopyx.com
> version:2.1
> end:vcard
> 
> 
> ------------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2132962.html
Sent from the General Questions mailing list archive at Nabble.com.

kphigh wrote:

> 
> Hey Derek,
> 
> I used buildout to get mysql-python and sqlalchemda.  Do these results
> look ok? I still don't the sqlalchemyda in the ZMI

That all looked normal except:

> Generated script '/opt/Plone-3.1/zinstance/bin/bin/instance'.

"bin/bin"?

So what happened when you did:

# bin/instance debug

and tried all the things I suggested before?
-- 
derek

Not sure why bin/bin is there.. it was created with I ran buildout.  I
haven't done the other checks you mentioned before because I wanted to make
sure everything looked good after running buildout..   Since it appears
everything is ok I'll give those a try this afternoon.. I'll let you know
what happens...

Thanks for your help..

kevin


Derek Broughton wrote:
> 
> kphigh wrote:
> 
>> 
>> Hey Derek,
>> 
>> I used buildout to get mysql-python and sqlalchemda.  Do these results
>> look ok? I still don't the sqlalchemyda in the ZMI
> 
> That all looked normal except:
> 
>> Generated script '/opt/Plone-3.1/zinstance/bin/bin/instance'.
> 
> "bin/bin"?
> 
> So what happened when you did:
> 
> # bin/instance debug
> 
> and tried all the things I suggested before?
> -- 
> derek
> 
> 
> ------------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It is the best place to buy or sell services for
> just about anything Open Source.
> http://p.sf.net/sfu/Xq1LFB
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2133975.html
Sent from the General Questions mailing list archive at Nabble.com.

YEA!!!! Finally got it to work!!!  
I ended up using easy_install-2.4 to install the products.  I think even
though I exported my PATH to point to python 2.4, buildout still used the
system python 2.6 .(I tried adding the executable='python path' in my
buildout config file, but buildout did not work.)  The reason I think this
is because after I ran buildout, I tried importing _mysql using ver 2.4, but
got an error, however, when I used 2.6, the import was successful.  

Thanks for all your help, Derek..

kevin




Derek Broughton wrote:
> 
> kphigh wrote:
> 
>> 
>> I followed the install instructions for SQLAlchemyDA
> ... 
>> The SQLAlchemyDA does not appear in the ZMI.. I saw in another post about
>> not have the Pyton db driver installed and I do have them installed
>> (MySql-pyton1.2.2)
>> 
>> Any ideas on why the option does not appear in the ZMI?
> 
> I have this problem often with Oracle, and never with Postgres, and it 
> basically comes down to the fact that the DB driver has to work...
> 
> Use a Zope debug instance, like:
> 
>    $ bin/instance debug
> 
> You might get lucky and see exactly why it doesn't work in the messages it 
> displays before the first prompt.  Otherwise...
> 
> Try to import the MySql driver.  If it doesn't work, then it's not
> installed 
> in the right place.  If it does work, try to create a connection with the 
> MySQL driver (I don't know how you do that in MySql, so I can't give an 
> example).
> 
> If you can get a connection directly, then try:
>> from Products.SQLAlchemyDA import *
>> x=da.createSAWrapper(dsn='mysql:///database')
> 
> By that point you should know the problem
> -- 
> derek
> 
> 
> ------------------------------------------------------------------------------
> _______________________________________________
> Plone-Users mailing list
> Plone-Users@...
> https://lists.sourceforge.net/lists/listinfo/plone-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Adding-MySql-database-adapter-using-SQLAlchemy-tp2102138p2147568.html
Sent from the General Questions mailing list archive at Nabble.com.