Ahhhh.
I think I know what happened.
The defaults for mysqldump do not backup stored procedures.
That is why you need to add the -R on the command line.
Glad to see you fixed this.
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-08-04, at 11:47 , Fletcher Haynes <[email protected]> wrote:
> 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
------------------------------------------------------------------------------
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
