How do I add mysql to php? [SOLVED]

cwc · Last edited by cwc on Thu Jun 19, 2008 1:02 pm; edited 1 time in total

Edited after we solved the problem.
The key was to add mysl and mysqli (refer to this post) in the /etc/make.conf and

add:
dev-lang/php mysql mysqli
dev-lang/php apache2
dev-db/mysql -berkdb innodb other_use_flags
in /etc/portage/package.use

********************************************************************
I've installed apache 2 php and mysql on a testing box.
Now I'm trying to load the mysql modules with apache with no luck.

Any hints out there?

Here is my make.conf for apache.

APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias proxy"

Here is my php infro dump"

makism · Tux's lil' helper Joined: 24 Oct 2007 Posts: 85

as ./configure indicates, you have no support for mysql in php...
try, emerging php again, with USE="mysql mysqli"

cwc · Posted: Wed Jun 18, 2008 6:54 pm Post subject: I added mysql and mysqli

No luck.

I emerged apache again with

APACHE2_MODULES="actions alias auth_basic mysql mysqli authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias proxy"

I'm not sure what to do now. I might have to emerge php again so I get the mysql.so rather than the mysql.dll.

Hmmmm. Any other ideas?
_________________
Without diversity there can be no evolution:)

tgR10 · Posted: Wed Jun 18, 2008 8:08 pm Post subject:

xtz · Posted: Wed Jun 18, 2008 8:10 pm Post subject:

mysql.dll

kashani · Posted: Wed Jun 18, 2008 8:34 pm Post subject:

I would emerge -pv php and make sure that you see mysql and mysqli USE flags are turned on. Then emerge php. Emerging apache again does not affect PHP at all.

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

cwc · Posted: Wed Jun 18, 2008 9:33 pm Post subject:

cwc · Posted: Wed Jun 18, 2008 10:28 pm Post subject: no luck

kashani · Posted: Wed Jun 18, 2008 10:30 pm Post subject:

what is the output of emerge -pv php and have you restarted apache since you rebuilt php?

kashani
_________________
Will personally fix your server in exchange for motorcycle related shop tools in good shape.

zyko · Posted: Wed Jun 18, 2008 10:45 pm Post subject:

Is APACHE2_MODULES the same as USE? Make sure to set the right USE flags for dev-lang/php in addition to APACHE2_MODULES.

What's the output of "emerge -pvt php"?

cwc · Posted: Wed Jun 18, 2008 11:38 pm Post subject:

cwc · Posted: Wed Jun 18, 2008 11:41 pm Post subject: setting use and apache?

Mad Merlin · Veteran Joined: 09 May 2005 Posts: 1155

zyko · Posted: Thu Jun 19, 2008 12:35 am Post subject:

There you go, you have "-mysql -mysqli" in your use flags.

Edit your /etc/portage/package.use to use those two flags. You need a line like this in there:

cwc · Posted: Thu Jun 19, 2008 1:43 am Post subject:

cwc · Posted: Thu Jun 19, 2008 3:32 am Post subject:

Mad Merlin · Veteran Joined: 09 May 2005 Posts: 1155

make.conf is global (it applies to all packages), while package.use only applies to individual packages ('dev-lang/php mysql mysqli' for example adds the mysql and mysqli USE flags to dev-lang/php only). package.use takes precedence over make.conf, but you only need to set a USE flag once. package.use comes in handy when you want a specific package's USE flags to differ from the global USE flags.

emerge -avt is short for emerge -a -v -t, you should be able to find -a -v and -t in the emerge man page.
_________________
Game! - Where the stick is mightier than the sword!

zyko · Posted: Thu Jun 19, 2008 4:36 am Post subject:

I would recommend that you always use -avt when you emerge something.

-v (--verbose) makes emerge print more information.

-t (--tree) arranges items according to dependency structures. Useful to quickly spot which package depends on what.

-a (--ask) shows you what emerge would like to do and then asks if you agree (y/n). This way you can quickly examine use flags etc. before you actually do stuff.

Blindly emerging (without -a or -p) isn't a very smart thing to do. Portage offers you total control, so go ahead and use it. That's what it's all about.

There's more info here: http://gentoo-wiki.com/HOWTO_Use_Portage_Correctly and in the official documentation over at http://gentoo.org/doc/en/ .

cwc · Posted: Thu Jun 19, 2008 1:10 pm Post subject: Thank you all!

Thanks to all that helped on this one! This was a big help. In the past I've used Fedora and Redhat and all the work was done for you which made installation easy but you did not have the speed or control as with Gentoo. With all the help I've got since I started this install in late March (slow learner here) I should be able to start setting up Gentoo boxes in out off line lab at the school I teach at.

This is one of the best Linux Forum in the world!
_________________
Without diversity there can be no evolution:)