Mysql5/PHP5 installed from ports on FBSD 6

Playing around with a new machine, installed FBSD 6 and
decided to try the
latest PHP5 and MySQL5 in the ports tree. Normally using
PHP4 something
under apache 1.3.29 for ages now.

Did a portsnap to get the latest port tree.

Built from ports: apache 2.0.55, then mysql 5.0.19 and
started it then
built php 5.1.2 and installed the php5 extensions for mysql.

Everything starts up ok, hit the server and do a phpinfo()
ok things look
like they went ok, scroll down and see for the mysql
settings:

Active Persistent Links 	0
Active Links 	0
Client API version 	5.0.19
MYSQL_MODULE_TYPE 	no value
MYSQL_SOCKET 	/tmp/mysql.sock
MYSQL_INCLUDE 	no value
MYSQL_LIBS 	no value

oh thats not good, seeing the INCLUDE and LIBS with 'no
value'. So copy
over a small test db and some php scripts to the new server,
all I get
output is 'error' when doing a sql query via php...nothing
in
httpd-error.log like my other php4/apache1.3 machine either,
so I dont
know how its failing.

Did I miss a --with-mysql somewhere while doing php?

Anyone have an idea here of what to try next?

Thanks.


_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

On Wed, Apr 05, 2006 at 11:50:48PM -0700, Keith Woodworth
wrote:
> Built from ports: apache 2.0.55, then mysql 5.0.19 and
started it then
> built php 5.1.2 and installed the php5 extensions for
mysql.

Sounds good.

> Active Persistent Links 	0
> Active Links 	0
> Client API version 	5.0.19
> MYSQL_MODULE_TYPE 	no value
> MYSQL_SOCKET 	/tmp/mysql.sock
> MYSQL_INCLUDE 	no value
> MYSQL_LIBS 	no value

Nothing out of the ordinary in this output. Is MySQL still
running and
is the socket still there? Also, did you initialize the
MySQL database
and set a root password?

> oh thats not good, seeing the INCLUDE and LIBS with
'no value'. So
> copy over a small test db and some php scripts to the
new server, all
> I get output is 'error' when doing a sql query via
php...nothing in
> httpd-error.log like my other php4/apache1.3 machine
either, so I dont
> know how its failing.

By copying over a test db, do you mean importing an SQL
dump, or did you
just copy over some files? Also, are the privileges on the
test database
right and does it show up when you do a SHOW DATABASES; ?

And 'error' is the only thing the script spits out?
That's a bit hard
for diagnostics, IMHO.

-- 
Riemer Palstra		     		      Amsterdam, The Netherlands
riemerpalstra.com				 http://www.palstra.com/
_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

Try stopping everything - MySQL and Apache and then do

ldconfig -m /usr/local/lib/mysql

/usr/local/etc/rc.d/mysql-server.sh start
apachectl start or apachectl -DSSL start or
/usr/local/etc/rc.d/apache*.sh
start

See if that changes anything...

D



On 4/6/06, Keith Woodworth <kwoodycitytel.net> wrote:
>
>
> Playing around with a new machine, installed FBSD 6 and
decided to try the
> latest PHP5 and MySQL5 in the ports tree. Normally
using PHP4 something
> under apache 1.3.29 for ages now.
>
> Did a portsnap to get the latest port tree.
>
> Built from ports: apache 2.0.55, then mysql 5.0.19 and
started it then
> built php 5.1.2 and installed the php5 extensions for
mysql.
>
> Everything starts up ok, hit the server and do a
phpinfo() ok things look
> like they went ok, scroll down and see for the mysql
settings:
>
> Active Persistent Links         0
> Active Links    0
> Client API version      5.0.19
> MYSQL_MODULE_TYPE       no value
> MYSQL_SOCKET    /tmp/mysql.sock
> MYSQL_INCLUDE   no value
> MYSQL_LIBS      no value
>
> oh thats not good, seeing the INCLUDE and LIBS with
'no value'. So copy
> over a small test db and some php scripts to the new
server, all I get
> output is 'error' when doing a sql query via
php...nothing in
> httpd-error.log like my other php4/apache1.3 machine
either, so I dont
> know how its failing.
>
> Did I miss a --with-mysql somewhere while doing php?
>
> Anyone have an idea here of what to try next?
>
> Thanks.
>
>
> _______________________________________________
> freebsd-ispfreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"
>



--
Derrick T. Woolworth, President
ServeTheWeb, LLC.  http://www.ServeTheWeb.com

