Hello Fabrice,
Seems to lack of many tables here.
I just only fresh install PF4.7, then upgrade to v5 as repo.
Should i have to do now? Drop pf database and install db again or something
like that?
Best regards,
-----Original Message-----
From: "Durand fabrice" <[email protected]>
Sent: 5/26/2015 8:32 AM
To: "[email protected]"
<[email protected]>
Subject: Re: [PacketFence-users] Apply to Vlan
Hello Minh,
it miss a procedure in your database.
Let's do:
mysqldump -uroot -p pf --no-data --routines
and compare with db/pf-schema.sql
Regards
Fabrice
Le 2015-05-25 04:57, Minh Trung a écrit :
Hello,
I am still not able to resolved this issue:
Mon May 25 15:33:20 2015 : Error: [sql] Couldn't update SQL accounting STOP
record - PROCEDURE pf.acct_stop does not exist
Mon May 25 15:33:20 2015 : Error: rlm_sql_mysql: Cannot store result
Mon May 25 15:33:20 2015 : Error: rlm_sql_mysql: MySQL error 'PROCEDURE
pf.acct_stop does not exist'
Although, the client can access the portal and authorize successful.
Do i am wrong any file configured?
Any help is appreciated,
On 6 May 2015 at 22:11, Juan Camilo Valencia <[email protected]>
wrote:
Hi Minh,
I don´t have the excatly procedure write it, however is very simple.
1. Open up in a text editor, nedit is my preference, the schema of the database
that match your version of pf.
2. At the same time connect to pf database, "mysql -u pf -p pf".
3. Search in the schema for the keyword "procedure", the first match is in a
comment that says "-- Adding RADIUS Updates Stored Procedure".
4. Copy and paste in the mysql command the entire code that start with "
DROP..." until says "DELIMITER ; ..."
5. Yo need to do this as many times as procedures you find in the schema, I
tried to cp and paste all at once and for some reason failed, so do it step by
step with each procedure.
I hope that this help you,
Best Regards,
On Tue, May 5, 2015 at 10:14 PM, Minh Trung <[email protected]> wrote:
Hello Juan,
I showed and it empty.
mysql> use pf;
Database changed
mysql> show procedure status;
Empty set (0.00 sec)
Now, i using PF v5.0.5 and i saw many procedures just after the radius tables
at docs in db's PF directory.
Would you please point me the exact command to insert them?
Thank a lot.
Regards,
On 29 April 2015 at 20:40, Juan Camilo Valencia
<[email protected]> wrote:
Hi minh,
Probably you are missing the storage procedures that radius needs for the
accounting, login into your db and execute
show procedures status;
If does not appear any information you are missing that, probably because you
made a backup of your info without the procedures next time use the modifiers
--procedures in mysqldump command. To fix this open your sql schema for your pf
version in db packetfence directory and look for the procedures just after the
radius tables and start insert those ones manually.
I hope that this can help you.
Best regards
El mar, abr 28, 2015 08:08, Minh Trung <[email protected]> escribió:
Hello Fabrice,
I was successful in configured the vmware machine in tag the vlan as above we
discussed (it take long time to figure out ) and i also see the portal on
device which is plugged in the port testing.
But on radius log still show the error:
Tue Apr 28 16:53:57 2015 : Auth: Login OK: [c80aa930b31f] (from client
10.126.123.10 port 50001 cli C8-0A-A9-30-B3-1F)
Tue Apr 28 16:53:58 2015 : Auth: rlm_perl: Returning vlan 210 to request from
c8:0a:a9:30:b3:1f port 50001
Tue Apr 28 16:53:58 2015 : Error: [sql] Couldn't insert SQL accounting START
record - PROCEDURE pf.acct_start does not exist
Tue Apr 28 16:54:00 2015 : Error: [sql] Couldn't update SQL accounting STOP
record - PROCEDURE pf.acct_stop does not exist
Tue Apr 28 16:54:00 2015 : Error: rlm_sql_mysql: Cannot store result
Tue Apr 28 16:54:00 2015 : Error: rlm_sql_mysql: MySQL error 'PROCEDURE
pf.acct_stop does not exist'
Tue Apr 28 16:54:05 2015 : Error: [sql] Couldn't update SQL accounting STOP
record - PROCEDURE pf.acct_stop does not exist
Tue Apr 28 16:54:05 2015 : Error: rlm_sql_mysql: Cannot store result
Tue Apr 28 16:54:05 2015 : Error: rlm_sql_mysql: MySQL error 'PROCEDURE
pf.acct_stop does not exist'
Do i miss configured any on database?
I have DHCP(windows OS) existed with DHCP range 10.126.123.x how to make
clients will retrieved DHCP from Windows OS after clients finished register?
Should i need change all ports on switch L2 to default(Vlan1)?
Any help is appreciated,
Thanks & regards,
On 2 April 2015 at 00:46, Durand fabrice <[email protected]> wrote:
Hello Minh,
you have to tag the vlan 210 and 220 on the switch port where packetfence has
been plugged on the vswitch.
I don't have the exact way to do it but it look like there is documentation on
internet to do that.
Regards
Fabrice
Le 2015-03-31 23:11, Minh Trung a écrit :
[The entire original message is not included.]
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
