mysql5 & php5 not working, help? - GoFuckYourself.com

Mr Pheer · 04-17-2007, 10:57 PM

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 · 04-17-2007, 11:05 PM

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 · 04-17-2007, 11:06 PM

more details... what's happening?

Mr Pheer · 04-17-2007, 11:20 PM

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 · 04-17-2007, 11:23 PM

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

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

Mr Pheer · 04-17-2007, 11:28 PM

Quote:

Originally Posted by GrouchyAdmin

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 · 04-17-2007, 11:30 PM

Quote:

Originally Posted by Mr Pheer

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 · 04-17-2007, 11:31 PM

Quote:

Originally Posted by GrouchyAdmin

You can install many of these with 'sysinstall'.

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

GrouchyAdmin · 04-17-2007, 11:33 PM

Quote:

Originally Posted by Mr Pheer

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 · 04-17-2007, 11:48 PM

Quote:

Originally Posted by GrouchyAdmin

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 · 04-18-2007, 12:41 AM

i am running php5 with mysql5 no issues

Mr Pheer · 04-18-2007, 02:20 AM

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 · 04-18-2007, 03:51 AM

Quote:

Originally Posted by 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

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 · 04-18-2007, 12:02 PM

Quote:

Originally Posted by Fris

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 · 04-18-2007, 12:21 PM

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 · 04-18-2007, 12:27 PM

joel to the rescue

fris · 04-18-2007, 01:21 PM

Quote:

Originally Posted by 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)

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

most of those are needed for any decent web site

04-17-2007, 10:57 PM	#1
Mr Pheer Retired Industry Role: Join Date: Dec 2002 Posts: 21,222	mysql5 & php5 not working, help? 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 __________________ 2 lifeguards for Jessica

04-17-2007, 11:05 PM	#2
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	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. __________________ AIM: GrouchyGfy

04-17-2007, 11:06 PM	#3
Swish Confirmed User Join Date: Mar 2006 Location: San Diego, CA Posts: 1,421	more details... what's happening? __________________ Naughty America - Director of Technology It's a CELEBRATION bitches!! For the hottest content promote Naughty America! swish at naughtyamerica dot com \| ICQ: 226 737 620 \| See Who I Am At AdultWhosWho.com!

04-17-2007, 11:20 PM	#4
Mr Pheer Retired Industry Role: Join Date: Dec 2002 Posts: 21,222	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 __________________ 2 lifeguards for Jessica

04-17-2007, 11:23 PM	#5
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	You didn't install the modules? Oh, wow. Look for other php5-extensions. You can install many of these with 'sysinstall'. __________________ AIM: GrouchyGfy

04-18-2007, 12:41 AM	#11
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	i am running php5 with mysql5 no issues

04-18-2007, 02:20 AM	#12
Mr Pheer Retired Industry Role: Join Date: Dec 2002 Posts: 21,222	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 __________________ 2 lifeguards for Jessica

04-18-2007, 12:21 PM	#15
rowan Too lazy to set a custom title Join Date: Mar 2002 Location: Australia Posts: 17,393	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)

04-18-2007, 12:27 PM	#16
split_joel Confirmed User Join Date: Jan 2005 Posts: 2,270	joel to the rescue __________________ E-mail marketing - Automation Scripting - IP Space AIM: splitjoelp ICQ: 254759453 skype - splitjoelp 702-941-6465