Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL Problem with Shortel Migration

Posted on 2011-03-13
7
553 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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…

860 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