phpinfo() not showing mySQL

FirstBorn · 07-04-2008, 12:08 AM

Hi!

When running phpinfo() script, mySQL is not
displayed in the output.

Linux Box: Mandriva 2005 Ltd. Edition

mySQL info:
Linux firstborn 2.6.11-6mdk #1 Tue Mar 22 16:04:32 CET 2005 i686

phpinfo(); does Not show mySQL.
Shut down and restarted httpd, and Still not there.

The versions of mySQL and PHP are below:
mySQL Server version: 5.0.51a
PHP Version 4.3.10

Any Ideas?

Thanks,
FirstBorn

bathory · 07-04-2008, 01:55 AM

How did you install php and mysql? If you used your distro's packages I guess you missed something like php-mysql or mysqli. If you built it from source you missed to add mysql support. Take a look at the configure line of phpinfo() to see how php was configured.

FirstBorn · 07-04-2008, 03:52 AM

Quote:

Originally Posted by bathory

The easiest way to upgrade, is to use your distro's package manager (that is urpmi in you case), since it can resolve any dependencies problems that may occur.

Hi bathory,

I've attempted:
urpmi php -wget
what is the correct syntax to upgrade?

Results:

Code:

urpmi php -wget
Unknown option: w
Unknown option: g
Unknown option: e
Unknown option: t
The package(s) are already installed

I've attached the 'help' for it here.

Thanks,
FirstBorn

Code:

urpmi version 4.6.24
Copyright (C) 1999-2005 Mandrakesoft.
This is free software and may be redistributed under the terms of the GNU GPL.

usage:
  --help         - print this help message.
  --update       - use only update media.
  --media        - use only the given media, separated by comma.
  --searchmedia  - use only the given media to search requested (or updated) packages.
  --excludemedia - do not use the given media, separated by comma.
  --sortmedia    - sort media according to substrings separated by comma.
  --synthesis    - use the given synthesis instead of urpmi db.
  --auto         - automatically select a package in choices.
  --auto-select  - automatically select packages to upgrade the system.
  --no-uninstall - never ask to uninstall a package, abort the installation.
  --keep         - keep existing packages if possible, reject requested
                   packages that leads to remove.
  --split-level  - split in small transaction if more than given packages
                   are going to be installed or upgraded,
                   default is 20.
  --split-length - small transaction length, default is 1.
  --fuzzy        - impose fuzzy search (same as -y).
  --src          - next package is a source package (same as -s).
  --install-src  - install only source package (no binaries).
  --clean        - remove rpm from cache before anything else.
  --noclean      - keep rpm not used in cache.
  --force        - force invocation even if some packages do not exist.
  --allow-nodeps - allow asking user to install packages without
                   dependencies checking.
  --allow-force  - allow asking user to install packages without
                   dependencies checking and integrity.
  --parallel     - distributed urpmi across machines of alias.
  --root         - use another root for rpm installation.
  --use-distrib  - configure urpmi on the fly from a distrib tree, useful
                   to install a chroot with --root option.
  --wget         - use wget to retrieve distant files.
  --curl         - use curl to retrieve distant files.
  --limit-rate   - limit the download speed.
  --resume       - resume transfer of partially-downloaded files
                   (--no-resume disables it, default is disabled).
  --proxy        - use specified HTTP proxy, the port number is assumed
                   to be 1080 by default (format is <proxyhost[:port]>).
  --proxy-user   - specify user and password to use for proxy
                   authentication (format is <user:password>).
  --bug          - output a bug report in directory indicated by
                   next arg.
  --env          - use specific environment (typically a bug
                   report).
  --verify-rpm   - verify rpm signature before installation
                   (--no-verify-rpm disable it, default is enabled).
  --test         - verify if the installation can be achieved correctly.
  --excludepath  - exclude path separated by comma.
  --excludedocs  - exclude doc files.
  --skip         - packages which installation should be skipped
  --more-choices - when several packages are found, propose more choices
                   than the default.
  --norebuild    - don't try to rebuild hdlist if not readable.
  --strict-arch  - upgrade only packages with the same architecture.
  -a             - select all matches on command line.
  -p             - allow search in provides to find package.
  -P             - do not search in provides to find package.
  -y             - impose fuzzy search (same as --fuzzy).
  -s             - next package is a source package (same as --src).
  -q             - quiet mode.
  -v             - verbose mode.

  names or rpm files given on command line will be installed.

