Re: PHP mysql_connect randomly failing
If you reach to maximum mysql connection limit or link limit, mysql_connect will fail. Check limits and current fullness. ---Original Message--- From: Jon Drukman Date: 21 Ağustos 2003 Perşembe 11:32:47 To: [EMAIL PROTECTED] Subject: Re: PHP mysql_connect randomly failing Antony Dovgal wrote:> On Tue, 19 Aug 2003 14:36:15 -0700> Jon Drukman <[EMAIL PROTECTED]> wrote:>>Approximately 1% of the time it just fails, for no stated reason:Warning: mysql_connect() [http://www.php.net/function.mysql-connect]: >>in /var/httpd/htdocs/pi/pi.php on line 3>>mysql connect failed:Any ideas why this would be happening? PHP is version 4.3.1 (same >>results with the latest 4.3.3 release candidate), Mysql is 4.0.12> > You should turn > track_errors = On> in your php.ini (default value is Off), if you want to see last PHP error in $php_errmsg variable.> > But I suppose the best solution would be not to use $php_errmsg, but to use mysql_error() - > at least this function does not depend on configuration settings.mysql_error is not set when mysql_connect fails, because there is no actual mysql resource to get the error message from.anyway i set track_errors=on (confirmed with phpinfo()) but i still get the same message as above - no error is reported.-jsd--- MySQL General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]. IncrediMail - Email has finally evolved - Click Here
Security related! Not possible to hide table structure. I couldn't find..... ?
Hello, Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4 You want to give a specific permission to a user named USER1 For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1. and you did not assign any other permission to USER1. Now everything is OK! USER1 can only select FIELD1 and FIELD4, and can not see data or change or etc.. to FIELD2 or FIELD3.. So we think that everything is OK! But, USER1 is still able to see the table structure of TABLE1. He see fields which i don't want him to see! As i searched internet related to this topic i couldn't find any satistfactory solution to this one. Anyone has idea to prevent USER1 to be able to see table structure and only permission to SELECT FIELD1 and FIELD4 as i assigned? Also there should be some default error message for these users when they try to select from another field. why? Because if my first question gets answered and solved, then, USER1 can try to SELECT FIELD3 FROM TABLE1.. .and it will say something like "you have no permission for FIELD3" insted of this, it can be "This field does not exist".. Thanks. QWERTY IncrediMail - Email has finally evolved - Click Here
Security question: Possible to hide table structure? I couldn't find...
Hello, Think that we have a database named DATABASE1, and table named TABLE1, and fields named FIELD1, FIELD1,FIELD2,FIELD3,FIELD4 You want to give a specific permission to a user named USER1 For ex, you give only SELECT permission to USER1 for FIELD1 and FIELD4 in TABLE1 and DATABASE1. and you did not assign any other permission to USER1. Now everything is OK! USER1 can only select FIELD1 and FIELD4, and can not see data or change or etc.. to FIELD2 or FIELD3.. So we think that everything is OK! But, USER1 is still able to see the table structure of TABLE1. He see fields which i don't want him to see! As i searched internet related to this topic i couldn't find any satistfactory solution to this one. Anyone has idea to prevent USER1 to be able to see table structure and only permission to SELECT FIELD1 and FIELD4 as i assigned? Also there should be some default error message for these users when they try to select from another field. why? Because if my first question gets answered and solved, then, USER1 can try to SELECT FIELD3 FROM TABLE1.. .and it will say something like "you have no permission for FIELD3" insted of this, it can be "This field does not exist".. Thanks. QWERTY IncrediMail - Email has finally evolved - Click Here
Feuere Deinen Boss !!!
Wenn Sie am diesem List posten, bitten Sie nur English schreiben. Auch, ist dieses List nur fur MySQL Fragen. -Original Message- From: Job-Mobil [mailto:[EMAIL PROTECTED]] Sent: None To: [EMAIL PROTECTED] Subject: Feuere Deinen Boss ! Warum immer wieder für andere arbeiten, wenn Sie DM 2.000,- pro Woche für sich selbst haben können ! Weitere Informationen nur unter: [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 - 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
