Re: [PacketFence-users] node database errors after upgrade?

[denis via PacketFence-users]

Le 14/06/2017 à 17:51, Fabrice Durand via PacketFence-users a écrit :

Hello Denis,

you will have to compare the current schema and the schema from this
file :
https://github.com/inverse-inc/packetfence/blob/devel/db/pf-schema-6.4.0.sql

Connect to the db pf and do :explain node; and compare ...


I just dropped locationlog and recreated it and it worked.

Thanks !

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] node database errors after upgrade?

[denis via PacketFence-users]

Le 14/06/2017 à 17:51, Fabrice Durand via PacketFence-users a écrit :

Hello Denis,

you will have to compare the current schema and the schema from this
file :
https://github.com/inverse-inc/packetfence/blob/devel/db/pf-schema-6.4.0.sql

Connect to the db pf and do :explain node; and compare ...



Ok, thanks,

there are 3 fields missing  in  location_log. Is it safe to drop the 
table and recreate it, or do i need to alter it ?


Denis



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] node database errors after upgrade?

[Fabrice Durand via PacketFence-users]

Hello Denis,

you will have to compare the current schema and the schema from this
file :
https://github.com/inverse-inc/packetfence/blob/devel/db/pf-schema-6.4.0.sql

Connect to the db pf and do :explain node; and compare ...

regards

Fabrice



Le 2017-06-14 à 11:16, denis via PacketFence-users a écrit :
> Hello,
>
> I'm running a 6.4 PF server, upgraded from 4.x  6 months ago.
>
> Primary functionnalities ( 802.1x, vlan enforcement,
> autoregistration...) are working as expected, but nodes databases
> seems to be corrupted :
>
>
> - node status is always unknown, switches and ports are not displayed
> on node info,
>
> - reevaluate access gives and error and does nothing.
>
> - packetfence.log has a lot of errors like
>
> Jun 14 17:00:36 httpd.aaa(9080) INFO: [mac:28:84:fa:f7:f8:c8] database
> query failed with: Unknown column 'role' in 'field list' (errno: 1054)
> (pf::db::db_query_execute)
>
> Apart from that it works.
>
>
> When upgrading db from 4.x i was very cautious in applying schema
> updates, but it looks like something goes wrong. I'm not expert in db,
> so if someone can help me to correct this problem, i will be happy to
> do this before upgrading to 7.1.
>
> Thanks
>
> Denis
>
>
>
> --
>
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> ___
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users

-- 
Fabrice Durand
fdur...@inverse.ca ::  +1.514.447.4918 (x135) ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence 
(http://packetfence.org) 


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

[PacketFence-users] node database errors after upgrade?

[denis via PacketFence-users]

Hello,

I'm running a 6.4 PF server, upgraded from 4.x  6 months ago.

Primary functionnalities ( 802.1x, vlan enforcement, 
autoregistration...) are working as expected, but nodes databases seems 
to be corrupted :



- node status is always unknown, switches and ports are not displayed on 
node info,


- reevaluate access gives and error and does nothing.

- packetfence.log has a lot of errors like

Jun 14 17:00:36 httpd.aaa(9080) INFO: [mac:28:84:fa:f7:f8:c8] database 
query failed with: Unknown column 'role' in 'field list' (errno: 1054) 
(pf::db::db_query_execute)


Apart from that it works.


When upgrading db from 4.x i was very cautious in applying schema 
updates, but it looks like something goes wrong. I'm not expert in db, 
so if someone can help me to correct this problem, i will be happy to do 
this before upgrading to 7.1.


Thanks

Denis



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] PF 7.1 remove inline mode

[Sokolowski, Darryl via PacketFence-users]

Thanks Fabrice!
That worked perfectly!

Darryl

From: Fabrice Durand via PacketFence-users 
[mailto:packetfence-users@lists.sourceforge.net]
Sent: Wednesday, June 14, 2017 8:12 AM
To: packetfence-users@lists.sourceforge.net
Cc: Fabrice Durand 
Subject: Re: [PacketFence-users] PF 7.1 remove inline mode


Hello Darryl,

in fact you just have to modify networks.conf and cluster.conf to remove inline 
related config. (bin/pfcmd configreload hard)

Regards

Fabrice



Le 2017-06-13 à 18:12, Sokolowski, Darryl via PacketFence-users a écrit :
Hi all,
let me say I'm loving this product! Good work to all involved!
Thank you for all your efforts!

My question is, I built my environment first, then clustered, and found out 
that inline mode isn't supported in the clustered environment.
So I'd like to remove it from my clustered environment, but can I do that 
safely?
Can I just access the configurator again and clear the inline checkbox?

Or can I remove the references for the inline interface from the config files?
I wanted to ask before I hose my installation.

Thanks
Darryl




>>> CONFIDENTIALITY NOTICE <<<