FirstBorn · 07-04-2008, 06:59 AM

Quote:

Originally Posted by bathory

How did you install php and mysql? If you used your distro's packages I guess you missed something like php-mysql or mysqli. If you built it from source you missed to add mysql support. Take a look at the configure line of phpinfo() to see how php was configured.

Hi bathory,

Thanks for helping.

Are You referring to the "Configuration Command" section?
That one reads:
"This is irrelevant, look inside the /usr/share/doc/php-4.3.10/configure_command file.
urpmi is your friend, use it to install extensions not shown below."

Since I used Mandriva's install section to install this,
how would I go about fixing this?

Thanks,
FirstBorn

bathory · 07-04-2008, 07:15 AM

Quote:

Are You referring to the "Configuration Command" section?
That one reads:
"This is irrelevant, look inside the /usr/share/doc/php-4.3.10/configure_command file.
urpmi is your friend, use it to install extensions not shown below."

Yes, I'm referring to this part.
So since it says to use urpmi to install missing extensions, take a look at this that could be helpful.

Regards

FirstBorn · 07-04-2008, 07:16 AM

Quote:

Originally Posted by bathory

How did you install php and mysql? If you used your distro's packages I guess you missed something like php-mysql or mysqli. If you built it from source you missed to add mysql support. Take a look at the configure line of phpinfo() to see how php was configured.

Hi bathory,

Thank You Very Much for pointing Me in the right direction.

I had to log in as root to install the "php-mysql" that You
had suggested above.

I Really Appreciate Your Help!

It's All Fixed.

Thanks,
FirstBorn

FirstBorn · 07-04-2008, 07:21 AM

Quote:

Originally Posted by bathory

Yes, I'm referring to this part.
So since it says to use urpmi to install missing extensions, take a look at this that could be helpful.

Regards

Thanks, bathory,

Just ran "urpmi mysql" through the Konsole
... and the following results were displayed:
"The package(s) are already installed"

Am I safe to guess that I 'should' have no issues with
any dependencies or anything of the sort in the near future?

Thanks,
FirstBorn

bathory · 07-04-2008, 07:41 AM

Quote:

Am I safe to guess that I 'should' have no issues with
any dependencies or anything of the sort in the near future?

I guess you're OK. Perhaps you could upgrade php to a more recent version
Anyway glad you've made it.

Regards

FirstBorn · 07-04-2008, 08:18 AM

Quote:

Originally Posted by bathory

I guess you're OK. Perhaps you could upgrade php to a more recent version
Anyway glad you've made it.

Regards

Hi bathory,

Thanks.

Now that You mentioned it,
what's the BEST Way
(not necessarily the easiest)
method to Upgrade My php?

Should I just download it from
php.net and do the tar thing?

Thanks,
FirstBorn

bathory · 07-04-2008, 08:42 AM

The easiest way to upgrade, is to use your distro's package manager (that is urpmi in you case), since it can resolve any dependencies problems that may occur.

FirstBorn · 07-04-2008, 08:57 AM

Quote:

Originally Posted by bathory

The easiest way to upgrade, is to use your distro's package manager (that is urpmi in you case), since it can resolve any dependencies problems that may occur.

Hi bathory,

Not sure what happened, but My post was
posted above this one somewhere...

Anyway, here is My response.

Thanks,

FirstBorn
---------------------------------------

Quote:

Originally Posted by bathory

The easiest way to upgrade, is to use your distro's package manager (that is urpmi in you case), since it can resolve any dependencies problems that may occur.

