Hey Louis,
I think this was my fault. I host PF's database on a separate server, and I
upgraded it along with the 4.3 PF upgrade. I think the mysqlrestore did not
include the procedures. I checked, and they were present in my old PF db.
I've manually readded them and all is well.
Thanks for your help!
On Thu, Jul 31, 2014 at 8:12 AM, Louis Munro <[email protected]> wrote:
> 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
>
>
--
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
