Solved

SQL Problem with Shortel Migration

Posted on 2011-03-13
7
545 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Creating and Managing Databases with phpMyAdmin in cPanel.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

708 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

20 Experts available now in Live!

Get 1:1 Help Now