?
Solved

SQL Problem with Shortel Migration

Posted on 2011-03-13
7
Medium Priority
?
565 Views
Last Modified: 2012-05-11
We are currently trying to restore our phone system data from a backup to a new installation.
The phone system is a Shortel system which runs on SQL.
There is a sample script in the MySQL folder called RestoreConfig, which relies on a file being located in the c:\ called shorewareConfigDump.sql.
This file is in the c:\ and I have gone to run the script and it comes back with the following error code (see below).

The backup was taken from a Server 2003 machine and is being restored to a Server 2008 machine.

A quick google indicateds “SET GLOBAL log_bin_trust_routine_creators=1; “ should resolve but I don't know how to implement it.

Any help would be appreciated.
C:\Program Files (x86)\Shoreline Communications\ShoreWare Server\MySQL\MySQL Ser
ver 5.0\Examples>restoreconfig.bat
ERROR 1418 (HY000) at line 8083: This function has none of DETERMINISTIC, NO SQL
, or READS SQL DATA in its declaration and binary logging is enabled (you *might
* want to use the less safe log_bin_trust_function_creators variable)

Open in new window

0
Comment
Question by:lemonville
  • 5
  • 2
7 Comments
 
LVL 29

Expert Comment

by:mass2612
ID: 35124506
Hi,

To set the variable you can use the command prompt such as: -

set SET GLOBAL log_bin_trust_routine_creators=1

This will create and variable called "GLOBAL log_bin_trust_routine_creators" with a value of 1 which you can query by entering SET at the command prompt or echo %GLOBAL log_bin_trust_routine_creators% this variable is only available for the command prompt session you are in.

You could add it via My Computer > Properties > Advanced > Environment Variables > New. This sets it permanently.

http://vlaurie.com/computers2/Articles/environment.htm
0
 
LVL 1

Author Comment

by:lemonville
ID: 35124571
Doing the echo command just brings back %GLOBAL log_bin_trust_routine_creators%
Which I would assume means the variable hasn't been set as it should come back with a value of 1

Does the server need a restart after setting the variable?
0
 
LVL 1

Author Comment

by:lemonville
ID: 35124605
I think this command is supposed to be done in some sort of SQL command line, as per:
 (FROM MYSQL KNOWLEDGEBASE)

"To relax the preceding conditions on function creation (that you must have the SUPER privilege and that a function must be declared deterministic or to not modify data), set the global log_bin_trust_function_creators system variable to 1. By default, this variable has a value of 0, but you can change it like this:

mysql> SET GLOBAL log_bin_trust_function_creators = 1;
You can also set this variable by using the --log-bin-trust-function-creators=1 option when starting the server.

If binary logging is not enabled, log_bin_trust_function_creators does not apply. SUPER is not required for function creation unless, as described previously, the DEFINER value in the function definition requires it."
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
LVL 1

Author Comment

by:lemonville
ID: 35124689
After a restart, the system variable was set.

However - this system variable has not helped and the same error is occurring.
0
 
LVL 29

Expert Comment

by:mass2612
ID: 35124936
I'd suggest you delete this question and post again for someone with more exp with mySQL- sorry
0
 
LVL 1

Accepted Solution

by:
lemonville earned 0 total points
ID: 35125146
This has to be done VIA the MySQL command line. (found in the MySQL\bin folder)
Once set the issue is resolved.
0
 
LVL 1

Author Closing Comment

by:lemonville
ID: 35163544
No acceptable answers, ended up doing my own research
0

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question