PHP, MySQL & FC6

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • martinf
    #1

    PHP, MySQL & FC6

    Hello group,

    I've inherited a box running FC6.

    The website I'm trying to copy across to it ran fine on FC5.. PHP &
    MySQL were set up 'out-the-box' so the site just worked.

    Somethings changed with FC6.

    Trying to run the DB script now gives:

    PHP Fatal error: Call to undefined function mysql_connect()

    Looking at phpinfo();, the configure command has the switch
    "--without-mysql" in it, which I figure is the root of my problem.

    MySQL is definitely installed on the box, I've a database up and running
    on that just fine. It can be accessed locally and remotely.

    My question is, what's the simplest way to get PHP to recognise MySQL is
    there to use? Preferably without breaking anything else (e.g., there's a
    cron job that calls yum daily to do updates.. This must still work
    afterwards!!)

    Thanks for any pointers.
    Tags: None
    • noi
      #2
      Re: PHP, MySQL & FC6

      On Mon, 16 Apr 2007 05:23:27 +0100, martinf wrote this:
      Hello group,
      >
      I've inherited a box running FC6.
      >
      The website I'm trying to copy across to it ran fine on FC5.. PHP & MySQL
      were set up 'out-the-box' so the site just worked.
      >
      Somethings changed with FC6.
      >
      Trying to run the DB script now gives:
      >
      PHP Fatal error: Call to undefined function mysql_connect()
      >
      Looking at phpinfo();, the configure command has the switch
      "--without-mysql" in it, which I figure is the root of my problem.
      >
      MySQL is definitely installed on the box, I've a database up and running
      on that just fine. It can be accessed locally and remotely.
      >
      My question is, what's the simplest way to get PHP to recognise MySQL is
      there to use? Preferably without breaking anything else (e.g., there's a
      cron job that calls yum daily to do updates.. This must still work
      afterwards!!)
      >
      Thanks for any pointers.
      Are you sure it's MySQL and not PHP? Versions the same in FC5 vs FC6?

        Comment

        • martinf
          #3
          Re: PHP, MySQL & FC6

          noi wrote:
          >Somethings changed with FC6.
          >>
          >Trying to run the DB script now gives:
          >>
          > PHP Fatal error: Call to undefined function mysql_connect()
          >>
          >Looking at phpinfo();, the configure command has the switch
          >"--without-mysql" in it, which I figure is the root of my problem.
          >>
          >MySQL is definitely installed on the box, I've a database up and running
          >on that just fine. It can be accessed locally and remotely.
          >>
          >My question is, what's the simplest way to get PHP to recognise MySQL is
          >there to use? Preferably without breaking anything else (e.g., there's a
          >cron job that calls yum daily to do updates.. This must still work
          >afterwards!! )
          >>
          >Thanks for any pointers.
          >
          Are you sure it's MySQL and not PHP? Versions the same in FC5 vs FC6?
          Yup it was PHP. If my question gave the impression MySQL was to blame it
          wasn't meant to. There are details on the PHP site about the change
          and why it's happened, I just didn't know how to fix it!

          The fix (which didn't make it into a.l.r and c.l.p) for the benefit of
          any future Googlers is:

          yum install php-mysql
          service httpd restart

            Comment

            • Hadron
              #4
              Re: PHP, MySQL & FC6

              noi <noi@siam.comwr ites:
              On Mon, 16 Apr 2007 05:23:27 +0100, martinf wrote this:
              >
              >Hello group,
              >>
              >I've inherited a box running FC6.
              >>
              >The website I'm trying to copy across to it ran fine on FC5.. PHP & MySQL
              >were set up 'out-the-box' so the site just worked.
              >>
              >Somethings changed with FC6.
              >>
              >Trying to run the DB script now gives:
              >>
              > PHP Fatal error: Call to undefined function mysql_connect()
              >>
              >Looking at phpinfo();, the configure command has the switch
              >"--without-mysql" in it, which I figure is the root of my problem.
              >>
              >MySQL is definitely installed on the box, I've a database up and running
              >on that just fine. It can be accessed locally and remotely.
              >>
              >My question is, what's the simplest way to get PHP to recognise MySQL is
              >there to use? Preferably without breaking anything else (e.g., there's a
              >cron job that calls yum daily to do updates.. This must still work
              >afterwards!! )
              >>
              >Thanks for any pointers.
              >
              Are you sure it's MySQL and not PHP? Versions the same in FC5 vs FC6?
              >
              It is probably just that the php mysql module is not loaded. In Ubuntu
              it can be installed by synaptic.

                Comment

                • Toby A Inkster
                  #5
                  Re: PHP, MySQL &amp; FC6

                  martinf wrote:
                  PHP Fatal error: Call to undefined function mysql_connect()
                  On Mandrake (which is a fork of Redhat from long ago) there is a
                  particular package called "php-mysql" which includes the MySQL extension.
                  Try looking for a similarly named package.

                  --
                  Toby A Inkster BSc (Hons) ARCS
                  Contact Me ~ http://tobyinkster.co.uk/contact
                  Geek of ~ HTML/SQL/Perl/PHP/Python*/Apache/Linux

                  * = I'm getting there!

                    Comment

                    Previous template Next
                    Working...