php - (Apparently) weird "Access denied" MySQL error -


i begun working on legacy php application , found myself fighting strange behavior. i'll try explain scenario/code/error:

  1. all queries executed through singleton class, opens connection , keeps opened whole session (as far understand code)

  2. every time mysql_query returns false, exception thrown.

  3. many queries executes "fine", complaining not existing tables (one of tasks clean messy-clipper-inherited-database-scheme, i'm running code , creating tables needed). after creating missing tables, queries runs well.

  4. some queries returning 1045 error: access denied user 'appuser'@'localhost' (using password: yes)

here comes "weird" behavior:

  1. i have enabled general log in mysql install, there no mentions of access denied errors. application queries seem run fine (i "seem to" because i'm having problems understanding sections of log format).

  2. the username/password configured in singleton class ok. can log in using mysql cli interface, besides many other queries runs fine. if try use wrong username/password on mysql cli, access denied correctly logged in general log.

  3. the stack trace of thrown exceptions (in php, obviously) shows exceptions came singleton class handle queries.

  4. there seems no pattern in "rejected" queries. big select queries, nothing more. have left outer joins, others have 24 from clauses.

  5. i'm logging mysql_stat result, on every query, , prints server status before both working queries , failing ones. although, i'm not sure if function depends on valid credential/session mysql server.

so, guys think going on down here? clue? educated guess?

if need more information/background, i'll happily provide... :)

examining in more details problematic selects, find common table, between them. guess what? not table, view, actually. when tried select view, using graphic tool (mysql workbench), error clear , "obvious".

when developer exported database (mysql dump), tool added line this, on every view creation code:

/*!50013 definer=`oldappuser`@`%` sql security definer */

i don't know why, did. since local database has different username/password/scheme, became source of 4-hours-long-headache.

to fix dropped old view , re-created it, without definer directive.

moral of story: watch out options check when dumping database , pay attention security stuff, in case changing user/pass/scheme in new server.


Comments

Post a Comment

Popular posts from this blog

monitor web browser programmatically in Android? -

i've got tricky question here. need users make payment bank (namely barclaycard) in uk. so, have https url , add parameters (such amount pay, order reference, etc) url, start http connection intent.actionview, redirect user browser can enter credit card details on bank's webpage , make payment our account successfully. far ? the code use below (i changed values privacy reasons) problem is, need app when user has completed/failed/cancelled payment. barclaycardautomatically redirects particular url when payment has succeeded, 1 if failed. there no way of knowing when barclaycard payment has succeeded go android app somehow ? button cardbutton = (button) findviewbyid(r.id.card_button); cardbutton.setonclicklistener(new view.onclicklistener() { @override public void onclick(view arg0) { string prehashstring = new string(); string prohashstring = new string(); string shapassphrase = new string(); shapassphrase = "gsvth£h70zkh...
Read more

Shrink a YouTube video to responsive width -

i have youtube video embedded on our website , when shrink screen tablet or phone sizes stops shrinking @ around 560px in width. standard youtube videos or there can add code make go smaller? you can make youtube videos responsive css. wrap iframe in div class of "videowrapper" , apply following styles: .videowrapper { float: none; clear: both; width: 100%; position: relative; padding-bottom: 56.25%; padding-top: 25px; height: 0; } .videowrapper iframe { position: absolute; top: 0; left: 0; width: 100%; height: 100%; } the .videowrapper div should inside responsive element. padding on .videowrapper necessary keep video collapsing. may have tweak numbers depending upon layout.
Read more

c# - Using multiple datasets in RDLC -

i working on rdlc reports, , reports work fine. got stuck when added 1 more dataset rdlc file. on adding dataset, added data source well. ran project, , report no more working giving error: a data source instance has not been supplied data source can 1 please guide me on steps take in order use multiple datasets. using visual studio 2012. multiple datasources added follows: reportviewer1.localreport.datasources.add(rds); reportviewer1.localreport.datasources.add(rds1); refer link: http://www.c-sharpcorner.com/uploadfile/robo60/standalonerdlcreports11142007183516pm/standalonerdlcreports.aspx all parts covered in this. also refer usefull discussion: http://forums.asp.net/t/1241964.aspx
Read more