At 21:07 -0700 12/8/05, Andre Turpin wrote:
So I'm trying to write some triggers to help synchronize account information
between my master account database and a secondary database where I keep
information for radius accounts. My SQL syntax sucks, and I don't have much
luck reading the docs on the site (I might have a learning
disability...undiscovered as of yet)...so if anyone could spot what I'm
doing wrong I'd be very grateful. Trigger is included, and I've included the
error message that SQLyog spits out when I try to add the trigger...
I've documented my steps, so hopefully it doesn't look like complete
horses&*^, and thanks for any help anyone can offer.
TRIGGER = radius_modify (pretty much the same trigger as another one called
radius_insert...which triggers on INSERTs)
===================
DELIMITER $$;
DELIMITER $$
(no ;)
DROP TRIGGER `vexim`.`radius_modify`$$
CREATE TRIGGER `vexim`.`radius_modify` AFTER UPDATE on `vexim`.`users`
FOR EACH ROW
BEGIN
# Check if the accout is enabled, *and* allowed dialup access
IF NEW.enabled = 1 AND NEW.on_dialup = 'on' THEN
# First insert them into the radius user account table (
radius.radcheck)
INSERT INTO radius.radcheck (id,UserName,Value) VALUES (NEW.user_id,
NEW.localpart,NEW.clear);
# Then insert them into the radius group table (radius.usergroup),
group is always 'dynamic'
INSERT INTO radius.usergroup(id,UserName,GroupName) VALUES (
NEW.user_id,NEW.localpart,'dynamic');
# Otherwise, if they're not enabled, *or* they're not allowed dial-up
access...
ELSE IF NEW.enabled = 0 OR NEW.on_dialup = 'off' THEN
ELSEIF
(not ELSE IF)
# Remove them from the radius user account table if they're there...
DELETE FROM radius.radcheck WHERE id = OLD.user_id;
# and remove them from the radius group table if they're there.
DELETE FROM radius.usergroup WHERE id = OLD.user_id;
END IF;
END$$
END;$$
DELIMITER ;$$
DELIMITER ;
(no $$)
My error message:
==============
Error Code : 1360
Trigger does not exist
(0 ms taken)
That's okay, it's from your DROP TRIGGER statement that drops a trigger
that doesn't exist.
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '' at line 17
(16 ms taken)
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
