![[OpenBSDsupport]](/images/smalltitle-support.png){kind=small}
#define _XOPEN_SOURCE with
#define _GNU_SOURCE in two files; otherwise the compiler complains about missing math functions
</DISCLAIMER>
MYSQL-ADMINISTRATOR
If you plan on connecting to (not building against) a MySQL database < 5.0.3 (which is most of us), you should install 1.0.22a, not 1.1.14.
For user administration (and maybe other features), mysql-admin 1.1.14 needs to connect to a MySQL 5.0.3 database.
mysql-administrator 1.1.14 is sending the SQL query select * from mysql.procs_priv and, when that fails, mysql-admin will give the
"Could not retrieve user privilege information." error dialog.
You do not need to build against MySQL 5.0.3; building either version of the administrator will work against MySQL 4.0.23p1.
mv ./images/icons/png/maintree/16x16_StartStopService.png0000644 ./images/icons/png/maintree/16x16_StartStopService.png mv ./library/tests/test_get_cnf_value/t/common.test.query0000644 ./library/tests/test_get_cnf_value/t/common.test.query mv ./library/tests/test_update_cnf/test_update_cnf.vcproj0000644 ./library/tests/test_update_cnf/test_update_cnf.vcproj mv ./library/tests/test_get_all_cnf_sections/test_priv.sh0000644 ./library/tests/test_get_all_cnf_sections/test_priv.sh mv ./images/icons/png/sections/startup_variables_gray.png0000644 ./images/icons/png/sections/startup_variables_gray.png mv ./images/icons/png/maintree/24x24_StartStopService.png0000644 ./images/icons/png/maintree/24x24_StartStopService.png mv ./res/mac/English.lproj/ServerConnections.nib/info.nib0000644 ./res/mac/English.lproj/ServerConnections.nib/info.nib mv ./res/mac/English.lproj/ServerInformation.nib/info.nib0000644 ./res/mac/English.lproj/ServerInformation.nib/info.nib mv ./res/mac/English.lproj/DataFileEditor.nib/classes.nib0000644 ./res/mac/English.lproj/DataFileEditor.nib/classes.nib mv ./res/mac/English.lproj/HealthGraphEditor.nib/info.nib0000644 ./res/mac/English.lproj/HealthGraphEditor.nib/info.nib mv ./res/mac/English.lproj/ServiceControl.nib/classes.nib0000644 ./res/mac/English.lproj/ServiceControl.nib/classes.nib mv ./source/mac/MySQL\ Administrator.xcode/akojima.pbxuser0000644 ./source/mac/MySQL\ Administrator.xcode/akojima.pbxuser mv ./source/mac/MySQL\ Administrator.xcode/project.pbxproj0000644 ./source/mac/MySQL\ Administrator.xcode/project.pbxproj
./configure; gmake; gmake install
--with-gtkhtml=libgtkhtml-3.# option. I choose gtkhtml 3.1.20 and built the query browser
against that. FYI - OpenBSD 3.8 offers gtkhtml 3.6.2 as a package; I have not upgraded yet but those that have, you should install the
packaged version and attempt a build against that version of gtkhtml.
gmake. You will get the following error:
make: don't know how to make w. Stop in /home/krichard/mysql-gui-4.0.23p1/mysql-query-browser-1.1.14/mysql-query-browser/source/linux/gtksourceview.
cd source/linux/gtksourceview; gmake; cd ../../..
gmake; gmake install
MYSQL GUI COMMON
If you are installing into non-standard areas (e.g, a prefix not /usr/local) my advice is to build the mysql-gui-common that came with the GUI tool you are installing. If you are using non-default values for the
parent GUI tool, such as --prefix, make sure the mysql-gui-common gets the same options, if applicable.
If you are installing both the admin and query browser into the same prefix, you may have problems with conflicting
gui-common installations. I have not tested this part yet.
mv ./library/tests/read_international/read_international.cpp0000644 ./library/tests/read_international/read_international.cpp
up
--- mysql-gui-common/library/source/myx_library.c.dist Tue Sep 20 18:54:13 2005
+++ mysql-gui-common/library/source/myx_library.c Tue Sep 20 18:54:45 2005
@@ -581,11 +581,14 @@
//of mysql_real_connect are in utf8
//mysql_options(mysql, MYSQL_SET_CHARSET_NAME, "utf8");
+#if defined(MYSQL_VESION_ID) && (MYSQL_VERSION_ID >= 40101)
if (myx_mysql_get_private(mysql)->embedded)
mysql_options(mysql, MYSQL_OPT_USE_EMBEDDED_CONNECTION, (char *)1);
else
mysql_options(mysql, MYSQL_OPT_USE_REMOTE_CONNECTION, (char *)1);
+#endif
+
if (!mysql_real_connect(mysql, user_conn->hostname, user_conn->username,
user_conn->password, user_conn->schema,
user_conn->port,
--- mysql-administrator/source/linux/MInstanceInfo.cc.dist Tue Sep 20 19:06:16 2005
+++ mysql-administrator/source/linux/MInstanceInfo.cc Tue Sep 20 19:06:28 2005
@@ -846,6 +846,11 @@
info.free= (long long)fs.f_bsize * fs.f_bavail;
info.type= "unknown";
+
+#ifdef OpenBSD
+info.type= fs.f_fstypename;
+#else
+
for (unsigned int i= 0; i < sizeof(fstypes)/sizeof(FSType); i++)
{
if (fstypes[i].id == fs.f_type)
@@ -854,6 +859,7 @@
break;
}
}
+#endif
return true;
}
--- mysql-administrator/source/linux/MAServerLogsPanel.cc.dist Tue Sep 20 19:07:29 2005
+++ mysql-administrator/source/linux/MAServerLogsPanel.cc Tue Sep 20 19:12:19 2005
@@ -14,7 +14,7 @@
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA */
-#define _XOPEN_SOURCE /* glibc2 needs this */
+#define _GNU_SOURCE /* glibc2 needs this */
#include <time.h>
#include "myadmin.h"
--- MQHistory.cc.dist Sat Oct 8 20:19:50 2005 +++ MQHistory.cc Sat Oct 8 20:20:40 2005 @@ -16,8 +16,8 @@ #include "myqb.h" -#ifndef _XOPEN_SOURCE -#define _XOPEN_SOURCE /* glibc2 needs this */ +#ifndef _GNU_SOURCE +#define _GNU_SOURCE /* glibc2 needs this */ #endif #include <time.h>
REFERENCES
MySQL Admin/Query GUI requirements (see bug report about building against < MySQL 4.1.1):
Administrator
Query Browswer
Bug Report for Incorrect MySQL requirements (and the fix):
http://bugs.mysql.com/bug.php?id=12585
Running Administrator 1.1 against < MySQL 5.0.3 fails because of missing mysql.procs_priv table . MySQL Admin 1.1 will try to select from
procs_priv when doing User Administration.
mysql.procs_priv table was added in MySQL 5.0.3
Gtkmm 2.0/2.2 can be installed in parallel with gtkmm 1.2 (version 1.2 is available in 3.7 i386 packages) This is based entirely off of the
following gtkmm webpage.
http://www.gtkmm.org/download.shtml
up
ONLINE SOURCE LOCATIONS
Building from source can be as simple as running ./configure; gmake; gmake install .
To see all options available for each package, run ./configure --help
The following are links to tarred/zipped formats. If you would rather have bz2, you will find them in the same directory.
libsigc++-1.2.7
gtkmm-2.2.12
gtkhtml-3.1.20 (Query Browser only)
Administrator 1.0
Administrator 1.1
Query Browser 1.1
MD5 (libsigc++-1.2.7.tar.gz) = b939751dff0db9652c5dbfc9de685efa
MD5 (gtkmm-2.2.12.tar.gz) = 99f4580a55db3926753446ddff55a478
MD5 (gtkhtml-3.1.20.tar.gz) = 0b47f10a77b0244af3c25a109ae98e0c
MD5 (mysql-administrator-1.0.22a.tar.gz) = ed0f1af3eb7be03c2785ad9057492b75
MD5 (mysql-administrator-1.1.2.tar.gz) = 3d8bfbadbe160d9cd73ce3cce1eb088a
MD5 (mysql-query-browser-1.1.14.tar.gz) = dd185df8266f7375924dcc732258e9e7
AUTHOR
Keith Alan Richardson
keith dot alan at gmail dot com
up