dbTalk Databases Forums  

Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core

mailing.database.mysql-plusplus mailing.database.mysql-plusplus


Discuss Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core in the mailing.database.mysql-plusplus forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core - 07-25-2006 , 11:59 AM






------=_Part_250833_16450867.1153846667391
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi, I have trouble trying to deal with a client in india who only has a xeon
processor or a dual core and my application uses MySQL++ library to make the
connection to mysql. The MySQL installation is a regular rpm file nothing
specific for the 64 bit and i can run it just fine, but when my application
runs on the xeon / dual core it core dumps at the time when i am trying to
connect to mysql, connect() throws an exception, unfortunately the
executable i sent to client didnt have a catch in it, so i dont know what
seems to be the exact reason, but someone ever face this issue?

I can run the exact same code here in my lab with a regular P4.

What gives?

Thanks
Ankur

------=_Part_250833_16450867.1153846667391--

Reply With Quote
  #2  
Old   
AT
 
Posts: n/a

Default Re: Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core - 07-25-2006 , 12:20 PM






------=_Part_251722_15964311.1153847910601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I get a access denied exception, when i can use the same username and
password and enter with mysql -u user -p option??

Anything?


On 7/25/06, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com> wrote:
Quote:
Hi, I have trouble trying to deal with a client in india who only has a
xeon processor or a dual core and my application uses MySQL++ library to
make the connection to mysql. The MySQL installation is a regular rpm file
nothing specific for the 64 bit and i can run it just fine, but when my
application runs on the xeon / dual core it core dumps at the time when i am
trying to connect to mysql, connect() throws an exception, unfortunately the
executable i sent to client didnt have a catch in it, so i dont know what
seems to be the exact reason, but someone ever face this issue?

I can run the exact same code here in my lab with a regular P4.

What gives?

Thanks
Ankur

------=_Part_251722_15964311.1153847910601--


Reply With Quote
  #3  
Old   
AT
 
Posts: n/a

Default Re: Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core - 07-25-2006 , 12:22 PM



------=_Part_90440_19584354.1153848067068
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Dear Ankur

Yes, i think you will need to rebuild, because amd64 and Intel noncona
(known as x86_64) are a different binary platform if the os and or the code
was compiled with any optimization like the -march=someprocessor flag, but
the weird thing seems to happen with your executable, you should try
recompiling it for x86_64.

Myself I own one of those Sempron processors with a Venice Core, so it is
x86_64, and i use ubuntu, sometimes code compiled for normal 32 bit
processor does not work as desired because of the little different binary
compatibility between the code.

2006/7/25, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com>:
Quote:
Hi, I have trouble trying to deal with a client in india who only has a
xeon
processor or a dual core and my application uses MySQL++ library to make
the
connection to mysql. The MySQL installation is a regular rpm file nothing
specific for the 64 bit and i can run it just fine, but when my
application
runs on the xeon / dual core it core dumps at the time when i am trying to
connect to mysql, connect() throws an exception, unfortunately the
executable i sent to client didnt have a catch in it, so i dont know what
seems to be the exact reason, but someone ever face this issue?

I can run the exact same code here in my lab with a regular P4.

What gives?

Thanks
Ankur


------=_Part_90440_19584354.1153848067068--


Reply With Quote
  #4  
Old   
AT
 
Posts: n/a

Default Re: Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core - 07-25-2006 , 12:33 PM



------=_Part_90724_15289475.1153848728476
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Actually you can specify them in the mysqlpp::Connection constructor, look:

Connection<http://tangentsoft.net/mysql++/doc/refman/html/classmysqlpp_1_1Connection.html#a1>(const
char *db, const char *host="", const char *user="", const char
*passwd="", uint<http://tangentsoft.net/mysql++/doc/refman/html/namespacemysqlpp.html#a7>port=0,
my_bool compress=0, unsigned int connect_timeout=60,
cchar<http://tangentsoft.net/mysql++/doc/refman/html/namespacemysqlpp.html#a6>*socket_name=0,
unsigned int client_flag=0)