_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

Try stopping everything - MySQL and Apache and then do

ldconfig -m /usr/local/lib/mysql

/usr/local/etc/rc.d/mysql-server.sh start
apachectl start or apachectl -DSSL start or
/usr/local/etc/rc.d/apache*.sh
start

See if that changes anything...

D



On 4/6/06, Keith Woodworth <kwoodycitytel.net> wrote:
>
>
> Playing around with a new machine, installed FBSD 6 and
decided to try the
> latest PHP5 and MySQL5 in the ports tree. Normally
using PHP4 something
> under apache 1.3.29 for ages now.
>
> Did a portsnap to get the latest port tree.
>
> Built from ports: apache 2.0.55, then mysql 5.0.19 and
started it then
> built php 5.1.2 and installed the php5 extensions for
mysql.
>
> Everything starts up ok, hit the server and do a
phpinfo() ok things look
> like they went ok, scroll down and see for the mysql
settings:
>
> Active Persistent Links         0
> Active Links    0
> Client API version      5.0.19
> MYSQL_MODULE_TYPE       no value
> MYSQL_SOCKET    /tmp/mysql.sock
> MYSQL_INCLUDE   no value
> MYSQL_LIBS      no value
>
> oh thats not good, seeing the INCLUDE and LIBS with
'no value'. So copy
> over a small test db and some php scripts to the new
server, all I get
> output is 'error' when doing a sql query via
php...nothing in
> httpd-error.log like my other php4/apache1.3 machine
either, so I dont
> know how its failing.
>
> Did I miss a --with-mysql somewhere while doing php?
>
> Anyone have an idea here of what to try next?
>
> Thanks.
>
>
> _______________________________________________
> freebsd-ispfreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"
>



--
Derrick T. Woolworth, President
ServeTheWeb, LLC.  http://www.ServeTheWeb.com

_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

Try stopping everything - MySQL and Apache and then do

ldconfig -m /usr/local/lib/mysql

/usr/local/etc/rc.d/mysql-server.sh start
apachectl start or apachectl -DSSL start or
/usr/local/etc/rc.d/apache*.sh
start

See if that changes anything...

D



On 4/6/06, Keith Woodworth <kwoodycitytel.net> wrote:
>
>
> Playing around with a new machine, installed FBSD 6 and
decided to try the
> latest PHP5 and MySQL5 in the ports tree. Normally
using PHP4 something
> under apache 1.3.29 for ages now.
>
> Did a portsnap to get the latest port tree.
>
> Built from ports: apache 2.0.55, then mysql 5.0.19 and
started it then
> built php 5.1.2 and installed the php5 extensions for
mysql.
>
> Everything starts up ok, hit the server and do a
phpinfo() ok things look
> like they went ok, scroll down and see for the mysql
settings:
>
> Active Persistent Links         0
> Active Links    0
> Client API version      5.0.19
> MYSQL_MODULE_TYPE       no value
> MYSQL_SOCKET    /tmp/mysql.sock
> MYSQL_INCLUDE   no value
> MYSQL_LIBS      no value
>
> oh thats not good, seeing the INCLUDE and LIBS with
'no value'. So copy
> over a small test db and some php scripts to the new
server, all I get
> output is 'error' when doing a sql query via
php...nothing in
> httpd-error.log like my other php4/apache1.3 machine
either, so I dont
> know how its failing.
>
> Did I miss a --with-mysql somewhere while doing php?
>
> Anyone have an idea here of what to try next?
>
> Thanks.
>
>
> _______________________________________________
> freebsd-ispfreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"
>



--
Derrick T. Woolworth, President
ServeTheWeb, LLC.  http://www.ServeTheWeb.com

_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

Try stopping everything - MySQL and Apache and then do

ldconfig -m /usr/local/lib/mysql

/usr/local/etc/rc.d/mysql-server.sh start
apachectl start or apachectl -DSSL start or
/usr/local/etc/rc.d/apache*.sh
start

See if that changes anything...

D



