On 2012-04-26 05:32, Greg Landrum wrote:
> I continue to be unable to reproduce these problems.
>
> Running on a 64bit Ubuntu 11.10 VM I installed the following packages
> using apt-get:
> sudo apt-get install postgresql
> sudo apt-get install postgresql-contrib postgresql-server-dev-all
>
> I build the cartridge:
>
> glandrum@ubuntu:~/RDKit_2012_03_1/Code/PgSQL/rdkit$ make
>
> Install it (notice the "sudo"):
>
> glandrum@ubuntu:~/RDKit_2012_03_1/Code/PgSQL/rdkit$ sudo make install
>
> Create a postgresql account for my user:
>
> glandrum@ubuntu:~/RDKit_2012_03_1/Code/PgSQL/rdkit$ sudo su postgres
> postgres@ubuntu:/home/glandrum/RDKit_2012_03_1/Code/PgSQL/rdkit$
> createuser glandrum
> Shall the new role be a superuser? (y/n) y
>
> And then run the tests:
>
> glandrum@ubuntu:~/RDKit_2012_03_1/Code/PgSQL/rdkit$ make installcheck
> /usr/lib/postgresql/9.1/lib/pgxs/src/makefiles/../../src/test/regress/pg_regress
> --inputdir=. --psqldir='/usr/lib/postgresql/9.1/bin'
> --dbname=contrib_regression rdkit-91 props btree molgist bfpgist-91
> sfpgist slfpgist fps
> (using postmaster on Unix socket, default port)
> ============== dropping database "contrib_regression" ==============
> NOTICE: database "contrib_regression" does not exist, skipping
> DROP DATABASE
> ============== creating database "contrib_regression" ==============
> CREATE DATABASE
> ALTER DATABASE
> ============== running regression test queries ==============
> test rdkit-91 ... ok
> test props ... ok
> test btree ... ok
> test molgist ... ok
> test bfpgist-91 ... ok
> test sfpgist ... ok
> test slfpgist ... ok
> test fps ... ok
>
> =====================
> All 8 tests passed.
> =====================
>
> Can you please check your configuration to make sure that the packages
> are all installed and the appropriate accounts are there?
>
> -greg
>
Dear Greg,
On my Ubuntu 10.04 I can build against and install into Postgres 9.0
without any issues. I did a "createuser jhje" as postgres and then ran
the test suite.
jhje@ubuntu-lynet-test:~/RDKit_2012_03_1/Code/PgSQL/rdkit$ make installcheck
/opt/postgres/9.0/lib/postgresql/pgxs/src/makefiles/../../src/test/regress/pg_regress
--inputdir=. --psqldir=/opt/postgres/9.0/bin --dbname=contrib_regression
rdkit-pre91 props btree molgist bfpgist-pre91 sfpgist slfpgist fps
(using postmaster on Unix socket, port 5432)
============== dropping database "contrib_regression" ==============
DROP DATABASE
============== creating database "contrib_regression" ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries ==============
test rdkit-pre91 ... ok
test props ... ok
test btree ... ok
test molgist ... ok
test bfpgist-pre91 ... ok
test sfpgist ... ok
test slfpgist ... ok
test fps ... ok
=====================
All 8 tests passed.
=====================
jhje@ubuntu-lynet-test:~/RDKit_2012_03_1/Code/PgSQL/rdkit$
After having installed the cartridge as the postgres user with "psql <
/opt/postgres/9.0/share/postgresql/contrib/rdkit.sql":
postgres@ubuntu-lynet-test:~$ psql
Password:
psql (9.0.4)
Type "help" for help.
postgres=# select mol_amw('CCCC');
mol_amw
---------
58.124
(1 row)
postgres=# show rdkit.tanimoto_threshold;
rdkit.tanimoto_threshold
--------------------------
0.5
(1 row)
postgres=#
But against postgres 9.1 both the test suite and the attempt to do
"create extension rdkit" fails with
FATAL: failed to initialize rdkit.tanimoto_threshold to 0.5
FATAL: failed to initialize rdkit.tanimoto_threshold to 0.5
On the Linux Mint VM I found that I didn't have the postgresql-contrib
package installed. I added it but it didn't make a difference.
Both of the VMs I have used are 32-bit and you are using a 64-bit VM. I
wonder if that is significant. I don't have a 64-bit Linux VM ready for
test building at the moment but let me see if I can establish one.
Kind regards
-- Jan Holst Jensen
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Rdkit-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rdkit-discuss
