[opensuse] Could anybody be so nice to suggest me an opensource software for Online Virtual Library like iVia?
Dear my friends... After 2 weeks trying to install iVia which I downloaded from "http://ivia.ucr.edu/" without success on OpenSuSE11.1, I think I have been desperated already. I can't solved this problem: " sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # ./root-install === ./root-install: Checking needed packages... === ... ... ... ./update_database.sh Database revision number before updates: 06000003 Applying database update: 06000004.sql Query: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' iViaCore-exec-sql: Error: error: iViaCore-exec-sql: in DbConnection::execSql: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, conte...: FEHLER: keine Berechtigung f�r Sprache plpythonu (my translation: no access right to plpythonu). StackTrace::getNonGdbBacktrace()+0x3b Exception::Exception(std::string const&)+0xd0 DbConnection::execSql(std::string const&)+0x1c2 iViaCore-exec-sql(main+0x28f) [0x804aa1f] libc.so.6(__libc_start_main+0xe5) [0x40a45705] iViaCore-exec-sql [0x8049871] in sql statement 0) CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' make[1]: *** [install] Error 1 make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/db_updates' make: *** [install] Error 2 *** ./build-libiViaCore: Error in building your libiViaCore installation! *** ./root-install: Error in building your libiViaCore installation! ". Anybody can suggest me the same kind of software as iVia? Web based is a mandatory. Thank you very much in advance. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Ricky Tompu Breaky (ricky.breaky@uni.de) [20090930 02:08]:
As my crystal ball is currently out of order, please describe in more detail the steps you have already taken. Oherwise it's kind of hard to help you. Philipp -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, 30 Sep 2009 16:35:42 +0200 Philipp Thomas <pth@suse.de> wrote:
Dear Philips. Firstly, thank you very much for your generousity. I've downloaded the 'libiViaCore-6.0.1 ==== sussy:/home/ivia/libiViaCore-6.0.1 # ./configure --prefix=/home/ivia/libiViaCore-installed checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... /bin/mkdir -p checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for uname... /bin/uname checking machine architecture... i686 checking for g++... g++ checking for C++ compiler default output file name... a.out checking whether the C++ compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking for style of include used by make... GNU checking dependency style of g++... gcc3 checking for a BSD-compatible install... /usr/bin/install -c checking for ranlib... ranlib checking whether ln -s works... yes checking for gcc... gcc checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking dependency style of gcc... gcc3 checking for xml2-config... /usr/bin/xml2-config checking for libxml - version >= 2.0.0... yes (version 2.7.1) checking for cp... /bin/cp checking for cat... /bin/cat checking for diff... /usr/bin/diff checking for gdb... /usr/bin/gdb checking for gunzip... /usr/bin/gunzip checking for ispell... /usr/bin/ispell checking for pdftotext... /usr/bin/pdftotext checking for zip... /usr/bin/zip checking for main in -lpcre... yes checking for main in -ldb... yes checking for main in -lrt... yes checking for main in -lssl... yes checking for main in -lmagic... yes checking for main in -ltokyocabinet... yes checking for main in -lcurl... yes checking for main in -lwv2... yes checking for main in -lUnitTest++... no checking for main in -lunittest++... no configure: creating ./config.status config.status: creating Makefile.common config.status: creating Makefile config.status: creating Doxyfile config.status: creating Doxygen.h config.status: creating db_updates/Makefile config.status: creating debian/Makefile config.status: creating mkdep/Makefile config.status: creating pdftoxml/Makefile config.status: creating programs/Makefile config.status: creating rexa-pstotext/Makefile config.status: creating share/Makefile config.status: creating share/doc/Makefile config.status: creating share/doc/libiViaCore/Makefile config.status: creating share/language_models/Makefile config.status: creating share/man/Makefile config.status: creating share/man/man1/Makefile config.status: creating share/man/man5/Makefile config.status: creating share/names/Makefile config.status: creating tests/Makefile config.status: creating tests/unittests/Makefile config.status: creating utils/Makefile config.status: executing depfiles commands sussy:/home/ivia/libiViaCore-6.0.1 # make make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' sussy:/home/ivia/libiViaCore-6.0.1 # make install make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' Installing headers... cd install-scripts && ./update-config-files ./update-config-files: Creating custom '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/noise_words' ./update-config-files: skipping '/home/ivia/.iViaCore/noise_words' Installing library... #@/usr/bin/install -c -m600 lib/libiViaCore.a /home/ivia/libiViaCore-installed/lib make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/mkdep' Installing iViaCore-mkdep ... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/mkdep' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' Installing rexa-pstotext... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/share' Installing... make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc' Installing documentation... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' ... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/language_models' Installing language models... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/language_models' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man' Installing man pages... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' Installing man1... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' Installing man5... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/names' Installing common name data... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/names' make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/utils' Installing utils... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/utils' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/db_updates' ./update_database.sh iViaCore-exec-sql: Error: error: iViaCore-exec-sql: DbConnection::connect: PQsetdbLogin() failed: fe_sendauth: no password supplied (host: localhost, port: 5432, username: ivia, database: iVia)! StackTrace::getNonGdbBacktrace()+0x3b Exception::Exception(std::string const&)+0xd0 DbConnection::connect(std::string const&, unsigned short, std::string const&, std::string const&)+0x261 DbConnection::DbConnection(std::string const&, unsigned short, std::string const&, std::string const&)+0x94 iViaCore-exec-sql(main+0x163) [0x804a8f3] libc.so.6(__libc_start_main+0xe5) [0x40a45705] iViaCore-exec-sql [0x8049871] in sql statement 0) Error: Unable to fetch database version from database. Server down? make[1]: *** [install] Error 1 make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/db_updates' make: *** [install] Error 2 sussy:/home/ivia/libiViaCore-6.0.1 # ===== But the PostgreSQL is OK, look: " sussy:/home/ivia/libiViaCore-6.0.1 # rcpostgresql status Checking for PostgreSQL: running sussy:/home/ivia/libiViaCore-6.0.1 # ". Here is my 'iVia.conf': " sussy:/home/ivia/libiViaCore-6.0.1/etc # cat iVia.conf [DbAuth] database_name = "iVia" host_name = "localhost" port = POSTGRESQL_PORT user_name = "postgres" password = "<<mypassword>>" sussy:/home/ivia/libiViaCore-6.0.1/etc # ". Sigh.... when I use the '/home/ivia/libiViaCore-6.0.1/install-scripts/root-install' than I'm stucked on this error: " sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # ./root-install === ./root-install: Checking needed packages... === ... ... ... ./update_database.sh Database revision number before updates: 06000003 Applying database update: 06000004.sql Query: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' iViaCore-exec-sql: Error: error: iViaCore-exec-sql: in DbConnection::execSql: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, conte...: FEHLER: keine Berechtigung f�r Sprache plpythonu (my translation: no access right to plpythonu). StackTrace::getNonGdbBacktrace()+0x3b Exception::Exception(std::string const&)+0xd0 DbConnection::execSql(std::string const&)+0x1c2 iViaCore-exec-sql(main+0x28f) [0x804aa1f] libc.so.6(__libc_start_main+0xe5) [0x40a45705] iViaCore-exec-sql [0x8049871] in sql statement 0) CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' make[1]: *** [install] Error 1 make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/db_updates' make: *** [install] Error 2 *** ./build-libiViaCore: Error in building your libiViaCore installation! *** ./root-install: Error in building your libiViaCore installation! ". Thank you very much in advance. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, 30 Sep 2009 16:35:42 +0200 Philipp Thomas <pth@suse.de> wrote:
Dear Philipp, what do you think about the output of this my try: /home/ivia/libiViaCore-6.0.1/install-scripts === ./root-install: Granting user access to all tables in the PostgreSQL databases === === ./root-install: Installing libiViaCore === === ./build-libiViaCore: Running build-libiViaCore... === === ./build-libiViaCore: Creating or updating ~/.pgpass... === We just updated (if it preexisted) or created ~/.pgpass. Please note that if you had a peexisting .pgpass file this may or may not have lead to a conflict. In particular if you have modified the PostgreSQL authentication in /etc/... our .pgpass may or may not work and you may have to manually modify it. Some documentation concerning .pgpass can be found at http://www.postgresql.org/docs/current/static/libpq-pgpass.html If you have no idea what we are talking about you are most likely fine and can ignore this information. <enter> === ./build-libiViaCore: Switching to libiViaCore directory... === === ./build-libiViaCore: Creating soft links required by autoconf... === === ./build-libiViaCore: Running aclocal... === /usr/share/aclocal/dotconf.m4:5: warning: underquoted definition of AM_PATH_DOTCONF /usr/share/aclocal/dotconf.m4:5: run info '(automake)Extending aclocal' /usr/share/aclocal/dotconf.m4:5: or see http://sources.redhat.com/automake/automake.html#Extending-aclocal === ./build-libiViaCore: Running autoconf... === === ./build-libiViaCore: Running configure... === checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... /bin/mkdir -p checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for uname... /bin/uname checking machine architecture... i686 checking for g++... g++ checking for C++ compiler default output file name... a.out checking whether the C++ compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking for style of include used by make... GNU checking dependency style of g++... gcc3 checking for a BSD-compatible install... /usr/bin/install -c checking for ranlib... ranlib checking whether ln -s works... yes checking for gcc... gcc checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking dependency style of gcc... gcc3 checking for xml2-config... /usr/bin/xml2-config checking for libxml - version >= 2.0.0... yes (version 2.7.1) checking for cp... /bin/cp checking for cat... /bin/cat checking for diff... /usr/bin/diff checking for gdb... /usr/bin/gdb checking for gunzip... /usr/bin/gunzip checking for ispell... /usr/bin/ispell checking for pdftotext... /usr/bin/pdftotext checking for zip... /usr/bin/zip checking for main in -lpcre... yes checking for main in -ldb... yes checking for main in -lrt... yes checking for main in -lssl... yes checking for main in -lmagic... yes checking for main in -ltokyocabinet... yes checking for main in -lcurl... yes checking for main in -lwv2... yes checking for main in -lUnitTest++... no checking for main in -lunittest++... no configure: creating ./config.status config.status: creating Makefile.common config.status: creating Makefile config.status: creating Doxyfile config.status: creating Doxygen.h config.status: creating db_updates/Makefile config.status: creating debian/Makefile config.status: creating mkdep/Makefile config.status: creating pdftoxml/Makefile config.status: creating programs/Makefile config.status: creating rexa-pstotext/Makefile config.status: creating share/Makefile config.status: creating share/doc/Makefile config.status: creating share/doc/libiViaCore/Makefile config.status: creating share/language_models/Makefile config.status: creating share/man/Makefile config.status: creating share/man/man1/Makefile config.status: creating share/man/man5/Makefile config.status: creating share/names/Makefile config.status: creating tests/Makefile config.status: creating tests/unittests/Makefile config.status: creating utils/Makefile config.status: executing depfiles commands === ./build-libiViaCore: Done running configure... === === ./build-libiViaCore: Attempting to make libiViaCore === make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' === ./build-libiViaCore: Updating .iViaCore configuration files === ./update-config-files: Creating custom '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/noise_words' ./update-config-files: skipping '/home/ivia/.iViaCore/noise_words' /home/ivia/libiViaCore-6.0.1 === ./build-libiViaCore: Attempting to make install libiViaCore === make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' Installing headers... cd install-scripts && ./update-config-files ./update-config-files: Creating custom '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/noise_words' ./update-config-files: skipping '/home/ivia/.iViaCore/noise_words' Installing library... #@/usr/bin/install -c -m600 lib/libiViaCore.a /home/ivia/libiViaCore-installed/lib make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/mkdep' Installing iViaCore-mkdep ... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/mkdep' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' Installing rexa-pstotext... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/share' Installing... make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc' Installing documentation... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' ... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/language_models' Installing language models... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/language_models' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man' Installing man pages... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' Installing man1... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' Installing man5... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/names' Installing common name data... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/names' make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/utils' Installing utils... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/utils' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/db_updates' ./update_database.sh Database revision number before updates: 06000003 Applying database update: 06000004.sql Query: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' iViaCore-exec-sql: Error: error: iViaCore-exec-sql: in DbConnection::execSql: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, conte...: FEHLER: keine Berechtigung f�r Sprache plpythonu StackTrace::getNonGdbBacktrace()+0x3b Exception::Exception(std::string const&)+0xd0 DbConnection::execSql(std::string const&)+0x1c2 iViaCore-exec-sql(main+0x28f) [0x804aa1f] libc.so.6(__libc_start_main+0xe5) [0x40a45705] iViaCore-exec-sql [0x8049871] in sql statement 0) CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' make[1]: *** [install] Error 1 make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/db_updates' make: *** [install] Error 2 *** ./build-libiViaCore: Error in building your libiViaCore installation! *** ./root-install: Error in building your libiViaCore installation! sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # cls -bash: cls: command not found sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # clear sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # ./root-install === ./root-install: Checking needed packages... === which: no rug in (/usr/lib/mpi/gcc/openmpi/bin:/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/opt/cross/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/lib/qt3/bin) Loading repository data... Reading installed packages... 'make' is already installed. 'gcc-c++' is already installed. 'automake' is already installed. 'autoconf' is already installed. 'libxml2-devel' is already installed. 'pcre-devel' is already installed. 'libdb-4_5-devel' is already installed. 'libopenssl-devel' is already installed. 'postgresql' is already installed. 'postgresql-server' is already installed. 'postgresql-plpython' is already installed. 'postgresql-devel' is already installed. 'doxygen' is already installed. 'zip' is already installed. 'gdb' is already installed. 'file-devel' is already installed. 'libbz2-devel' is already installed. 'libcurl-devel' is already installed. 'xpdf' is already installed. 'wv2-devel' is already installed. Resolving package dependencies... Nothing to do. libtokyocabinet is also required, but the current SuSe distribution does not include it. You'll need to go to http://sourceforge.net/projects/tokyocabinet , get the source, and build it yourself, then continue the install. <enter> PostgreSQL on Suse is installed by default to use ident sameuser authorization. LibiViacore uses md5 password authorization and connects to the PostgreSQL server using a TCP connection to localhost on the port you specified at the beginning of the install. If this is not what you are currently using, you can modify it as root in the PostgreSQL configuration file pg_hba.conf, which is often found in /etc/postgresql or in /var/lib/pgsql/data . The end of this install will fail until this change is completed and the server restarted. <enter> === ./root-install: Generating ISO-8859-15 locale... === === ./root-install: Creating the PostgreSQL databases and a PostgreSQL user === Password: FEHLER: Rolle »ivia« existiert bereits Password: *** ./root-install: Error in building your libiViaCore installation! -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On September 30, 2009, Ricky Tompu Breaky wrote:
Mien Deutch isn't very gut, but I think this is saying that there is a problem with the user ivia in your postgres database.
This is also in the logs you posted, saying that the login for the user ivai failed. Have you created a user ivia? Can you log in with it to the database? -- Collector of vintage computers http://www.ncf.ca/~ba600 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Thank you very much, Mike. It's solved. On Wed, 30 Sep 2009 16:52:42 -0400 Mike <kenziem@sympatico.ca> wrote:
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, 30 Sep 2009 16:52:42 -0400 Mike <kenziem@sympatico.ca> wrote:
=== Upppss... Sorry Mike... I am so tired and exhausted....and that makes me so careless replying the wrong email... No, Mike... it's not been solved.... Give me time to sleep and after that I reset my postgres get all empty again like newly installed and try to install the ivia again and report it again in this mail-list. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
* Ricky Tompu Breaky (ricky.breaky@uni.de) [20090930 02:08]:
As my crystal ball is currently out of order, please describe in more detail the steps you have already taken. Oherwise it's kind of hard to help you. Philipp -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, 30 Sep 2009 16:35:42 +0200 Philipp Thomas <pth@suse.de> wrote:
Dear Philips. Firstly, thank you very much for your generousity. I've downloaded the 'libiViaCore-6.0.1 ==== sussy:/home/ivia/libiViaCore-6.0.1 # ./configure --prefix=/home/ivia/libiViaCore-installed checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... /bin/mkdir -p checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for uname... /bin/uname checking machine architecture... i686 checking for g++... g++ checking for C++ compiler default output file name... a.out checking whether the C++ compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking for style of include used by make... GNU checking dependency style of g++... gcc3 checking for a BSD-compatible install... /usr/bin/install -c checking for ranlib... ranlib checking whether ln -s works... yes checking for gcc... gcc checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking dependency style of gcc... gcc3 checking for xml2-config... /usr/bin/xml2-config checking for libxml - version >= 2.0.0... yes (version 2.7.1) checking for cp... /bin/cp checking for cat... /bin/cat checking for diff... /usr/bin/diff checking for gdb... /usr/bin/gdb checking for gunzip... /usr/bin/gunzip checking for ispell... /usr/bin/ispell checking for pdftotext... /usr/bin/pdftotext checking for zip... /usr/bin/zip checking for main in -lpcre... yes checking for main in -ldb... yes checking for main in -lrt... yes checking for main in -lssl... yes checking for main in -lmagic... yes checking for main in -ltokyocabinet... yes checking for main in -lcurl... yes checking for main in -lwv2... yes checking for main in -lUnitTest++... no checking for main in -lunittest++... no configure: creating ./config.status config.status: creating Makefile.common config.status: creating Makefile config.status: creating Doxyfile config.status: creating Doxygen.h config.status: creating db_updates/Makefile config.status: creating debian/Makefile config.status: creating mkdep/Makefile config.status: creating pdftoxml/Makefile config.status: creating programs/Makefile config.status: creating rexa-pstotext/Makefile config.status: creating share/Makefile config.status: creating share/doc/Makefile config.status: creating share/doc/libiViaCore/Makefile config.status: creating share/language_models/Makefile config.status: creating share/man/Makefile config.status: creating share/man/man1/Makefile config.status: creating share/man/man5/Makefile config.status: creating share/names/Makefile config.status: creating tests/Makefile config.status: creating tests/unittests/Makefile config.status: creating utils/Makefile config.status: executing depfiles commands sussy:/home/ivia/libiViaCore-6.0.1 # make make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' sussy:/home/ivia/libiViaCore-6.0.1 # make install make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' Installing headers... cd install-scripts && ./update-config-files ./update-config-files: Creating custom '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/noise_words' ./update-config-files: skipping '/home/ivia/.iViaCore/noise_words' Installing library... #@/usr/bin/install -c -m600 lib/libiViaCore.a /home/ivia/libiViaCore-installed/lib make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/mkdep' Installing iViaCore-mkdep ... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/mkdep' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' Installing rexa-pstotext... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/share' Installing... make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc' Installing documentation... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' ... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/language_models' Installing language models... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/language_models' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man' Installing man pages... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' Installing man1... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' Installing man5... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/names' Installing common name data... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/names' make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/utils' Installing utils... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/utils' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/db_updates' ./update_database.sh iViaCore-exec-sql: Error: error: iViaCore-exec-sql: DbConnection::connect: PQsetdbLogin() failed: fe_sendauth: no password supplied (host: localhost, port: 5432, username: ivia, database: iVia)! StackTrace::getNonGdbBacktrace()+0x3b Exception::Exception(std::string const&)+0xd0 DbConnection::connect(std::string const&, unsigned short, std::string const&, std::string const&)+0x261 DbConnection::DbConnection(std::string const&, unsigned short, std::string const&, std::string const&)+0x94 iViaCore-exec-sql(main+0x163) [0x804a8f3] libc.so.6(__libc_start_main+0xe5) [0x40a45705] iViaCore-exec-sql [0x8049871] in sql statement 0) Error: Unable to fetch database version from database. Server down? make[1]: *** [install] Error 1 make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/db_updates' make: *** [install] Error 2 sussy:/home/ivia/libiViaCore-6.0.1 # ===== But the PostgreSQL is OK, look: " sussy:/home/ivia/libiViaCore-6.0.1 # rcpostgresql status Checking for PostgreSQL: running sussy:/home/ivia/libiViaCore-6.0.1 # ". Here is my 'iVia.conf': " sussy:/home/ivia/libiViaCore-6.0.1/etc # cat iVia.conf [DbAuth] database_name = "iVia" host_name = "localhost" port = POSTGRESQL_PORT user_name = "postgres" password = "<<mypassword>>" sussy:/home/ivia/libiViaCore-6.0.1/etc # ". Sigh.... when I use the '/home/ivia/libiViaCore-6.0.1/install-scripts/root-install' than I'm stucked on this error: " sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # ./root-install === ./root-install: Checking needed packages... === ... ... ... ./update_database.sh Database revision number before updates: 06000003 Applying database update: 06000004.sql Query: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' iViaCore-exec-sql: Error: error: iViaCore-exec-sql: in DbConnection::execSql: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, conte...: FEHLER: keine Berechtigung f�r Sprache plpythonu (my translation: no access right to plpythonu). StackTrace::getNonGdbBacktrace()+0x3b Exception::Exception(std::string const&)+0xd0 DbConnection::execSql(std::string const&)+0x1c2 iViaCore-exec-sql(main+0x28f) [0x804aa1f] libc.so.6(__libc_start_main+0xe5) [0x40a45705] iViaCore-exec-sql [0x8049871] in sql statement 0) CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' make[1]: *** [install] Error 1 make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/db_updates' make: *** [install] Error 2 *** ./build-libiViaCore: Error in building your libiViaCore installation! *** ./root-install: Error in building your libiViaCore installation! ". Thank you very much in advance. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, 30 Sep 2009 16:35:42 +0200 Philipp Thomas <pth@suse.de> wrote:
Dear Philipp, what do you think about the output of this my try: /home/ivia/libiViaCore-6.0.1/install-scripts === ./root-install: Granting user access to all tables in the PostgreSQL databases === === ./root-install: Installing libiViaCore === === ./build-libiViaCore: Running build-libiViaCore... === === ./build-libiViaCore: Creating or updating ~/.pgpass... === We just updated (if it preexisted) or created ~/.pgpass. Please note that if you had a peexisting .pgpass file this may or may not have lead to a conflict. In particular if you have modified the PostgreSQL authentication in /etc/... our .pgpass may or may not work and you may have to manually modify it. Some documentation concerning .pgpass can be found at http://www.postgresql.org/docs/current/static/libpq-pgpass.html If you have no idea what we are talking about you are most likely fine and can ignore this information. <enter> === ./build-libiViaCore: Switching to libiViaCore directory... === === ./build-libiViaCore: Creating soft links required by autoconf... === === ./build-libiViaCore: Running aclocal... === /usr/share/aclocal/dotconf.m4:5: warning: underquoted definition of AM_PATH_DOTCONF /usr/share/aclocal/dotconf.m4:5: run info '(automake)Extending aclocal' /usr/share/aclocal/dotconf.m4:5: or see http://sources.redhat.com/automake/automake.html#Extending-aclocal === ./build-libiViaCore: Running autoconf... === === ./build-libiViaCore: Running configure... === checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... /bin/mkdir -p checking for gawk... gawk checking whether make sets $(MAKE)... yes checking for uname... /bin/uname checking machine architecture... i686 checking for g++... g++ checking for C++ compiler default output file name... a.out checking whether the C++ compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking for style of include used by make... GNU checking dependency style of g++... gcc3 checking for a BSD-compatible install... /usr/bin/install -c checking for ranlib... ranlib checking whether ln -s works... yes checking for gcc... gcc checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking dependency style of gcc... gcc3 checking for xml2-config... /usr/bin/xml2-config checking for libxml - version >= 2.0.0... yes (version 2.7.1) checking for cp... /bin/cp checking for cat... /bin/cat checking for diff... /usr/bin/diff checking for gdb... /usr/bin/gdb checking for gunzip... /usr/bin/gunzip checking for ispell... /usr/bin/ispell checking for pdftotext... /usr/bin/pdftotext checking for zip... /usr/bin/zip checking for main in -lpcre... yes checking for main in -ldb... yes checking for main in -lrt... yes checking for main in -lssl... yes checking for main in -lmagic... yes checking for main in -ltokyocabinet... yes checking for main in -lcurl... yes checking for main in -lwv2... yes checking for main in -lUnitTest++... no checking for main in -lunittest++... no configure: creating ./config.status config.status: creating Makefile.common config.status: creating Makefile config.status: creating Doxyfile config.status: creating Doxygen.h config.status: creating db_updates/Makefile config.status: creating debian/Makefile config.status: creating mkdep/Makefile config.status: creating pdftoxml/Makefile config.status: creating programs/Makefile config.status: creating rexa-pstotext/Makefile config.status: creating share/Makefile config.status: creating share/doc/Makefile config.status: creating share/doc/libiViaCore/Makefile config.status: creating share/language_models/Makefile config.status: creating share/man/Makefile config.status: creating share/man/man1/Makefile config.status: creating share/man/man5/Makefile config.status: creating share/names/Makefile config.status: creating tests/Makefile config.status: creating tests/unittests/Makefile config.status: creating utils/Makefile config.status: executing depfiles commands === ./build-libiViaCore: Done running configure... === === ./build-libiViaCore: Attempting to make libiViaCore === make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' === ./build-libiViaCore: Updating .iViaCore configuration files === ./update-config-files: Creating custom '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/noise_words' ./update-config-files: skipping '/home/ivia/.iViaCore/noise_words' /home/ivia/libiViaCore-6.0.1 === ./build-libiViaCore: Attempting to make install libiViaCore === make -C programs all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make -C rexa-pstotext all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make -C tests all make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/tests' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/tests' Installing headers... cd install-scripts && ./update-config-files ./update-config-files: Creating custom '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/BannedUrlRegExps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/Blacklister.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/CachedPageFetcher.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlBlacklist.txt' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlGetSite.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/UrlMaps.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/corpora.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: skipping '/home/ivia/.iViaCore/iVia.conf' ./update-config-files: Creating custom '/home/ivia/.iViaCore/noise_words' ./update-config-files: skipping '/home/ivia/.iViaCore/noise_words' Installing library... #@/usr/bin/install -c -m600 lib/libiViaCore.a /home/ivia/libiViaCore-installed/lib make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/mkdep' Installing iViaCore-mkdep ... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/mkdep' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/pdftoxml' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/programs' Installing programs... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/programs' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' Installing rexa-pstotext... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/rexa-pstotext' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/share' Installing... make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc' Installing documentation... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' ... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc/libiViaCore' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/doc' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/language_models' Installing language models... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/language_models' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man' Installing man pages... make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' Installing man1... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man1' make[3]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' Installing man5... make[3]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man/man5' make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/man' make[2]: Entering directory `/home/ivia/libiViaCore-6.0.1/share/names' Installing common name data... make[2]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share/names' make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/share' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/utils' Installing utils... make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/utils' make[1]: Entering directory `/home/ivia/libiViaCore-6.0.1/db_updates' ./update_database.sh Database revision number before updates: 06000003 Applying database update: 06000004.sql Query: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' iViaCore-exec-sql: Error: error: iViaCore-exec-sql: in DbConnection::execSql: CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, conte...: FEHLER: keine Berechtigung f�r Sprache plpythonu StackTrace::getNonGdbBacktrace()+0x3b Exception::Exception(std::string const&)+0xd0 DbConnection::execSql(std::string const&)+0x1c2 iViaCore-exec-sql(main+0x28f) [0x804aa1f] libc.so.6(__libc_start_main+0xe5) [0x40a45705] iViaCore-exec-sql [0x8049871] in sql statement 0) CREATE OR REPLACE FUNCTION insert_robots_entry(canonical_name varchar(255), expires TIMESTAMP, contents TEXT) returns bool as $$ retval = plpy.execute("SELECT robots_id FROM robots_dot_txts WHERE canonical_hostname = '%s'"%(canonical_name)) insert_robots_stmt = "INSERT INTO robots_dot_txts (canonical_hostname, expiration, contents) VALUES ('%s','%s','%s') RETURNING robots_id" update_robots_stmt = "UPDATE robots_dot_txts SET canonical_hostname='%s', expiration='%s', contents='%s' WHERE robots_id = %d " insert_alias_stmt = "INSERT INTO aliases_and_canonical_hostnames VALUES ('%s', %d)" plpy.execute("BEGIN WORK") if (retval.nrows() == 0) : results=plpy.execute(insert_robots_stmt%(canonical_name,expires,contents)) plpy.execute(insert_alias_stmt%(canonical_name, results[0]['robots_id'])) else : plpy.execute(update_robots_stmt%(canonical_name, expires, contents, retval[0]['robots_id'])) plpy.execute("COMMIT") return retval.nrows() != 0 $$ LANGUAGE 'plpythonu' make[1]: *** [install] Error 1 make[1]: Leaving directory `/home/ivia/libiViaCore-6.0.1/db_updates' make: *** [install] Error 2 *** ./build-libiViaCore: Error in building your libiViaCore installation! *** ./root-install: Error in building your libiViaCore installation! sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # cls -bash: cls: command not found sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # clear sussy:/home/ivia/libiViaCore-6.0.1/install-scripts # ./root-install === ./root-install: Checking needed packages... === which: no rug in (/usr/lib/mpi/gcc/openmpi/bin:/sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/opt/kde3/bin:/opt/cross/bin:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/lib/qt3/bin) Loading repository data... Reading installed packages... 'make' is already installed. 'gcc-c++' is already installed. 'automake' is already installed. 'autoconf' is already installed. 'libxml2-devel' is already installed. 'pcre-devel' is already installed. 'libdb-4_5-devel' is already installed. 'libopenssl-devel' is already installed. 'postgresql' is already installed. 'postgresql-server' is already installed. 'postgresql-plpython' is already installed. 'postgresql-devel' is already installed. 'doxygen' is already installed. 'zip' is already installed. 'gdb' is already installed. 'file-devel' is already installed. 'libbz2-devel' is already installed. 'libcurl-devel' is already installed. 'xpdf' is already installed. 'wv2-devel' is already installed. Resolving package dependencies... Nothing to do. libtokyocabinet is also required, but the current SuSe distribution does not include it. You'll need to go to http://sourceforge.net/projects/tokyocabinet , get the source, and build it yourself, then continue the install. <enter> PostgreSQL on Suse is installed by default to use ident sameuser authorization. LibiViacore uses md5 password authorization and connects to the PostgreSQL server using a TCP connection to localhost on the port you specified at the beginning of the install. If this is not what you are currently using, you can modify it as root in the PostgreSQL configuration file pg_hba.conf, which is often found in /etc/postgresql or in /var/lib/pgsql/data . The end of this install will fail until this change is completed and the server restarted. <enter> === ./root-install: Generating ISO-8859-15 locale... === === ./root-install: Creating the PostgreSQL databases and a PostgreSQL user === Password: FEHLER: Rolle »ivia« existiert bereits Password: *** ./root-install: Error in building your libiViaCore installation! -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On September 30, 2009, Ricky Tompu Breaky wrote:
Mien Deutch isn't very gut, but I think this is saying that there is a problem with the user ivia in your postgres database.
This is also in the logs you posted, saying that the login for the user ivai failed. Have you created a user ivia? Can you log in with it to the database? -- Collector of vintage computers http://www.ncf.ca/~ba600 -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Thank you very much, Mike. It's solved. On Wed, 30 Sep 2009 16:52:42 -0400 Mike <kenziem@sympatico.ca> wrote:
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, 30 Sep 2009 16:52:42 -0400 Mike <kenziem@sympatico.ca> wrote:
=== Upppss... Sorry Mike... I am so tired and exhausted....and that makes me so careless replying the wrong email... No, Mike... it's not been solved.... Give me time to sleep and after that I reset my postgres get all empty again like newly installed and try to install the ivia again and report it again in this mail-list. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (3)
-
Mike -
Philipp Thomas -
Ricky Tompu Breaky