On 4/6/06, Keith Woodworth <kwoodycitytel.net> wrote:
>
>
> Playing around with a new machine, installed FBSD 6 and
decided to try the
> latest PHP5 and MySQL5 in the ports tree. Normally
using PHP4 something
> under apache 1.3.29 for ages now.
>
> Did a portsnap to get the latest port tree.
>
> Built from ports: apache 2.0.55, then mysql 5.0.19 and
started it then
> built php 5.1.2 and installed the php5 extensions for
mysql.
>
> Everything starts up ok, hit the server and do a
phpinfo() ok things look
> like they went ok, scroll down and see for the mysql
settings:
>
> Active Persistent Links         0
> Active Links    0
> Client API version      5.0.19
> MYSQL_MODULE_TYPE       no value
> MYSQL_SOCKET    /tmp/mysql.sock
> MYSQL_INCLUDE   no value
> MYSQL_LIBS      no value
>
> oh thats not good, seeing the INCLUDE and LIBS with
'no value'. So copy
> over a small test db and some php scripts to the new
server, all I get
> output is 'error' when doing a sql query via
php...nothing in
> httpd-error.log like my other php4/apache1.3 machine
either, so I dont
> know how its failing.
>
> Did I miss a --with-mysql somewhere while doing php?
>
> Anyone have an idea here of what to try next?
>
> Thanks.
>
>
> _______________________________________________
> freebsd-ispfreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"
>



--
Derrick T. Woolworth, President
ServeTheWeb, LLC.  http://www.ServeTheWeb.com

_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

Try stopping everything - MySQL and Apache and then do

ldconfig -m /usr/local/lib/mysql

/usr/local/etc/rc.d/mysql-server.sh start
apachectl start or apachectl -DSSL start or
/usr/local/etc/rc.d/apache*.sh
start

See if that changes anything...

D



On 4/6/06, Keith Woodworth <kwoodycitytel.net> wrote:
>
>
> Playing around with a new machine, installed FBSD 6 and
decided to try the
> latest PHP5 and MySQL5 in the ports tree. Normally
using PHP4 something
> under apache 1.3.29 for ages now.
>
> Did a portsnap to get the latest port tree.
>
> Built from ports: apache 2.0.55, then mysql 5.0.19 and
started it then
> built php 5.1.2 and installed the php5 extensions for
mysql.
>
> Everything starts up ok, hit the server and do a
phpinfo() ok things look
> like they went ok, scroll down and see for the mysql
settings:
>
> Active Persistent Links         0
> Active Links    0
> Client API version      5.0.19
> MYSQL_MODULE_TYPE       no value
> MYSQL_SOCKET    /tmp/mysql.sock
> MYSQL_INCLUDE   no value
> MYSQL_LIBS      no value
>
> oh thats not good, seeing the INCLUDE and LIBS with
'no value'. So copy
> over a small test db and some php scripts to the new
server, all I get
> output is 'error' when doing a sql query via
php...nothing in
> httpd-error.log like my other php4/apache1.3 machine
either, so I dont
> know how its failing.
>
> Did I miss a --with-mysql somewhere while doing php?
>
> Anyone have an idea here of what to try next?
>
> Thanks.
>
>
> _______________________________________________
> freebsd-ispfreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"
>



--
Derrick T. Woolworth, President
ServeTheWeb, LLC.  http://www.ServeTheWeb.com

_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

On Thu, 6 Apr 2006, Riemer Palstra wrote:

|->On Wed, Apr 05, 2006 at 11:50:48PM -0700, Keith
Woodworth wrote:
|->
|->> Active Persistent Links 	0
|->> Active Links 	0
|->> Client API version 	5.0.19
|->> MYSQL_MODULE_TYPE 	no value
|->> MYSQL_SOCKET 	/tmp/mysql.sock
|->> MYSQL_INCLUDE 	no value
|->> MYSQL_LIBS 	no value
|->
|->Nothing out of the ordinary in this output. Is MySQL
still running and
|->is the socket still there? Also, did you initialize
the MySQL database
|->and set a root password?

Really? having no value above is ok? yes mysql is still
running and the
socket is still in /tmp.

I did init the database - mysql_install_db, change the
perms/ownership as
mysql was not starting and a quick google showed me that
problem.

Didnt set the root yet...shortcutting things now as Ive been
staring at
php and perl all day and starting to get tired.

|->> oh thats not good, seeing the INCLUDE and LIBS
with 'no value'. So
|->> copy over a small test db and some php scripts to
the new server, all
|->> I get output is 'error' when doing a sql query
via php...nothing in
|->> httpd-error.log like my other php4/apache1.3
machine either, so I dont
|->> know how its failing.
|->
|->By copying over a test db, do you mean importing an
SQL dump, or did you
|->just copy over some files? Also, are the privileges on
the test database
|->right and does it show up when you do a SHOW
DATABASES; ?
|->
|->And 'error' is the only thing the script spits out?
That's a bit hard
|->for diagnostics, IMHO.

Created the directory under /var/db/mysql, copied over the 3
files that
make that database up. Login to mysql and the database is
there, show
tables shows the table and a select * from <table>
gives me the data that
I know is there.

And yes 'error' is the only thing that gets output to the
browser when the
php script gets hit. I know its not great.

I think I need to look at mysql more as I did things a bit
quick and dirty
here.

Thanks.



_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

Well, Keith, Riemer is right - those values for
MYSQL_INCLUDE and MYSQL_LIBS
are correct.  I'm running the same config on FreeBSD 6.0
and show the same
values, so I just assumed it might be your mysql client
libraries weren't
available, but more likely than not, if that were the case,
Apache wouldn't
start or would give and error about not being able to load
the mysql module.

Make sure you have display_errors turned on - set
error_reporting to E_ALL
and restart Apache and see if you get a better error
message.

And I really hate to say this, but if all else fails,
reboot.

D


On 4/6/06, Keith Woodworth <kwoodycitytel.net> wrote:
>
> On Thu, 6 Apr 2006, Riemer Palstra wrote:
>
> |->On Wed, Apr 05, 2006 at 11:50:48PM -0700, Keith
Woodworth wrote:
> |->
> |->> Active Persistent Links    0
> |->> Active Links       0
> |->> Client API version         5.0.19
> |->> MYSQL_MODULE_TYPE  no value
> |->> MYSQL_SOCKET       /tmp/mysql.sock
> |->> MYSQL_INCLUDE      no value
> |->> MYSQL_LIBS         no value
> |->
> |->Nothing out of the ordinary in this output. Is
MySQL still running and
> |->is the socket still there? Also, did you
initialize the MySQL database
> |->and set a root password?
>
> Really? having no value above is ok? yes mysql is still
running and the
> socket is still in /tmp.
>
> I did init the database - mysql_install_db, change the
perms/ownership as
> mysql was not starting and a quick google showed me
that problem.
>
> Didnt set the root yet...shortcutting things now as Ive
been staring at
> php and perl all day and starting to get tired.
>
> |->> oh thats not good, seeing the INCLUDE and
LIBS with 'no value'. So
> |->> copy over a small test db and some php
scripts to the new server, all
> |->> I get output is 'error' when doing a sql
query via php...nothing in
> |->> httpd-error.log like my other php4/apache1.3
machine either, so I
> dont
> |->> know how its failing.
> |->
> |->By copying over a test db, do you mean importing
an SQL dump, or did
> you
> |->just copy over some files? Also, are the
privileges on the test
> database
> |->right and does it show up when you do a SHOW
DATABASES; ?
> |->
> |->And 'error' is the only thing the script spits
out? That's a bit hard
> |->for diagnostics, IMHO.
>
> Created the directory under /var/db/mysql, copied over
the 3 files that
> make that database up. Login to mysql and the database
is there, show
> tables shows the table and a select * from
<table> gives me the data that
> I know is there.
>
> And yes 'error' is the only thing that gets output to
the browser when the
> php script gets hit. I know its not great.
>
> I think I need to look at mysql more as I did things a
bit quick and dirty
> here.
>
> Thanks.
>
>
>
> _______________________________________________
> freebsd-ispfreebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"
>



--
Derrick T. Woolworth, President
ServeTheWeb, LLC.  http://www.ServeTheWeb.com

_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"

On Thu, 6 Apr 2006, Derrick T. Woolworth wrote:

|->Try stopping everything - MySQL and Apache and then do
|->
|->ldconfig -m /usr/local/lib/mysql
|->
|->/usr/local/etc/rc.d/mysql-server.sh start
|->apachectl start or apachectl -DSSL start or
/usr/local/etc/rc.d/apache*.sh
|->start

Ok, I'm way to tired now... 

I'm not sure if this did it or not, but I think I was
chasing my
tail with the 'no value' on the phpinfo() for mysql libs.

The queries work as they should with the little test db I
have and the php
scripts that go with it.

It might have been partially me being to tired, not setting
the password
on the sql side, taking the password out of the php script,
putting it
back in, taking it out again and now it seems to work. I get
output of
'error' when the password is in the php script, and it
works as it should
when there is no password there...

been awake almost 20 hrs now...had enough.

Thanks guys for the help. Much appreciated.

Keith
_______________________________________________
freebsd-ispfreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to
"freebsd-isp-unsubscribefreebsd.org"