This electronic mail (e-mail) message, including any and/or all attachments, is 
for the sole use of the intended recipient(s), and may contain confidential 
and/or privileged information, pertaining to business conducted under the 
direction and supervision of EarthColor, Inc. All e-mail messages, which may 
have been established as expressed views and/or opinions (stated either within 
the e-mail message or any of its attachments), are left to the sole 
responsibility of that of the sender, and are not necessarily attributed to 
EarthColor, Inc. Unauthorized interception, review, use, disclosure or 
distribution of any such information contained within this e-mail message 
and/or its attachment(s), is(are) strictly prohibited. If you are not the 
intended recipient, please contact the sender by replying to this e-mail 
message, along with the destruction of all copies of the original e-mail 
message (along with any attachments).



--

Check out the vibrant tech community on one of the world's most

engaging tech sites, Slashdot.org! http://sdm.link/slashdot




___

PacketFence-users mailing list

PacketFence-users@lists.sourceforge.net

https://lists.sourceforge.net/lists/listinfo/packetfence-users



--

Fabrice Durand

fdur...@inverse.ca ::  +1.514.447.4918 (x135) ::  
www.inverse.ca

Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence 
(http://packetfence.org)
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] VLAN Enforcement

[Fabrice Durand via PacketFence-users]

Hello Rafael,

vlan 10 is for registration so it's normal that you don't have internet
access.

Regards

Fabrice



Le 2017-06-12 à 16:14, Diogo Rafael via PacketFence-users a écrit :
>
> Hi,
>
> Im trying to implement VLAN Enforcement on my environment but im
> having some troubles
>
> I have to interfaces eth0 that connects to the internet and eth1.
>
> On the interface eth1 i have 3 VLANs, VLAN 10 for registration, VLAN
> 20 for Isolation, and VLAN 30 is none.
>
> When a user try to register on VLAN10 he cant go throught the
> internet. Please help me.
>
>
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> ___
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users

-- 
Fabrice Durand
fdur...@inverse.ca ::  +1.514.447.4918 (x135) ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence 
(http://packetfence.org) 

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] PF 7.1 remove inline mode

[Fabrice Durand via PacketFence-users]

Hello Darryl,

in fact you just have to modify networks.conf and cluster.conf to remove
inline related config. (bin/pfcmd configreload hard)

Regards

Fabrice



Le 2017-06-13 à 18:12, Sokolowski, Darryl via PacketFence-users a écrit :
>
> Hi all,
>
> let me say I’m loving this product! Good work to all involved!
>
> Thank you for all your efforts!
>
>  
>
> My question is, I built my environment first, then clustered, and
> found out that inline mode isn’t supported in the clustered environment.
>
> So I’d like to remove it from my clustered environment, but can I do
> that safely?
>
> Can I just access the configurator again and clear the inline checkbox?
>
>  
>
> Or can I remove the references for the inline interface from the
> config files?
>
> I wanted to ask before I hose my installation.
>
>  
>
> Thanks
>
> Darryl
>
>  
>
>
>
> 
>
> >>> CONFIDENTIALITY NOTICE <<<
>
> This electronic mail (e-mail) message, including any and/or all
> attachments, is for the sole use of the intended recipient(s), and may
> contain confidential and/or privileged information, pertaining to
> business conducted under the direction and supervision of EarthColor,
> Inc. All e-mail messages, which may have been established as expressed
> views and/or opinions (stated either within the e-mail message or any
> of its attachments), are left to the sole responsibility of that of
> the sender, and are not necessarily attributed to EarthColor, Inc.
> Unauthorized interception, review, use, disclosure or distribution of
> any such information contained within this e-mail message and/or its
> attachment(s), is(are) strictly prohibited. If you are not the
> intended recipient, please contact the sender by replying to this
> e-mail message, along with the destruction of all copies of the
> original e-mail message (along with any attachments).
>
>
> --
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
>
>
> ___
> PacketFence-users mailing list
> PacketFence-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/packetfence-users

-- 
Fabrice Durand
fdur...@inverse.ca ::  +1.514.447.4918 (x135) ::  www.inverse.ca
Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence 
(http://packetfence.org) 

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Re: [PacketFence-users] [SPAM] Re: haproxy | mysql

[mj via PacketFence-users]

Hi Bebbet and Louis,

Thanks for your answers!

MJ

On 06/13/2017 03:05 PM, Bebbet van Dinges via PacketFence-users wrote:

if you run netstat -tapn, can you see where the mysql instance is
listening? if its on 127.0.0.1:3306, then the haproxy can listen on the
management:3306, no problem. When a request to management:3306 gets
made, haproxy will proxy the request to the appropriate server.

(as per my understanding of haproxy-pf combo)

Bebbet

On 13-6-2017 08:52, lists via PacketFence-users wrote:



On 12-6-2017 20:48, lists via PacketFence-users wrote:

"Project-Id-Version: 7.0.0 POT-Creation-Date: YEAR-MO-DA HO:MI+ZONE
PO-Revision-Date: 2017-04-19 11:56-0400 Last-Translator: Inverse inc.
 Language-Team: English Language: en MIME-Version:
1.0 Content-Type: text/plain; charset=ASCII Content-Transfer-Encoding:
8bit Plural-Forms: nplurals=2; plural=(n != 1); "

Any idea how that could have happened..?

Well, dropped pf database, recreated, reimported, reran all database
upgrades, and now the nodes appear as well. :-)

Question on the haproxy config on port 3306 remains though.

MJ

--

Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users


--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
___
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users