Home
| Calendar
| Mail Lists
| List Archives
| Desktop SIG
| Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU |
Please CC all your responses to discuss at blu.org, not to me. I am not a mySQL expert. In fact I've never run the beast, so I honestly have no idea how to "fix" it. You can try "installing mysql" as the apache user, or reading the apache, php, or mysql docs.. Or you can ask on discuss, and someone _else_ might have an idea... -derek "Mike Volmar" <mvolmar at fruitlands.org> writes: > How do I solve it? Permissions seem hard to deal with in mySQL. > > -----Original Message----- > From: Derek Atkins [mailto:warlord at MIT.EDU] > Sent: Wednesday, December 04, 2002 4:33 PM > To: Mike Volmar > Cc: discuss at blu.org > Subject: Re: mySQL question > > > Perhaps your web server is not running as root, then, and this is a > permissions problem? > > -derek > > "Mike Volmar" <mvolmar at fruitlands.org> writes: > > > I can run 'select * from events' from the mysql> proimpt just fine, but > only > > when logged in as the root linux user. > > > > > > -----Original Message----- > > From: Derek Atkins [mailto:warlord at MIT.EDU] > > Sent: Wednesday, December 04, 2002 4:09 PM > > To: Mike Volmar > > Cc: discuss at blu.org > > Subject: Re: mySQL question > > > > > > Perhaps '$result' contains an error (because mysql_query() returned > > an error)? Can you run this query by hand against your MySQL DB on > > Linux? > > > > -derek > > > > "Mike Volmar" <mvolmar at fruitlands.org> writes: > > > > > mysql_select_db("events"); > > > $query = "select * from events"; > > > $result = mysql_query($query); > > > > > > $num_results = mysql_num_rows($result); // this line throws error > > > > -- > > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory > > Member, MIT Student Information Processing Board (SIPB) > > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH > > warlord at MIT.EDU PGP key available > > > > -- > Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory > Member, MIT Student Information Processing Board (SIPB) > URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH > warlord at MIT.EDU PGP key available > -- Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory Member, MIT Student Information Processing Board (SIPB) URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH warlord at MIT.EDU PGP key available
BLU is a member of BostonUserGroups | |
We also thank MIT for the use of their facilities. |