Hi bathory,

I've attempted:
urpmi php -wget
what is the correct syntax to upgrade?

Results:

Code:

urpmi php -wget
Unknown option: w
Unknown option: g
Unknown option: e
Unknown option: t
The package(s) are already installed

I've attached the 'help' for it here.

Thanks,
FirstBorn

Code:

urpmi version 4.6.24
Copyright (C) 1999-2005 Mandrakesoft.
This is free software and may be redistributed under the terms of the GNU GPL.

usage:
  --help         - print this help message.
  --update       - use only update media.
  --media        - use only the given media, separated by comma.
  --searchmedia  - use only the given media to search requested (or updated) packages.
  --excludemedia - do not use the given media, separated by comma.
  --sortmedia    - sort media according to substrings separated by comma.
  --synthesis    - use the given synthesis instead of urpmi db.
  --auto         - automatically select a package in choices.
  --auto-select  - automatically select packages to upgrade the system.
  --no-uninstall - never ask to uninstall a package, abort the installation.
  --keep         - keep existing packages if possible, reject requested
                   packages that leads to remove.
  --split-level  - split in small transaction if more than given packages
                   are going to be installed or upgraded,
                   default is 20.
  --split-length - small transaction length, default is 1.
  --fuzzy        - impose fuzzy search (same as -y).
  --src          - next package is a source package (same as -s).
  --install-src  - install only source package (no binaries).
  --clean        - remove rpm from cache before anything else.
  --noclean      - keep rpm not used in cache.
  --force        - force invocation even if some packages do not exist.
  --allow-nodeps - allow asking user to install packages without
                   dependencies checking.
  --allow-force  - allow asking user to install packages without
                   dependencies checking and integrity.
  --parallel     - distributed urpmi across machines of alias.
  --root         - use another root for rpm installation.
  --use-distrib  - configure urpmi on the fly from a distrib tree, useful
                   to install a chroot with --root option.
  --wget         - use wget to retrieve distant files.
  --curl         - use curl to retrieve distant files.
  --limit-rate   - limit the download speed.
  --resume       - resume transfer of partially-downloaded files
                   (--no-resume disables it, default is disabled).
  --proxy        - use specified HTTP proxy, the port number is assumed
                   to be 1080 by default (format is <proxyhost[:port]>).
  --proxy-user   - specify user and password to use for proxy
                   authentication (format is <user:password>).
  --bug          - output a bug report in directory indicated by
                   next arg.
  --env          - use specific environment (typically a bug
                   report).
  --verify-rpm   - verify rpm signature before installation
                   (--no-verify-rpm disable it, default is enabled).
  --test         - verify if the installation can be achieved correctly.
  --excludepath  - exclude path separated by comma.
  --excludedocs  - exclude doc files.
  --skip         - packages which installation should be skipped
  --more-choices - when several packages are found, propose more choices
                   than the default.
  --norebuild    - don't try to rebuild hdlist if not readable.
  --strict-arch  - upgrade only packages with the same architecture.
  -a             - select all matches on command line.
  -p             - allow search in provides to find package.
  -P             - do not search in provides to find package.
  -y             - impose fuzzy search (same as --fuzzy).
  -s             - next package is a source package (same as --src).
  -q             - quiet mode.
  -v             - verbose mode.

  names or rpm files given on command line will be installed.

bathory · 07-04-2008, 09:05 AM

Since I'm not a Mandriva user, I can only point you to this post, to find out urpmi usage. Maybe Easy URPMI is more easy to use.

Regards

FirstBorn · 07-04-2008, 11:06 AM

Quote:

Originally Posted by bathory

Since I'm not a Mandriva user, I can only point you to this post, to find out urpmi usage. Maybe Easy URPMI is more easy to use.

Regards

Hi bathory,

Thanks.

I followed the instructions on that post and nothing
happened, so I'll look into the Easy URPMI as per Your
suggestion above.

Again, Thanks for All of Your Help!

Thanks,
FirstBorn