Skip to main content

MySQL Enterprise thingy

It's been a weird thing when you install MySQL server especially the one that is 'enterprise' version is not working with your PHP. That is the problem that my friend and I facing today. Since PHP require php-mysql extension to connect to MySQL server but php-mysql is only work with mysql-server from the Repos (Redhat/Centos).

1) Remove default mysql-server/php-mysql
2) Install MySQL Enterprise
3) Dependencies conflict occur + headache + install php-mysql

shell> yum install php-mysql
Loaded plugins: rhnplugin, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package php-mysql.x86_64 0:5.1.6-27.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: php-mysql--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: php-mysql
--> Running transaction check
---> Package mysql.x86_64 0:5.0.77-4.el5_4.2 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.77-4.el5_4.2.x86_64 from rhel-x86_64-server-5 has depsolving problems
  --> mysql conflicts with MySQL-server-advanced-gpl
Error: mysql conflicts with MySQL-server-advanced-gpl
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest

Googling around really takes my time.. but fortunately found one that might help me from the error that I bold above. I assume after installing mysql-client-enterprise(not a real name) should have libmysqlclient that php-mysql looking for..but I'm totally wrong. The libmysqlclient reside in one of the file that I download from the mysql enterprise but in mysql-share-compat-enterprise (not really complete name)


http://bugs.mysql.com/bug.php?id=46057


1) Install mysql-server-enterprise
2) Install mysql-client-enterprise
3) Install mysql-share-compat-enterprise


That should save your time and your penny! :)


yatta~

Comments

infoway test said…
yatta,

I have also facing the same problem.

Have you figure out the way that how to installed the MySQL Enterprise and connect with PHP?

Please let me know.

Thanks,
Monojit
July 7, 2010 at 6:15 AM
cgawumensah said…
All you have to do is to compile php from the source code ( download from it from http://www.php.net) this should solve your problem with mysql enterprise
January 19, 2012 at 7:43 AM
Post a Comment

Popular posts from this blog

Building a KVM Proxy

Traditionally we seldomly connect our KVM from the port directly to the server that consists of usb for keyboard and mouse, vga cable for display purposes. More advanced you may have an experience using the iKVM which connect all you kvm port from the internet where you can have a remote location as long as you have the internet connection. When technology evolve, physical server are becoming obsolete since we have the virtualization technology. Since that to access your virtual machine (vm) are more easier. Instead of using SSH, like a Xen hypervisor, the Xen itself can host as a KVM server and map to the vm on different port as configured from the config file.
Post a Comment
Read more

Warning Nuffnanger's!

Dear Nuffnangers, As you might already know, there are 2 different types of campaigns from Nuffnang: Metered (mCPM) Campaigns , which pay according to the number of visitors who see the ads; and Cost-Per-Click (CPC) campaigns, which pay bloggers based on the number of clicks generated on the ads. It has come to our attention that certain groups have been committing click fraud, which is defined as clicking on CPC advertisements intentionally just to generate earnings for a blog's owner. Do note that this act is an abuse of our Terms & Conditions under Section 6. Banner ads are only supposed to be clicked on if the viewer is interested to find out more about the advertising campaign, and not for the intention of earning extra money. Should this situation worsen, the frequency of ad campaigns might be significantly reduced as we'll only be able to sell ad spaces on blogs with no click fraud record. Our system is capable of tracking these illegal actions...
2 comments
Read more

Python - Xen and libvirt

more function can be found in python dir libvirtclass.txt shell> find / -name libvirtclass.txt Generated Classes for libvir-python # # Global functions of the module # # functions from module libvirt open() openReadOnly() virEventRegisterImpl() virInitialize() # functions from module virterror virGetLastError() virResetLastError() # # Set of classes of the module # Class virDomain()     # functions from module libvirt     ID()     OSType()     XMLDesc()     attachDevice()     blockPeek()     connect()     coreDump()     create()     destroy()     detachDevice()     maxMemory()     maxVcpus()     memoryPeek() migrate()     name()     reboot()     ref()     resume()  ...
Post a Comment
Read more