Computer Geeks

Computer Geeks

Geek Shop

Geek News

Geek Stuff

Science Geek

Computer Gaming

Linux Chat

Building Websites

Computer Forums

Computer Help Forum

Computer Hardware Forum

Computer Software Programs


Go Back   Computer Forums > Geek Stuff
FAQ Community Calendar Today's Posts Search

Geek Stuff General forum for discussing anything geek. If your topic doesn't fit in any of the other forums then post it here.

Computer Geeks
» Active Discussions
Computer Geeks
No Threads to Display.
» Other Websites
- Software Publishing

- Server Hardening
Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2006, 03:08 PM
chiefsmurph chiefsmurph is offline
Junior Member
GB Beginner
 
Join Date: Mar 2006
Posts: 29
Default PHP MySql Problem

I haven't used mysql at all until yesterday when I tried to install SMF. I was getting some database connection issues, tried to work them out, and ended up giving up. Today I bought the domain pcgamertalk.com so I have got to work this out so I tried phpBB hoping it would miraculously work. Not suprisingly, that didn't work. When installing phpBB it gave me an option to change the type of database the forum should be installed in. I tried both MySql versions it allowed me and neither worked.

Obviously something is wrong with configuration of php and mysql, but I can't figure it out. When I login into webmin, I can add databases and tables to mysql, but I can't connect from a php script. Has anyone else had this problem? Thanks
Reply With Quote
  #2  
Old 04-06-2006, 04:44 AM
Soulwatcher's Avatar
Soulwatcher Soulwatcher is offline
Senior Member
GB GEEK
 
Join Date: Feb 2006
Posts: 309
Send a message via MSN to Soulwatcher
Default

chiefsmurph I have to apologize for getting back to you late on this one. I have a side project going that eating all my free time. It sounds like your missing the php-devel for either MySQL or http. I had the same problem on my server. It turned out that I needed http php-devel and after I installed it everything worked.
Reply With Quote
  #3  
Old 04-06-2006, 12:21 PM
chiefsmurph chiefsmurph is offline
Junior Member
GB Beginner
 
Join Date: Mar 2006
Posts: 29
Default

The php-devel for http or mysql is not just for http or mysql, right? I looked on google and couldn't find anything for "php-devel for http," but when I searched just for php-devel there were plenty of rpms.

I downloaded one and tried to install it, but I got an error:

file /usr/bin/pear from install of php-devel-4.0.6-12 conflicts with file from package php-pear-4.3.9-3.8

Do I have to uninstall php's old extensions before I try to install php-devel or does that mean I already had them?
Reply With Quote
  #4  
Old 04-06-2006, 05:30 PM
Soulwatcher's Avatar
Soulwatcher Soulwatcher is offline
Senior Member
GB GEEK
 
Join Date: Feb 2006
Posts: 309
Send a message via MSN to Soulwatcher
Default

Quote:
Originally Posted by chiefsmurph
The php-devel for http or mysql is not just for http or mysql, right? I looked on google and couldn't find anything for "php-devel for http," but when I searched just for php-devel there were plenty of rpms.

I downloaded one and tried to install it, but I got an error:

file /usr/bin/pear from install of php-devel-4.0.6-12 conflicts with file from package php-pear-4.3.9-3.8

Do I have to uninstall php's old extensions before I try to install php-devel or does that mean I already had them?
Your going to have to update the php-devel with yum. Try "yum install MySQL-devel" and try "yum install php-devel" Let me know if one of those two fixes your problem.
Reply With Quote
  #5  
Old 04-06-2006, 10:17 PM
chiefsmurph chiefsmurph is offline
Junior Member
GB Beginner
 
Join Date: Mar 2006
Posts: 29
Default

Ran them both and no luck. Still getting error here.

MySQL-devel gave me:

No Match for argument: MySQL-devel
Nothing to do

Php-devel did a lot. Looked like this:

Transaction Summary
======================
Install 1 Package(s)
Update 3 Package(s)
Remove 0 Package(s)
Reply With Quote
  #6  
Old 04-07-2006, 04:51 AM
Soulwatcher's Avatar
Soulwatcher Soulwatcher is offline
Senior Member
GB GEEK
 
Join Date: Feb 2006
Posts: 309
Send a message via MSN to Soulwatcher
Default

Quote:
Originally Posted by chiefsmurph
Ran them both and no luck. Still getting error here.

MySQL-devel gave me:

No Match for argument: MySQL-devel
Nothing to do

Php-devel did a lot. Looked like this:

Transaction Summary
======================
Install 1 Package(s)
Update 3 Package(s)
Remove 0 Package(s)


Try "yum install php4-mysql" and let me know if that works? Dont worry we will get you up and running. Also check and make sure php_mysql.dll is enabled in the php.ini.
Reply With Quote
  #7  
Old 04-07-2006, 01:05 PM
chiefsmurph chiefsmurph is offline
Junior Member
GB Beginner
 
Join Date: Mar 2006
Posts: 29
Default

yum install php4-mysql said nothing to do, but I looked in my php.ini file and theres no php_mysql.dll.

I searched for mysql and found: extension_dir = /var/lib/mysql/ is that right?

Also, extension wasn't set. I thought it had something to do with extensions but I may be way off.
Reply With Quote
  #8  
Old 04-08-2006, 01:39 PM
Soulwatcher's Avatar
Soulwatcher Soulwatcher is offline
Senior Member
GB GEEK
 
Join Date: Feb 2006
Posts: 309
Send a message via MSN to Soulwatcher
Default

The only other thing I can think of is you need to rebuild PHP for MySQL. What OS are you running and what version of PHP do you have?

If your running PHP 4 you can follow this guide to rebuild your PHP for MySQL.
http://www.eth0.us/sourcephp
Reply With Quote
  #9  
Old 04-08-2006, 01:54 PM
chiefsmurph chiefsmurph is offline
Junior Member
GB Beginner
 
Join Date: Mar 2006
Posts: 29
Default

Centos Php 4. Thanks for the help. I'll try to recompile php later today.
Reply With Quote
  #10  
Old 04-08-2006, 05:42 PM
chiefsmurph chiefsmurph is offline
Junior Member
GB Beginner
 
Join Date: Mar 2006
Posts: 29
Default

I read the page on recompiling php and I got to the part where I was running "up2date libpng-devel libjpeg-devel freetype-devel freetype libjpeg libpng." I ran it and it gave me

Downloading headers to solve dependencies...
There was an error downloading: http://mirror.centos.org/centos/4/os...L4_U2.i386.hdr
There was an error downloading: http://mirror.centos.org/centos/4/os...2.1-1.i386.hdr

...continually
Reply With Quote
Reply


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

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

Forum Jump

Powered by vBadvanced CMPS v3.2.3

All times are GMT -5. The time now is 03:48 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
HTML Help provided by HTML Help Central.