APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2
hi, since 3 days, i'm trying to connect to MYSQL 5.0.18 from php scripts using Apache et Macromedia 2004 Dreamweaver. Could someone help me doing this? Best regard. - Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et l'international.Téléchargez la version beta.
Re: APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2
persant mpote [EMAIL PROTECTED] wrote on 02/16/2006 10:29:37 AM: hi, since 3 days, i'm trying to connect to MYSQL 5.0.18 from php scripts using Apache et Macromedia 2004 Dreamweaver. Could someone help me doing this? Best regard. - Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et l'international. Téléchargez la version beta. What exactly have been the commands you have tried and what exactly were the error messages you received? We can't help you until you provide us with more details. Have you tried the advice in the manual? http://dev.mysql.com/doc/refman/5.0/fr/can-not-connect-to-server.html http://dev.mysql.com/doc/refman/5.0/fr/starting-server.html What successes or failures have you had? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2
First you need to make sure that you have a running mysql server for the client mysql program to connect to. If the server is not runing, you will obviously not be able to connect to it. I find the following utility very helpfull - been messsing around with it today. http://www.student.nada.kth.se/~f91-men/qps/ It give a graphical UI, into the running processes. I noticed using qps, that sometimes the mysqld_safe script loads into memory, but does not actually load a mysqld process. Also, version 4.0.21 only spawns one child process, where 5.0.18 starts several processes in memory. I had the RPM 5.0.18 version running, and two other seperate binary distro's of 5.0.18, all on different sockets and ports. I've given up with using mysqld_safe to run the mysqld daemon. It is to unpredictable. qps also shows all the command line arguments passed to mysqld, which shows at a glance which ports and sockets the daemons are listening on. It is included with SuSE 9.2 pro, as an extra package. I think it lives on the DVD's. You can download qps from the link above. Keith In theory, theory and practice are the same; In practice they are not. On Thu, 16 Feb 2006, persant mpote wrote: To: mysql@lists.mysql.com From: persant mpote [EMAIL PROTECTED] Subject: APACHE 2.0 can't connect to MYSQL 5 when using PHP 5.1.2 hi, since 3 days, i'm trying to connect to MYSQL 5.0.18 from php scripts using Apache et Macromedia 2004 Dreamweaver. Could someone help me doing this? Best regard. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Persistent connection with Apache 2.0 and perl
Hi, How I can make a persistent connection in httpd.conf and get the $dbh in my perl script ? Thanks for help Accédez au courrier électronique de La Poste : www.laposte.net ; 3615 LAPOSTENET (0,34/mn) ; tél : 08 92 68 13 50 (0,34/mn) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How I Got PHP4.2.2, Apache 2.0, mySQL and RedHat 8.0 to work
Well, it seems there are some glitches with and snags and other fun stuff to deal with when doing a straight RedHat 8.0 install. It turns out you have to edit your /etc/php.ini and uncomment out the extension=mysql.so line for starters. It also helps to set short_open_tag = On. Another fun thing to contend with is the fact that register_globals is now off by default, s, read this page: http://www.zend.com/zend/art/art-sweat4.php to see how to get around this (without turning RG on of course). I have some sites that use .php and some that use .phtml and you'd think it would be as simple as modifying /etc/httpd/conf.d/php.conf, dupe the entry and change the extension. Wrong. What I did was change it to: FilesMatch \.(php|phtml|phps|php4|php3)$ SetOutputFilter PHP SetInputFilter PHP LimitRequestBody 524288 /FilesMatch DirectoryIndex index.php index.phtml I use virtual hosts but none use SSL currently, and haven't figured that part out with the SSL.conf so I just renamed it to ssl.conf.disabled and created a virtual-hosts.conf that looks like this: VirtualHost * DocumentRoot /home/foo/public_html ServerName foo.com ServerAlias ww.foo.com *.foo.* ErrorLog logs/foo-error_log CustomLog logs/foo-access_log common /VirtualHost And at the end of the httpd.conf file you have to turn VH on by uncommenting NameVirtualHost * And I also added this at the bottom to catch all that don't match with an entry in my virtual-hosts.conf file above: VirtualHost * ServerAdmin webmaster@localhost DocumentRoot /var/www/html ServerName localhost ErrorLog /etc/httpd/logs/error_log CustomLog /etc/httpd/logs/access_log common /VirtualHost I also went ahead and installed mySQL-MAX, so you need to create a /etc/my.cnf file and put something like: [mysqld] # You can write your other MySQL server options here # ... innodb_data_home_dir= # Data file(s) must be able to # hold your data and indexes. # Make sure you have enough # free disk space. innodb_data_file_path = ibdata1:10M:autoextend # Set buffer pool size to # 50 - 80 % of your computer's # memory set-variable = innodb_buffer_pool_size=70M set-variable = innodb_additional_mem_pool_size=10M # Set the log file size to about # 25 % of the buffer pool size set-variable = innodb_log_file_size=20M set-variable = innodb_log_buffer_size=8M # Set ..flush_log_at_trx_commit # to 0 if you can afford losing # some last transactions innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=50 #innodb_flush_method=fdatasync #set-variable = innodb_thread_concurrency=5 skip-locking set-variable = max_connections=200 #set-variable = read_buffer_size=1M set-variable = sort_buffer=1M # Set key_buffer to 5 - 50% # of your RAM depending on how # much you use MyISAM tables, but # keep key_buffer + InnoDB # buffer pool size 80% of # your RAM set-variable = key_buffer=10M Somehow the pretty /etc/rc.d/init.d/mysql script has changed (probably due to mysqlMax) I like the old one with the green [ OK ] messages like everything else there and I'm not sure how to get it back :( but it works for now and I have innoDB tables, so I can't complain too much. Hope this helps someone and saves them the nearly 7 hours I've spent today getting it all working. Most of that is sifting through a million web pages and trying to find the magic incantation on Google to get the solutions. DÆVID. http://daevid.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Apache 2.0
Dear Sir or Ms. Is there a stable version of MySQL that runs on Apache 2.0? Thanks for your time. Jeff Whitman Managing Member JW NetSource, LLC Contact Information: Jeff Whitman JW NetSource, LLC PO Box 702 115 East Main Manchester, MI 48158-0702 734-428-7770 877-341-7770 734-428-1777 (fax) a href= http://www.JWNetSource.com JW NetSource.com/a a href= mailto:[EMAIL PROTECTED] E-Mail/a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Apache 2.0
We use the current stable version of MySQL on a server running Apache 2.0 with no problem. - Original Message - From: Jeff Whitman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 09, 2002 10:55 AM Subject: Apache 2.0 Dear Sir or Ms. Is there a stable version of MySQL that runs on Apache 2.0? Thanks for your time. Jeff Whitman Managing Member JW NetSource, LLC Contact Information: Jeff Whitman JW NetSource, LLC PO Box 702 115 East Main Manchester, MI 48158-0702 734-428-7770 877-341-7770 734-428-1777 (fax) a href= http://www.JWNetSource.com JW NetSource.com/a a href= mailto:[EMAIL PROTECTED] E-Mail/a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Apache 2.0
On Sun, Jun 09, 2002 at 11:55:29AM -0400, Jeff Whitman wrote: Dear Sir or Ms. Is there a stable version of MySQL that runs on Apache 2.0? Thanks for your time. Question is is httpd-2.0.X stable?? Jeff Whitman Managing Member JW NetSource, LLC Contact Information: Jeff Whitman JW NetSource, LLC PO Box 702 115 East Main Manchester, MI 48158-0702 734-428-7770 877-341-7770 734-428-1777 (fax) a href= http://www.JWNetSource.com JW NetSource.com/a a href= mailto:[EMAIL PROTECTED] E-Mail/a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- contact: Dave Yadallee NetKnow The Internet Knowledge Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Apache 2.0
Hello. On Sun 2002-06-09 at 11:55:29 -0400, [EMAIL PROTECTED] wrote: Dear Sir or Ms. Is there a stable version of MySQL that runs on Apache 2.0? MySQL and Apache are two different applications which don't use each other directly. So any versions (of both) should be fine. Just pick the latest MySQL stable release for your needs, should currently be 3.23.49a. There are modules for Apache will use MySQL (mod_auth_mysql, mod_php, ...) which may use a existing MySQL database, but that is a different story. You would have to check which MySQL version these modules require. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php