Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

mysql issue

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers mysql issue
# 1  
Old 11-20-2003
mysql issue
I have a lot of files getting this on a new install of phpmysql 4.3.4
any ideas what would be causing this...
Fatal error: Call to undefined function: mysql_connect() in /home/httpd/vhosts/ucandevelopments.com/httpdocs/includes/functions/database.php on line 19
# 2  
Old 11-20-2003
Your PHP is not compiled with MySQL functions enabled. See if there are some RPM packages with the missing libraries. For example, php-mysql (I don't know the exact name)
# 3  
Old 11-20-2003
i did a search and my sql is on the server how do i enable it
# 4  
Old 11-20-2003
Mysql may be on the box, but is php compiled to use mysql?

If you look in your apache libexec directory (or whereever your php module is living (httpd.conf)) - do the following:

dump -C libphp4.so | grep -i mysql

If you don't see any mysql functions, your PHP wasn't compiled with mysql support (ieSmilie

In PHP src directory (php-4.0.3pl1/)

# ./configure --with-mysql \
--with-xml \
--enable-track-vars \
--with-apache=../apache_1.3.14 \

# make
# make install

Cheers,

Keith
# 5  
Old 11-20-2003
it is i got it working when i installed i was upgrading and forgot to remove the old php.ini so it was trying to use that as soon as i swithed and rebooted it worked
 
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

syntax issue mysql in bash script

I'm running mysql in a bash script mysql <<EOF query EOF one query is like this: UPDATE $dbname.$prefix"config" SET value = $var WHERE "$prefix"config.name = 'table colname'; with variable but it's giving an error i'm not sure what to put for "$prefix"config.name the table... (3 Replies)
Discussion started by: vanessafan99
3 Replies

2. Shell Programming and Scripting

syntax issue with quotes in mysql command for a bash script

i'm trying to write a bash script that executes a mysql statement mysql -sN -e INSERT INTO "$database"."$tableprefix"users (var1, var2,var3) VALUES (123, '1','') i don't know where to put the quotes it doesnt work with this one: ` it seems i can only put double quotes around the... (0 Replies)
Discussion started by: vanessafan99
0 Replies

3. Programming

LEFT JOIN issue in Mysql

I have a data table as follows: mysql> select * from validations where source = "a03"; +------------+-------+--------+ | date | price | source | +------------+-------+--------+ | 2001-01-03 | 80 | a03 | | 2001-01-04 | 82 | a03 | | 2001-01-05 | 84 | a03 | | 2001-01-06... (2 Replies)
Discussion started by: figaro
2 Replies

4. Linux

mysql server start issue

Hi, I have installed mysql in linux box as mysql-5.0.77-4.el5_6.6.. I would like to start the server. But there is no mysql file in this location /etc/init.d/ Please advice how to start the server now !! Thnaks, Mani (5 Replies)
Discussion started by: Mani_apr08
5 Replies

5. Web Development

Strange Mysql issue

Hi all, I recently changed the name of my hostname from 'abc123' to 'abc456' (as an example). I then added a user in my mysql database with the new host and removed references to the old users and hostname. The strange thing is though, a process using the database still uses the old... (1 Reply)
Discussion started by: muay_tb
1 Replies

6. Programming

derefencing issue with perl and mysql

I've tried every type of dereferencing I can think of but I still can't get to array data. #!/usr/bin/perl use DBI; use DBD::mysql; use DBI qw(:sql_types); $hostname = "localhost"; $database = "c2"; $username = "user"; $password = "password"; $dbh =... (4 Replies)
Discussion started by: s_becker
4 Replies

7. UNIX and Linux Applications

mysql query browser issue

Hi, I'm new to mysql, I've installed MYSQL on our unix server and started MYSQL on this server. I've now downloaded MYSQL Query Browser, when I try to connect to MYSQL server, I get the following error "could not connect to the specified instance" - MySQL Error Number 1130. From the... (3 Replies)
Discussion started by: venhart
3 Replies

8. UNIX for Dummies Questions & Answers

PHP-MySQL: POST issue

I am moving from a shared hosting environment to a dedicated box. The migration also involves a mySQL database managed using a web-based PHP interface. I can read the contents of the db (connection is good) but when I try to administer, the form variables aren't going from step 1 (add) to step 2... (0 Replies)
Discussion started by: adrious
0 Replies
Login or Register to Ask a Question