Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum. |
Notices |
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
|
 |
11-28-2004, 01:31 PM
|
#1
|
LQ Newbie
Registered: Sep 2004
Posts: 17
Rep:
|
mysql
Slackware 10, kernel 2.6.7
cant connect to mysql via php.
It returns nothing, no error messages nothing.
Trying to run an Imagegallery that worked fine on another server, On my server all php functions work except mysql, the script contains error messages. for example if it canīt connect to mysql server it should say cant connect.... but all I get is a blank page. :/
|
|
|
11-28-2004, 02:49 PM
|
#2
|
LQ Newbie
Registered: May 2003
Location: The Netherlands
Distribution: LFS
Posts: 28
Rep:
|
The default of the newer versions of PHP is to generate no errors/warnings whatsoever on the page, but instead log them to the server log file. This is the best set-up for a production server, but not for a testing server.
To (temporarily) turn error-reporting on so you can debug your mysql connection, open your php.ini file and set the following:
error_reporting = E_ALL
display_errors = On
Don't forget to set them back to their old values (if desired) when you're done.
Alternatively, you can check Apache's error log to see what exactly goes wrong with the mysql connection.
|
|
|
11-28-2004, 03:22 PM
|
#3
|
LQ Newbie
Registered: Sep 2004
Posts: 17
Original Poster
Rep:
|
[Sun Nov 28 23:16:33 2004] [notice] Apache/1.3.32 (Unix) PHP/4.3.9 configured -- resuming normal operations
[Sun Nov 28 23:16:33 2004] [notice] Accept mutex: sysvsem (Default: sysvsem)
[Sun Nov 28 23:19:04 2004] [notice] caught SIGTERM, shutting down
thatīs all it says
hereīs some code
if (@mysql_query($sql)) {
echo 'Added comment<br><hr>';
} else {
echo 'It wasnīt possible to add any comments';
}
and itīs still just a blank page..... so thereīs something really wrong here
|
|
|
11-28-2004, 03:29 PM
|
#4
|
LQ Newbie
Registered: May 2003
Location: The Netherlands
Distribution: LFS
Posts: 28
Rep:
|
Quote:
if (@mysql_query($sql)) {
|
Ok, what you're saying with the '@mysql_query' there, is: "execute the function "mysql_query" and suppress any notices, warnings and errors it might generate". Remove the '@' to see the errors. For more information about error control in PHP, see the PHP manual.
|
|
|
11-28-2004, 03:41 PM
|
#5
|
LQ Newbie
Registered: Sep 2004
Posts: 17
Original Poster
Rep:
|
Yes indeed Iīm a newbie and should read the manual, however I removed the @ in different places...
Call to undefined function: mysql_connect()
so it doesnīt seem to support mysql functions at all
itīs compiled with mysql so I really dont understand this
hereīs the phpinfo output
Configure Command './configure' '--prefix=/usr' '--disable-static' '--with-apxs=/usr/sbin/apxs' '--sysconfdir=/etc' '--enable-discard-path' '--with-config-file-path=/etc/apache' '--enable-safe-mode' '--with-openssl' '--with-mhash' '--enable-bcmath' '--with-bz2' '--with-pic' '--enable-calendar' '--enable-ctype' '--with-gdbm' '--with-db3' '--with-imap-ssl=/usr/local/lib/c-client' '--with-imap=/usr/local/lib/c-client' '--enable-dbase' '--enable-ftp' '--with-iconv' '--with-exif' '--enable-exif' '--with-gd' '--enable-gd-native-ttf' '--with-jpeg-dir=/usr' '--with-png' '--with-gmp' '--with-mysql=shared,/usr' '--with-gettext=shared,/usr' '--with-expat-dir=/usr' '--with-xml' '--enable-wddx' '--with-mm=/usr' '--enable-trans-sid' '--enable-shmop' '--enable-sockets' '--with-regex=php' '--enable-sysvsem' '--enable-sysvshm' '--enable-yp' '--enable-memory-limit' '--with-tsrm-pthreads' '--enable-shared' '--disable-debug' '--with-zlib=/usr'
Last edited by sonaatti; 11-28-2004 at 03:52 PM.
|
|
|
11-28-2004, 04:05 PM
|
#6
|
LQ Newbie
Registered: Sep 2004
Posts: 17
Original Poster
Rep:
|
I found the solution here ->
http://www.vttoth.com/badmysql.htm
just had to add the extension_dir in php.ini ....
|
|
|
All times are GMT -5. The time now is 06:24 PM.
|
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.
|
Latest Threads
LQ News
|
|