mysqldb on cygwin

Pehaba,

does anyone knows how to install MySQLdb on cygwin?

- test device: MySQLdb 0.9.2.0 targz + cygwin
1.5.7-cr-0x9e + python
2.3.3 [GCC 3.3.1 (cygming special)] on cygwin + mysql
4.0.17 win32
- modified setup.py's using thread library.. NO,
library + include
path also
- result:

dody@D /tmp/MySQL-python-0.9.2
$ python setup.py build
running build
running build_py
running build_ext
building '_mysql' extension
creating build/temp.cygwin-1.5.7-i686-2.3
gcc -fno-strict-aliasing -DNDEBUG -g -O3 -Wall
-Wstrict-prototypes -I/cygdrive/c
/mysql/include -I/usr/include/python2.3 -c _mysql.c -o
build/temp.cygwin-1.5.7-i
686-2.3/_mysql.o -DMS_WIN32
In file included from _mysql.c:41:
/cygdrive/c/mysql/include/mysql.h:42:1: warning: "STDCALL"
redefined
In file included from /usr/include/w32api/windows.h:48,
from _mysql.c:34:
/usr/include/w32api/windef.h:105:1: warning: this is the
location of the previou
s definition
_mysql.c: In function `_mysql_ConnectionObject_info':
_mysql.c:1150: warning: assignment discards qualifiers
from pointer target type
_mysql.c: In function `_mysql_ConnectionObject_stat':
_mysql.c:1379: warning: assignment discards qualifiers
from pointer target type
_mysql.c: At top level:
_mysql.c:2007: warning: initialization from incompatible
pointer type
_mysql.c:2096: warning: initialization from incompatible
pointer type
gcc -shared -Wl,--enable-auto-image-base
build/temp.cygwin-1.5.7-i686-2.3/_mysql
...o -L/cygdrive/c/mysql/lib/opt
-L/usr/lib/python2.3/config -lmysqlclient -lz -lp
ython2.3 -o build/lib.cygwin-1.5.7-i686-2.3/_mysql.dll
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x67): In
function `_mysql_Excep
tion':
/tmp/MySQL-python-0.9.2/_mysql.c:110: undefined reference
to `_mysql_errno'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0xdf):/tmp/MySQL-python-0.9.2/_m
ysql.c:159: undefined reference to `_mysql_error'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2d5): In
function `_mysql__fet
ch_row':
/tmp/MySQL-python-0.9.2/_mysql.c:924: undefined reference
to `_mysql_fetch_row'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x329):/tmp/MySQL-python-0.9.2/_
mysql.c:944: undefined reference to `_mysql_errno'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x366):/tmp/MySQL-python-0.9.2/_
mysql.c:927: undefined reference to `_mysql_fetch_row'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0xbf0): In
function `_mysql_thre
ad_safe':
/tmp/MySQL-python-0.9.2/_mysql.c:174: undefined reference
to `_mysql_thread_safe
'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0xccb): In
function `_mysql_Resu
ltObject_Initialize':
/tmp/MySQL-python-0.9.2/_mysql.c:212: undefined reference
to `_mysql_use_result'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0xceb):/tmp/MySQL-python-0.9.2/_
mysql.c:221: undefined reference to `_mysql_num_fields'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0xd16):/tmp/MySQL-python-0.9.2/_
mysql.c:224: undefined reference to `_mysql_fetch_fields'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0xdca):/tmp/MySQL-python-0.9.2/_
mysql.c:214: undefined reference to `_mysql_store_result'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1007):
In function `_mysql_Con
nectionObject_Initialize':
/tmp/MySQL-python-0.9.2/_mysql.c:315: undefined reference
to `_mysql_init'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1030):/tmp/MySQL-python-0.9.2/
_mysql.c:322: undefined reference to `_mysql_options'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1055):/tmp/MySQL-python-0.9.2/
_mysql.c:326: undefined reference to `_mysql_options'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x10ab):/tmp/MySQL-python-0.9.2/
_mysql.c:333: undefined reference to `_mysql_real_connect'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x10f0):/tmp/MySQL-python-0.9.2/
_mysql.c:332: undefined reference to `_mysql_options'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1106):/tmp/MySQL-python-0.9.2/
_mysql.c:330: undefined reference to `_mysql_options'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1120):/tmp/MySQL-python-0.9.2/
_mysql.c:328: undefined reference to `_mysql_options'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1146):/tmp/MySQL-python-0.9.2/
_mysql.c:318: undefined reference to `_mysql_options'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x12c6):
In function `_mysql_Con
nectionObject_close':
/tmp/MySQL-python-0.9.2/_mysql.c:420: undefined reference
to `_mysql_close'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1314):
In function `_mysql_Con
nectionObject_affected_rows':
/tmp/MySQL-python-0.9.2/_mysql.c:441: undefined reference
to `_mysql_affected_ro
ws'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x137d):
In function `_mysql_deb
ug':
/tmp/MySQL-python-0.9.2/_mysql.c:457: undefined reference
to `_mysql_debug'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x13e3):
In function `_mysql_Con
nectionObject_dump_debug_info':
/tmp/MySQL-python-0.9.2/_mysql.c:477: undefined reference
to `_mysql_dump_debug_
info'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1464):
In function `_mysql_Con
nectionObject_errno':
/tmp/MySQL-python-0.9.2/_mysql.c:497: undefined reference
to `_mysql_errno'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x14c4):
In function `_mysql_Con
nectionObject_error':
/tmp/MySQL-python-0.9.2/_mysql.c:513: undefined reference
to `_mysql_error'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x157a):
In function `_mysql_esc
ape_string':
/tmp/MySQL-python-0.9.2/_mysql.c:541: undefined reference
to `_mysql_real_escape
_string'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x15bd):/tmp/MySQL-python-0.9.2/
_mysql.c:544: undefined reference to
`_mysql_escape_string'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1694):
In function `_mysql_str
ing_literal':
/tmp/MySQL-python-0.9.2/_mysql.c:581: undefined reference
to `_mysql_real_escape
_string'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x16fc):/tmp/MySQL-python-0.9.2/
_mysql.c:584: undefined reference to
`_mysql_escape_string'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1dc1):
In function `_mysql_Res
ultObject_describe':
/tmp/MySQL-python-0.9.2/_mysql.c:730: undefined reference
to `_mysql_num_fields'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1dcf):/tmp/MySQL-python-0.9.2/
_mysql.c:731: undefined reference to `_mysql_fetch_fields'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1ebd):
In function `_mysql_Res
ultObject_field_flags':
/tmp/MySQL-python-0.9.2/_mysql.c:766: undefined reference
to `_mysql_num_fields'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1ecb):/tmp/MySQL-python-0.9.2/
_mysql.c:767: undefined reference to `_mysql_fetch_fields'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1f63):
In function `_mysql_row
_to_tuple':
/tmp/MySQL-python-0.9.2/_mysql.c:814: undefined reference
to `_mysql_num_fields'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x1f86):/tmp/MySQL-python-0.9.2/
_mysql.c:816: undefined reference to
`_mysql_fetch_lengths'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2056):
In function `_mysql_row
_to_dict':
/tmp/MySQL-python-0.9.2/_mysql.c:840: undefined reference
to `_mysql_num_fields'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2087):/tmp/MySQL-python-0.9.2/
_mysql.c:842: undefined reference to
`_mysql_fetch_lengths'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x209b):/tmp/MySQL-python-0.9.2/
_mysql.c:843: undefined reference to `_mysql_fetch_fields'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x23e6):
In function `_mysql_row
_to_dict_old':
/tmp/MySQL-python-0.9.2/_mysql.c:879: undefined reference
to `_mysql_num_fields'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2417):/tmp/MySQL-python-0.9.2/
_mysql.c:881: undefined reference to
`_mysql_fetch_lengths'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x242b):/tmp/MySQL-python-0.9.2/
_mysql.c:882: undefined reference to `_mysql_fetch_fields'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x27df):
In function `_mysql_Res
ultObject_fetch_row':
/tmp/MySQL-python-0.9.2/_mysql.c:1003: undefined reference
to `_mysql_num_rows'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x28e4):
In function `_mysql_Con
nectionObject_change_user':
/tmp/MySQL-python-0.9.2/_mysql.c:1050: undefined reference
to `_mysql_change_use
r'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2964):
In function `_mysql_Con
nectionObject_character_set_name':
/tmp/MySQL-python-0.9.2/_mysql.c:1072: undefined reference
to `_mysql_character_
set_name'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x29ae):
In function `_mysql_get
_client_info':
/tmp/MySQL-python-0.9.2/_mysql.c:1088: undefined reference
to `_mysql_get_client
_info'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2a04):
In function `_mysql_Con
nectionObject_get_host_info':
/tmp/MySQL-python-0.9.2/_mysql.c:1103: undefined reference
to `_mysql_get_host_i
nfo'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2a64):
In function `_mysql_Con
nectionObject_get_proto_info':
/tmp/MySQL-python-0.9.2/_mysql.c:1118: undefined reference
to `_mysql_get_proto_
info'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2ac4):
In function `_mysql_Con
nectionObject_get_server_info':
/tmp/MySQL-python-0.9.2/_mysql.c:1133: undefined reference
to `_mysql_get_server
_info'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2b26):
In function `_mysql_Con
nectionObject_info':
/tmp/MySQL-python-0.9.2/_mysql.c:1150: undefined reference
to `_mysql_info'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2bb1):
In function `_mysql_Con
nectionObject_insert_id':
/tmp/MySQL-python-0.9.2/_mysql.c:1186: undefined reference
to `_mysql_insert_id'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2c51):
In function `_mysql_Con
nectionObject_kill':
/tmp/MySQL-python-0.9.2/_mysql.c:1205: undefined reference
to `_mysql_kill'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2cd4):
In function `_mysql_Con
nectionObject_field_count':
/tmp/MySQL-python-0.9.2/_mysql.c:1228: undefined reference
to `_mysql_field_coun
t'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2d37):
In function `_mysql_Res
ultObject_num_fields':
/tmp/MySQL-python-0.9.2/_mysql.c:1242: undefined reference
to `_mysql_num_fields
'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2da7):
In function `_mysql_Res
ultObject_num_rows':
/tmp/MySQL-python-0.9.2/_mysql.c:1258: undefined reference
to `_mysql_num_rows'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2e23):
In function `_mysql_Con
nectionObject_ping':
/tmp/MySQL-python-0.9.2/_mysql.c:1282: undefined reference
to `_mysql_ping'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2ed9):
In function `_mysql_Con
nectionObject_query':
/tmp/MySQL-python-0.9.2/_mysql.c:1305: undefined reference
to `_mysql_real_query
'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x2f81):
In function `_mysql_Con
nectionObject_select_db':
/tmp/MySQL-python-0.9.2/_mysql.c:1335: undefined reference
to `_mysql_select_db'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x3013):
In function `_mysql_Con
nectionObject_shutdown':
/tmp/MySQL-python-0.9.2/_mysql.c:1356: undefined reference
to `_mysql_shutdown'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x30a1):
In function `_mysql_Con
nectionObject_stat':
/tmp/MySQL-python-0.9.2/_mysql.c:1379: undefined reference
to `_mysql_stat'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x325e):
In function `_mysql_Con
nectionObject_thread_id':
/tmp/MySQL-python-0.9.2/_mysql.c:1441: undefined reference
to `_mysql_thread_id'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x3479):
In function `_mysql_Con
nectionObject_dealloc':
/tmp/MySQL-python-0.9.2/_mysql.c:420: undefined reference
to `_mysql_close'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x35df):
In function `_mysql_Res
ultObject_data_seek':
/tmp/MySQL-python-0.9.2/_mysql.c:1521: undefined reference
to `_mysql_data_seek'

