Re: Connect remote DB server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Shahmat,

I had installed all. But, it still can't work. The constrain is that I can't
install mysql on application server. That's why I need to make a remote db
connection... should I install the php-devel-*.rpm on application server?

Here is the rpm on APP server,
[webmas@devimc01 webmas]$ rpm -qa | grep -i php
php-mysql-4.3.2-11.1.ent
php-imap-4.3.2-11.1.ent
php-ldap-4.3.2-11.1.ent
php-4.3.2-11.1.ent
[webmas@devimc01 webmas]$ rpm -qa | grep -i mysql
php-mysql-4.3.2-11.1.ent
MySQL-devel-4.0.13-0
MySQL-shared-compat-4.0.13-0
MySQL-client-4.0.13-0

And, DB server,
[webmas@devimc02 webmas]$ rpm -qa | grep -i php
php-ldap-4.3.2-14.ent
php-4.3.2-14.ent
php-imap-4.3.2-14.ent
php-4.3.2-11.1.ent
php-mysql-4.3.2-14.ent
[webmas@devimc02 webmas]$ rpm -qa | grep -i mysql
MySQL-shared-compat-4.0.13-0
MySQL-client-4.0.13-0
MySQL-devel-4.0.13-0
MySQL-server-4.0.13-0
php-mysql-4.3.2-14.ent

Any idea?

Laurence

"Shahmat Dahlan" <shahmatd@xxxxxxxxxxxx> ???
news:416B43CA.9010104@xxxxxxxxxxxx ???...
> How about mysql client (which will include all the necessary libraries)?
> having php-mysql install, doesn't mean you will be able to connect if
> you don't have the libraries.
> Since I assume that you are using some form of redhat linux dist, how
> about the following packages (if I remember them correctly):
> 1. mysql-4.x
> 2. mysql-devel
> 3. mysqlclient
>
>
> Laurence Lim wrote:
>
> >Hi Shahmat,
> >
> >The platform im using is EL3, I have asked the engineer to install the
> >packages (rpms),
> >
> >php-imap-4.3.2-11.1.ent
> >php-ldap-4.3.2-11.1.ent
> >php-4.3.2-11.1.ent
> >php-mysql-4.3.2-11.1.ent
> >
> >Is these enough? Thanks for reply!
> >
> >"Shahmat Dahlan" <shahmatd@xxxxxxxxxxxx> ???
> >news:416A4CCD.3060906@xxxxxxxxxxxx ???...
> >
> >
> >>I think the mysql extension was not loaded, that's why you got the
> >>message, and it was not able to recognize the function mysql_connect.
> >>
> >>Fatal error: Call to undefined function: mysql_connect()
> >>
> >>how did you install your copy of php? compile it from source?
> >>
> >>
> >>Laurence Lim wrote:
> >>
> >>
> >>
> >>>Hi all, im new to PHP.net.
> >>>
> >>>Im developing a program to retrieve data from a remote DB server
running
> >>>MySQL. The code written as
> >>>
> >>>if (!($dbLink = mysql_connect("some.remote.host", $dbUser, $dbPass))) {
> >>> print ("mysql_connect failed!");
> >>> exit;
> >>>}
> >>>
> >>>But, it doesn't work... and return me the error msg,
> >>>
> >>>Fatal error: Call to undefined function: mysql_connect() in
> >>>/var/www/philately/hkpo-eng/request_information/test.php on line 6
> >>>
> >>>I have granted permission for access, no firewall blocking... Anyone
know
> >>>why it happens? Thanks for reply!
> >>>
> >>>Regards, Laurence
> >>>
> >>>
> >>>
> >>>
> >>>
> >
> >
> >

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux