6 messages in com.mysql.lists.perlRE: Access Denied| From | Sent On | Attachments |
|---|---|---|
| Joe Robuck | 27 Jun 1999 22:32 | |
| Jochen Wiedmann | 28 Jun 1999 01:37 | |
| Joe Robuck | 28 Jun 1999 06:57 | |
| Moroney, Dennis | 28 Jun 1999 07:26 | |
| Joe Robuck | 28 Jun 1999 09:10 | |
| Moroney, Dennis | 28 Jun 1999 09:35 |
| Subject: | RE: Access Denied |
|---|---|
| From: | Moroney, Dennis (Moro...@zeus.dt.uh.edu) |
| Date: | 06/28/1999 09:35:29 AM |
| List: | com.mysql.lists.perl |
You are welcome. BTW, I keep the following ACL entry in msql.acl just to avoid the kind of problem you described earlier.
# defaults for anonymous databases database=* read=* write=your_db_owner_goes_here host=*.your.domain access=local,remote option=rfc931
Enjoy!
-----Original Message----- From: Joe Robuck [SMTP:jo...@webolution.com] Sent: Monday, June 28, 1999 11:11 AM To: Moroney, Dennis Cc: msql...@lists.mysql.com Subject: RE: Access Denied
Dennis, That was it. There was an entry for this database in the msql.acl file that I wasn't aware of. Thank you very much.
- Joe
-----Original Message----- From: Moroney, Dennis [mailto:Moro...@zeus.dt.uh.edu] Sent: Monday, June 28, 1999 7:27 AM To: 'Joe Robuck' Cc: msql...@lists.mysql.com Subject: RE: Access Denied
Check msql.acl for permissions to the database you are trying to connect to. Possibly the UID you are using is not permitted to even read the database in question?
-----Original Message----- From: Joe Robuck [SMTP:jo...@webolution.com] Sent: Monday, June 28, 1999 8:58 AM To: Jochen Wiedmann Cc: msql...@lists.mysql.com Subject: RE: Access Denied
Jochen, Thanks for your reply. What you say might make sense except for 2 things:
1. I literally have dozens of other eperl pages with the same owner, group, and permissions running on the same web server, accessing the same instance of mSQL just a different database.
2. The same program runs fine normal cgi.
I'm really stuck. If you have any other suggestions, It would be much appreciated.
Thanks,
Joe
-----Original Message----- From: joe [mailto:joe]On Behalf Of Jochen Wiedmann Sent: Monday, June 28, 1999 1:38 AM To: Joe Robuck Cc: msql...@lists.mysql.com Subject: Re: Access Denied
Joe Robuck wrote:
All, I have a small test program that I wrote that simply
connects to an mSQL
database and inserts a record into a table. When I run it as a
regular perl
program from the command line it works fine. When I make a few
small
changes
and run it as an eperl page, I get the following error:
DBD::mSQL::st execute failed: Access Denied at test.phtml line 25.
You should consider that the web server is running as another user.
Bye,
Jochen
-- Jochen Wiedmann jo...@ispsoft.de Life has brown and green eyes. :-) +49 7123 14887
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail msql...@lists.mysql.com
To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail msql...@lists.mysql.com instead.