Solved

SQL Problem with Shortel Migration

Posted on 2011-03-13
7
547 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

863 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now