build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x3660):
In function `_mysql_Res
ultObject_row_seek':
/tmp/MySQL-python-0.9.2/_mysql.c:1537: undefined reference
to `_mysql_row_tell'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x3675):/tmp/MySQL-python-0.9.2/
_mysql.c:1538: undefined reference to `_mysql_row_seek'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x36d7):
In function `_mysql_Res
ultObject_row_tell':
/tmp/MySQL-python-0.9.2/_mysql.c:1553: undefined reference
to `_mysql_row_tell'
build/temp.cygwin-1.5.7-i686-2.3/_mysql.o(.text+0x372b):
In function `_mysql_Res
ultObject_dealloc':
/tmp/MySQL-python-0.9.2/_mysql.c:1562: undefined reference
to `_mysql_free_resul
t'
collect2: ld returned 1 exit status
error: command 'gcc' failed with exit status 1

dody@D /tmp/MySQL-python-0.9.2
$

================================================== =========================================
Akses Internet Prabayar TELKOMNet-Prepaid,
nominal Rp.10.000- Rp.150.000.
Dapatkan di Plasa - Plasa TELKOM terdekat (khusus di Jawa Timur)
================================================== =========================================

Jul 18 '05 #1

Subscribe Post Reply

2307

by: Dave Harrison | last post by:

Hi all, got a problem combinging mx and MySQLdb, when I build and install both for my Python2.1 install on a Solaris 9 box I can import mx fine, but importing MySQLdb causing python to core dump. ...

Python

MySQLdb installed, won't connect on OSX

by: Peter Nikolaidis | last post by:

Greetings, I am attempting to get MySQLdb 0.9.2 installed on Mac OS 10.2 with a Fink distribution of Python 2.2.2. I have seen only a few posts on the subject, some of them relate to...

Python

Installing MySQLdb under Cygwin

by: Perflubron | last post by:

Hi, I'm having trouble installing MySQLdb 0.9.2 on the following Cygwin system: - Python 2.2.2 - MySQL 3.23.57 - gcc 2.95.3-10 The steps I take are: 1. Modify setup.py - Set...

Python

Getting error condition from MySQLdb

by: Derek Fountain | last post by:

I was trying to use MySQLdb to connect to a database. All is OK, except I can't figure out how to get the details of an error. Suppose I try to connect to a non existant server, or with the wrong...

Python

MySQLdb returns "ValueError: invalid literal for float():" for cursor.execute('show databases')

by: Tim Williams | last post by:

I'm trying to write a simple python program to access a MySQL database. I'm having a problem with using MySQLdb to get the results of a SQL command in a cursor. Sometimes the cursor.execute works,...

Python

MySQLdb problem with mod_python, please help

by: ws Wang | last post by:

MySQLdb is working fine at command line, however when I tried to use it with mod_python, it give me a "server not initialized" error. This is working fine: ----------------------- testmy.py...

Python

MySQLdb-python how to install on MacOsX

by: Steve | last post by:

Darwin steve.local 8.3.0 Darwin Kernel Version 8.3.0: Mon Oct 3 20:04:04 PDT 2005; root:xnu-792.6.22.obj~2/RELEASE_PPC Power Macintosh powerpc MacOSX 10.4.3 mysql Ver 14.7 Distrib 4.1.14, for...

Python

MySQLdb installation error

by: Yi Xing | last post by:

Hi, I met the following error when I tried to install MySQLdb. I had no problem installing numarray, Numeric, Rpy, etc. Does anyone know what's the problem? Thanks! running install running...

Python

Re: how to mysqldb dict cursors

by: Steve Holden | last post by:

Vaibhav.bhawsar wrote: imported The point here is that MySQLdb is a package, not a module. Some packages have their top-level __init__.py import the package's sub-modules or sub-packages to...

Python

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

mysqldb on cygwin

Similar topics