mysql5 & php5 not working, help?

[Mr Pheer]

can someone tell me why mysql5 and php5 dont work together?

been working on this for hours and I'm about to start breaking shit

OS is freebsd 6.1

[GrouchyAdmin]

What are you trying to do?

First, see if old password support is enabled in your mysql config.

Then, if you have to, recompile PHP to use the new libraries.

Sorry, can't help much more than that; I need to eat, too.

[Swish]

more details... what's happening?

[Mr Pheer]

looks like ports/lang/php5 was installed

but to use mysql, you have to have /ports/databases/php5-mysql installed instead

oh well was just a few wasted hours

[GrouchyAdmin]

You didn't install the modules? Oh, wow.

Look for other php5-extensions. You can install many of these with 'sysinstall'.

[Mr Pheer]

You didn't install the modules? Oh, wow.

Look for other php5-extensions. You can install many of these with 'sysinstall'.

i'm not the one that setup the server

but after doing all of this i think I'll just handle it myself in the future

[Swish]

i'm not the one that setup the server

but after doing all of this i think I'll just handle it myself in the future

Always a good idea

[Mr Pheer]

You can install many of these with 'sysinstall'.

that looks like some scary shit... which option is it?

[GrouchyAdmin]

that looks like some scary shit... which option is it?

Uhm, if you are not familiar, 'X', then 'OK' to exit. You can really fuck your shit up if you don't know what you're doing.

However, if you navigate through the ports, 'All', then go through 'php5', you can install imagick, et al.

[Mr Pheer]

Uhm, if you are not familiar, 'X', then 'OK' to exit. You can really fuck your shit up if you don't know what you're doing.

However, if you navigate through the ports, 'All', then go through 'php5', you can install imagick, et al.

how much do you charge to be a sysadmin?

[fris]

i am running php5 with mysql5 no issues

[Mr Pheer]

I still dont have this working

I have literaly wasted my whole fucking day on this
I havent left the house or anything

this is just fucking FUCKED

[fris]

I still dont have this working

I have literaly wasted my whole fucking day on this
I havent left the house or anything

this is just fucking FUCKED

here are some thing you can try

did you add mysql_enable="YES" to rc.conf?

did you edit /usr/local/etc/rc.d/mysql-server.sh to include --old-passwords

if so move below

edit your Makefile so it has these

(cut and paste)


--enable-ctype \
--with-curl=/usr/local/bin \
--enable-exif \
--with-gd \
--with-freetype-dir=/usr/local \
--with-jpeg-dir=/usr/local \
--with-png-dir=/usr/local \
--with-zlib-dir=/usr \
--enable-mbstring \
--with-mcal=/usr/local \
--with-mcrypt=/usr/local \
--with-mhash=/usr/local \
--with-mysql=/usr/local \
--with-ncurses=/usr \
--enable-overload \
--with-pcre-regex=yes \
--enable-posix \
--with-readline=/usr \
--enable-session \
--enable-sockets \
--with-mysqli=/usr/local/bin/mysql_config \
--enable-tokenizer \
--enable-xml \
--with-apxs=/usr/local/sbin/apxs \
--enable-libxml \
--with-libxml-dir=${LOCALBASE} \
--enable-reflection \
--enable-spl \


that should do it

[Mr Pheer]

here are some thing you can try

did you add mysql_enable="YES" to rc.conf?

did you edit /usr/local/etc/rc.d/mysql-server.sh to include --old-passwords

if so move below

edit your Makefile so it has these

(cut and paste)


--enable-ctype \
--with-curl=/usr/local/bin \
--enable-exif \
--with-gd \
--with-freetype-dir=/usr/local \
--with-jpeg-dir=/usr/local \
--with-png-dir=/usr/local \
--with-zlib-dir=/usr \
--enable-mbstring \
--with-mcal=/usr/local \
--with-mcrypt=/usr/local \
--with-mhash=/usr/local \
--with-mysql=/usr/local \
--with-ncurses=/usr \
--enable-overload \
--with-pcre-regex=yes \
--enable-posix \
--with-readline=/usr \
--enable-session \
--enable-sockets \
--with-mysqli=/usr/local/bin/mysql_config \
--enable-tokenizer \
--enable-xml \
--with-apxs=/usr/local/sbin/apxs \
--enable-libxml \
--with-libxml-dir=${LOCALBASE} \
--enable-reflection \
--enable-spl \


that should do it

would that be the mysql, or the php makefile?

[rowan]

That looks like a PHP makefile, but that's an awful lot of options - some of those packages it's referencing may not be installed. At the very least you probably need the --with-mysql option. Have a look at the INSTALL/README file in the PHP archive for information on how to compile. (You'll need to compile both Apache and PHP)

[split_joel]

joel to the rescue

[fris]

That looks like a PHP makefile, but that's an awful lot of options - some of those packages it's referencing may not be installed. At the very least you probably need the --with-mysql option. Have a look at the INSTALL/README file in the PHP archive for information on how to compile. (You'll need to compile both Apache and PHP)

php makefile, with freebsd it will install the needed packages automatically.

most of those are needed for any decent web site