2006/7/25, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com>:
Quote:
I get a access denied exception, when i can use the same username and
password and enter with mysql -u user -p option??

Anything?


On 7/25/06, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com> wrote:

Hi, I have trouble trying to deal with a client in india who only has a
xeon processor or a dual core and my application uses MySQL++ library to
make the connection to mysql. The MySQL installation is a regular rpm
file
nothing specific for the 64 bit and i can run it just fine, but when my
application runs on the xeon / dual core it core dumps at the time when
i am
trying to connect to mysql, connect() throws an exception, unfortunately
the
executable i sent to client didnt have a catch in it, so i dont know
what
seems to be the exact reason, but someone ever face this issue?

I can run the exact same code here in my lab with a regular P4.

What gives?

Thanks
Ankur



------=_Part_90724_15289475.1153848728476--


Reply With Quote
  #5  
Old   
AT
 
Posts: n/a

Default Re: Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core - 07-25-2006 , 12:44 PM



------=_Part_252678_29133319.1153849379804
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks for the response, I am doing that...

I have the following information in my user table

/*!40000 ALTER TABLE `user` DISABLE KEYS */;
LOCK TABLES `user` WRITE;
INSERT INTO `user` VALUES

('localhost','root','','Y','Y'
,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','', '','','',0,0,0,0),
('lemko08.localdomain
','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y ','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','Y','Y','Y','','','','',0,0,0,0),
('lemko08.localdomain
','','','N','N','N','N','N','N','N','N','N','N','N ','N','N','N','N','N','N','N','N','N','N','N','N', 'N','N','N','','','','',0,0,0,0),
('localhost','','','N','N','N','N','N','N','N','N' ,'N','N','N','N','N','N','N','N','N','N','N','N',' N','N','N','N','N','N','','','','',0,0,0,0),
('','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y ','Y','Y','Y','Y','','','','',0,0,0,0),
('%','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y' ,'Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','Y','','','','',0,0,0,0),
('localhost','provision','*F3217201BB1C2D9940EDDE0 216E781949BE7D28F','Y','Y','Y','Y','Y','Y','Y','Y' ,'Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','Y','Y','','','','',0,0,0,0),
('%','provision','*F3217201BB1C2D9940EDDE0216E7819 49BE7D28F','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y' ,'N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','','','','',0,0,0,0),
('localhost.localdoamin
','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y ','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','Y','Y','Y','','','','',0,0,0,0),
('localhost.localdoamin
','provision','','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y' ,'Y','Y','Y','Y','Y','','','','',0,0,0,0);


and I have the exact same info in my P4 machine and I can log in without a
problem, when i run my command i get the following error

Access denied for user 'provision'@'Lemko08.localdomain' (using password:
YES)

Anything I could be missing..


On 7/25/06, Carlos Flores <cafg10 (AT) gmail (DOT) com> wrote:
Quote:
Actually you can specify them in the mysqlpp::Connection constructor,
look:

Connection
http://tangentsoft.net/mysql++/doc/r...ection.html#a1
(const
char *db, const char *host="", const char *user="", const char
*passwd="", uint
http://tangentsoft.net/mysql++/doc/r...ysqlpp.html#a7
port=0,
my_bool compress=0, unsigned int connect_timeout=60,
cchar
http://tangentsoft.net/mysql++/doc/r...ysqlpp.html#a6
*socket_name=0,
unsigned int client_flag=0)

2006/7/25, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com>:

I get a access denied exception, when i can use the same username and
password and enter with mysql -u user -p option??

Anything?


On 7/25/06, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com> wrote:

Hi, I have trouble trying to deal with a client in india who only has
a
xeon processor or a dual core and my application uses MySQL++ library
to
make the connection to mysql. The MySQL installation is a regular rpm
file
nothing specific for the 64 bit and i can run it just fine, but when
my
application runs on the xeon / dual core it core dumps at the time
when
i am
trying to connect to mysql, connect() throws an exception,
unfortunately
the
executable i sent to client didnt have a catch in it, so i dont know
what
seems to be the exact reason, but someone ever face this issue?

I can run the exact same code here in my lab with a regular P4.

What gives?

Thanks
Ankur





------=_Part_252678_29133319.1153849379804--


Reply With Quote
  #6  
Old   
AT
 
Posts: n/a

Default Re: Do we need to recompile MySQL++ lib for Xeon 64bit / Dual Core - 07-25-2006 , 12:54 PM



Ankur,

Which version of libmysqlclient / libmysqlpp are using in your
application ? Are both statically / dynamically linked ? Also which
MySQL server version is running on the x86_64 host ? I'm thinking that
you might have been using older libmysqlclient (before v.4.1) and trying
to connect to MySQL 4.1/5.0 server.

Regards,
Ovidiu

Ankur G35 Saxena wrote:
Quote:
Thanks for the response, I am doing that...

I have the following information in my user table

/*!40000 ALTER TABLE `user` DISABLE KEYS */;
LOCK TABLES `user` WRITE;
INSERT INTO `user` VALUES

('localhost','root','','Y','Y'
,'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','', '','','',0,0,0,0),

('lemko08.localdomain
','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y ','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','Y','Y','Y','','','','',0,0,0,0),

('lemko08.localdomain
','','','N','N','N','N','N','N','N','N','N','N','N ','N','N','N','N','N','N','N','N','N','N','N','N', 'N','N','N','','','','',0,0,0,0),

('localhost','','','N','N','N','N','N','N','N','N' ,'N','N','N','N','N','N','N','N','N','N','N','N',' N','N','N','N','N','N','','','','',0,0,0,0),

('','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y ','Y','Y','Y','Y','','','','',0,0,0,0),

('%','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y' ,'Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','Y','','','','',0,0,0,0),

('localhost','provision','*F3217201BB1C2D9940EDDE0 216E781949BE7D28F','Y','Y','Y','Y','Y','Y','Y','Y' ,'Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','Y','Y','','','','',0,0,0,0),

('%','provision','*F3217201BB1C2D9940EDDE0216E7819 49BE7D28F','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y' ,'N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','Y','Y','','','','',0,0,0,0),

('localhost.localdoamin
','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y ','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y', 'Y','Y','Y','Y','','','','',0,0,0,0),

('localhost.localdoamin
','provision','','Y','Y','Y','Y','Y','Y','Y','Y',' Y','Y','N','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y' ,'Y','Y','Y','Y','Y','','','','',0,0,0,0);



and I have the exact same info in my P4 machine and I can log in
without a
problem, when i run my command i get the following error

Access denied for user 'provision'@'Lemko08.localdomain' (using password:
YES)

Anything I could be missing..


On 7/25/06, Carlos Flores <cafg10 (AT) gmail (DOT) com> wrote:

Actually you can specify them in the mysqlpp::Connection constructor,
look:

Connection
http://tangentsoft.net/mysql++/doc/r...ection.html#a1

(const
char *db, const char *host="", const char *user="", const char
*passwd="", uint
http://tangentsoft.net/mysql++/doc/r...ysqlpp.html#a7
port=0,
my_bool compress=0, unsigned int connect_timeout=60,
cchar
http://tangentsoft.net/mysql++/doc/r...ysqlpp.html#a6
*socket_name=0,
unsigned int client_flag=0)

2006/7/25, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com>:

I get a access denied exception, when i can use the same username and
password and enter with mysql -u user -p option??

Anything?


On 7/25/06, Ankur G35 Saxena <g35rider (AT) gmail (DOT) com> wrote:

Hi, I have trouble trying to deal with a client in india who only
has
a
xeon processor or a dual core and my application uses MySQL++
library
to
make the connection to mysql. The MySQL installation is a regular
rpm
file
nothing specific for the 64 bit and i can run it just fine, but when
my
application runs on the xeon / dual core it core dumps at the time
when
i am
trying to connect to mysql, connect() throws an exception,
unfortunately
the
executable i sent to client didnt have a catch in it, so i dont know
what
seems to be the exact reason, but someone ever face this issue?

I can run the exact same code here in my lab with a regular P4.

What gives?

Thanks
Ankur







--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.