Mysql-gui-tools-5.0r9 compile

bgeddy · 02-01-2007, 08:41 PM

I have been playing with a LAMP setup under Slack 11, kernel 2.6.17 and have more or less got everything working. I would like to try out the MySql-gui front end to MySql but haven't had much success and so have been trying to compile MySql-gui-tools from source. The tools depend on the gtk libraries and have fell over at compile time due to undefined references to the gtk libs. This has led me back to recompiling the gtk libs and it's dependencies. I have now reached a brick wall with the compilation of gtkmm-2.4.8 as the make stage of building bombs out with a string of errors the first of which is

Code:

/usr/local/lib/libgtk-x11-2.0.so: undefined reference to `g_bookmark_file_get_title'

I have googled through every link to this error message and am still amd none the wiser. My "/usr/local/lib/libgtk-x11-2.0.so" is a link to libgtk-x11-2.0.so.1000.9 which exists.

Anyway - all I want to do is get a nice GUI fron end to MySql local databases for development purposes and mysql-gui-tools looks promising - if it would work!!

Anyone any ideas ??

H_TeXMeX_H · 02-01-2007, 09:11 PM

Well, for one, post more output, post everything past and including the first error message, these are likely to be important.

bgeddy · 02-02-2007, 08:44 AM

Sorry - I thought this might be something obvious or something someone had seen before. Anyway - I have posted ny config.log and the results of make (it errors out) to here :

http://slackware.pastebin.com/873594

If some kind soul could have a look and give me some ideas I would much appreciate it.

Cheers..

jong357 · 02-02-2007, 09:57 AM

What version of GTK+2 are you using? Also, I noticed that you rebuilt alot, if not all, of the "G libs"... I'll assume you did a removepkg on the stock ones before installing to /usr/local... Looks like you have a version mismatch, hence all the undefined symbols.

It's whining mostly about the new print functions from GTK+2.10.x so I'm going to say that you have 2.10.x installed.... If you built GTK+2.10 then you should be using a newer version of gtkmm than 2.4.x.... That's pretty old; 2 years. try here:

http://ftp.gnome.org/pub/GNOME/sources/gtkmm/2.10/

Make sure your mm libraries match the major version of it's companion libraries. Same for glib et. all.. Using Glib-2.12.x? Then use glibmm-2.12.x.... Same story if you plan on building the python bindings... pygtk-2.4.x isn't going to like GTK+2.10.x.... That would be my guess as to what's going on. configure's check for greater than but don't check for less than because the developer can't predict api changes in the future that will break their software. That 2 year old gtkmm is having a hissy over the new GTK+2 functions and doesn't know what to do with them.

bgeddy · 02-03-2007, 04:42 PM

I have to admit to being no expert in the wonderful world of ./configure, make, make install but I thought the linker was given a dependency chain in a makefile which specified which libraries to link against. I.E. that mysql-administrator link process was specifically looking for libgtkmm-2.4.so . I admit I think it is a mismatched version issue but as I said, I'm no expert. I have posted a copy of my /lib, /usr/lib and /usr/local/lib dirs at
http://slackware.pastebin.com/874644
I apologize for the length of this pastebin but the browser's search function should jump to any relevant bits. Should I be deleting, rebuilding any GTK stuff to sort out my build environment ? Sorry for throwing this at you but I really would like to know more about this and get mysqlgui_tools working. Thanks again...

jong357 · 02-04-2007, 09:47 AM

Have you tried to build the new gtkmm from the link above as I suggested? I thought it was fairly clear... Not sure what anyone is supposed to do with a listing of your lib directories. If anything, list the contents of /var/log/packages... Altho, if your not making packages with everything you've been recompiling, then that will do no good.

It seems to be a versioning problem, plain and simple. List the package names and versions of everything you've recompiled in your endeavor to get the mysql gui to work.

bgeddy · 02-05-2007, 08:41 AM

Well i have built the new gtkmm for your link OK. Now compiling mysql-administrator gives new link errors, this time it seems pango is causing it grief. Here is the tail of the messages - from when errors appear.

Code:

g++  -g -O2   -o mysql-administrator-bin  MGUserBrowserList.o MInstanceInfo.o MDataInterface.o MDynamicInterface.o MAdministrator.o MAPanel.o MAPreferences.o MAPreferencesEditor.o util.o main.o MAServerInformationPanel.o MAServiceControlPanel.o MAUserAdministrationPanel.o MAStartupParametersPanel.o MAServerConnectionsPanel.o MAHealthPanel.o MAServerLogsPanel.o MABackupPanel.o MARestorePanel.o MAReplicationStatusPanel.o MACatalogsPanel.o MADummyPanel.o ../../library/source/libadmin.a ../../../mysql-gui-common/source/linux/libmacommongui.a ../../../mysql-gui-common/library/base-library/source/.libs/libmysqlx.a ../../../mysql-gui-common/library/sql-parser/source/.libs/libsqlparser.a ../../../mysql-gui-common/library/utilities/source/.libs/libguiutil.a -L/usr/lib/mysql -lmysqlclient_r -lz -lpthread -lcrypt -lnsl -lm -lpthread -L/usr/lib -lssl -lcrypto -L/usr/local/lib -lglade-2.0 -lxml2 -lz -lgtkmm-2.4 -lgdkmm-2.4 -latkmm-1.6 -lgtk-x11-2.0 -lpangomm-1.4 -lglibmm-2.4 -lsigc-2.0 -lgdk-x11-2.0 -latk-1.0 -lgdk_pixbuf-2.0 -lm -lpangocairo-1.0 -lpango-1.0 -lcairo -lgobject-2.0 -lgmodule-2.0 -ldl -lglib-2.0   -lutil -L/usr/lib -lpcre
/usr/local/lib/libpangoft2-1.0.so.0: undefined reference to `g_type_register_static_simple'
/usr/local/lib/libpangoft2-1.0.so.0: undefined reference to `pango_quantize_line_geometry'
/usr/local/lib/libpangoft2-1.0.so.0: undefined reference to `pango_font_describe_with_absolute_size'
collect2: ld returned 1 exit status
make[3]: *** [mysql-administrator-bin] Error 1
make[3]: Leaving directory `/home/ed/mysql-gui-tools-5.0r9.tar.gz/mysql-gui-tools-5.0r9/mysql-administrator/source/linux'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/home/ed/mysql-gui-tools-5.0r9.tar.gz/mysql-gui-tools-5.0r9/mysql-administrator/source/linux'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/ed/mysql-gui-tools-5.0r9.tar.gz/mysql-gui-tools-5.0r9/mysql-administrator/source'
make: *** [all-recursive] Error 1

I can't quite get my head around these errors. IE the first one:

Code:

/usr/local/lib/libpangoft2-1.0.so.0: undefined reference to `g_type_register_static_simple'

- does this mean that libpangooft2-1.0.so.0 is looking for g_type_register_static_simple which I believe is available from glib2.12. My version of glib is libglib-2.0.so.0.1200.9 which I thought was a 2.12.9 version of glib. Am I making any sense here - this is causing me much grief but I feel I'm getting somewhere. Then the next error is:

Code:

/usr/local/lib/libpangoft2-1.0.so.0: undefined reference to `pango_quantize_line_geometry'

- I thought pango_quantize_line_geometry was defined in pango 1.12 and my copy of pango is libpango-1.0.so.0.1400.10 which I believe to be pango 1.14.

Thanks again for your time..

jong357 · 02-05-2007, 12:46 PM

Quote:

Originally Posted by jong357

List the package names and versions of everything you've recompiled in your endeavor to get the mysql gui to work.

Also, this thread is related and of importance.

http://www.linuxquestions.org/questi...d.php?t=521692