Hi Fabrice,
no original version installed was 4.3.0. From that point I upgraded to the
versions without problems befor today. Do you think that if I try to patch it
with the sql upgrade from 4.3 to 4.4 it fix the problem?
thank you
Luca
Date: Tue, 21 Apr 2015 08:55:00 -0400
From: [email protected]
To: [email protected]
Subject: Re: [PacketFence-users] Upgrade from 4.7.0 to 5.0.0 sql problem
Hello Lucas,
iplog_history come from upgrade 4.3 to 4.4 ( upgrade-4.3.0-4.4.0.sql)
4.7.0 was the original release version installed ?
Regards
Fabrice
Le 2015-04-21 08:48, luca comes a écrit :
> Hi all,
> I'm running PF version 4.7.0 on CentOS 6.6. Today I tried to update to
> the new release but I had some problems with the SQL procedure. My
> database schema is shown underneath:
>
> mysql> show tables;
> +-----------------------+
> | Tables_in_test_pf_upg |
> +-----------------------+
> | action |
> | activation |
> | billing |
> | class |
> | configfile |
> | dhcp_fingerprint |
> | ifoctetslog |
> | inline_accounting |
> | iplog |
> | locationlog |
> | locationlog_history |
> | node |
> | node_category |
> | node_useragent |
> | os_class |
> | os_mapping |
> | os_type |
> | person |
> | radacct |
> | radacct_log |
> | radius_nas |
> | savedsearch |
> | scan |
> | sms_carrier |
> | soh_filter_rules |
> | soh_filters |
> | temporary_password |
> | traplog |
> | trigger |
> | userlog |
> | violation |
> | wrix |
> +-----------------------+
> 32 rows in set (0.00 sec)
>
>
> As you can see iplog_history is missing so the procedure fails. Is the
> procedure correct or something is missing? I have to create manually
> the table?
>
> Thanks
>
> Luca
>
>
> ------------------------------------------------------------------------------
> BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
> Develop your own process in accordance with the BPMN 2 standard
> Learn Process modeling best practices with Bonita BPM through live exercises
> http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
> source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
>
>
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
--
Fabrice Durand
[email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
(http://packetfence.org)
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
