Got it ... Thanks David
>gcc -m64 test.c -L/usr/local/mysql/lib -lmysqlclient -lsocket -lnsl -lm -o test .. seemed to work I get a 'Bus Error (core dumped)' when I run it - but that's a problem with the code!! Thanks Andy On Tue, 2005-01-11 at 22:23 +1100, Logan, David (SST - Adelaide) wrote: > Hi Andy, > > I resolved the problem by reinstalling a 32bit version of mysql and the > DBI worked fine after that. Looks like you are missing a library or 2, > try nsl and socket. I think they have all the routines that you need to > link against. > > You may also need an include or 2. All the routines have man pages that > reference the libraries and includes required. > > Regards > > David Logan > Database Administrator > HP Managed Services > 148 Frome Street, > Adelaide 5000 > Australia > > +61 8 8408 4273 - Work > +61 417 268 665 - Mobile > +61 8 8408 4259 - Fax > > > -----Original Message----- > From: Andy Ford [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 11 January 2005 9:37 PM > To: Logan, David (SST - Adelaide) > Cc: mysql@lists.mysql.com > Subject: RE: compilation errors in mySQL C app > > Hi David > > Yes it is something like you say... > > >file /usr/local/bin/gcc > /usr/local/bin/gcc: ELF 32-bit MSB executable SPARC Version 1, > dynamically linked, not stripped > > >file /usr/local/bin/g++ > /usr/local/bin/gcc: ELF 32-bit MSB executable SPARC Version 1, > dynamically linked, not stripped > > >isainfo -kv > 64-bit sparcv9 kernel modules > > I got rid of the ELF issue with the -m64 option but still get the > following errors... > > > gcc -m64 test.c -L/usr/local/mysql/lib -lmysqlclient -o test > > Undefined first referenced > symbol in file > getpeername > /usr/local/mysql/lib/libmysqlclient.a(viosocket.o) > floor > /usr/local/mysql/lib/libmysqlclient.a(password.o) > socket > /usr/local/mysql/lib/libmysqlclient.a(client.o) > gethostbyname_r > /usr/local/mysql/lib/libmysqlclient.a(client.o) > setsockopt > /usr/local/mysql/lib/libmysqlclient.a(viosocket.o) > getservbyname > /usr/local/mysql/lib/libmysqlclient.a(libmysql.o) > connect > /usr/local/mysql/lib/libmysqlclient.a(client.o) > shutdown > /usr/local/mysql/lib/libmysqlclient.a(viosocket.o) > inet_ntoa > /usr/local/mysql/lib/libmysqlclient.a(my_net.o) > inet_addr > /usr/local/mysql/lib/libmysqlclient.a(client.o) > ld: fatal: Symbol referencing errors. No output written to test2 > collect2: ld returned 1 exit status > > Getting there slowly > > Thanks > > Andy > > On Tue, 2005-01-11 at 21:42 +1100, Logan, David (SST - Adelaide) wrote: > > Hi Andy, > > > > Are you using a 64bit option to compile your program (I can't remember > > the option on gcc -m64 I think)? Looks like a 64bit mysql library > trying > > to talk to a 32 bit program. I'm no expert but I had similar problems > > when I put a 64bit mysql on one of my Solaris boxen and tried to talk > > with a 32 bit perl implementation. > > > > Regards > > > > > > David Logan > > Database Administrator > > HP Managed Services > > 148 Frome Street, > > Adelaide 5000 > > Australia > > > > +61 8 8408 4273 - Work > > +61 417 268 665 - Mobile > > +61 8 8408 4259 - Fax > > > > > > -----Original Message----- > > From: Andy Ford [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, 11 January 2005 8:59 PM > > To: mysql@lists.mysql.com > > Subject: compilation errors in mySQL C app > > > > Hi everyone > > > > I am trying to compile a simple C program to connect to a mySQL > database > > (on localhost) and run a simple query. > > > > I am getting the following errors... > > > > >gcc test.c -L/usr/local/mysql/lib -lmysqlclient -o test > > > > ld: warning: file /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): > > wrong ELF class: ELFCLASS64 > > Undefined first referenced > > symbol in file > > mysql_query /var/tmp//ccpHcO9u.o > > mysql_init /var/tmp//ccpHcO9u.o > > mysql_close /var/tmp//ccpHcO9u.o > > mysql_free_result /var/tmp//ccpHcO9u.o > > mysql_num_rows /var/tmp//ccpHcO9u.o > > mysql_error /var/tmp//ccpHcO9u.o > > mysql_store_result /var/tmp//ccpHcO9u.o > > mysql_real_connect /var/tmp//ccpHcO9u.o > > mysql_fetch_row /var/tmp//ccpHcO9u.o > > > > ld: fatal: Symbol referencing errors. No output written to test2 > > collect2: ld returned 1 exit status > > > > Any ideas how I can fix these? > > > > Thanks > > > > Andy > > -- > > perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=<D+ ^" > > > > This e-mail is private and may be confidential and is for the intended > > recipient only. If misdirected, please notify us by telephone and > > confirm that it has been deleted from your system and any copies > > destroyed. If you are not the intended recipient you are strictly > > prohibited from using, printing, copying, distributing or > disseminating > > this e-mail or any information contained in it. We use reasonable > > endeavours to virus scan all e-mails leaving the Company but no > warranty > > is given that this e-mail and any attachments are virus free. You > > should undertake your own virus checking. The right to monitor e-mail > > communications through our network is reserved by us. > > > > > > -- perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=<D+ ^" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
