bookbase-help — Need help? Send mail to this list.

Re: [Bookbase-help] Bookbase as a semi-library?

[Caleb G. <ca...@ca...>]

On Tue, 2004-10-19 at 07:37, ch...@ch... wrote:
> Hey,
> 
> I'm trying to find a solution to a sorta home library system. Bookbase
> looks nice and tightly designed, but I need it to be able to use an
> external MySQL database (and obviously ./configure tells me I don't have
> mysql installed on my system). The other thing I'd need is to be able to
> run it cross-platform (i.e. windows users and linux users alike).
> 
> Is this possible with bookbase, or should I look elsewhere? I'm not a
> coder, but don't mind playing about with things.
> 
> Cheers for any advice you can give,
> 
> Felix

Felix,

Based on your needs I would suggest mCatalog
(http://mcatalog.sourceforge.net/).  Its written in mono, so it
should/could work in both linux and windows.  It's interface is pretty
slick too.
-- 
Caleb Groom <ca...@ca...>

[Bookbase-help] Bookbase as a semi-library?

[<ch...@ch...>]

Hey,

I'm trying to find a solution to a sorta home library system. Bookbase
looks nice and tightly designed, but I need it to be able to use an
external MySQL database (and obviously ./configure tells me I don't have
mysql installed on my system). The other thing I'd need is to be able to
run it cross-platform (i.e. windows users and linux users alike).

Is this possible with bookbase, or should I look elsewhere? I'm not a
coder, but don't mind playing about with things.

Cheers for any advice you can give,

Felix

[Bookbase-help] bookbase install error with lmysqlclient

[Michael B. <bm...@ya...>]

I also had a problem with the installation finding
lmysqlclient.

Even though I had installed the mysql-shared package,
I still had an issue.

I did some research and found that others had this
same problem with Red Hat 9 and what they did is copy
all files from /usr/lib/mysql to /usr/lib and that
seemed to work for me.

Mike Brennan

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

[Bookbase-help] bookbase install error "I can't find mysql.h."

[Michael B. <bm...@ya...>]

I tried to install bookbase and it could not find
mysql.h.  You might want to add to your FAQ that you
have to install the mysql-devel package as well as
some kind of C complier like GCC to install bookbase.

Output of error:

[root@cheyenne bookbase-0.8.8]# mysql -u root -p <
./bookbase_tables.sql
Enter password:
[root@cheyenne bookbase-0.8.8]# ./configure
checking for a BSD compatible install...
/usr/bin/install -c
checking whether build environment is sane... yes
checking for mawk... no
checking for gawk... gawk
checking whether make sets ${MAKE}... yes
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for executable suffix...
checking for object suffix... o
checking whether we are using the GNU C compiler...
yes
checking whether gcc accepts -g... yes
checking dependency style of gcc... gcc3
checking for POSIXized ISC... no
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler...
(cached) yes
checking whether gcc accepts -g... (cached) yes
checking dependency style of gcc... (cached) gcc3
checking for gcc option to accept ANSI C... none
needed
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for lpr... /usr/bin/lpr
checking for mysql... /usr/bin/mysql
checking for mysqldump... /usr/bin/mysqldump
checking for gtk-config... /usr/bin/gtk-config
checking for GTK - version >= 1.2.0... yes
checking for mysql/mysql.h... no
checking for /usr/local/include/mysql/mysql.h... no
 
        I can't find mysql.h.
        Please be certain you have the MySQL libraries
and shared
        files installed.


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/

[Bookbase-help] BookBase CVS

[Caleb G. <ca...@ca...>]

As far as I can tell, the v0.8.8 additions don't seem to be in CVS.  I
did a diff between the latest release tarball and CVS and found numerous
discrepancies.

I'd like to hack on BookBase again for grins.  I made a commit today
that I'll have to undo (didn't know CVS wasn't up to date at the time).

Greg, is CVS really out of date?  If so, do you mind committing your
changes?
-- 
Caleb Groom <ca...@ca...>

[Bookbase-help] Help for a stupid guy

[SOHO M. <soh...@ad...>]

I tried to connect to Bookbase, but got this message:

==============================================
Checking current connection status.
Attempting to connect.
Connection failed.
Access denied for user: 'hclowers@clowers_home.local' to database bookbase
==============================================

I imagine that I didn't setup MySQL properly.

Can you give me any guidance on how to set it up?  Thank you for your time.



                                                                        
        -- Harvey Clowers

[Bookbase-help] Just downloaded the program, and had to fix an aborted compile/make

[Rikke D. G. <rg...@te...>]

The program looks nice!

There's a few things I've noticed.  For one thing, password should be 
an option, as my mysql server only serves well, me basically, and I'm 
not using a password.  *gasp... oh the horror!*

On my Redhat 7.3 system the compile failed at first.   Not sure what 
exactly is screwy with the configure script to make it fail, but it 
doesn't correctly locate the -lmysqlclient flag.  This is probably 
Redhat specific, I noticed in the archives another person had this 
failure.  Basically when you compile, when you get to the mysql part, 
the linker barfs with  a bunch of undefined references like this:

/home/rgiles/downloads/bookbase-0.8.8/src/callbacks.c:320: undefined 
reference to `mysql_init'
/home/rgiles/downloads/bookbase-0.8.8/src/callbacks.c:325: undefined 
reference to `mysql_real_connect'
/home/rgiles/downloads/bookbase-0.8.8/src/callbacks.c:327: undefined 
reference to `mysql_error'
/home/rgiles/downloads/bookbase-0.8.8/src/callbacks.c:367: undefined 
reference to `mysql_num_rows'
/home/rgiles/downloads/bookbase-0.8.8/src/callbacks.c:375: undefined 
reference to `mysql_num_rows'

ad infinitum.  I fixed this by editting the Makefile in the /src 
directory.

I changed the line
bookbase_LDFLAGS =

to
bookbase_LDFLAGS = -L/usr/lib/mysql

The program compiles fine after that.  The fix is only temporary 
though, if you have to reconfigure it will lose that line.  I'm afraid 
I'm not enough of an automake, autoconf expert to fix it permanently.

I'm looking forward to using this program.  I'm glad I don't have to 
develop one myself, as I was thinking of doing that.  If I come up with 
a way to get around requiring a password, I'll send in the patch, if 
you want it.

Thanks for the program!

Rikke

Re: [Bookbase-help] Looking at bookbase.

[Greg K. <gre...@ba...>]

> First, it requires the ISBN number and refuses to accept a book without it.

This is something that will be corrected in the next version.

> There seems to be no way to select/modify an entry.
> If I "search" for a title, then click on a result, the book entry fields
> are not filled in. I am therefore forced to enter  them in again by hand,
> it attempts to add yet another entry.  This may be an error on my part,
> but how to I recall an entry to modify it?

This definitely does not sound right.  To modify an entry you should run a
search, right click on the entry you wish to modify, and select 'MODIFY'

> How do I maintain just one entry for each author, and list multiple
> books by this author?

It doesn't work that way.  Yet.  In the current version, the author's name is
stored as a text field in the book record.  This will be changed in upcoming
versions.

>  There does seem to be an extra field following
> the author name, is this for an author ID that allows my to refer back
> to an author in the db?

That second field was meant for a second author, but don't use it -- it's
broken.

> In absence of any satisfactory answers to these questions, is there any
> other book db system out there that would allow me to maintain a database
> of books without these restrictions?

Not as far as I know.  That's why I wrote this one.

> As is, I can't even use bookbase for initial entry because it seems to
> keep creating duplicate entries int he author and publisher fields.

I suspect there is something fishy going on between BookBase and whatever flavor
of unix you use.  If I were you, I wouldn't use the program until the next
version comes out.

Greg

[Bookbase-help] Looking at bookbase.

[Tom R. <th...@fo...>]

Sirs, I'm looking at using bookbase to track books that I've read/own.

I'm looking at bookbase and find a number of shortcomings here for
my purpose.

First, it requires the ISBN number and refuses to accept a book without it.
Many of the books I've read are old and don't necessarily have ISBN
numbers or have multiple ISBN numbers from various publishers/versions.
I would like not to give one or use some "N/A" or "unknown" type entry.

Problem is, this create duplicates ISBN numbers causing it to fail.

There seems to be no way to select/modify an entry.

If I "search" for a title, then click on a result, the book entry fields
are not filled in. I am therefore forced to enter  them in again by hand,
it attempts to add yet another entry.  This may be an error on my part,
but how to I recall an entry to modify it?

How do I maintain just one entry for each author, and list multiple
books by this author?  There does seem to be an extra field following
the author name, is this for an author ID that allows my to refer back
to an author in the db?  How is it used?

The same is true for publishers.  I would like to access just the author
or publisher fields for modification too.

On this issue, I would also like to have a comment field for each author
and publisher, and It should have some field for rating books, although
the comments field would do.

In absence of any satisfactory answers to these questions, is there any
other book db system out there that would allow me to maintain a database
of books without these restrictions?

My alternative is simply to do a php/web abased form and my own tables.
The other alternative is, of course, to modify the existing program,
but that would be a waste of my time if there aren't others of like mind
involved in this project.

As is, I can't even use bookbase for initial entry because it seems to
keep creating duplicate entries int he author and publisher fields.

I must have something wrong.

Please CC a copy to me directly because I'm not on any lists for this
project.

Thanks for any response (save flames :-).

-- 
----------------------------------------------------------------------
* Tom Redfern        Box 21 Snoqualmie   WA 98065-0021  USA          *
*                    Email: th...@fo...  Phone: (425) 888-7080 *
----------------------------------------------------------------------
The very powerful and the very stupid have one thing in common.
Instead of altering their views to fit the facts, they alter the facts
to fit their views ... which can be very uncomfortable if you happen to
be one of the facts that needs altering.  -- Doctor Who, "Face of Evil"

[Bookbase-help] Install questions

[John J. <jw...@cc...>]

I don't know much about mysql.  I am running Redhat 8.0 with all updates 
installed.
I followed the INSTALL instructions.  I made the database bookbase.  I 
ran ./configure.

Probably a dumb error on my part, but here goes.

Thanks in advance.  
John James

When I ran make, I got the following errors:

gcc  -g -O2 -Wall   -o bookbase  main.o support.o interface.o 
callbacks.o printing.o loan.o -L/usr/lib -L/usr/X11R6/lib -lgtk -lgdk 
-rdynamic -lgmodule -lglib -ldl -lXi -lXext -lX11 -lm
callbacks.o: In function `runSQL':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:201: 
undefined reference to `mysql_real_query'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:207: 
undefined reference to `mysql_store_result'
callbacks.o: In function `connect_button_clicked':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:320: 
undefined reference to `mysql_init'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:325: 
undefined reference to `mysql_real_connect'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:327: 
undefined reference to `mysql_error'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:375: 
undefined reference to `mysql_num_rows'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:367: 
undefined reference to `mysql_num_rows'
callbacks.o: In function `disconnect_button_clicked':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:417: 
undefined reference to `mysql_close'
callbacks.o: In function `matching_author_found':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:459: 
undefined reference to `mysql_fetch_row'
callbacks.o: In function `matching_publisher_found':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:499: 
undefined reference to `mysql_fetch_row'
callbacks.o: In function `add_author_to_author_table':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:557: 
undefined reference to `mysql_fetch_row'
callbacks.o: In function `add_pub_to_pub_table':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:611: 
undefined reference to `mysql_fetch_row'
callbacks.o: In function `check_author_table':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:675: 
undefined reference to `mysql_num_rows'
callbacks.o: In function `check_publisher_table':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:735: 
undefined reference to `mysql_num_rows'
callbacks.o: In function `verify_unique_isbn':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:1043: 
undefined reference to `mysql_num_rows'
callbacks.o: In function `add_button_clicked':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:1212: 
undefined reference to `mysql_fetch_row'
callbacks.o: In function `modify_bookid':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:1635: 
undefined reference to `mysql_num_rows'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:1638: 
undefined reference to `mysql_fetch_row'
callbacks.o: In function `display_results':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:2006: 
undefined reference to `mysql_fetch_row'
callbacks.o: In function `search_button_clicked':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:2322: 
undefined reference to `mysql_num_rows'
callbacks.o: In function `on_status1_activate':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:2967: 
undefined reference to `mysql_get_host_info'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:2968: 
undefined reference to `mysql_get_proto_info'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:2969: 
undefined reference to `mysql_get_server_info'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:2970: 
undefined reference to `mysql_get_client_info'
callbacks.o: In function `quit_button_clicked':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:3032: 
undefined reference to `mysql_close'
callbacks.o: In function `bookbase_destroy':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/callbacks.c:3051: 
undefined reference to `mysql_close'
loan.o: In function `is_book_loaned':
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/loan.c:81: undefined 
reference to `mysql_num_rows'
/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src/loan.c:83: undefined 
reference to `mysql_fetch_row'
collect2: ld returned 1 exit status
make[2]: *** [bookbase] Error 1
make[2]: Leaving directory `/home/Storage/Tarballs/Unzip/bookbase-0.8.8/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/Storage/Tarballs/Unzip/bookbase-0.8.8'
make: *** [all] Error 2

Re: [Bookbase-help] Help....

[Greg K. <gre...@ba...>]

Thad,

It looks like compile isn't finding the mysqlclient library.

> checking for mysql_init in -lmysqlclient... no

The package you need is MySQL-shared.  You can find it at the downloads site of
the MySQL homepage: www.mysql.org.

[Bookbase-help] Help....

[Thad V. <tv...@al...>]

Hello,

I don't know what I am doing wrong....Please point Me in the right direction...thanks :)

mysql version:     Ver 11.16 Distrib 3.23.49, for redhat-linux-gnu (i386)
mysqladmin version:  Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386


Here is a copy of the configure info:

checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for mawk... no
checking for gawk... gawk
checking whether make sets ${MAKE}... yes
checking for style of include used by make... GNU
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for executable suffix... 
checking for object suffix... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking dependency style of gcc... gcc3
checking for POSIXized ISC... no
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking dependency style of gcc... (cached) gcc3
checking for gcc option to accept ANSI C... none needed
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for lpr... /usr/bin/lpr
checking for mysql... /usr/bin/mysql
checking for mysqldump... /usr/bin/mysqldump
checking for gtk-config... /usr/bin/gtk-config
checking for GTK - version >= 1.2.0... yes
checking for mysql/mysql.h... yes
checking for mysql_init in -lmysqlclient... no
configure: creating ./config.status
config.status: creating Makefile
config.status: creating src/Makefile
config.status: creating config.h
config.status: config.h is unchanged



Here is a copy of the compile output:

make
cd . \
  && CONFIG_FILES= CONFIG_HEADERS=config.h \
     /bin/sh ./config.status
config.status: creating config.h
config.status: config.h is unchanged
make  all-recursive
make[1]: Entering directory `/home/thvargo/Booklist/bookbase-0.8.8'
Making all in src
make[2]: Entering directory `/home/thvargo/Booklist/bookbase-0.8.8/src'
source='main.c' object='main.o' libtool=no \
depfile='.deps/main.Po' tmpdepfile='.deps/main.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/X11R6/include    -g -O2 -Wall -c `test -f main.c || echo './'`main.c
source='support.c' object='support.o' libtool=no \
depfile='.deps/support.Po' tmpdepfile='.deps/support.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/X11R6/include    -g -O2 -Wall -c `test -f support.c || echo './'`support.c
source='interface.c' object='interface.o' libtool=no \
depfile='.deps/interface.Po' tmpdepfile='.deps/interface.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/X11R6/include    -g -O2 -Wall -c `test -f interface.c || echo './'`interface.c
source='callbacks.c' object='callbacks.o' libtool=no \
depfile='.deps/callbacks.Po' tmpdepfile='.deps/callbacks.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/X11R6/include    -g -O2 -Wall -c `test -f callbacks.c || echo './'`callbacks.c
source='printing.c' object='printing.o' libtool=no \
depfile='.deps/printing.Po' tmpdepfile='.deps/printing.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/X11R6/include    -g -O2 -Wall -c `test -f printing.c || echo './'`printing.c
source='loan.c' object='loan.o' libtool=no \
depfile='.deps/loan.Po' tmpdepfile='.deps/loan.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I/usr/include/gtk-1.2 -I/usr/include/glib-1.2 -I/usr/lib/glib/include -I/usr/X11R6/include    -g -O2 -Wall -c `test -f loan.c || echo './'`loan.c
gcc  -g -O2 -Wall   -o bookbase  main.o support.o interface.o callbacks.o printing.o loan.o -L/usr/lib -L/usr/X11R6/lib -lgtk -lgdk -rdynamic -lgmodule -lglib -ldl -lXi -lXext -lX11 -lm 
callbacks.o: In function `runSQL':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:201: undefined reference to `mysql_real_query'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:207: undefined reference to `mysql_store_result'
callbacks.o: In function `connect_button_clicked':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:320: undefined reference to `mysql_init'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:325: undefined reference to `mysql_real_connect'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:327: undefined reference to `mysql_error'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:367: undefined reference to `mysql_num_rows'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:375: undefined reference to `mysql_num_rows'
callbacks.o: In function `disconnect_button_clicked':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:417: undefined reference to `mysql_close'
callbacks.o: In function `matching_author_found':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:459: undefined reference to `mysql_fetch_row'
callbacks.o: In function `matching_publisher_found':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:499: undefined reference to `mysql_fetch_row'
callbacks.o: In function `add_author_to_author_table':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:557: undefined reference to `mysql_fetch_row'
callbacks.o: In function `add_pub_to_pub_table':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:611: undefined reference to `mysql_fetch_row'
callbacks.o: In function `check_author_table':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:675: undefined reference to `mysql_num_rows'
callbacks.o: In function `check_publisher_table':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:735: undefined reference to `mysql_num_rows'
callbacks.o: In function `verify_unique_isbn':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:1043: undefined reference to `mysql_num_rows'
callbacks.o: In function `add_button_clicked':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:1212: undefined reference to `mysql_fetch_row'
callbacks.o: In function `modify_bookid':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:1635: undefined reference to `mysql_num_rows'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:1638: undefined reference to `mysql_fetch_row'
callbacks.o: In function `display_results':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:2017: undefined reference to `mysql_fetch_row'
callbacks.o: In function `search_button_clicked':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:2322: undefined reference to `mysql_num_rows'
callbacks.o: In function `on_status1_activate':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:2967: undefined reference to `mysql_get_host_info'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:2968: undefined reference to `mysql_get_proto_info'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:2969: undefined reference to `mysql_get_server_info'
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:2970: undefined reference to `mysql_get_client_info'
callbacks.o: In function `quit_button_clicked':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:3032: undefined reference to `mysql_close'
callbacks.o: In function `bookbase_destroy':
/home/thvargo/Booklist/bookbase-0.8.8/src/callbacks.c:3051: undefined reference to `mysql_close'
loan.o: In function `is_book_loaned':
/home/thvargo/Booklist/bookbase-0.8.8/src/loan.c:81: undefined reference to `mysql_num_rows'
/home/thvargo/Booklist/bookbase-0.8.8/src/loan.c:83: undefined reference to `mysql_fetch_row'
collect2: ld returned 1 exit status
make[2]: *** [bookbase] Error 1
make[2]: Leaving directory `/home/thvargo/Booklist/bookbase-0.8.8/src'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/thvargo/Booklist/bookbase-0.8.8'
make: *** [all] Error 2

[Bookbase-help] Results of install, and comments

[<jh...@al...>]

First, I had to install MySQL to run it - and even after buying a book on 
MySQL I couldn't figure out how to add myself as a user with the ability
to create a database and diddle with it.

Then after doing configure and make, it couldn't find the mysql library
in the linking step.  Being incompetent to debug configure scripts I just
hand-edited the src/Makefile, adding -L/usr/lib/mysql -lmysqlclient
and then it linked up properly.

This is the first book catalog I found on sourceforge; and maybe it is not
the one I should be trying to use.  There doesn't seem to be any place to
put the book catalog number - how do you shelve your books if you don't 
use Library of Congress or Dewey Decimal catalog numbers?  The genre 
column isn't useful to me; that is implicit in the catalog number.
Nor do I have any use for the cover and cover price and times read data;
but I can ignore those.

Not being a Real Programmer, I got to wondering why a dbm is 
useful/necessary for a home library of a few thousand books.  I'm starting
to think maybe I should make a flat file, sort it by title and author and
catalog number, and then write a little program to print it nicely.

[Bookbase-help] Problem with make

[<an...@ya...>]

Hi :
  I had followed the INSTALL steps to add and update
table in MySql database, and the "./configure" script
worked with no error, but I got an error with make
step.You can see the attached picture that you will
find the main point are calling into Mysql command in
callback.c . I had check the the "configure" file, it
will check the herader file "MySql/MySql.h" and
"usr/local/include/MySql/MySql.h", but in my system my
MySql is in "/usr/include/MySql/MySql.h", I guess
that's why the "make" fail, could you tell me how to
solve it?

PS: My system are RH7.3 with full installation, so all
packages are installed in first installation, are the
default settig with RH7.3 prefer.

Thanks~

anukey


-----------------------------------------------------------------
< 每天都 Yahoo!奇摩 >  www.yahoo.com.tw

Re: [Bookbase-help] Adding the first record to Bookbase

[Greg K. <gre...@ba...>]

Jim,
I was hoping you'd write again, your previous messages to me were accidentally
deleted.
Please post the relevant SQL code from the MESSAGES window under the CONNECTION
tab.  This will show us exactly what's going wrong.  Also, post the ISBN you're
trying to enter.
Greg




                                                                                                                                                    
                      Jim <fa...@un...>                                                                                                     
                      Sent by:                              To:       boo...@li...                                           
                      boo...@li...        cc:                                                                                     
                      ceforge.net                           Subject:  [Bookbase-help] Adding the first record to Bookbase                           
                                                                                                                                                    
                                                                                                                                                    
                      09/03/02 04:40 PM                                                                                                             
                                                                                                                                                    
                                                                                                                                                    




-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When I try to add the first record to Bookbase, I enter everything including
a valid ISBN number and it fails to add the first record.  The error message
says "Not a unique ISBN".  Is this a known issue?  Is there a fix?  Is there
a way around it?
- --
Jim

Freedom is worth protecting

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBPXUeIisk3ywszI1FEQJcCwCg6YLvlu1JBqYWTtp5OfgbDMqCimoAoMaO
kE8im2Pwvr9ISTXMDDHPqB6T
=P7Vo
-----END PGP SIGNATURE-----


-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone?  Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
Bookbase-help mailing list
Boo...@li...
https://lists.sourceforge.net/lists/listinfo/bookbase-help

[Bookbase-help] Adding the first record to Bookbase

[Jim <fa...@un...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

When I try to add the first record to Bookbase, I enter everything including 
a valid ISBN number and it fails to add the first record.  The error message 
says "Not a unique ISBN".  Is this a known issue?  Is there a fix?  Is there 
a way around it?
- -- 
Jim

Freedom is worth protecting

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQA/AwUBPXUeIisk3ywszI1FEQJcCwCg6YLvlu1JBqYWTtp5OfgbDMqCimoAoMaO
kE8im2Pwvr9ISTXMDDHPqB6T
=P7Vo
-----END PGP SIGNATURE-----

Re: [Bookbase-help] problems installing

[Greg K. <gre...@ba...>]

Jeff,

Sorry about the delayed response, I've been on vacation.

The errors you're getting when you run configure make me think that you don't
have the gtk-development package/RPM/whatever installed.  Unless I'm mistaken,
gtk-config and all header files and such are part of gtk+-devel.  If you install
that RPM/package and try configure again, all should work.

As far as running bookbase_tables.sql script as root, that's perfectly okay.
All that script does is create the necessary table structure for the BookBase
database.  You'll probably want to create yourself a MySQL user at some point,
though, just to keep bad things from inadvertently happening.  It's fairly
simple, but you do have to have a little bit of MySQL knowledge.  In the
meantime, using root to login will work fine.

Please let me know if the gtk+-devel package gets you up and running.  If not,
I'll find another answer.

Greg



                                                                                                                                                    
                      Jeff Maxson                                                                                                                   
                      <jbm...@su...>             To:       boo...@li...                                           
                      Sent by:                              cc:                                                                                     
                      boo...@li...        Subject:  [Bookbase-help] problems installing                                           
                      ceforge.net                                                                                                                   
                                                                                                                                                    
                                                                                                                                                    
                      03/24/02 09:55 PM                                                                                                             
                                                                                                                                                    
                                                                                                                                                    





Hi there.  This looks just like something I would want to use, but I am
having a tough time starting up.

First, I'm running Debian GNU/Linux testing/woody with 3.something mysql
(just put it on this evening for this)

downloaded 0.8.8 of bookbase, unzipped it, and read the Install/Readme.
Tried the

mysql < ./bookbase_tables.sql

as myself, and it said

ERROR 1044 at line 11: Access denied for user: '@localhost' to database
'bookbase'

even though I am a member of the mysql group.  odd. Admittedly I know
nothing about SQL or MySQL. Anyway, I tried it as root and it took, though
I am sure something is bad about doing that.

I then proceeded to run ./configure as root and got (last part of
messages)

.
.
.
checking dependency style of gcc... gcc
checking for POSIXized ISC... no
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking dependency style of gcc... (cached) gcc
checking for gcc option to accept ANSI C... none needed
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for lpr... /usr/bin/lpr
checking for mysql... /usr/bin/mysql
checking for mysqldump... /usr/bin/mysqldump
checking for gtk-config... no
checking for GTK - version >= 1.2.0... no
*** The gtk-config script installed by GTK could not be found
*** If GTK was installed in PREFIX, make sure PREFIX/bin is in
*** your path, or set the GTK_CONFIG environment variable to the
*** full path to gtk-config.
configure: error: Cannot find GTK: Is gtk-config in path?

at that point, I am stuck.  I am pretty sure I am running gtk >= 1.2, as
when I do a "locate gtk" there are plenty of things that pop up as
libgtk1.2.soemthing.  "locate gtk-config" doesn't show up on my harddrive,
and "apt-get install gtk-config" doesn't come up with anything.

Help?

--
Jeff Maxson
jbm...@su...


_______________________________________________
Bookbase-help mailing list
Boo...@li...
https://lists.sourceforge.net/lists/listinfo/bookbase-help

[Bookbase-help] problems installing

[Jeff M. <jbm...@su...>]

Hi there.  This looks just like something I would want to use, but I am
having a tough time starting up.

First, I'm running Debian GNU/Linux testing/woody with 3.something mysql
(just put it on this evening for this)

downloaded 0.8.8 of bookbase, unzipped it, and read the Install/Readme.
Tried the

mysql < ./bookbase_tables.sql

as myself, and it said

ERROR 1044 at line 11: Access denied for user: '@localhost' to database
'bookbase'

even though I am a member of the mysql group.  odd. Admittedly I know
nothing about SQL or MySQL. Anyway, I tried it as root and it took, though
I am sure something is bad about doing that.

I then proceeded to run ./configure as root and got (last part of
messages)

.
.
.
checking dependency style of gcc... gcc
checking for POSIXized ISC... no
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking dependency style of gcc... (cached) gcc
checking for gcc option to accept ANSI C... none needed
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for lpr... /usr/bin/lpr
checking for mysql... /usr/bin/mysql
checking for mysqldump... /usr/bin/mysqldump
checking for gtk-config... no
checking for GTK - version >= 1.2.0... no
*** The gtk-config script installed by GTK could not be found
*** If GTK was installed in PREFIX, make sure PREFIX/bin is in
*** your path, or set the GTK_CONFIG environment variable to the
*** full path to gtk-config.
configure: error: Cannot find GTK: Is gtk-config in path?

at that point, I am stuck.  I am pretty sure I am running gtk >= 1.2, as
when I do a "locate gtk" there are plenty of things that pop up as
libgtk1.2.soemthing.  "locate gtk-config" doesn't show up on my harddrive,
and "apt-get install gtk-config" doesn't come up with anything.

Help?

-- 
Jeff Maxson
jbm...@su...