MySQL Forums - Source, Builds, Binaries

Problem linking (no replies)

shawn andrews — Fri, 17 May 2013 16:13:52 +0000

I'm trying to use C++ and SQL in Visual Studio, and trying to load a SQL example to make sure it's working.

This is the example project taken from [url="[url]http://www.nitecon.com/tutorials-articles/develop/cpp/c-mysql-beginner-tutorial/"[/url];]link[/url]

[code]

#include "my_global.h" // Include this file first to avoid problems
#include "mysql.h" // MySQL Include File
#define SERVER "localhost"
#define USER "username"
#define PASSWORD "password"
#define DATABASE "databasename"

#include
using namespace std;

#include "my_global.h" // Include this file first to avoid problems
#include "mysql.h" // MySQL Include File
#define SERVER "localhost"
#define USER "username"
#define PASSWORD "password"
#define DATABASE "databasename"

int main()
{
MYSQL *connect; // Create a pointer to the MySQL instance
connect=mysql_init(NULL); // Initialise the instance
/* This If is irrelevant and you don't need to show it. I kept it in for Fault Testing.*/
if(!connect) /* If instance didn't initialize say so and exit with fault.*/
{
fprintf(stderr,"MySQL Initialization Failed");
return 1;
}
/* Now we will actually connect to the specific database.*/

connect=mysql_real_connect(connect,SERVER,USER,PASSWORD,DATABASE,0,NULL,0);
/* Following if statements are unneeded too, but it's worth it to show on your
first app, so that if your database is empty or the query didn't return anything it
will at least let you know that the connection to the mysql server was established. */

if(connect){
printf("Connection Succeeded\n");
}
else{
printf("Connection Failed!\n");
}
MYSQL_RES *res_set; /* Create a pointer to recieve the return value.*/
MYSQL_ROW row; /* Assign variable for rows. */
mysql_query(connect,"SELECT * FROM TABLE");
/* Send a query to the database. */
unsigned int i = 0; /* Create a counter for the rows */

res_set = mysql_store_result(connect); /* Receive the result and store it in res_set */

unsigned int numrows = mysql_num_rows(res_set); /* Create the count to print all rows */

/* This while is to print all rows and not just the first row found, */

while ((row = mysql_fetch_row(res_set)) != NULL){
printf("%s\n",row != NULL ?
row : "NULL"); /* Print the row data */
}
mysql_close(connect); /* Close and shutdown */

system("pause");
return 0;
}

[/code]

Errors:

1>------ Build started: Project: connectSQL, Configuration: Debug Win32 ------ 1>main.obj : error LNK2019: unresolved external symbol _mysql_close@4 referenced in function _main 1>main.obj : error LNK2019: unresolved external symbol _mysql_fetch_row@4 referenced in function _main 1>main.obj : error LNK2019: unresolved external symbol _mysql_num_rows@4 referenced in function _main 1>main.obj : error LNK2019: unresolved external symbol _mysql_store_result@4 referenced in function _main 1>main.obj : error LNK2019: unresolved external symbol _mysql_query@8 referenced in function _main 1>main.obj : error LNK2019: unresolved external symbol _mysql_real_connect@32 referenced in function _main 1>main.obj : error LNK2019: unresolved external symbol _mysql_init@4 referenced in function _main 1>C:\Users\Shawn\Documents\Visual Studio 2010\Projects\connectSQL\Debug\connectSQL.exe : fatal error LNK1120: 7 unresolved externals ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

Include/Headers/Libs:

VC++ Directories->Include Directory->C:\Program Files\MySQL\MySQL Server 5.6\include VC++ Directories->Library Directory->C:\Program Files\MySQL\MySQL Server 5.6\lib VC++ Directories->Bin Directory->C:\Program Files\MySQL\MySQL Server 5.6\bin Linker->Input->Additional Dependencies->libmysql.lib

And I put libmysql.lib in Program Files(x86)->Microsoft Visual Studio 10.0->VC->lib which is where I believe i'm supposed to put it.

Compiling 5.6.11 from Source (5 replies)

Frank Malens — Fri, 24 May 2013 19:42:33 +0000

Hello everyone,
i am trying to compile 5.6.11 from Source on a Raspberry Pi with Raspian Linux (optimised version of Debian)

ncurses 5.9 and cmake 2.8.10 are allready compiled

I used this command:
sudo cmake . -DCMAKE_INSTALL_PREFIX=/data/mysql -DWITH_INNOBASE_STORAGE_ENGINE=1

