Re: [Rdkit-discuss] rdkit RPM for CentOS 5.3 ?
On Tue, Feb 25, 2014 at 9:40 PM, Jan Holst Jensen j...@biochemfusion.com wrote: I am testing if rdkit can be used from Oracle on a customer (test!) database. And said database runs on a CentOS 5.3 server - no OS upgrade in the near future. First step is to get rdkit working in Python 2.4 on that server. For a start, you can make your life easier by adding the EPEL repository and pulling python26 package from there. IIRC the only real blocker that prevented me from building RDKit against CentOS5 + EPEL was flex -- Gianluca Sforna http://morefedora.blogspot.com http://identi.ca/giallu - http://twitter.com/giallu -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk ___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
Re: [Rdkit-discuss] rdkit RPM for CentOS 5.3 ?
On Wed, Feb 26, 2014 at 10:56 AM, Gianluca Sforna gia...@gmail.com wrote: On Tue, Feb 25, 2014 at 9:40 PM, Jan Holst Jensen j...@biochemfusion.com wrote: I am testing if rdkit can be used from Oracle on a customer (test!) database. And said database runs on a CentOS 5.3 server - no OS upgrade in the near future. First step is to get rdkit working in Python 2.4 on that server. For a start, you can make your life easier by adding the EPEL repository and pulling python26 package from there. Yeah, I am pretty sure that there is python code that is not going to work with 2.4 IIRC the only real blocker that prevented me from building RDKit against CentOS5 + EPEL was flex Fortunately, flex is no longer required, so that one is gone. -greg -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
Re: [Rdkit-discuss] rdkit RPM for CentOS 5.3 ?
On 2014-02-26 11:04, Greg Landrum wrote: On Wed, Feb 26, 2014 at 10:56 AM, Gianluca Sforna gia...@gmail.com wrote: On Tue, Feb 25, 2014 at 9:40 PM, Jan Holst Jensen j...@biochemfusion.com wrote: I am testing if rdkit can be used from Oracle on a customer (test!) database. And said database runs on a CentOS 5.3 server - no OS upgrade in the near future. First step is to get rdkit working in Python 2.4 on that server. For a start, you can make your life easier by adding the EPEL repository and pulling python26 package from there. Yeah, I am pretty sure that there is python code that is not going to work with 2.4 IIRC the only real blocker that prevented me from building RDKit against CentOS5 + EPEL was flex Fortunately, flex is no longer required, so that one is gone. -greg Thanks, Gianluca and Greg. The EPEL repository looks like it could save the day, giving me a tool chain so I can build rdkit. I'll give it a try! Cheers -- Jan -- Biochemfusion ApS CVR(VAT) No. DK 32 05 74 46 by Jan Holst Jensen e-mail: j...@biochemfusion.com Lindegrdsvej 44, 2. TV Web: http://biochemfusion.com DK-2920 Charlottenlund, Copenhagen Phone: +45 30 48 00 50 . -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
Re: [Rdkit-discuss] Insert mol objects directly into postgres rdkit cartridge column?
Hi Hari, You can use mol_from_pkl(). Here's a quick demo: In [20]: m = Chem.MolFromSmiles('c1cnccc1') In [21]: pkl = buffer(m.ToBinary()) In [22]: curs.execute('select mol_from_pkl(%s)',(pkl,)) In [23]: curs.fetchone() Out[23]: ('c1ccncc1',) Is that enough to get you started? -greg On Tue, Feb 25, 2014 at 8:28 PM, hari jayaram hari...@gmail.com wrote: Hi , I am a newbie to postgres and the rdkit postgres database cartridge. I have gotten the cartridge installed and can query sub-structure similarity and do other things as documented in the cartridge documentation page. To create a molecule from the cartridge the documentation http://www.rdkit.org/docs/Cartridge.htmlrecommends something like: curs.execute('select molregno,mol_send(m) from rdk.mols where m@ %s',('c12c1nncc2',)) row = curs.fetchone() row (9830, read-only buffer for 0x...) Then the pickled output of mol_send will be used to create a new molecule from rdkit import Chem m = Chem.Mol(str(row[1])) Chem.MolToSmiles(m,True) 'CC(C)Sc1ccc(CC2CCN(C3CCN(C(=O)c4cnnc5c54)CC3)CC2)cc1' My question is : how about the other way .Is the only way to use the smiles and do an sql insert with the smiles and the mol_from_smiles function as in : insert into compounds (smiles,rdkit_mol,internal,external) VALUES ('C',mol_from_smiles('C);'ID-111','EI-222'); Is there a way to insert the python rdkit mol object into the database rdkit mol column directly. This is in some ways connected to a question I just asked ( django related) on stack overflow.http://stackoverflow.com/questions/22022163/how-to-handle-map-custom-postgresql-type-to-django-model Thanks a tonne for your help in advance Hari -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk ___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
[Rdkit-discuss] Fwd: Error in installation of RDkit from source on Mac OSx 10.9.1
Hi All, I tried to install via homebrew but after running it cannot move to stage of rdkit installation on Mac 10.9.1 brew install --HEAD rdkit ==* Installing rdkit dependency: *boost *==** Downloading http://downloads.sourceforge.net/project/boost/boost/1.49.0/boos http://downloads.sourceforge.net/project/boost/boost/1.49.0/boos* Already downloaded: /Library/Caches/Homebrew/boost-1.49.0.tar.bz2 *==** ./bootstrap.sh --prefix=/usr/local/Cellar/boost/1.49.0 --libdir=/usr/local/C* *==** ./bjam --prefix=/usr/local/Cellar/boost/1.49.0 --libdir=/usr/local/Cellar/bo* When i was trying to build from source then i am having some types.cpp error .Attached is the log of error msg. Then i tried to install RDkit from source with Boost and all dependencies.I was able to install Boost1.49 but the problem with rdkit cmake is that it is throwing an error at make[2]: *** [Code/RDGeneral/CMakeFiles/RDGeneral.dir/types.cpp.o] Error 1 make[1]: *** [Code/RDGeneral/CMakeFiles/RDGeneral.dir/all] Error My command was cmake -D PYTHON_LIBRARY=/usr/lib/python2.7/config/libpython2.7.a -D PYTHON_INCLUDE_DIR=/usr/include/python2.7 -D PYTHON_EXECUTABLE=/usr/bin/python -DBOOST_ROOT=/usr/local/boost_1_49_0 Then i also changed the boost version to 1.55 again i found the same error Anyone came across this type of error ? Attached is my error log. Can anyone guide me through whats going wrong. Abhik Seal Indiana University Bloomington Department of Chemical Informatics abs...@indiana.edu *OSDD CHEMINFORMATICS* +18123699097 http://mypage.iu.edu/~abseal/index.htm -- Forwarded message -- From: Abhik Seal abhik1...@gmail.com Date: Mon, Feb 24, 2014 at 11:25 PM Subject: Error in installation of RDkit from source on Mac OSx 10.9.1 To: Rdkit-discuss@lists.sourceforge.net rdkit-discuss@lists.sourceforge.net Hi All, I tried to install via homebrew but after running it cannot move to stage of rdkit installation on Mac 10.9.1 brew install --HEAD rdkit ==* Installing rdkit dependency: *boost *==** Downloading http://downloads.sourceforge.net/project/boost/boost/1.49.0/boos http://downloads.sourceforge.net/project/boost/boost/1.49.0/boos* Already downloaded: /Library/Caches/Homebrew/boost-1.49.0.tar.bz2 *==** ./bootstrap.sh --prefix=/usr/local/Cellar/boost/1.49.0 --libdir=/usr/local/C* *==** ./bjam --prefix=/usr/local/Cellar/boost/1.49.0 --libdir=/usr/local/Cellar/bo* When i was trying to build from source then i am having some types.cpp error .Attached is the log of error msg. Then i tried to install RDkit from source with Boost and all dependencies.I was able to install Boost1.49 but the problem with rdkit cmake is that it is throwing an error at make[2]: *** [Code/RDGeneral/CMakeFiles/RDGeneral.dir/types.cpp.o] Error 1 make[1]: *** [Code/RDGeneral/CMakeFiles/RDGeneral.dir/all] Error My command was cmake -D PYTHON_LIBRARY=/usr/lib/python2.7/config/libpython2.7.a -D PYTHON_INCLUDE_DIR=/usr/include/python2.7 -D PYTHON_EXECUTABLE=/usr/bin/python -DBOOST_ROOT=/usr/local/boost_1_49_0 Then i also changed the boost version to 1.55 again i found the same error Anyone came across this type of error ? Attached is my error log. Can anyone guide me through whats going wrong. Thanks Abhik Abhik Seal Indiana University Bloomington Department of Chemical Informatics abs...@indiana.edu *OSDD CHEMINFORMATICS* +18123699097 http://mypage.iu.edu/~abseal/index.htm abhikseal/usr/local/src/RDKit_2013_09_1/build$cmake .. -- Boost version: 1.55.0 -- Found the following Boost libraries: -- python -- Boost version: 1.55.0 -- Found the following Boost libraries: -- regex -- Configuring done -- Generating done -- Build files have been written to: /usr/local/src/RDKit_2013_09_1/build abhikseal/usr/local/src/RDKit_2013_09_1/build$make [ 1%] Built target fastentropy [ 1%] Built target inchi_support Scanning dependencies of target RDGeneral [ 2%] Building CXX object Code/RDGeneral/CMakeFiles/RDGeneral.dir/Invariant.cpp.o [ 2%] Building CXX object Code/RDGeneral/CMakeFiles/RDGeneral.dir/types.cpp.o In file included from /usr/local/src/RDKit_2013_09_1/Code/RDGeneral/types.cpp:15: In file included from /usr/local/src/RDKit_2013_09_1/Code/RDGeneral/types.h:20: In file included from /usr/local/src/RDKit_2013_09_1/Code/RDGeneral/Invariant.h:15: In file included from /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/string:434: In file included from /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/algorithm:593: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/utility:255:15: error: no viable overloaded '=' first = __p.first; ~ ^ ~ /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/__tree:1246:35: note: in instantiation of member function 'std::__1::pairconst
[Rdkit-discuss] Error in installation of RDkit from source on Mac OSx 10.9.1
Hi All, Apologies for multiple postings, ignore my last posting. I tried to install rdkit via homebrew but after running it cannot move to stage of rdkit installation on Mac 10.9.1 brew install --HEAD rdkit ==* Installing rdkit dependency: *boost *==** Downloading http://downloads.sourceforge.net/project/boost/boost/1.49.0/boos http://downloads.sourceforge.net/project/boost/boost/1.49.0/boos* Already downloaded: /Library/Caches/Homebrew/boost-1.49.0.tar.bz2 *==** ./bootstrap.sh --prefix=/usr/local/Cellar/boost/1.49.0 --libdir=/usr/local/C* *==** ./bjam --prefix=/usr/local/Cellar/boost/1.49.0 --libdir=/usr/local/Cellar/bo* When i was trying to build from source then i am having some types.cpp error .Attached is the log of error msg. Then i tried to install RDkit from source with Boost and all dependencies.I was able to install Boost1.49 but the problem with rdkit cmake is that it is throwing an error at make[2]: *** [Code/RDGeneral/CMakeFiles/RDGeneral.dir/types.cpp.o] Error 1 make[1]: *** [Code/RDGeneral/CMakeFiles/RDGeneral.dir/all] Error My command was cmake -D PYTHON_LIBRARY=/usr/lib/python2.7/config/libpython2.7.a -D PYTHON_INCLUDE_DIR=/usr/include/python2.7 -D PYTHON_EXECUTABLE=/usr/bin/python -DBOOST_ROOT=/usr/local/boost_1_49_0 Then i also changed the boost version to 1.55 again i found the same error Anyone came across this type of error ? Attached is my error log. Can anyone guide me through what's going wrong ? Thanks Abhik Abhik Seal Indiana University Bloomington Department of Chemical Informatics abs...@indiana.edu *OSDD CHEMINFORMATICS* +18123699097 http://mypage.iu.edu/~abseal/index.htm abhikseal/usr/local/src/RDKit_2013_09_1/build$cmake .. -- Boost version: 1.55.0 -- Found the following Boost libraries: -- python -- Boost version: 1.55.0 -- Found the following Boost libraries: -- regex -- Configuring done -- Generating done -- Build files have been written to: /usr/local/src/RDKit_2013_09_1/build abhikseal/usr/local/src/RDKit_2013_09_1/build$make [ 1%] Built target fastentropy [ 1%] Built target inchi_support Scanning dependencies of target RDGeneral [ 2%] Building CXX object Code/RDGeneral/CMakeFiles/RDGeneral.dir/Invariant.cpp.o [ 2%] Building CXX object Code/RDGeneral/CMakeFiles/RDGeneral.dir/types.cpp.o In file included from /usr/local/src/RDKit_2013_09_1/Code/RDGeneral/types.cpp:15: In file included from /usr/local/src/RDKit_2013_09_1/Code/RDGeneral/types.h:20: In file included from /usr/local/src/RDKit_2013_09_1/Code/RDGeneral/Invariant.h:15: In file included from /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/string:434: In file included from /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/algorithm:593: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/utility:255:15: error: no viable overloaded '=' first = __p.first; ~ ^ ~ /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/__tree:1246:35: note: in instantiation of member function 'std::__1::pairconst std::__1::basic_stringchar, boost::any::operator=' requested here __cache-__value_ = *__first; ^ /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/__tree:1187:9: note: in instantiation of function template specialization 'std::__1::__treestd::__1::pairconst std::__1::basic_stringchar, boost::any, std::__1::__map_value_compareconst std::__1::basic_stringchar, boost::any, std::__1::lessconst std::__1::basic_stringchar , true, std::__1::allocatorstd::__1::pairconst std::__1::basic_stringchar, boost::any ::__assign_multistd::__1::__tree_const_iteratorstd::__1::pairconst std::__1::basic_stringchar, boost::any, const std::__1::__tree_nodestd::__1::pairconst std::__1::basic_stringchar, boost::any, void * *, long ' requested here __assign_multi(__t.begin(), __t.end()); ^ /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/../lib/c++/v1/map:766:21: note: in instantiation of member function 'std::__1::__treestd::__1::pairconst std::__1::basic_stringchar, boost::any, std::__1::__map_value_compareconst std::__1::basic_stringchar, boost::any, std::__1::lessconst std::__1::basic_stringchar , true, std::__1::allocatorstd::__1::pairconst std::__1::basic_stringchar, boost::any ::operator=' requested here __tree_ = __m.__tree_; ^ /usr/local/src/RDKit_2013_09_1/Code/RDGeneral/Dict.h:41:13: note: in instantiation of member function 'std::__1::mapconst std::__1::basic_stringchar, boost::any, std::__1::lessconst std::__1::basic_stringchar , std::__1::allocatorstd::__1::pairconst
Re: [Rdkit-discuss] Insert mol objects directly into postgres rdkit cartridge column?
you can try use razi: http://razi.readthedocs.org/en/latest/database_creation_tutorial.html pozdrawiam Adrian 2014-02-26 18:34 GMT+01:00 Greg Landrum greg.land...@gmail.com: Hi Hari, You can use mol_from_pkl(). Here's a quick demo: In [20]: m = Chem.MolFromSmiles('c1cnccc1') In [21]: pkl = buffer(m.ToBinary()) In [22]: curs.execute('select mol_from_pkl(%s)',(pkl,)) In [23]: curs.fetchone() Out[23]: ('c1ccncc1',) Is that enough to get you started? -greg On Tue, Feb 25, 2014 at 8:28 PM, hari jayaram hari...@gmail.com wrote: Hi , I am a newbie to postgres and the rdkit postgres database cartridge. I have gotten the cartridge installed and can query sub-structure similarity and do other things as documented in the cartridge documentation page. To create a molecule from the cartridge the documentation http://www.rdkit.org/docs/Cartridge.htmlrecommends something like: curs.execute('select molregno,mol_send(m) from rdk.mols where m@ %s',('c12c1nncc2',)) row = curs.fetchone() row (9830, read-only buffer for 0x...) Then the pickled output of mol_send will be used to create a new molecule from rdkit import Chem m = Chem.Mol(str(row[1])) Chem.MolToSmiles(m,True) 'CC(C)Sc1ccc(CC2CCN(C3CCN(C(=O)c4cnnc5c54)CC3)CC2)cc1' My question is : how about the other way .Is the only way to use the smiles and do an sql insert with the smiles and the mol_from_smiles function as in : insert into compounds (smiles,rdkit_mol,internal,external) VALUES ('C',mol_from_smiles('C);'ID-111','EI-222'); Is there a way to insert the python rdkit mol object into the database rdkit mol column directly. This is in some ways connected to a question I just asked ( django related) on stack overflow.http://stackoverflow.com/questions/22022163/how-to-handle-map-custom-postgresql-type-to-django-model Thanks a tonne for your help in advance Hari -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk ___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk ___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss -- Flow-based real-time traffic analytics software. Cisco certified tool. Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer Customize your own dashboards, set traffic alerts and generate reports. Network behavioral analysis security monitoring. All-in-one tool. http://pubads.g.doubleclick.net/gampad/clk?id=126839071iu=/4140/ostg.clktrk___ Rdkit-discuss mailing list Rdkit-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rdkit-discuss