how to add permissions to EXECUTE PROCEDUREs ?

[lightscribe]

Fatal error: Uncaught exception 'Exception' with message 'Error in DB RIS Query: execute command denied to user 'benitto_7'@'10.33.249.5' for routine 'benitto_control.TeraWurfl_RIS'. Query: CALL TeraWurfl_RIS('SAGEM-myX5-2/1.0 Profile/MIDP-2.0 Configuration/CLDC-1.0 UP.Browser/6.2.2.6.d.2 (GUI) MMP/1.0',12,'Sagem') ' in /home/benitto/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php:102 Stack trace: #0 /home/benitto/public_html/Tera-Wurfl/UserAgentMatchers/UserAgentMatcher.php(73): TeraWurflDatabase_MySQL5->getDeviceFromUA_RIS('SAGEM-myX5-2/1....', 12, Object(SagemUserAgentMatcher)) #1 /home/benitto/public_html/Tera-Wurfl/UserAgentMatchers/SagemUserAgentMatcher.php(26): UserAgentMatcher->risMatch('SAGEM-myX5-2/1....', 12) #2 /home/benitto/public_html/Tera-Wurfl/TeraWurfl.php(175): SagemUserAgentMatcher->applyConclusiveMatch('SAGEM-myX5-2/1....') #3 /home/benitto/public_html/Tera-Wurfl/TeraWurfl.php(303): TeraWurfl->getDeviceIDFromUALoose('SAGEM-myX5-2/1....') #4 /home/benitto/public_html/Tera-Wurfl/c in /home/benitto/public_html/Tera-Wurfl/DatabaseConnectors/TeraWurflDatabase_MySQL5.php on line 102

tryed to remove user added it again no luck same error,
once before i managed to solve that kind of problem problem removing and adding user again
thanks for support

 

[Derek]

What kind of script is it? Does it need remote mysql?

 

[lightscribe]

it do not conect to remote mysql, http://www.tera-wurfl.com/wiki/index.php/Main_Page,
have a look http://secure.exofire.net/Tera-Wurfl/check_wurfl.php first time it checks for mysql data then it comes with error.
its php code based app

 

[Derek]

I don't see any errors.

 

[lightscribe]

mmm so i guess its on my end, did you tried to change http://secure.exofire.net/Tera-Wurfl/check_wurfl.php to different device? nokia or mot from samples

 

[Derek]

I don't have different devices.. Did you give all the permissions from your user to the database?

 

[lightscribe]

yes i selected all availible permissions,
http://secure.exofire.net/Tera-Wurfl/check_wurfl.php
could you copy and paste them into field then submit to check for that error

Try some of these:

*

SonyEricssonK700i/R2AC SEMC-Browser/4.0.2 Profile/MIDP-2.0 Configuration/CLDC-1.1

*

MOT-T720/S_G_05.30.0CR MIB/2.0 Profile/MIDP-1.0 Configuration/CLDC-1.0

*

SAGEM-myX5-2/1.0 Profile/MIDP-2.0 Configuration/CLDC-1.0 UP.Browser/6.2.2.6.d.2 (GUI) MMP/1.0

*

NokiaN90-1/3.0541.5.2 Series60/2.8 Profile/MIDP-2.0 Configuration/CLDC-1.1

thanks

 

[tera-wurfl]

Hi guys, this is Steve Kamerman, the Tera-WURFL author. The error message he is receiving "Error in DB RIS Query: execute command denied to user 'benitto_7'" is only thrown if he does not have the MySQL EXECUTE permission. How are users managed in the control panel? Do you have access to phpMyAdmin, or is there some other interface?

Also, if you upgrade to Tera-WURFL 2.1.2, the install.php script will tell you if you have this permission or not, and detection will be more accurate

Thanks,

Steve Kamerman
http://www.tera-wurfl.com

 

[lightscribe]

Today i'm trying it on different pc and it seems to work, no errors, my version of tera-wurfl 2.1.1 i'll update it to newer, when i get new errors, if i get them. Thanks For replys lads
i'm new here. so i guess to manage users its only one option in cpanel --> mysql databases.
phpMyAdmin also in c panel but didnt found how to add execute permission, nothing there
sorry about my english

 

[lightscribe]

Steve could you help me out please, where to find learning materials on development and how to add WURLF to web site?
i would love to create server side c# website and and actually not know how to 1st steps after instaling?

 

[lightscribe]

ok i downloding newer version and start everything from begining, same error no execute permission,