And when i use the sudo make command i get this error:

[ 63%] Building CXX object sql/CMakeFiles/sql.dir/unireg.cc.o
[ 63%] Building C object sql/CMakeFiles/sql.dir/__/libmysql/errmsg.c.o
[ 63%] Building C object sql/CMakeFiles/sql.dir/__/sql-common/client.c.o
[ 63%] Building C object sql/CMakeFiles/sql.dir/__/sql-common/client_plugin.c.o
/work/mysql-5.6.11/sql-common/client_plugin.c: In function âmysql_client_plugin_initâ:
/work/mysql-5.6.11/sql-common/client_plugin.c:252:5: error: incompatible type for argument 5 of âadd_pluginâ
/work/mysql-5.6.11/sql-common/client_plugin.c:120:1: note: expected âva_listâ but argument is of type âintâ
/work/mysql-5.6.11/sql-common/client_plugin.c: In function âmysql_client_register_pluginâ:
/work/mysql-5.6.11/sql-common/client_plugin.c:310:5: error: incompatible type for argument 5 of âadd_pluginâ
/work/mysql-5.6.11/sql-common/client_plugin.c:120:1: note: expected âva_listâ but argument is of type âintâ
make[2]: *** [sql/CMakeFiles/sql.dir/__/sql-common/client_plugin.c.o] Error 1
make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2
make: *** [all] Error 2

I was unable to find something about this on the internet. I hope you can help me
Thanks

libmysql.dll 5.6.11 failed to load in windows 8 (64bits) (1 reply)

Fernando Pereira — Fri, 03 May 2013 00:04:27 +0000

Hello. I'm trying to use this DLL but it seems to have a problem.
My software used to work with the previous versions of this DLL.

