DelphiFAQ Home Search:

Problems installing DBD::mysql on Solaris 8

 

comments6 comments. Current rating: 4 stars (3 votes). Leave comments and/ or rate it.

Question:

I need to access a mysql database using perl on Solaris 8. I installed DBI already but fail to install DBD::mysql.

I get error messages that the gcc compiler does not understand certain options:
gcc: unrecognized option `-Xa'
gcc: language arch=v8 not recognized


If I just copy the DBD::mysql.pm to the target directory, I get error messages that the driver cannot be located in Mysql.pm

Answer:

I was in the same situation. After unpacking DBD-mysql-3.0006.tar I ran

perl Makefile.PL

Then when running make, those error messages showed up.
I looked at the options for gcc and found that I should remove them. I also found that the option for the include files (search path -I) specified a folder that did not exist in my system.
The original include file path was /usr/local/mysql/include/mysql but after installing the package on Solaris (all with the default values) it should have been /usr/local/mysql/include


So instead I created the makefile using:

perl Makefile.PL --cflags="-I/usr/local/mysql/include"

Then I issued a 'make', followed by 'make install', and everything worked fine.



Comments:

2006-09-29, 10:49:35
anonymous from India  
rating
Thanx man!
this made my day!
2006-11-22, 02:33:25
anonymous from Netherlands  
rating
Yep thank you very much for sharing your knowlegde. This saved me a lot of time.

Grtz
2006-11-29, 06:22:57
anonymous from United States  
Thanks a lot !
2014-12-16, 13:54:00
anonymous from Baarn, Netherlands  
Hi Dave.My name's Rafael, I'm a brazilian IT prnesfsiooal who's been studying for the MySQL Certification Test.I stumbled upon a problem: since Amazon and other sites aren't shipping stuff to addresses outside USA, I'm not able to get the MySQL Certified Study Guide 5.0's CD ('Practice Questions for the MySQL Certification Exams'). Is there any way for you to send me a copy of the disc (via eMail or any other way) if you have it? I know it seems like a desperate try (and it is),but here where I live I couldn't find a shop or someone who could bring me the book.Thanks in advanceRafael
2015-01-01, 01:29:39
anonymous from Venezuela  
Hi Sheeri,I know this is a long comment, but if you could find the time to reply, I would be very grueftal.I'm working with a few friends to try to launch a social network type of site, with many of the typical social network site features (profiles, photos, comments, videos, etc). We are using LAMP environment. I've been tasked with researching MySQL Cluster, MySQL Replication, and how various other large sites cope with large amounts of traffic and how they solve their scalability and HA issues. We don't want to become popular one night and be overwhelmed by the traffic.What I've found is this:- Replication is widely used by many of the largest sites- memcached is widely used by many of the largest sites- MySQL Cluster is not widely used at all (not sure why seems like a great product)As far as I can tell, Replication has some problems:- the delay in syncing current data to the slaves.- replication is ideal for read-intensive applications.- need to modify web application to read from slaves and write to master.- MOST IMPORTANTLY: the single point of failure and bottleneck point with 1 master server.From what I read and understand, MySQL Cluster is ideal for both read and write intensive applications and is built for high availability and scalability. Seems like a great solution. But why is no one using it for web applications?It seems everyone is recommending replication, but I have concerns about it:1. Initially, I expect that there will be as many writes as reads as more and more users create profiles, post photos, comments, etc. Considering that replication is great for read-intensive applications, would replication be of any help here?2. The SPOF with 1 Master MySQL server really scares me. I've read about Master-Master Replication but again, the bottleneck would be the writes. Am I wrong?3. Even if I partition my data across different master databases, if one of them fails then part of the site (and potentially the entire site) might go offline. Or am I wrong?4. How do these big sites use replication without running into write performance issues?Thanks for any help and suggestions!Konstantin http://gagrct.com [url= http://ywxfcfv.com]..fcfv[/url] [link= http://knrwyejrbnx...bnx[/link]
2015-04-08, 12:39:15
eyntnv  
rating
qsaahcxq

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: