Problem after an upgrade to php 5.0.1 and Apache 1.3.31

[NothingHere]

Hello,

I have upgraded, on linux redhat 8, to Apache 1.3.31 and PHP 5.0.1.
I think all was good but, POST method on Form did not work, and create of
mysql db wouldn't work ( with mysql_create_db() I have the error "Call to
undefined function : mysql_create_db()").

I think I have doing something wrong when I was installing PHP, so I have
rebuild it with a minimal configuration (just mysql, apxs, and
config-file-path ).
Nothing appens ... same problem as above.

I decided to go back to my old PHP (4.3.2) and Apache (1.3.29) ... always
same problem (and I've tested with all my config option or just basic config
option).

I need to use mysql_create_db() (yes I know it's depreciated), and of course
I need to use the post method in my form.

I've try to not specify my mysql dir when I do "./configure --with-mysql",
but I need to specify on configure of PHP where mysql is ( so I use
../configure --with-mysql=/opt/mysql ).

All other query between php and mysql seem to work fine ( and PHPMyAdmin
works fine ! ).

Anyone have an idea ? I fond nothing on google ...

Please, need help ... really !

[Polaris]

"NothingHere" <nothing_h@hotmail.com> schreef in bericht
news:ci4lli$ff8$1@news-reader3.wanadoo.fr...

> Hello,
>
> I have upgraded, on linux redhat 8, to Apache 1.3.31 and PHP 5.0.1.
> I think all was good but, POST method on Form did not work, and create of
> mysql db wouldn't work ( with mysql_create_db() I have the error "Call to
> undefined function : mysql_create_db()").
>
> I think I have doing something wrong when I was installing PHP, so I have
> rebuild it with a minimal configuration (just mysql, apxs, and
> config-file-path ).
> Nothing appens ... same problem as above.
>
> I decided to go back to my old PHP (4.3.2) and Apache (1.3.29) ... always
> same problem (and I've tested with all my config option or just basic

config

> option).
>
> I need to use mysql_create_db() (yes I know it's depreciated), and of

course

> I need to use the post method in my form.
>
> I've try to not specify my mysql dir when I do "./configure --with-mysql",
> but I need to specify on configure of PHP where mysql is ( so I use
> ./configure --with-mysql=/opt/mysql ).
>
> All other query between php and mysql seem to work fine ( and PHPMyAdmin
> works fine ! ).

So php and mysql are working fine...So the config from apache is ok an
dphi.ini seems to be fine to...

> Anyone have an idea ? I fond nothing on google ...
>
> Please, need help ... really !
>
>

Try next script:
<?php
// you need to replace server, username and paswword with your own data
$link = mysql_connect("server", "username", "password")
or exit("Can not make an connection: " . mysql_error());
if (mysql_create_db("my_db")) {
print ("Database successfully created\n");
} else {
printf ("Error with creation of database: %s\n", mysql_error());
}
?>

What does the script do? Errors or warnings...

Polaris.

[NothingHere]

"Polaris" <ask4polaris@hotmail.com> a écrit dans le message de
news:4145e250$0$62352$5fc3050@dreader2.news.tiscal i.nl...

>

> >

> Try next script:
> <?php
> // you need to replace server, username and paswword with your own

data

> $link = mysql_connect("server", "username", "password")
> or exit("Can not make an connection: " . mysql_error());
> if (mysql_create_db("my_db")) {
> print ("Database successfully created\n");
> } else {
> printf ("Error with creation of database: %s\n", mysql_error());
> }
> ?>
>
> What does the script do? Errors or warnings...
>
> Polaris.

I found, for the first problem, that register_global where Off, not On
(sorry that was a stupid mistake ;) ) but now it's work !

--

For the problem of "mysql_create_db()" I've try your script, and replace
username & password with root ones.
Thats what I have :
Fatal error: Call to undefined function mysql_create_db() in
/var/www/polaristest.php on line 5

Thats help you on something ? ... not me ... :(


Thanks for help ...

- Nothing

[Polaris]

"NothingHere" <nothing_h@hotmail.com> schreef in bericht
news:ci56oo$rfg$1@news-reader5.wanadoo.fr...

>
> "Polaris" <ask4polaris@hotmail.com> a écrit dans le message de
> news:4145e250$0$62352$5fc3050@dreader2.news.tiscal i.nl...

> >

> > >

> > Try next script:
> > <?php
> > // you need to replace server, username and paswword with your own

> data

> > $link = mysql_connect("server", "username", "password")
> > or exit("Can not make an connection: " . mysql_error());
> > if (mysql_create_db("my_db")) {
> > print ("Database successfully created\n");
> > } else {
> > printf ("Error with creation of database: %s\n", mysql_error());
> > }
> > ?>
> >
> > What does the script do? Errors or warnings...
> >
> > Polaris.

>
> I found, for the first problem, that register_global where Off, not On
> (sorry that was a stupid mistake ;) ) but now it's work !
>
> --
>
> For the problem of "mysql_create_db()" I've try your script, and replace
> username & password with root ones.
> Thats what I have :
> Fatal error: Call to undefined function mysql_create_db() in
> /var/www/polaristest.php on line 5
>
> Thats help you on something ? ... not me ... :(
>
>
> Thanks for help ...
>
> - Nothing
>
>

replace this line: if (mysql_create_db("my_db")) {
with: if (mysql_query("CREATE DATABASE my_db")) {

What does it do now? Errors /warnings...
I'm not giving up so fast ;-)

[L�ʻie Techie]

On Tue, 14 Sep 2004 00:25:35 +0200, NothingHere wrote:

> I found, for the first problem, that register_global where Off, not On
> (sorry that was a stupid mistake ;) ) but now it's work !

register_global is dangerous as it could overwrite any variables used by
your script! remember that register_globals creates variables for _all_
parameters passed in, not just the ones you were expecting.

> For the problem of "mysql_create_db()" I've try your script, and replace
> username & password with root ones.
> Thats what I have :
> Fatal error: Call to undefined function mysql_create_db() in
> /var/www/polaristest.php on line 5
>
> Thats help you on something ? ... not me ... :(

It tells me that PHP 5 does not include MySQL support by default (some
licensing issue). You need to recompile, telling configure where your
MySQL install root is:
configure --with-mysql=/usr

HTH,
La'ie Techie

[NothingHere]

"Polaris" <ask4polaris@hotmail.com> a écrit dans le message de
news:41462145$0$62374$5fc3050@dreader2.news.tiscal i.nl...

> >

> replace this line: if (mysql_create_db("my_db")) {
> with: if (mysql_query("CREATE DATABASE my_db")) {
>
> What does it do now? Errors /warnings...
> I'm not giving up so fast ;-)
>
>

That's works ... I have that :
" Database successfully created "
And I check in phpmyadmin : "my_db" exist ...

I don't want to change all my script with this line ... so, how can I get
mysql_create_db to works ?
It's stop working since I have upgraded to php 5.0.1 ... before with php
4.3.2 it's works fine ...

.... Thanks for help ;)

[NothingHere]

"La?ie Techie" <laie@win_remove_get_nospam_solutions.com> a écrit dans le
message de news:1095139809.xoBANyWg+FPZCtRVpTgK3A@teranews...

> On Tue, 14 Sep 2004 00:25:35 +0200, NothingHere wrote:
>

> > I found, for the first problem, that register_global where Off, not On
> > (sorry that was a stupid mistake ;) ) but now it's work !

>
> register_global is dangerous as it could overwrite any variables used by
> your script! remember that register_globals creates variables for _all_
> parameters passed in, not just the ones you were expecting.
>

Thanks, I would check that ...

> > For the problem of "mysql_create_db()" I've try your script, and replace
> > username & password with root ones.
> > Thats what I have :
> > Fatal error: Call to undefined function mysql_create_db() in
> > /var/www/polaristest.php on line 5
> >
> > Thats help you on something ? ... not me ... :(

>
> It tells me that PHP 5 does not include MySQL support by default (some
> licensing issue). You need to recompile, telling configure where your
> MySQL install root is:
> configure --with-mysql=/usr
>
> HTH,
> La'ie Techie
>

Here is my configure options I've used :
'./configure' '--with-apxs=/opt/apache/bin/apxs' '--with-mysql=/opt/mysql'
'--with-config-file-path=/etc'
As you can see, it's compiled with mysql.
Another think :
There is no "mysql.so" on my computer, and I installed php & apache from
source, not from rpm.
PHP 4.3.2 works fine with "mysql_create_db", and I see there is no line in
php.ini 4.3.2 about mysql.so , so I think I don't need it ...
"mysql_create_db" don't work since I've upgraded from PHP 4.3.2 to PHP 5.0.1
....

Hopes since you know that you can help me ... ;)
Thanks for all ...

- Nothing

[Steve]

I notice here [url]http://www.php.net/mysql_create_db[/url] that there is a
warning:

"This function will not be available if the MySQL extension was built
against a MySQL 4.x client library."
Does that apply to you?

---
Steve