unable to create function through Navicat lite - mysql

[Nelly]

Hello, I'm trying to create 2 DEFINER functions but i seem to get an authentication error.

Code: Select all

mysql> DELIMITER ;;
CREATE DEFINER=`altisage`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE `vehicles` SET `active`= 0;
END
;;
1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
mysql>

any ideas? - I have verified that i am logged in to the database (able to create tables)

[Nelly]

also when i click on the Functions button in Navicat i get an error:

Code: Select all

1548 - Cannot load from mysql.proc. The table is probably corrupted

[Edge100x]

We do not currently support user-defined functions through our shared hosting. The second error that you saw just means that they aren't allowed (which is confusing; I don't know why they do not use a better one).

[Nelly]

The 2 functions I require are pretty harmless as you can see, would it be possible for an administrator to create them for me?

Code: Select all

DELIMITER ;;
CREATE DEFINER=`altisage`@`localhost` PROCEDURE `resetLifeVehicles`()
BEGIN
UPDATE `vehicles` SET `active`= 0;
END;;

Code: Select all

DELIMITER ;;
CREATE DEFINER=`altisage`@`localhost` PROCEDURE `deleteDeadVehicles`()
BEGIN
	DELETE FROM `vehicles` WHERE `alive` = 0;
END;;

They are to ensure clean running of the arma3 altis life server i have with you guys.

[Edge100x]

I'm sorry, but no.

We hope to support user-defined functions at some point, but right now our systems are just not set up to keep track of them. Adding one manually would break things in many ways.

The main reason that user-defined functions present a problem is that they use the shared global namespace, as databases do. There are also some permissions concerns that will need to be addressed. Support will entail adding new features to the control panel to allow them to be created and tracked there.

[.=QUACK=.Major.Pain]

They have to be installed as a root user's permissions.
And as mentioned, not something that's available.

It looks like your using these for a dayz version mod.
If your using a VDS, your can install something like Xampp and have the ability to do everything yourself.
Or if you have a website and access to cPanel, you can try to install a database with your webhosting. But you could find a similar issue depending on the hosting company.

[Edge100x]

Be very careful if you choose XAMPP, as we've had countless customers have their default installations exploited by attackers. Know what you're doing and lock it down properly.

[Nelly]

Thanks for the replies, I've decided to just run the delete and update commands regularly - there is a security risk with this, but nothing a regular offsite backup can avert in the case of a disaster.