refdb-devel Mailing List for RefDB (Page 9)
Status: Beta
Brought to you by:
mhoenicka
Menu
▾
▴
refdb-devel — List for RefDB developers
You can subscribe to this list here.
| 2001 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(14) |
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
(8) |
May
(1) |
Jun
(1) |
Jul
(1) |
Aug
(2) |
Sep
(1) |
Oct
|
Nov
|
Dec
(1) |
| 2003 |
Jan
|
Feb
(1) |
Mar
(5) |
Apr
(6) |
May
(6) |
Jun
(4) |
Jul
(11) |
Aug
|
Sep
(3) |
Oct
|
Nov
|
Dec
(174) |
| 2004 |
Jan
(10) |
Feb
(2) |
Mar
|
Apr
|
May
(2) |
Jun
(2) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2005 |
Jan
(2) |
Feb
(6) |
Mar
(11) |
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
(25) |
Oct
(18) |
Nov
(16) |
Dec
(19) |
| 2006 |
Jan
(6) |
Feb
|
Mar
|
Apr
(21) |
May
(9) |
Jun
(5) |
Jul
(51) |
Aug
(89) |
Sep
(42) |
Oct
(19) |
Nov
(47) |
Dec
(4) |
| 2007 |
Jan
(8) |
Feb
(1) |
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
(4) |
Aug
(4) |
Sep
(5) |
Oct
|
Nov
(7) |
Dec
(4) |
| 2008 |
Jan
|
Feb
|
Mar
|
Apr
(14) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(2) |
| 2009 |
Jan
|
Feb
(21) |
Mar
(8) |
Apr
(5) |
May
(6) |
Jun
(2) |
Jul
(5) |
Aug
|
Sep
(3) |
Oct
(14) |
Nov
|
Dec
|
| 2010 |
Jan
(18) |
Feb
(5) |
Mar
|
Apr
|
May
(4) |
Jun
(3) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(4) |
Oct
|
Nov
|
Dec
|
| 2012 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(9) |
Nov
|
Dec
|
|
From: SourceForge.net <no...@so...> - 2006-11-09 22:13:52
|
Bugs item #1593786, was opened at 2006-11-09 23:13 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593786&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Compilation fails on refdb-init-pgsql Initial Comment: Sorry to bother you again, but : sed 's%/var/log%/var/log%' < ./refdb-init.in | \ sed 's%/var/run%/var/run%' | \ sed 's%<pkgdatadir>%/usr/share/refdb%' | \ sed 's%<db_path>%/var/lib/lib/refdb/db%' | \ sed 's%<main_db>%refdb%g' | \ sed 's%<myshell>%/bin/bash%' | \ sed 's%<psarg>%ax%' | \ sed 's%<prefix>%/usr%' | \ sed 's%<sysconfdir>%/etc/refdb%g' | \ sed 's%<piddir>%/var/run%' > refdb-init make[1]: *** No rule to make target `refdb-init-pgsql', needed by `all-am'. Stop. make[1]: *** Waiting for unfinished jobs.... chmod a+x refdbctl chmod a+x refdb-init make[1]: Leaving directory `/home/steletch/rpm/BUILD/refdb-0.9.8-pre7/scripts' make: *** [all-recursive] Error 1 Seems we're going to another pre :-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593786&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 21:09:07
|
Bugs item #1584361, was opened at 2006-10-25 13:51 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584361&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: refdb-init searches for the wrong dump file Initial Comment: I tried to install refdb agin (for testing :-) but it failed at the refdb-init script step. The error message is: "refdb.dump.mysql is not readable or missing" This error comes from the script which tries to read the file "/usr/local/share/refdb/sql/refdb.dump.mysql" instead of the correct "/usr/local/share/refdb/sql/refdb.2.dump.mysql" Please note the '2' between "refdb" and "dump". I'm assuming this is a temporary problem, but just to be sure the situation get fixed before final. Moreover, this is not mysql-specific since it is the same for all refdb plugins: refdb.2.dump.mysql refdb.2.dump.mysql41 refdb.2.dump.pgsql refdb.2.dump.sqlite Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 22:09 Message: Logged In: YES user_id=85809 fixed in svn, see also refdb-0.9.8-pre7. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:04 Message: Logged In: YES user_id=85809 This is indeed a temporary problem, although it does not hurt at all to add it to the bug list to make sure I'll fix it. I have not yet updated refdb-init to make use of the new main database administration features that I've added to refdbd. refdb-init still creates the main database manually which is no longer required. Once that is changed, refdb-init will no longer need to access the dump files directly. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584361&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 16:08:44
|
Bugs item #1593394, was opened at 2006-11-09 14:00 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593394&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Changelog is empty in 0.9.8-pre6 Initial Comment: Small detail, but the file is empty ... ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 17:08 Message: Logged In: YES user_id=85809 My bad, I must have screwed up the svn2cl call somehow. I'll fix this in the next prerelease. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 14:14 Message: Logged In: YES user_id=85809 My bad, I must have screwed up the svn2cl call somehow. I'll fix this in the next prerelease. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593394&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 13:14:40
|
Bugs item #1593394, was opened at 2006-11-09 14:00 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593394&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Changelog is empty in 0.9.8-pre6 Initial Comment: Small detail, but the file is empty ... ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 14:14 Message: Logged In: YES user_id=85809 My bad, I must have screwed up the svn2cl call somehow. I'll fix this in the next prerelease. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593394&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 13:13:22
|
Bugs item #1593311, was opened at 2006-11-09 12:13 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Build problem with 0.9.8-pre6 Initial Comment: strfncs.c: In function 'min_token_length': strfncs.c:1296: error: 'SIZE_T_MAX' undeclared (first use in this function) strfncs.c:1296: error: (Each undeclared identifier is reported only once strfncs.c:1296: error: for each function it appears in.) ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 14:13 Message: Logged In: YES user_id=85809 Ok, I've checked in the fix (svn revision 218). I'll upload another prerelease tonight. And I'll make sure the Changelog isn't empty this time... ---------------------------------------------------------------------- Comment By: steletch (steletch) Date: 2006-11-09 14:01 Message: Logged In: YES user_id=1129476 Yep, solves the build problem, another pre soon ? ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 12:44 Message: Logged In: YES user_id=85809 Looks like another case of BSD vs. Linux oddities. Could you please add the following lines at the top of strfncs.c, somewhere close to the other #define statements, and try again? /* Max integer that can be stored in a size_t variable */ #ifndef SIZE_T_MAX #define SIZE_T_MAX UINT_MAX #endif /* !SIZE_T_MAX */ ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 13:01:29
|
Bugs item #1593311, was opened at 2006-11-09 12:13 Message generated for change (Comment added) made by steletch You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Build problem with 0.9.8-pre6 Initial Comment: strfncs.c: In function 'min_token_length': strfncs.c:1296: error: 'SIZE_T_MAX' undeclared (first use in this function) strfncs.c:1296: error: (Each undeclared identifier is reported only once strfncs.c:1296: error: for each function it appears in.) ---------------------------------------------------------------------- >Comment By: steletch (steletch) Date: 2006-11-09 14:01 Message: Logged In: YES user_id=1129476 Yep, solves the build problem, another pre soon ? ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 12:44 Message: Logged In: YES user_id=85809 Looks like another case of BSD vs. Linux oddities. Could you please add the following lines at the top of strfncs.c, somewhere close to the other #define statements, and try again? /* Max integer that can be stored in a size_t variable */ #ifndef SIZE_T_MAX #define SIZE_T_MAX UINT_MAX #endif /* !SIZE_T_MAX */ ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 13:00:59
|
Bugs item #1593394, was opened at 2006-11-09 14:00 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593394&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Changelog is empty in 0.9.8-pre6 Initial Comment: Small detail, but the file is empty ... ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593394&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 11:44:32
|
Bugs item #1593311, was opened at 2006-11-09 12:13 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Build problem with 0.9.8-pre6 Initial Comment: strfncs.c: In function 'min_token_length': strfncs.c:1296: error: 'SIZE_T_MAX' undeclared (first use in this function) strfncs.c:1296: error: (Each undeclared identifier is reported only once strfncs.c:1296: error: for each function it appears in.) ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-09 12:44 Message: Logged In: YES user_id=85809 Looks like another case of BSD vs. Linux oddities. Could you please add the following lines at the top of strfncs.c, somewhere close to the other #define statements, and try again? /* Max integer that can be stored in a size_t variable */ #ifndef SIZE_T_MAX #define SIZE_T_MAX UINT_MAX #endif /* !SIZE_T_MAX */ ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-09 11:13:34
|
Bugs item #1593311, was opened at 2006-11-09 12:13 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: Build problem with 0.9.8-pre6 Initial Comment: strfncs.c: In function 'min_token_length': strfncs.c:1296: error: 'SIZE_T_MAX' undeclared (first use in this function) strfncs.c:1296: error: (Each undeclared identifier is reported only once strfncs.c:1296: error: for each function it appears in.) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1593311&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-02 14:13:38
|
Feature Requests item #1548540, was opened at 2006-08-29 14:44 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385994&aid=1548540&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None >Status: Closed Priority: 5 Private: No Submitted By: Olivier Berger (olberger) Assigned to: Markus Hoenicka (mhoenicka) Summary: citestyle : insert citation key in bibliographic output Initial Comment: Following the discussion in : http://sourceforge.net/mailarchive/message.php?msg_id=36624076 , I'd like to see refdb use something in CITESTYLE to help insert the citation key of an entry anywhere in the bibliographic output, for instance in an <abbrev> docbook XML tag (as an alternative to REFNUMBER for numbered entries). Thanks in advance. ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-02 15:13 Message: Logged In: YES user_id=85809 This feature has been implemented in svn since revision 152 and can be tested using the prereleases 0.9.8-pre4 and later. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385994&aid=1548540&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-11-02 08:20:18
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-11-02 09:20 Message: Logged In: YES user_id=85809 There is a configure switch to set the main database name (--with-main-db=name), but this doesn't solve your problem entirely. As far as I understand you need to run RefDB using a single database, rather than with a main database and one or more reference databases. I have to admit that I have not anticipated any need for doing this. Unfortunately both the main database and the reference databases contain a table "t_meta" with identical columns. I'd have to make the main database meta table name configurable too to avoid the name clash. Even then some RefDB commands are likely to fail, e.g. the createdb command, as it will attempt to create a database that already exists, instead of just adding columns to it. You'd have to create the reference database tables from a SQL script (which RefDB provides) instead of using the createdb command. You'd also have to refrain from using the main database maintenance mode of refdbd as it would delete your reference data. I think I could provide (fragile) support for this feature in one of the next prereleases for further testing. Adding robust support may require more thorough changes which I could add at a later time. Would you mind submitting a feature request for this? After all, it's not a bug but rather a limitation of RefDB. ---------------------------------------------------------------------- Comment By: steletch (steletch) Date: 2006-10-31 18:18 Message: Logged In: YES user_id=1129476 Hum, that's bad.. I've checked on my ISP and i cannot (at least for now) change the database name. I've asked him why and if it could be at least aliased, but no answer yet. Could it be possible to get a parameter for specifying the database name (for customizing refdb to the one provided by my ISP). I'm ok for a personal hack if tests are needed ... And for the non existing message, i've no clue, but i've carefully checked and nothing happens on the server side. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-27 09:24 Message: Logged In: YES user_id=85809 > Note that on the remote host, the database name is *not* > refdb, and the password is *not* refdb. That pretty much explains why your setup can't work. Each RefDB installation requires exactly one main database called refdb to hold the styles and the journal name word list, and at least one reference database with a different name. The refdb database is not used by all client commands, but many require a connection to this database as well. This is especially true for the viewstat command. The command does not access any reference data, but it still needs a connection to the database engine to retrieve version numbers and such. Therefore viewstat causes refdbd to connect to the refdb database. If that is missing, you're screwed. So please make sure there is a main database called refdb, created from the appropriate dump file, and make sure the permissions allow you to connect to that database from your local computer. BTW I don't understand why the refdbd -s -e 0 -l 7 log says nothing. If you run the viewstat command, and get the "could not open main database" message on the client side, refdbd must have listed the connection parameters. You should see that it tries to connect to the refdb database, and you should also see the error message returned by the database engine. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-26 22:05 Message: Logged In: NO Unfortunately, nothing :-( For what it worths, the remote database name is not refdb but cm126109 I can connect to it with: mysql -h <remote host> -u <remote user> -p <remote password> -d <remote database>, and see all the tables i've already created (the database itself contains all tables you expect from a refdb database, *but its name is not refdb*) Here is what i've done: 1 - start refdbd using --- refdbd -V -s -e 0 -l 7 2 - start refdba using --- refdba -u <remote user> -w <remote password> -d <remote database> -i <remote host> In refdba, if i type set, i can see refdb is pointing to <remote host>, but when i type viewstat, i get: from refdba --- could not establish server connection from refdbd --- <nothing> ... Note that on the remote host, the database name is *not* refdb, and the password is *not* refdb. Anything else ? When i enter in refdba the command *set*, i see the correct <host> ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 15:04 Message: Logged In: YES user_id=85809 I would like to know what refdbd -l 7 says at the point where you run "viewstat". Does that give any clue? ---------------------------------------------------------------------- Comment By: steletch (steletch) Date: 2006-10-26 14:54 Message: Logged In: YES user_id=1129476 To be clear... I can connect to the external database with mysql -u -p, i've checked via phpmyadmin or the mysql command line that the database is created and correctly filled in 'as fas as i can redad from the dump). I lanched refdb with -l 7 I then launched refdba with -u -p -i as appropriate The result of the command 'viewstat' is: "could not open main database" I'll check again tonight in case i missed any step in this process. I'll let you know after the test. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 14:38 Message: Logged In: YES user_id=85809 > refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> The -u and -w switches are not required here, they are used only if you run refdbd to check or update the main database. If you run refdbd as an application server, the username and passwords are always provided by the clients. > ??? Nothin tells me i have it :-( Well, refdbd can't. As I said above, refdbd needs a client connection providing the username and password in order to even attempt to talk to a database engine. At this point, i.e. right after startup, refdbd does not know whether or not it can connect to the database engine. > refdba: viewstat > could not open main database You need to use the same username+password in refdba as you would in the mysql command line client. Can you indeed connect from your local box to the remote MySQL server with a command like this: mysql -u <username> -p refdb The permissions of the MySQL engine must allow the user in question to connect to the particular database from your local box. You may want to review the contents of the db, host, and user tables of the mysql database in order to check your permissions. To make sure your setup is ok you should also look at the -l 7 output of refdbd when you run the viewstat command. You'll see the connection parameters as they arrive at refdbd. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 23:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-31 17:18:30
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Comment added) made by steletch You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: steletch (steletch) Date: 2006-10-31 18:18 Message: Logged In: YES user_id=1129476 Hum, that's bad.. I've checked on my ISP and i cannot (at least for now) change the database name. I've asked him why and if it could be at least aliased, but no answer yet. Could it be possible to get a parameter for specifying the database name (for customizing refdb to the one provided by my ISP). I'm ok for a personal hack if tests are needed ... And for the non existing message, i've no clue, but i've carefully checked and nothing happens on the server side. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-27 09:24 Message: Logged In: YES user_id=85809 > Note that on the remote host, the database name is *not* > refdb, and the password is *not* refdb. That pretty much explains why your setup can't work. Each RefDB installation requires exactly one main database called refdb to hold the styles and the journal name word list, and at least one reference database with a different name. The refdb database is not used by all client commands, but many require a connection to this database as well. This is especially true for the viewstat command. The command does not access any reference data, but it still needs a connection to the database engine to retrieve version numbers and such. Therefore viewstat causes refdbd to connect to the refdb database. If that is missing, you're screwed. So please make sure there is a main database called refdb, created from the appropriate dump file, and make sure the permissions allow you to connect to that database from your local computer. BTW I don't understand why the refdbd -s -e 0 -l 7 log says nothing. If you run the viewstat command, and get the "could not open main database" message on the client side, refdbd must have listed the connection parameters. You should see that it tries to connect to the refdb database, and you should also see the error message returned by the database engine. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-26 22:05 Message: Logged In: NO Unfortunately, nothing :-( For what it worths, the remote database name is not refdb but cm126109 I can connect to it with: mysql -h <remote host> -u <remote user> -p <remote password> -d <remote database>, and see all the tables i've already created (the database itself contains all tables you expect from a refdb database, *but its name is not refdb*) Here is what i've done: 1 - start refdbd using --- refdbd -V -s -e 0 -l 7 2 - start refdba using --- refdba -u <remote user> -w <remote password> -d <remote database> -i <remote host> In refdba, if i type set, i can see refdb is pointing to <remote host>, but when i type viewstat, i get: from refdba --- could not establish server connection from refdbd --- <nothing> ... Note that on the remote host, the database name is *not* refdb, and the password is *not* refdb. Anything else ? When i enter in refdba the command *set*, i see the correct <host> ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 15:04 Message: Logged In: YES user_id=85809 I would like to know what refdbd -l 7 says at the point where you run "viewstat". Does that give any clue? ---------------------------------------------------------------------- Comment By: steletch (steletch) Date: 2006-10-26 14:54 Message: Logged In: YES user_id=1129476 To be clear... I can connect to the external database with mysql -u -p, i've checked via phpmyadmin or the mysql command line that the database is created and correctly filled in 'as fas as i can redad from the dump). I lanched refdb with -l 7 I then launched refdba with -u -p -i as appropriate The result of the command 'viewstat' is: "could not open main database" I'll check again tonight in case i missed any step in this process. I'll let you know after the test. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 14:38 Message: Logged In: YES user_id=85809 > refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> The -u and -w switches are not required here, they are used only if you run refdbd to check or update the main database. If you run refdbd as an application server, the username and passwords are always provided by the clients. > ??? Nothin tells me i have it :-( Well, refdbd can't. As I said above, refdbd needs a client connection providing the username and password in order to even attempt to talk to a database engine. At this point, i.e. right after startup, refdbd does not know whether or not it can connect to the database engine. > refdba: viewstat > could not open main database You need to use the same username+password in refdba as you would in the mysql command line client. Can you indeed connect from your local box to the remote MySQL server with a command like this: mysql -u <username> -p refdb The permissions of the MySQL engine must allow the user in question to connect to the particular database from your local box. You may want to review the contents of the db, host, and user tables of the mysql database in order to check your permissions. To make sure your setup is ok you should also look at the -l 7 output of refdbd when you run the viewstat command. You'll see the connection parameters as they arrive at refdbd. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 23:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-30 21:31:31
|
Bugs item #1587512, was opened at 2006-10-30 22:31 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1587512&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Markus Hoenicka (mhoenicka) Assigned to: Markus Hoenicka (mhoenicka) Summary: citestylex documentation is out of date Initial Comment: citestylex has gained a few tricks, e.g. the citation key citation format. Most of these new features are undocumented which makes it unnecessarily hard to use them :-( ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1587512&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-27 07:24:35
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-27 09:24 Message: Logged In: YES user_id=85809 > Note that on the remote host, the database name is *not* > refdb, and the password is *not* refdb. That pretty much explains why your setup can't work. Each RefDB installation requires exactly one main database called refdb to hold the styles and the journal name word list, and at least one reference database with a different name. The refdb database is not used by all client commands, but many require a connection to this database as well. This is especially true for the viewstat command. The command does not access any reference data, but it still needs a connection to the database engine to retrieve version numbers and such. Therefore viewstat causes refdbd to connect to the refdb database. If that is missing, you're screwed. So please make sure there is a main database called refdb, created from the appropriate dump file, and make sure the permissions allow you to connect to that database from your local computer. BTW I don't understand why the refdbd -s -e 0 -l 7 log says nothing. If you run the viewstat command, and get the "could not open main database" message on the client side, refdbd must have listed the connection parameters. You should see that it tries to connect to the refdb database, and you should also see the error message returned by the database engine. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-26 22:05 Message: Logged In: NO Unfortunately, nothing :-( For what it worths, the remote database name is not refdb but cm126109 I can connect to it with: mysql -h <remote host> -u <remote user> -p <remote password> -d <remote database>, and see all the tables i've already created (the database itself contains all tables you expect from a refdb database, *but its name is not refdb*) Here is what i've done: 1 - start refdbd using --- refdbd -V -s -e 0 -l 7 2 - start refdba using --- refdba -u <remote user> -w <remote password> -d <remote database> -i <remote host> In refdba, if i type set, i can see refdb is pointing to <remote host>, but when i type viewstat, i get: from refdba --- could not establish server connection from refdbd --- <nothing> ... Note that on the remote host, the database name is *not* refdb, and the password is *not* refdb. Anything else ? When i enter in refdba the command *set*, i see the correct <host> ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 15:04 Message: Logged In: YES user_id=85809 I would like to know what refdbd -l 7 says at the point where you run "viewstat". Does that give any clue? ---------------------------------------------------------------------- Comment By: steletch (steletch) Date: 2006-10-26 14:54 Message: Logged In: YES user_id=1129476 To be clear... I can connect to the external database with mysql -u -p, i've checked via phpmyadmin or the mysql command line that the database is created and correctly filled in 'as fas as i can redad from the dump). I lanched refdb with -l 7 I then launched refdba with -u -p -i as appropriate The result of the command 'viewstat' is: "could not open main database" I'll check again tonight in case i missed any step in this process. I'll let you know after the test. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 14:38 Message: Logged In: YES user_id=85809 > refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> The -u and -w switches are not required here, they are used only if you run refdbd to check or update the main database. If you run refdbd as an application server, the username and passwords are always provided by the clients. > ??? Nothin tells me i have it :-( Well, refdbd can't. As I said above, refdbd needs a client connection providing the username and password in order to even attempt to talk to a database engine. At this point, i.e. right after startup, refdbd does not know whether or not it can connect to the database engine. > refdba: viewstat > could not open main database You need to use the same username+password in refdba as you would in the mysql command line client. Can you indeed connect from your local box to the remote MySQL server with a command like this: mysql -u <username> -p refdb The permissions of the MySQL engine must allow the user in question to connect to the particular database from your local box. You may want to review the contents of the db, host, and user tables of the mysql database in order to check your permissions. To make sure your setup is ok you should also look at the -l 7 output of refdbd when you run the viewstat command. You'll see the connection parameters as they arrive at refdbd. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 23:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-26 20:05:15
|
Bugs item #1584375, was opened at 2006-10-25 05:06 Message generated for change (Comment added) made by nobody You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-26 13:05 Message: Logged In: NO Unfortunately, nothing :-( For what it worths, the remote database name is not refdb but cm126109 I can connect to it with: mysql -h <remote host> -u <remote user> -p <remote password> -d <remote database>, and see all the tables i've already created (the database itself contains all tables you expect from a refdb database, *but its name is not refdb*) Here is what i've done: 1 - start refdbd using --- refdbd -V -s -e 0 -l 7 2 - start refdba using --- refdba -u <remote user> -w <remote password> -d <remote database> -i <remote host> In refdba, if i type set, i can see refdb is pointing to <remote host>, but when i type viewstat, i get: from refdba --- could not establish server connection from refdbd --- <nothing> ... Note that on the remote host, the database name is *not* refdb, and the password is *not* refdb. Anything else ? When i enter in refdba the command *set*, i see the correct <host> ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 06:04 Message: Logged In: YES user_id=85809 I would like to know what refdbd -l 7 says at the point where you run "viewstat". Does that give any clue? ---------------------------------------------------------------------- Comment By: steletch (steletch) Date: 2006-10-26 05:54 Message: Logged In: YES user_id=1129476 To be clear... I can connect to the external database with mysql -u -p, i've checked via phpmyadmin or the mysql command line that the database is created and correctly filled in 'as fas as i can redad from the dump). I lanched refdb with -l 7 I then launched refdba with -u -p -i as appropriate The result of the command 'viewstat' is: "could not open main database" I'll check again tonight in case i missed any step in this process. I'll let you know after the test. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 05:38 Message: Logged In: YES user_id=85809 > refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> The -u and -w switches are not required here, they are used only if you run refdbd to check or update the main database. If you run refdbd as an application server, the username and passwords are always provided by the clients. > ??? Nothin tells me i have it :-( Well, refdbd can't. As I said above, refdbd needs a client connection providing the username and password in order to even attempt to talk to a database engine. At this point, i.e. right after startup, refdbd does not know whether or not it can connect to the database engine. > refdba: viewstat > could not open main database You need to use the same username+password in refdba as you would in the mysql command line client. Can you indeed connect from your local box to the remote MySQL server with a command like this: mysql -u <username> -p refdb The permissions of the MySQL engine must allow the user in question to connect to the particular database from your local box. You may want to review the contents of the db, host, and user tables of the mysql database in order to check your permissions. To make sure your setup is ok you should also look at the -l 7 output of refdbd when you run the viewstat command. You'll see the connection parameters as they arrive at refdbd. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 14:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 05:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-26 13:04:59
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 15:04 Message: Logged In: YES user_id=85809 I would like to know what refdbd -l 7 says at the point where you run "viewstat". Does that give any clue? ---------------------------------------------------------------------- Comment By: steletch (steletch) Date: 2006-10-26 14:54 Message: Logged In: YES user_id=1129476 To be clear... I can connect to the external database with mysql -u -p, i've checked via phpmyadmin or the mysql command line that the database is created and correctly filled in 'as fas as i can redad from the dump). I lanched refdb with -l 7 I then launched refdba with -u -p -i as appropriate The result of the command 'viewstat' is: "could not open main database" I'll check again tonight in case i missed any step in this process. I'll let you know after the test. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 14:38 Message: Logged In: YES user_id=85809 > refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> The -u and -w switches are not required here, they are used only if you run refdbd to check or update the main database. If you run refdbd as an application server, the username and passwords are always provided by the clients. > ??? Nothin tells me i have it :-( Well, refdbd can't. As I said above, refdbd needs a client connection providing the username and password in order to even attempt to talk to a database engine. At this point, i.e. right after startup, refdbd does not know whether or not it can connect to the database engine. > refdba: viewstat > could not open main database You need to use the same username+password in refdba as you would in the mysql command line client. Can you indeed connect from your local box to the remote MySQL server with a command like this: mysql -u <username> -p refdb The permissions of the MySQL engine must allow the user in question to connect to the particular database from your local box. You may want to review the contents of the db, host, and user tables of the mysql database in order to check your permissions. To make sure your setup is ok you should also look at the -l 7 output of refdbd when you run the viewstat command. You'll see the connection parameters as they arrive at refdbd. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 23:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-26 12:54:57
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Comment added) made by steletch You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: steletch (steletch) Date: 2006-10-26 14:54 Message: Logged In: YES user_id=1129476 To be clear... I can connect to the external database with mysql -u -p, i've checked via phpmyadmin or the mysql command line that the database is created and correctly filled in 'as fas as i can redad from the dump). I lanched refdb with -l 7 I then launched refdba with -u -p -i as appropriate The result of the command 'viewstat' is: "could not open main database" I'll check again tonight in case i missed any step in this process. I'll let you know after the test. ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 14:38 Message: Logged In: YES user_id=85809 > refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> The -u and -w switches are not required here, they are used only if you run refdbd to check or update the main database. If you run refdbd as an application server, the username and passwords are always provided by the clients. > ??? Nothin tells me i have it :-( Well, refdbd can't. As I said above, refdbd needs a client connection providing the username and password in order to even attempt to talk to a database engine. At this point, i.e. right after startup, refdbd does not know whether or not it can connect to the database engine. > refdba: viewstat > could not open main database You need to use the same username+password in refdba as you would in the mysql command line client. Can you indeed connect from your local box to the remote MySQL server with a command like this: mysql -u <username> -p refdb The permissions of the MySQL engine must allow the user in question to connect to the particular database from your local box. You may want to review the contents of the db, host, and user tables of the mysql database in order to check your permissions. To make sure your setup is ok you should also look at the -l 7 output of refdbd when you run the viewstat command. You'll see the connection parameters as they arrive at refdbd. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 23:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-26 12:38:28
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-26 14:38 Message: Logged In: YES user_id=85809 > refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> The -u and -w switches are not required here, they are used only if you run refdbd to check or update the main database. If you run refdbd as an application server, the username and passwords are always provided by the clients. > ??? Nothin tells me i have it :-( Well, refdbd can't. As I said above, refdbd needs a client connection providing the username and password in order to even attempt to talk to a database engine. At this point, i.e. right after startup, refdbd does not know whether or not it can connect to the database engine. > refdba: viewstat > could not open main database You need to use the same username+password in refdba as you would in the mysql command line client. Can you indeed connect from your local box to the remote MySQL server with a command like this: mysql -u <username> -p refdb The permissions of the MySQL engine must allow the user in question to connect to the particular database from your local box. You may want to review the contents of the db, host, and user tables of the mysql database in order to check your permissions. To make sure your setup is ok you should also look at the -l 7 output of refdbd when you run the viewstat command. You'll see the connection parameters as they arrive at refdbd. ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 23:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-25 21:53:17
|
Bugs item #1584375, was opened at 2006-10-25 05:06 Message generated for change (Comment added) made by nobody You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2006-10-25 14:53 Message: Logged In: NO Well, i tried to follow your recommendations, but i'm pretty missing something... I tried to do: refdbd -i <database server ip> -b <database port> -V -u <database admin> -w <database admin password> -s -e 0 -l 7 -d <database name> And i get : dbi_driver_dir went to: dbi is up using default driver dir Available libdbi database drivers: mysql Requested libdbi driver found Database directory: /var/lib/refdb/db application server started share extended notes by default use cm126109 as default database use /tmp/refdbd_fifo9900 as fifo server waiting n_max_fd=4 ??? Nothin tells me i have it :-( When i do: refdba Please enter your password: refdba: set serverip 127.0.0.1 port 9734 verbose f pager stdout username stephane timeout 180 logfile /var/log/refdba.log logdest 2 loglevel 6 refdblib (i tried also by setting a username + password) refdba: viewstat could not open main database So refdbd has not connected correclyt :-( I've set up the database manually on the remote computer (using the import mysql function for the appropriate mysql41+ dump). I can see via phpmyadmin the database 's structure is there, and from my local computer, i can connect to the remote computer. Anything i'm missing ? Cheers, Stéphane ---------------------------------------------------------------------- Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 05:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-25 12:23:52
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open >Resolution: Works For Me Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:23 Message: Logged In: YES user_id=85809 I'm sure that this is just a configuration problem as it was one of the design goals to be able to separate the clients, the application server, and the database engine physically if you have any reasons to do so. refdbd (or rather the libdbi driver it uses) basically acts as the database engine client. In order to access the database engine on a different machine, you need to tweak two refdbd settings: - set the IP address of the box that runs your database engine. Either set "serverip" in the refdbdrc config file, or use the -i command line switch. Use the IP address or the hostname if it can be resolved properly - set the port where the database engine listens. Set "dbsport" in refdbcrc, or use the -b command line switch (*NOT* the more appealing -p switch which defines which port refdbd listens on for client connections) This should be all it takes on the RefDB side. Of course you need to configure your database engine appropriately. E.g. both MySQL and PostgreSQL listen to local connections only by default for security reasons. You'll have to flip a switch to make them serve external connections. Also, both engines support host-based authentication. That is, you need to set the database permissions properly to allow connections from refdbd. It may be slightly confusing that the host in question is the box where refdbd runs, not where the client runs (because refdbd acts as the database engine client, as mentioned before). ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-25 12:07:03
|
Bugs item #1584375, was opened at 2006-10-25 14:06 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: refdbd Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Markus Hoenicka (mhoenicka) Summary: External database link not possible Initial Comment: Unless i have not read correctly the manual, i think it is not possible to have a separate refdb server and a database server (be it mysql or postgresql). It would be nice to be able to separate it since having a separate database server would be nice (i.e. the external database server can be on the internet and refdbd on another machine). In fact, most providers allow database functinalities but do not permit software installation (refdb). If i'm wrong, please tell me where i could correct it please. Cheers, Stéphane ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584375&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-25 12:04:13
|
Bugs item #1584361, was opened at 2006-10-25 13:51 Message generated for change (Comment added) made by mhoenicka You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584361&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open >Resolution: Later Priority: 5 Private: No Submitted By: steletch (steletch) >Assigned to: Markus Hoenicka (mhoenicka) Summary: refdb-init searches for the wrong dump file Initial Comment: I tried to install refdb agin (for testing :-) but it failed at the refdb-init script step. The error message is: "refdb.dump.mysql is not readable or missing" This error comes from the script which tries to read the file "/usr/local/share/refdb/sql/refdb.dump.mysql" instead of the correct "/usr/local/share/refdb/sql/refdb.2.dump.mysql" Please note the '2' between "refdb" and "dump". I'm assuming this is a temporary problem, but just to be sure the situation get fixed before final. Moreover, this is not mysql-specific since it is the same for all refdb plugins: refdb.2.dump.mysql refdb.2.dump.mysql41 refdb.2.dump.pgsql refdb.2.dump.sqlite Cheers, Stéphane ---------------------------------------------------------------------- >Comment By: Markus Hoenicka (mhoenicka) Date: 2006-10-25 14:04 Message: Logged In: YES user_id=85809 This is indeed a temporary problem, although it does not hurt at all to add it to the bug list to make sure I'll fix it. I have not yet updated refdb-init to make use of the new main database administration features that I've added to refdbd. refdb-init still creates the main database manually which is no longer required. Once that is changed, refdb-init will no longer need to access the dump files directly. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584361&group_id=26091 |
|
From: SourceForge.net <no...@so...> - 2006-10-25 11:51:28
|
Bugs item #1584361, was opened at 2006-10-25 13:51 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584361&group_id=26091 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: steletch (steletch) Assigned to: Nobody/Anonymous (nobody) Summary: refdb-init searches for the wrong dump file Initial Comment: I tried to install refdb agin (for testing :-) but it failed at the refdb-init script step. The error message is: "refdb.dump.mysql is not readable or missing" This error comes from the script which tries to read the file "/usr/local/share/refdb/sql/refdb.dump.mysql" instead of the correct "/usr/local/share/refdb/sql/refdb.2.dump.mysql" Please note the '2' between "refdb" and "dump". I'm assuming this is a temporary problem, but just to be sure the situation get fixed before final. Moreover, this is not mysql-specific since it is the same for all refdb plugins: refdb.2.dump.mysql refdb.2.dump.mysql41 refdb.2.dump.pgsql refdb.2.dump.sqlite Cheers, Stéphane ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=385991&aid=1584361&group_id=26091 |
|
From: Markus H. <mar...@mh...> - 2006-10-12 12:48:46
|
David Nebauer <dav...@sw...> was heard to say:
> This is a quoting problem.
A weird one at that.
The postinstall script is assembling the
> following command:
>
> cmd="refdbd -a -D \"sqlite\" -i \"/var/lib/refdb/db\""
>
> and executing it with a simple
>
> ${cmd}
>
This seems to be the culprit. I ran the following tests in my bash:
$ refdbd -a -D sqlite -e 0 -l 7 -i 'usr/local/var/lib/refdb/db'
[...]
connected to database server using database:
refdb
current main database version: 2
So the command you're trying to run works perfectly fine. But when I try to do
it like your script:
$ cmd="refdbd -a -D sqlite -e 0 -l 7 -i 'usr/local/var/lib/refdb/db'"
$ echo $cmd
refdbd -a -D sqlite -e 0 -l 7 -i 'usr/local/var/lib/refdb/db'
$ ${cmd}
Database directory:
'usr/local/var/lib/refdb/db'
check main database version
pc51997
Administrator
3306
sqlite
'usr/local/var/lib/refdb/db'
UTF8
refdb
failed to connect to database server using database:
refdb
libdbi could not establish a connection
could not open main database
Can't access or create SQLite database
maintenance of main database failed
That is, running the command as ${cmd} does not consume the quotes as when you
run the very same command in the shell. refdbd receives the quoted arguments
which are no longer properly recognized.
One workaround is to run the command like this:
echo $cmd|sh
although more elegant ways may exist.
regards,
Markus
--
Markus Hoenicka
mar...@ca...
(Spam-protected email: replace the quadrupeds with "mhoenicka")
http://www.mhoenicka.de
|
|
From: Markus H. <mar...@mh...> - 2006-10-12 12:24:33
|
David Nebauer <dav...@sw...> was heard to say: > After upgrading to svn revision 193 I now get an error when running the > command > > refdbd -a -D "sqlite" -i "/var/lib/refdb/db" > > as part of the debian package install. It announces the error > > '(null)' cannot be resolved as a hostname > > and exits with a non-zero return value. > That's not good. However, I can't reproduce the problem on my Windows/Cygwin box at work (using sqlite3 as I don't have sqlite 2.x installed). On your box refdbd claims that ip_or_path is NULL, although it is an initialized stack variable. It would take a pretty gross memory error to achieve this, but valgrind tells me there is nothing wrong. I'm afraid you'd have to look at refdbd with a debugger in order to see what's wrong. Are you familiar with gdb? I'd set a breakpoint after the getopt loop and check the values every couple of lines to see where the values get lost. If this is above your head, I'll run these tests on the weekend on a Debian box, provided I can reproduce the problem. regards, Markus -- Markus Hoenicka mar...@ca... (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de |
6 messages has been excluded from this view by a project administrator.
