sugar don't find mySQL installation!

[fcodebue]

hi guy,
after various configuration my install phase can't find any mysql on my redhat 9.0 server.
I have my mySQL with /tmp/lib/mysql.sock file when active but... sugar don't find it... infact while I'm trying to install sugarCRM 4.0.1 Opensource edition in Step 2: System Check Acceptance I have:
PHP version OK (ver 4.4.2)
?????????????????? Not Available
XML Parsing OK
cURL Library OK
Writable SugarCRM Configuration File (config.php) OK
Writable Custom Directory OK
Writable Modules Sub-Directories and Files OK
Writable Data Sub-Directories OK
Writable Cache Sub-Directories OK
Writable Session Save Path (/tmp) OK
PHP Safe Mode Turned Off OK
PHP Allow Call Time Pass Reference Turned On OK
PHP Memory Limit >= 20M OK (No Limit)

Note: Your php configuration file (php.ini) is located at:
/usr/local/lib/php.ini

it can't find and no print mySQL!!!!!
where I have to look!
fcodebue

[kbrill]

?????????????????? Not Available

?????????

Create a php script called 'phpinfo.php' in your CRM directory and put

<?php
phpinfo();
?>

in it, then browse to it and see if it mentions mySQL.

[fcodebue]

it's possible I find in phpInfo MYSQL section:

MYSQL_SOCKET /tmp/mysql.sock
and
mysql.default_socket /var/lib/mysql/mysql.sock

perhaps it's this my problem? php look into /tmp dir if mySQL is running but my real sock file is in /var/lib/mysql

fab10

[kbrill]

You might look into changing this section of your php.ini file

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

[joey]

A better method would be to add a symbolic link to link the two together rather than modifying your php.ini.

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

... should do the trick.

Regards,
Joey P.
SugarCRM

[fcodebue]

nothing todo!!!!!!!!!!!!!!!!

These are my config ( not all...)

PHP Version 4.4.2
'./configure' '--with-apxs=/www/bin/apxs' '--with-mysql' '--with-curl=../curl-7.12.2'


MySQL
Client API version 3.23.49
MYSQL_SOCKET /tmp/mysql.sock
mysql.default_socket /var/lib/mysql/mysql.sock

my.cnf
[client]
#password = mypwd
port = 3306
socket = /tmp/mysql.sock

[mysqld]
port = 3306
socket = /tmp/mysql.sock
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data

myserver.log last line
Version: '5.0.18-max-log' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Edition - Experimental (GPL)

Codebue Fabio

[nkendrick]

make sure you have php-mysql installed (yum install php-mysq if you have yum installedl) you might as well also install php-devel and mysql-devel

Hope this helps

[kbrill]

Do you have any other PHP/MySQL scripts on this server?

[fcodebue]

ya I have some other php/mySQL program...phpmyadmin

now I'm trying to reinstall all with mySQL 4.1.16

brb