Hi Fletcher,
First, check to see if the procedure exists.
Log in to mysql as root and show the existing procedures.
This is the output for my test database:
# mysql -p pf
(enter password)
mysql> show procedure status
-> ;
+----+-------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db | Name | Type | Definer | Modified | Created
| Security_type | Comment | character_set_client |
collation_connection | Database Collation |
+----+-------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| pf | acct_start | PROCEDURE | root@localhost | 2014-06-22 15:56:52 |
2014-06-22 15:56:52 | DEFINER | | latin1 |
latin1_swedish_ci | latin1_swedish_ci |
| pf | acct_stop | PROCEDURE | root@localhost | 2014-06-22 15:56:52 |
2014-06-22 15:56:52 | DEFINER | | latin1 |
latin1_swedish_ci | latin1_swedish_ci |
| pf | acct_update | PROCEDURE | root@localhost | 2014-06-22 15:56:52 |
2014-06-22 15:56:52 | DEFINER | | latin1 |
latin1_swedish_ci | latin1_swedish_ci |
+----+-------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
3 rows in set (0.09 sec)
You can also check to see if the procedure appears in a dump of the database
schema and procedures:
# mysqldump -p pf --no-data -R
My output contains lines like these:
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 PROCEDURE
`acct_stop`(
IN p_timestamp datetime,
IN p_acctsessiontime int(12),
IN p_acctinputoctets bigint(20),
IN p_acctoutputoctets bigint(20),
IN p_acctterminatecause varchar(12),
IN p_acctdelaystop varchar(32),
IN p_connectinfo_stop varchar(50),
IN p_acctsessionid varchar(64),
IN p_username varchar(64),
IN p_nasipaddress varchar(15),
IN p_acctstatustype varchar(25)
)
BEGIN
DECLARE Previous_Input_Octets bigint(20);
DECLARE Previous_Output_Octets bigint(20);
DECLARE Previous_Session_Time int(12);
SELECT SUM(acctinputoctets), SUM(acctoutputoctets), SUM(acctsessiontime)
INTO Previous_Input_Octets, Previous_Output_Octets, Previous_Session_Time
FROM radacct_log
WHERE acctsessionid = p_acctsessionid
AND username = p_username
AND nasipaddress = p_nasipaddress;
IF (Previous_Session_Time IS NULL) THEN
SET Previous_Session_Time = 0;
SET Previous_Input_Octets = 0;
SET Previous_Output_Octets = 0;
END IF;
UPDATE radacct SET
acctstoptime = p_timestamp,
acctsessiontime = p_acctsessiontime,
acctinputoctets = p_acctinputoctets,
acctoutputoctets = p_acctoutputoctets,
acctterminatecause = p_acctterminatecause,
connectinfo_stop = p_connectinfo_stop
WHERE acctsessionid = p_acctsessionid
AND username = p_username
AND nasipaddress = p_nasipaddress
AND (acctstoptime IS NULL OR acctstoptime = 0);
INSERT INTO radacct_log
(acctsessionid, username, nasipaddress,
timestamp, acctstatustype, acctinputoctets, acctoutputoctets,
acctsessiontime)
VALUES
(p_acctsessionid, p_username, p_nasipaddress,
p_timestamp, p_acctstatustype, (p_acctinputoctets - Previous_Input_Octets),
(p_acctoutputoctets - Previous_Output_Octets),
(p_acctsessiontime - Previous_Session_Time));
END */;;
If the procedure really does not exist you may have to create it, though I
wonder how it could be missing.
This has been part of PacketFence for quite some time now.
Let us know.
Regards,
--
Louis Munro
[email protected] :: www.inverse.ca
+1.514.447.4918 *125 :: +1 (866) 353-6153
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
On 2014-07-29, at 14:12 , Fletcher Haynes <[email protected]> wrote:
> Hey Louis,
>
> I am using RHEL6. Output below:
> lrwxrwxrwx 1 pf pf 19 Jul 24 09:02 /usr/local/pf/db/pf-schema.sql ->
> pf-schema-4.3.0.sql
>
> Thanks!
>
>
>
> On Tue, Jul 29, 2014 at 10:27 AM, Louis Munro <[email protected]> wrote:
> Hi Fletcher,
> Can you tell us what distro you are running on?
>
> Also, give us the output of :
>
> # ls -l /usr/local/pf/db/pf-schema.sql
>
> Regards,
> --
> Louis Munro
> [email protected] :: www.inverse.ca
> +1.514.447.4918 *125 :: +1 (866) 353-6153
> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
> (www.packetfence.org)
>
> On 2014-07-25, at 18:10 , Fletcher Haynes <[email protected]> wrote:
>
>> Have another fun issue after the upgrade to 4.3.0. =) Now in my radius.log,
>> I see many occurrences of:
>>
>> PROCEDURE pf.acct_update does not exist
>> Couldn't update SQL accounting STOP record - PROCEDURE pf.acct_stop does not
>> exist
>>
>> Anyone else seen this?
>>
>> --
>> Fletcher Haynes <[email protected]>
>> Systems Administrator/Network Services Consultant
>> Willamette Integrated Technology Services
>> Willamette University, Salem, OR
>> Phone: 503.370.6016
>> ------------------------------------------------------------------------------
>> Want fast and easy access to all the code in your enterprise? Index and
>> search up to 200,000 lines of code with a free copy of Black Duck
>> Code Sight - the same software that powers the world's largest code
>> search on Ohloh, the Black Duck Open Hub! Try it now.
>> http://p.sf.net/sfu/bds_______________________________________________
>> PacketFence-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
>
> --
> Fletcher Haynes <[email protected]>
> Systems Administrator/Network Services Consultant
> Willamette Integrated Technology Services
> Willamette University, Salem, OR
> Phone: 503.370.6016
> ------------------------------------------------------------------------------
> Infragistics Professional
> Build stunning WinForms apps today!
> Reboot your WinForms applications with our WinForms controls.
> Build a bridge from your legacy apps to the future.
> http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk_______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Infragistics Professional
Build stunning WinForms apps today!
Reboot your WinForms applications with our WinForms controls.
Build a bridge from your legacy apps to the future.
http://pubads.g.doubleclick.net/gampad/clk?id=153845071&iu=/4140/ostg.clktrk
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
