Page 1 of 2

Help with apache Mysql Php (Solved)

Posted: Wed Mar 08, 2006 10:43 am
by Rodeo
Hi im tryin to get a website runnin from my computer,Im running into problems while tryin to install postnuke it keeps saying no database made error on line 350,Which leads me to believe there is something not happening with mySql5 or Php5,Im new to almost everything So any advice would help Thank's.

P.s if there is another post about this im sorry i looked thru alot of post's and didn't find nething so a link would be awesome Thanks again

Posted: Wed Mar 08, 2006 10:48 am
by feyd
It may require that you create a database for it to use before it can go further in the installation. Log into MySQL via command line under root or similarly powered level control. Create the database for it to use. Then try again.

Posted: Wed Mar 08, 2006 12:04 pm
by Rodeo
i went to the command line and it said to type create database Test; and it will create one which it did,But when i try to use that when installing postnuke it say's no database made

Posted: Wed Mar 08, 2006 12:19 pm
by feyd

Posted: Wed Mar 08, 2006 1:54 pm
by Rodeo
i tried useing that page and it's telling me to install phpmyadmin which i try to do but with no luck i install mysql after i installed php and apache would that make a diffrence when tryin to get a database to use?


Is there something ez i can use to make a website on my computer? like a program that does all this for me i just want to use postnuke Anyone know?

Posted: Thu Mar 09, 2006 12:45 pm
by a94060
if you want to manage your databases and dont want to go thru all the command line stuff,you should get PHPMyAdmin

Posted: Fri Mar 10, 2006 12:42 am
by Rodeo
i have tried the myadmin i can't seem to get it working either ;\

Posted: Fri Mar 10, 2006 1:28 am
by RobertGonzalez
Rodeo wrote:i have tried the myadmin i can't seem to get it working either ;\
What errors are you getting from phpMyAdmin? Are you sure the database username you supplied to your app are good and that they have the correct database permissions? There are lot of things that might be causing your problems. A little more information might be useful.

Posted: Fri Mar 10, 2006 12:30 pm
by a94060
are you sure that the phpmyadmin is configured correctly? are you sure that MYSQL is even runing in the background? in linux,try using the command

Code: Select all

/etc/init.d/mysql restart
for windows,check out the services panel or run the mysql command client shortcut and see if it is runnng.


i think that the best bet is that your permissions are wrong somehow.

Posted: Fri Mar 10, 2006 2:07 pm
by Rodeo
in mysql i can create a database with the Create database test;
and it says ok but i can't seem to get postnuke to install when usein the database,
it says can't create database i have tried clickin the create database and without.im not sure if im supposed to use localhost or not, this is the link that my site has

http://rodeos.dyndns.org:1500/ Thank's for any advice

this is the error it says


No database made.
Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\includes\classes\adodb\drivers\adodb-mysql.inc.php on line 350

Posted: Fri Mar 10, 2006 2:13 pm
by feyd
Rodeo wrote:Fatal error: Call to undefined function mysql_connect() in C:\Program Files\Apache Group\Apache2\htdocs\includes\classes\adodb\drivers\adodb-mysql.inc.php on line 350
Well that says it right there. PHP 5 doesn't have MySQL built-in. You've got to load the extension.

Open your php.ini, find the extensions section, uncomment or add extension=php_mysql.dll and extension=php_mysqli.dll. Save the file and restart Apache.

Posted: Fri Mar 10, 2006 4:09 pm
by Rodeo
you said open the php.ini in the c:\php folder correct? if so should it look like this?

; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

;extension=php_mbstring.dll
;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
;extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
;extension=php_mssql.dll
;extension=php_msql.dll
;extension=php_mysql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll
;extension=php_oracle.dll
;extension=php_pgsql.dll
;extension=php_shmop.dll
;extension=php_snmp.dll
;extension=php_sockets.dll
;extension=php_sqlite.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
;extension=php_xmlrpc.dll
;extension=php_xsl.dll
extension=php_mysql.dll
extension=php_mysqli.dll

and if im useing php5 should i put the php_mysql5.dll?thanks for the advice

Posted: Fri Mar 10, 2006 4:20 pm
by feyd
read the PHP 5 notes here.

Posted: Fri Mar 10, 2006 5:41 pm
by Rodeo
ok i got everything working except one thing.For some reason i can't use my

http://rodeos.dyndns.org:3000 for it to go to the site i have to go to http://127.0.0.1/
How do i change this so it will use the other link so everyone can go to my site,Any advice is a help thanks

Posted: Fri Mar 10, 2006 5:55 pm
by feyd
which site are you talking about?