Problem: Failed to load library (Microsoft's function getLastError() returns error code 193).

Then I tried to see what the TDUMP returns and it returns: Error: Internal Error at 0x42213f with base 0x400000.

Steps to reproduce:
1. Download the MySQL 5.6 for windows (installer or zip package).
2. Install/uncompress (I've a 64bits windows 8).
3. Open Windows Command Prompt (cmd).
4. Access the libmysql folder (cd C:\Mysql...).
5. Run tdump (tdump libmysql.dll)

Unable to download MySQL 5.6.11 (2 replies)

Jason S — Mon, 29 Apr 2013 19:40:28 +0000

I have gone to http://dev.mysql.com/downloads/installer/ from IE, Chrome and Firefox and for the life of me can't get a download to initiate. Is anyone else having that problem?

It takes me to a page that shows only: Begin Your Download - mysql-installer-community-5.6.11.0.msi

Yet there are no links, buttons, anything other than the menus on the left. I just want to know if I'm going crazy or something.

What are the steps I have to take after compilation and installation? (5 replies)

Tomas Sandven — Fri, 12 Apr 2013 14:35:56 +0000

It was pretty straight-forward to compile and install MySQL to my home directory. I used this command:

cmake -D MYSQL_DATADIR=/home/tomas/mysql/data -D SYSCONFDIR=/home/tomas/mysql/etc -D CMAKE_INSTALL_PREFIX=/home/tomas/mysql .

Now I have MySQL installed in the folder '/home/tomas/mysql'. What now? The server refuses to start because I'm lacking the tables in the mysql database, and mysql_install_db is refusing to work without giving me any reason as far as I can tell.

If anybody could spell the process out for me that would help a lot, and I'm sure future visitors would be grateful as well!

Thanks

---

More details about my specific problem: http://serverfault.com/questions/498380/how-do-i-install-the-initial-mysql-tables-after-a-compilation-from-source

MySQL Embedded server on Windows hang in mysql_init with INFINITE WaitForSingleObject (no replies)

Ismael Briones Vilar — Mon, 08 Apr 2013 21:05:43 +0000

Hi.

I'm trying build a program with MinGW (4.7), using libmysqld, but it enter in a loop in mysql_init and never get out of this function. I debuged it and this is the call stack:

myslq_init
mysql_server_init
init_embedded_server
init_server_components
plugin_init
plugin_initialize
int (** plugin_type_initialize)(st_plugin_int *)
innobase_start_or_create_for_mysql
recv_recovery_from_checkpoint_start_func
recv_synchronize_groups
rw_lock_s_lock_spin
sync_array_wait_event
os_event_wait_low
WaitForSingleObject - with a wait time of INFINITE

What is the problem?

This is the program:

#include
#include
#include
#include

MYSQL *mysql;
MYSQL_RES *results;
MYSQL_ROW record;

static char *server_options[] = {"mysql_test",
"--defaults-file=c:\\mysql_embedded\\my.ini",
NULL };
int num_elements = (sizeof(server_options) / sizeof(char *)) - 1;
static char *server_groups[] = {"embedded", "server", NULL };

int main(void)
{
mysql_library_init(num_elements, server_options, (char **)server_groups);

mysql = mysql_init(mysql);

mysql_library_end();

return 0;
}

This is my.ini:

[embedded]
basedir=C:/mysql_embedded
datadir=C:/mysql_embedded/data
language=C:/mysql_embedded/share/english

[server]
basedir=C:/mysql_embedded
datadir=C:/mysql_embedded/data
language=C:/mysql_embedded/share/english

I compile with:

g++ -o test test.cpp -Id:\MySQLServer5.6.10\include -Ld:\MySQLServer5.6.10\lib -l libmysqld -D__LCC__

I have tried with different version of libmysqld: MySQL 5.1.68, 5.5.30, 5.6.10 but all hangs in myslq_init.

I'm running it in VMware.

What's the problem?

Setting MySQL_PROTOCOL_TCP in C or Objective C (1 reply)

Ken Bodnar — Tue, 26 Mar 2013 22:49:34 +0000

I built a MySQL client library for iOS 6 on a Mac. It worked perfectly on a local database because the MAC OS uses the Unix socket. I then added port forward libraries to a remote database. The client fails because it is attempting to use the /tmp/mysql.sock. I do not want it to use sockets, I want it to use TCP protocols. Going through the source, I found MYSQL_PROTOCOL_TCP and MYSQL_PROTOCOL_DEFAULT.

These are easy to set from the command line with --protocol=TCP.

How would I set these programatically in the code when invoking the connection object which inits mysql?

Thanks in advance.

Cross Compile Connector/C(libmysql) for Linux/PowerPC architecture (2 replies)

Niranjan Mahabaleshwar — Fri, 05 Apr 2013 06:08:23 +0000

I want to cross compiling libmysql for Linux/PowerPC. Hence I downloaded the source code, made changes to CMake so that the compiler in my tool chain is used (ppc_4xx-gcc and ppc_4xx-g++). Then when I start to build I get problems because of collision in my toolchain and libmysql wrt openssl.

openssl header files are present both in libmysql source and my toolchain as shown below

libmysql - /extlib/yassl/include/openssl
toolchain - /opt/ELDK/4.2/ppc_4xx/usr/include/openssl

Hence when the files in libmysql are being compiled I get collisions because of my toolchain. How should I proceed ? I guess I shoule use files present in libmysql rather my toolchain wrt openssl.

I provide the include path /opt/ELDK/4.2/ppc_4xx/usr/include to CMake as it contains all the standard libraries, but this enables files in openssl being used for compilation. How can I make sure files for openssl from my toolchain are not used ?

Or am I missing something elementary ? Has anyone done something similar ?

PS: CMAKE Version 2.8.10.2

Error compiling 5.5.9 on Snow Leopard with cmake (1 reply)

Tony Sherwood — Thu, 21 Mar 2013 21:09:37 +0000

Hi, first time compiler here... I'm attempting to compile mysql 5.5.9 on Snow Leopard so that I can get the header files to copy into my MAMP directory so that the mysql2 gem will install so that I can start learning Rails. :) The compilation fails because it thinks my compiler is broken, and I'm not sure what to do. Relevant information below. Can anyone help me resolve this?

Oh, and I found this thread with the same problem, and tried Casey's fix, but it didn't work: http://forums.mysql.com/read.php?117,389447,389478#msg-389478

-----------------------------------------------

I got the source for mysql out of the MAMP components zip file available at:

http://sourceforge.net/projects/mamp/files/mamp/2.0.2/MAMP_components_2.0.2.zip/download

-----------------------------------------------

REDACTED:mysql-5.5.9 REDACTED$ gcc -v
Using built-in specs.
Target: i686-apple-darwin10
Configured with: /var/tmp/gcc/gcc-5666.3~6/src/configure --disable-checking --enable-werror --prefix=/usr --mandir=/share/man --enable-languages=c,objc,c++,obj-c++ --program-transform-name=/^[cg][^.-]*$/s/$/-4.2/ --with-slibdir=/usr/lib --build=i686-apple-darwin10 --program-prefix=i686-apple-darwin10- --host=x86_64-apple-darwin10 --target=i686-apple-darwin10 --with-gxx-include-dir=/include/c++/4.2.1
Thread model: posix
gcc version 4.2.1 (Apple Inc. build 5666) (dot 3)

-------------------------------------------------

cmake version 2.8.7

-------------------------------------------------

REDACTED:mysql-5.5.9 REDACTED$ cmake . -DMYSQL_UNIX_ADDR=/Applications/MAMP/tmp/mysql/mysql.sock -DCMAKE_INSTALL_PREFIX=/Applications/MAMP/Library > log.txt
CMake Error at /usr/local/Cellar/cmake/2.8.7/share/cmake/Modules/CMakeTestCCompiler.cmake:52 (MESSAGE):
The C compiler "/usr/bin/cc" is not able to compile a simple test program.

It fails with the following output:

Change Dir: /tmp/mysql-5.5.9/CMakeFiles/CMakeTmp

Run Build Command:/usr/bin/make "cmTryCompileExec/fast"

/usr/bin/make -f CMakeFiles/cmTryCompileExec.dir/build.make
CMakeFiles/cmTryCompileExec.dir/build

/usr/local/Cellar/cmake/2.8.7/bin/cmake -E cmake_progress_report
/tmp/mysql-5.5.9/CMakeFiles/CMakeTmp/CMakeFiles 1

Building C object CMakeFiles/cmTryCompileExec.dir/testCCompiler.c.o

/usr/bin/cc -isysroot -o CMakeFiles/cmTryCompileExec.dir/testCCompiler.c.o
-c /tmp/mysql-5.5.9/CMakeFiles/CMakeTmp/testCCompiler.c

i686-apple-darwin10-gcc-4.2.1:
CMakeFiles/cmTryCompileExec.dir/testCCompiler.c.o: No such file or
directory

make[1]: *** [CMakeFiles/cmTryCompileExec.dir/testCCompiler.c.o] Error 1

make: *** [cmTryCompileExec/fast] Error 2

CMake will not be able to correctly generate this project.
Call Stack (most recent call first):
CMakeLists.txt:83 (PROJECT)

---------------------------------------------------------

If anyone could help, I'd appreciate it. This is really annoying.

Build fails Mysql 5.6.10 CMake 2.8.10.2 Centos 5.7 (2 replies)

dingling liu — Sun, 24 Mar 2013 01:45:14 +0000

I get the following error when I build Mysql5.6.10

plane Centos 5.7 x86_64
CMake 2.8.10.2

Scanning dependencies of target sql
[ 52%] Building CXX object sql/CMakeFiles/sql.dir/sql_yacc.cc.o
c++: Internal error: Killed (program cc1plus)
Please submit a full bug report.
See http://bugzilla.redhat.com/bugzilla>; for instructions.
make[2]: *** [sql/CMakeFiles/sql.dir/sql_yacc.cc.o] Error 1
make[1]: *** [sql/CMakeFiles/sql.dir/all] Error 2
make: *** [all] Error 2

Any advice would be appreciated.
Thank you

BUILD/autorun.sh not found (1 reply)

Dennis Rodman — Sat, 09 Mar 2013 02:12:38 +0000

Hello, I just downloaded a fresh install of Mysql v.5.1.68 on Linux.

I am now trying to run the following command to get SphinxSE installed:

# sh BUILD/autorun.sh

I am entering that from within my mysql folder, and received the following error:

"No such file or directory"

Naturally, I checked within the folder to see, and nope, no BUILD directory there (or autorun.sh file, either).

Can anybody advise? I downloaded this version of MySQL straight from mysql.com. I am not quite ready to update at this time, hence my needing to download a (relatively) older version (5.1.68).

Any ideas on how to get that directory/file into the build? Or, a possible workaround?

Here are the instructions I've been following to install SphinxSE onto my system (I'm now stuck at the part about running # sh BUILD/autorun.sh):

http://sphinxsearch.com/wiki/doku.php?id=sphinx_sphinxse_on_rhel

(possible workaround?)

Build fails "st_mysql_const_lex_string" undefined (2 replies)

Sebastian Kloska — Wed, 06 Mar 2013 11:50:01 +0000

Trying to compile mysql-5.6.10 fails for me.

I'm compiling on a gentoo based system on which many development tools (including cmake) are hand-rolled i.e. do not originate from the distro but are compiled from scratch. "cmake ." works without trouble but a "make " gives me

.../include/m_string.h:283:10: error: dereferencing pointer to incomplete type

It seems st_mysql_const_lex_string is not known and the cpmpiler doesn't have a clue what to make with LEX_STRING. On a Fedora 18 everything works just fine

Any help will be highly appreciated

Sebastian

CPack errors when building Connector/C 6.0.2 (1 reply)

Robert Hegner — Fri, 15 Feb 2013 12:26:47 +0000

I get the following two errors when I try to generate the Visual Studio 2010 build files for MySQL Connector/C 6.0.2 with CMake 2.8.10.2 on Windows 7 x64.

CMake Error at /usr/share/cmake-2.8/Modules/CPack.cmake:395 (message):
CPack package description file: "README" could not be found.
Call Stack (most recent call first):
/usr/share/cmake-2.8/Modules/CPack.cmake:399 (cpack_check_file_exists)
CMakeLists.txt:371 (INCLUDE)

CMake Error at /usr/share/cmake-2.8/Modules/CPack.cmake:395 (message):
CPack license resource file: "LICENSE.mysql" could not be found.
Call Stack (most recent call first):
/usr/share/cmake-2.8/Modules/CPack.cmake:400 (cpack_check_file_exists)
CMakeLists.txt:371 (INCLUDE)

I also get the same errors when trying to generate Unix Makefiles in Debian Wheezy with CMake 2.8.9

Segmentation Fault after MySQL login (1 reply)

Jim Anderson — Mon, 25 Feb 2013 04:05:40 +0000

I'm trying to install MySQL 5.5.18 on a Linux Redhat environment. I've compile and install the binaries using cmake but when I try to connect to the database I get a segmentation fault error rather than the sql prompt.

Ex error:

mysql -u root -p
password:

Segmentation Fault

When MySQL 5.6 GA release available (2 replies)

Ben Zhou — Sun, 17 Feb 2013 00:16:06 +0000

Anybody know if there is a timeline for MySQL community server 5.6 GA release?

We are looking at 'Fractional Seconds in Time Values' feature that MySQL added in 5.6.4. Currently, MySQL 5.6 is still in Development Release.

Thanks a lot!
Ben

Build from Source on Windows 7 Ultimate x64 (no replies)

Dai Nishikawa — Thu, 31 Jan 2013 13:46:08 +0000

I have downloaded the zip package of source code for Windows. I created an install directory naming it 'MySQL' under the Program Files folder and tried to run mysqld.exe, then mysql.exe only to get the results below:

130131 22:30:30 [Warning] Can't create test file c:\program files\mysql\data\tyo
dev001.lower-test
130131 22:30:30 [Warning] Can't create test file c:\program files\mysql\data\tyo
dev001.lower-test
130131 22:30:30 [Note] Plugin 'FEDERATED' is disabled.
130131 22:30:30 InnoDB: The InnoDB memory heap is disabled
130131 22:30:30 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130131 22:30:30 InnoDB: Compressed tables use zlib 1.2.3
130131 22:30:30 InnoDB: Initializing buffer pool, size = 128.0M
130131 22:30:30 InnoDB: Completed initialization of buffer pool
130131 22:30:30 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.

C:\Windows\system32>"c:\program files\mysql\bin\mysql.exe"
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

I researched the error message on the web but could not work out whether there is something to perform before successfully launching mysql. Any advice would be appreciated.

Thank you,

Ead

How to get old Mysql version binaries ( zip archives ) for Linux . (2 replies)

sandeep thakur — Tue, 05 Feb 2013 16:26:35 +0000

Hi,

I am looking for mysql-5.5.20 GA Linux binaries in order to install it on my Linux system. Can someone please help me out from where I can get the binary distribution of old Mysql packages. I don't want to use rpm or source distribution.

Regards,
Sandeep Thakur

reducing MySQL footprint (Disk space) (no replies)

keith sutton — Mon, 21 Jan 2013 15:40:05 +0000

Hi Everyone,

I am working on a project whereby the system has limited disk space.
I am trying to reduce the physical on disk space of MySQL and have removed unneeded files, (documentation, debug, test, etc.) and found that I can compile the source and further reduce the size.

I have looked at the "MySQL Source-Configuration Options" page found here: http://dev.mysql.com/doc/refman/5.1/en/source-configuration-options.html
Can someone tell me about their experience, steps they have taken to reduce the footprint of MySQL on disk. I am not too concerned about in memory usage at this time as I will address that at a later time.

Thanks,
Keith

WiX Installer Package with Instance Configuration Wizard (no replies)

Elmar Teitge — Tue, 15 Jan 2013 15:56:21 +0000

Hello,

I have built the community-server version 5.5.29 from source with Visual Studio MSI projekt. The msi package installs all needed folders, but does not start the instance configuration wizard.
Is this wizard not included with the sources, or have I done an error in the build settings?

Thanks a lot for your help.

Where to get MYSQL ODBC 5.2w driver (1 reply)

Melvin Stober — Wed, 16 Jan 2013 22:09:26 +0000

Where can I download the MySQL ODBC 5.2w driver? I have a datasource in MS-Windows 7 64-bit computer that uses it but apparently the driver is not installed. When I try to remove the dsn I get the error message that it can not find the driver. I've done several google searches and can find anywhere to download the driver.

Building ODBC connector on Windows : "Apparently odbc headers could not be found." (no replies)

Guillaume F — Tue, 08 Jan 2013 10:41:21 +0000

Hi,

Attempting to build 64bits ODBC connector on Windows (debug version).

Cmake execution is raising this message :
"Apparently odbc headers could not be found. 2nd and 3rd parameters assumed to be (*)SQLULEN by default"

Full output :
"-- Configuring to build Unicode driver
-- MySQL Include dir: C:/Program Files/MySQL/MySQL Server 5.5/include library dir: C:/Program Files/MySQL/MySQL Server .5/lib/debug
-- MySQL client libraries: mysqlclient;ws2_32
-- Checking if SQLColAttribute last arg is compatible with SQLLEN* - FALSE
-- Checking if SQLColAttribute last arg is compatible with SQLPOINTER - FALSE
-- Checking if SQLParamOptions() 2nd and 3rd arg is compatible with SQLULEN - FALSE
-- Checking if SQLParamOptions() 2nd and 3rd arg is compatible with SQLUINTEGER - FALSE
-- Apparently odbc headers could not be found. 2nd and 3rd parameters assumed to be (*)SQLULEN by default
-- Enabling threads support
-- MySQL client lib(version 50529) requires Secure32.lib - TRUE
-- Configuring done
-- Generating done
-- Build files have been written to:"

Command line is :
cmake -G "Visual Studio 9 2008 Win64" -DCMAKE_BUILD_TYPE=Debug

Build finally succeeds, so should I ignore ? How do I feed Cmake the Windows SDK include / lib folders location ?

Thanks.

Guillaume

UDF question (no replies)

Pieter Huiberts — Thu, 20 Dec 2012 14:15:19 +0000

I like to create UDF in MySQL to make some functions run faster. I understand that they can be written in C or C++. Out web page goes between MysQL and MSSQL database depending on the customer.

Problem is that I don't know C or C++, instead I can do VB (or C#) .NET. Is it possible to create the code in VB, compile the binary and load it up as a UDF in MySQL?

Didn't find examples, which is a bit of a sign...

abort cmake of Mysql 5.6.8 (2 replies)

mickey vle — Fri, 21 Dec 2012 10:52:06 +0000

can i Modify the “OPTION(WITH_INNODB_MEMCACHED "" OFF)” to ”OPTION(WITH_INNODB_MEMCACHED "Enable InnoDB Memcache" ON)“ in the CMakeLists.txt. Because i want to using innodb+memcache 。Anybody can help me ？

CAn we edit Mysql login screen (4 replies)

ADITYA PULIKANTI — Sun, 16 Dec 2012 14:25:00 +0000

HI Everyone,
I need your help. Can we edit the mysql login screen page.( linux)
**************************************************************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.66 Source distribution

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

********************************************************************

PLeas help me in this reg

When replacing storage engine, how is mysql_declare_plugin read? (no replies)

Scott Simpson — Wed, 28 Nov 2012 01:51:31 +0000

I'm building mysql on Windows under cygwin (I'm taking over the code for someone else). We have a custom storage engine I have the source code for. It uses the

mysql_declare_plugin

call to declare our storage engine. I'm statically linking this code into mysqld.exe but it isn't finding our storage engine. How are the storage engines registered? I assume that there is a struct somewhere I'm not populating correctly. Thanks.

Add new file to a project, via cmake (1 reply)

F. Vlad — Sun, 25 Nov 2012 02:32:24 +0000

Hello,

I'm using mysql as GPL project, and I must add a few functions and export them, using Visual Studio 2010. I must do that inside libmysqld project. I must add a new file, that must compile using c++ compiler, and also add the exported functions to the .def file. I can do that at once in Visual Studio. Now, the problem is that I will have to make the source code available to others. That won't be a problem. The problem is that I would rather add the code to the new file, and modify cmake scripts in order to add that file to the project, and compile it with C++. I found out on how to set a file to be compiled with c++, but how do I add a new file to libmysqld project?
I tried inside libmysqld\CMakeLists.txt, I added myfile.cpp inside the SET(SQL_EMBEDDED_SOURCES ...) and I copied the file inside libmysqld\ folder also. Still, after running cmake . -G "Visual Studio 10", I can't find my file in the project. The same must happen to a .def file that contains the function names that I export from the new libmysqld.dll.
Anybody could tell me how to add a file to libmysqld project, using cmake scripts?
I would appreciate it very much!

Thank you,
V.

issues with configuring cmake options and OpenSSL (1 reply)

Jim Rice — Fri, 02 Nov 2012 19:29:53 +0000

Any ideas on how to pass the MYSQL_CHECK_SSL tests?

I've tried setting variables for OPENSSL_ROOT_DIR, OPENSSL_LIBRARIES and OPENSSL_INCLUDE_DIR, but still no joy ...

solaris-build# cmake -DCMAKE_C_FLAGS=-m64 -DCMAKE_CXX_FLAGS=-m64 -DWITH_SSL=system .
-- MySQL 5.5.27-ndb-7.2.8
-- Packaging as: mysql-cluster-7.2.8-solaris10-x86_64
CMake Error at cmake/ssl.cmake:83 (MESSAGE):
Cannot find appropriate system libraries for SSL. Use WITH_SSL=bundled to
enable SSL support
Call Stack (most recent call first):
CMakeLists.txt:266 (MYSQL_CHECK_SSL)

What am I missing here?

Cross compile woes (no replies)

Keith McRae — Wed, 31 Oct 2012 16:45:29 +0000

I'm trying to cross compile 5.5.28 to ARM. I've followed the various articles on the net and cmake runs fine. However when I run make, I notice:

[ 7%] Building C object cmd-line-utils/libedit/CMakeFiles/edit.dir/np/vis.c.o
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/vis.c: In function `isnvis':
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/vis.c:311: warning: implicit declaration of function `_DIAGASSERT'
[ 7%] Building C object cmd-line-utils/libedit/CMakeFiles/edit.dir/np/unvis.c.o
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/unvis.c: In function `unvis':
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/unvis.c:220: warning: implicit declaration of function `_DIAGASSERT'
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/unvis.c:449: warning: implicit declaration of function `__arraycount'
[ 7%] Building C object cmd-line-utils/libedit/CMakeFiles/edit.dir/np/strlcpy.c.o
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/strlcpy.c: In function `strlcpy':
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/strlcpy.c:60: warning: implicit declaration of function `_DIAGASSERT'
[ 7%] Building C object cmd-line-utils/libedit/CMakeFiles/edit.dir/np/strlcat.c.o
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/strlcat.c: In function `strlcat':
/home/keith.mcrae/src/mysql-5.5.28-Linux-arm/cmd-line-utils/libedit/np/strlcat.c:63: warning: implicit declaration of function `_DIAGASSERT'

Everything else builds ok, but then:

Linking CXX executable mysql
../cmd-line-utils/libedit/libedit.a(vis.c.o)(.text+0x600): In function `isnvis':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(vis.c.o)(.text+0x60c): In function `isnvis':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(vis.c.o)(.text+0x7d0): In function `istrsnvis':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(vis.c.o)(.text+0x7dc): In function `istrsnvis':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(vis.c.o)(.text+0x7e8): In function `istrsnvis':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(vis.c.o)(.text+0x998): more undefined references to `_DIAGASSERT' follow
../cmd-line-utils/libedit/libedit.a(el.c.o)(.text+0x868): In function `el_source':
: undefined reference to `libedit_fgetln'
../cmd-line-utils/libedit/libedit.a(historyn.c.o)(.text+0xb04): In function `history_load':
: undefined reference to `libedit_fgetln'
../cmd-line-utils/libedit/libedit.a(historyn.c.o)(.text+0xbf8): In function `history_load':
: undefined reference to `libedit_fgetln'
../cmd-line-utils/libedit/libedit.a(unvis.c.o)(.text+0x1c): In function `unvis':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(unvis.c.o)(.text+0x28): In function `unvis':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(unvis.c.o)(.text+0x678): In function `unvis':
: undefined reference to `__arraycount'
../cmd-line-utils/libedit/libedit.a(unvis.c.o)(.text+0x690): In function `unvis':
: undefined reference to `__arraycount'
../cmd-line-utils/libedit/libedit.a(unvis.c.o)(.text+0x760): In function `strnunvisx':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(unvis.c.o)(.text+0x76c): In function `strnunvisx':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(unvis.c.o)(.text+0x7ec): In function `strnunvisx':
: undefined reference to `_DIAGASSERT'
../cmd-line-utils/libedit/libedit.a(history.c.o)(.text+0xb08): In function `history_load':
: undefined reference to `libedit_fgetln'
../cmd-line-utils/libedit/libedit.a(history.c.o)(.text+0xc08): In function `history_load':
: undefined reference to `libedit_fgetln'
collect2: ld returned 1 exit status
make[2]: *** [client/mysql] Error 1
make[1]: *** [client/CMakeFiles/mysql.dir/all] Error 2
make: *** [all] Error 2

I found _DIAGASSERT in cmd-line-utils/libedit/sys.h as:
#ifndef _DIAGASSERT
#define _DIAGASSERT(x)

My theory is that GCC (version 3.3.2 for ARM) is including the sys.h from /usr/local/arm-linux/include (which doesn't define _DIAGASSERT) rather than the one from cmd-line-utils/libedit/ ?
If this is the case, how do I tell cmake to use the one from libedit rather than /usr/local/arm-linux please?

As I read it, _DIAGASSERT is an empty function, so as a 'last resort' I could just comment out the calls in the affected .c files. Any thoughts on this?

Thanks in advance
Keith

Mysql Enterprise Edition 1-4 Socket Server (1 reply)

Mannoj Kumar — Wed, 12 Sep 2012 12:00:40 +0000

Hi Folks,

When I check for price tags for Mysql, I see a clause called "1-4 socket server" or "5+ Socket Server".. what does it means? Socket in generic term means Inter Communication Protocol. And for Mysql a socket unix file helps to communicate Mysql server and Mysql client within local server. And that exists only one as far as I know for one mysql server instance. Please correct me if my understanding is wrong. Kindly shed some light what is meant by 4, 5+ sockets as I see cost increases as socket numbers rises and advantages of it.

Thanks!!

Compiling a driver for Qt (no replies)

Zenn Celdor — Fri, 17 Aug 2012 00:41:19 +0000

Hi,

I came here from Qt Center and Qt Project forums because there is nobody who gave me reasonable answer so far.

My question is if there is anybody here who develops applications using QtSDK? I recently wanted to connect my brand new application made in the framework Qt to MySql server but I found that a file/driver called QMYSQL is missing. The documentations says that I need to compile this module by myself.

In their website, I found that I would need mysql libraries. Those libraries are used by a C++ compiler. They are supposed to be installed along with main program if I am to choose custom installation with them. The documentation on this webiste:
http://doc.qt.nokia.com/4.7-snapshot/sql-driver.html#qmysql
in section regarding windows states that I can find the libraries in the folder \lib\opt. However when I inspect the mysql folder in my machine, there is not such folder. I installed any possible file from setup. Was this folder "lib\opt" there in previous versions of mysql?

I though it could be changed so I tried to specify the folder \lib instead and the compilation began. However, after a while, make found a missing file mysql.lib. There is nowhere I can see this file!!! Can someone help with this issue please?

The procedure is that, essentially, to make this module, I need to run the command:
qmake "INCLUDEPATH+=include" "LIBS+=libmysql.lib" mysql.pro

that produces a Makefile. include and libmysql.lib are the folder and the file copied from the mysql folder. Then I can run make. When make is executed, after a while the error appears that there is no file mysql.lib. PLease if you want to see logs from the compilation, they are here:
http://www.qtcentre.org/threads/50581-Huge-problems-while-installing-QMYSQL-driver?p=227313&highlight=#post227313
quite long. In Qt, nobody can help, I have hope perhaps someone here can help.

Regards

PS. I m sorry. Probably the English is not very good and I did not expressed things I should have. I hope you can understand the problem.