Mailing List Archive: mxODBC and MySQL

mxODBC and MySQL

Jun 7, 1999, 1:27 PM

Post #1 of 5 (853 views)

Hi,

I compiled and installed mxODBC for MySQL on SuSE 6.1 without problems.
I get this:
Python 1.5.2b2 (#6, Feb 28 1999, 21:41:19) [GCC egcs-2.91.60 19981201
(egcs-1.1
.1 on linux2
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import ODBC.MySQL
Traceback (innermost last):
File "<stdin>", line 1, in ?
File "/usr/local/lib/python1.5/ODBC/MySQL/__init__.py", line 7, in ?
from mxODBC import *
ImportError: /usr/local/lib/python1.5/ODBC/MySQL/mxODBC.so: undefined
symbol: PyBuffer_Type
>>

regards

Joachim Schmitz

------------------------------------------------------------------------------
P R O F I . N E T A G * Joachim Schmitz * Senior Network Consultant
------------------------------------------------------------------------------
profi.net | Aindlinger Str. 7 | Voice +49 821 27062-0
Hassler & Mair AG | 86167 Augsburg | Fax +49 821 27062-99
| Germany | Email js@profi.net

mxODBC and MySQL [ In reply to ]

mal at lemburg

Jun 7, 1999, 2:12 PM

Post #2 of 5 (852 views)

Permalink

Joachim Schmitz wrote:
>
> Hi,
>
> I compiled and installed mxODBC for MySQL on SuSE 6.1 without problems.
> I get this:
> Python 1.5.2b2 (#6, Feb 28 1999, 21:41:19) [GCC egcs-2.91.60 19981201
> (egcs-1.1
> .1 on linux2
> Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
> >>> import ODBC.MySQL
> Traceback (innermost last):
> File "<stdin>", line 1, in ?
> File "/usr/local/lib/python1.5/ODBC/MySQL/__init__.py", line 7, in ?
> from mxODBC import *
> ImportError: /usr/local/lib/python1.5/ODBC/MySQL/mxODBC.so: undefined
> symbol: PyBuffer_Type
> >>

You can either upgrade to 1.5.2 final or turn off the buffer
type code in mxODBC.c manually (enclosed in HAVE_PYTHON_BUFFEROBJECTS
#defines). I guess you stumbled into test code that I forgot to remove
for the distribution; sorry.

--
Marc-Andre Lemburg
______________________________________________________________________
Y2000: 207 days left
Business: http://www.lemburg.com/
Python Pages: http://www.lemburg.com/python/

mxODBC and MySQL [ In reply to ]

perry at ac-copy

Jun 7, 1999, 11:44 PM

Post #3 of 5 (851 views)

Permalink

I ugraded to 1.5.2 now I get:

Python 1.5.2 (#1, Jun 8 1999, 07:26:20) [GCC egcs-2.91.66 19990314
(egcs-1.1.2 on linux2
Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
>>> import ODBC.MySQL
Traceback (innermost last):
File "<stdin>", line 1, in ?
File "/usr/local/lib/python1.5/ODBC/MySQL/__init__.py", line 7, in ?
from mxODBC import *
ImportError: /usr/local/lib/python1.5/ODBC/MySQL/mxODBC.so: undefined
symbol: SQLTables

regards

Joachim Schmitz

On Mon, 7 Jun 1999, M.-A. Lemburg wrote:

> Joachim Schmitz wrote:
> >
> > Hi,
> >
> > I compiled and installed mxODBC for MySQL on SuSE 6.1 without problems.
> > I get this:
> > Python 1.5.2b2 (#6, Feb 28 1999, 21:41:19) [GCC egcs-2.91.60 19981201
> > (egcs-1.1
> > .1 on linux2
> > Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
> > >>> import ODBC.MySQL
> > Traceback (innermost last):
> > File "<stdin>", line 1, in ?
> > File "/usr/local/lib/python1.5/ODBC/MySQL/__init__.py", line 7, in ?
> > from mxODBC import *
> > ImportError: /usr/local/lib/python1.5/ODBC/MySQL/mxODBC.so: undefined
> > symbol: PyBuffer_Type
> > >>
>
> You can either upgrade to 1.5.2 final or turn off the buffer
> type code in mxODBC.c manually (enclosed in HAVE_PYTHON_BUFFEROBJECTS
> #defines). I guess you stumbled into test code that I forgot to remove
> for the distribution; sorry.
>

------------------------------------------------------------------------------
P R O F I . N E T A G * Joachim Schmitz * Senior Network Consultant
------------------------------------------------------------------------------
profi.net | Aindlinger Str. 7 | Voice +49 821 27062-0
Hassler & Mair AG | 86167 Augsburg | Fax +49 821 27062-99
| Germany | Email js@profi.net

mxODBC and MySQL [ In reply to ]

mal at lemburg

Jun 8, 1999, 1:04 AM

Post #4 of 5 (853 views)

Permalink

Joachim Schmitz wrote:
>
> I ugraded to 1.5.2 now I get:
>
> Python 1.5.2 (#1, Jun 8 1999, 07:26:20) [GCC egcs-2.91.66 19990314
> (egcs-1.1.2 on linux2
> Copyright 1991-1995 Stichting Mathematisch Centrum, Amsterdam
> >>> import ODBC.MySQL
> Traceback (innermost last):
> File "<stdin>", line 1, in ?
> File "/usr/local/lib/python1.5/ODBC/MySQL/__init__.py", line 7, in ?
> from mxODBC import *
> ImportError: /usr/local/lib/python1.5/ODBC/MySQL/mxODBC.so: undefined
> symbol: SQLTables

Hmm, the MyODBC driver does define this function. Could be that
you've linked against the wrong lib or that the loader doesn't
find the .so file.

Cheers,
--
Marc-Andre Lemburg
______________________________________________________________________
Y2000: 206 days left
Business: http://www.lemburg.com/
Python Pages: http://www.lemburg.com/python/

mxODBC and MySQL [ In reply to ]

cvlcareer at yahoo

Jun 11, 1999, 10:08 AM

Post #5 of 5 (848 views)

Permalink

Hello Everybody,
I've installed Mysql on Windows-NT 4.0.
Used those commands to NET START MYSQL.
But i donot see any Mysql Prompt.
Anybody would be able to help me out in running Mysql successfuly. I
thank you in advance for your time.
At the sql prompt i should be able to run Sql queries.

Sincerely
Thx,
Loki

--- Joachim Schmitz <perry@ac-copy.net> wrote:
>
> Hi,
>
> I compiled and installed mxODBC for MySQL on SuSE
> 6.1 without problems.
> I get this:
> Python 1.5.2b2 (#6, Feb 28 1999, 21:41:19) [GCC
> egcs-2.91.60 19981201
> (egcs-1.1
> .1 on linux2
> Copyright 1991-1995 Stichting Mathematisch Centrum,
> Amsterdam
> >>> import ODBC.MySQL
> Traceback (innermost last):
> File "<stdin>", line 1, in ?
> File
> "/usr/local/lib/python1.5/ODBC/MySQL/__init__.py",
> line 7, in ?
> from mxODBC import *
> ImportError:
> /usr/local/lib/python1.5/ODBC/MySQL/mxODBC.so:
> undefined
> symbol: PyBuffer_Type
> >>
>
> regards
>
> Joachim Schmitz
>
>
------------------------------------------------------------------------------
> P R O F I . N E T A G * Joachim Schmitz *
> Senior Network Consultant
>
------------------------------------------------------------------------------
> profi.net | Aindlinger Str. 7
> | Voice +49 821 27062-0
> Hassler & Mair AG | 86167 Augsburg
> | Fax +49 821 27062-99
> | Germany
> | Email js@profi.net
>
>
> --
> http://www.python.org/mailman/listinfo/python-list
>

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com