Classifier 2.0 Beta for MacOS

[afraser]

The margin vs. iteration plot isn't critical, so you don't need pyCellProfiler. You will need to install the classifier function in MySQL however. I don't know how to do this off the top of my head but here's a link that might get you started (http://dev.mysql.com/doc/refman/5.0/en/adding-udf.html). It's a holiday today so I'll have to get back to you on Monday. The MySQL function to be installed is in a file in src/ called _classifier.c

CPA is also now bundled for distribution in Mac and Windows, it's just a matter of us posting it on the website.
-Adam

[Coen]

Hi Adam,

Thanks for your reply. I have compiled the _classifier.so and copied it into the plugin folder of mysql installation. Next I tried to create the classifier function with : 'mysql>> CREATE FUNCTION classifier RETURNS INTEGER SONAME '_classifier.so';'. This resulted in the following error:

ERROR 1126 (HY000): Can't open shared library '_classifier.so' (errno: 0 dlopen(/usr/local/mysql-5.1.35-osx10.5-x86/lib/plugin/_classifier.so, 2): Symbol not found: __Py_NoneStruct
Referenced from: /)

Any suggestions?

Thanks in advance,

Coen

[afraser]

There's another classify.c, in src/mysql_plugins. That's the one you want to build and install.

[Coen]

Hi Adam

Success at last. I have compiled the classify.c with the following command:
gcc -fPIC -Wall -I /usr/local/mysql-5.1.35-osx10.5-x86/include -dynamiclib -lstdc++ -o classify.so classify.c

copied the classify.so to:
/usr/local/mysql-5.1.35-osx10.5-x86/lib/plugin

started the mySQL server:
/usr/local/mysql/bin/mysql -u root -p

and installed it with:
mysql> CREATE FUNCTION classifier RETURNS INTEGER SONAME 'classify.so'

Thanks again for your help.

Coen

[afraser]

Great! Thanks for posting your steps.

[afraser]

UPDATE:

A new version of CellProfiler Analyst (including the Classifier tool) has been released and is available for download for Mac OS and Windows from: http://cellprofiler.org/downloadCPA.shtml

...installation is as easy as downloading and opening the file.