Le 09/01/2017 à 13:19, denis a écrit :
>
>
> Le 06/01/2017 à 14:30, Fabrice Durand a écrit :
>> Hello Denis,
>>
>> you need to run all the sql upgrade from 4.6 to 6.4.
>>
>>
> Hello, I tried this, with -f option to bypass errors with already
> existing fields and keys, but now in 6.4 there are some remaining
> problems :
>
> - nodes are not displayed ( no errors, just nothing displayed in the
> list ). Users are ok.
here is an example of node table :
mysql> select * from node where computername = "micro-a12-t01"\G
*************************** 1. row ***************************
mac: 00:26:b9:77:ff:3c
pid: micro-a12-t01$
category_id: 8
detect_date: 2014-12-08 10:20:08
regdate: 2014-12-08 10:20:08
unregdate: 2100-01-01 00:00:00
lastskip: 0000-00-00 00:00:00
time_balance: NULL
bandwidth_balance: NULL
status: reg
user_agent:
computername: micro-a12-t01
notes: AUTO-REGISTERED
last_arp: 0000-00-00 00:00:00
last_dhcp: 2017-01-05 13:31:17
dhcp_fingerprint: 1,15,3,6,44,46,47,31,33,121,249,43
dhcp_vendor: NULL
device_type: NULL
device_class: NULL
bypass_vlan:
voip: no
autoreg: yes
sessionid:
machine_account: NULL
bypass_role_id: NULL
1 row in set (0.00 sec)
>
> - radiusd can't start, radius.log shows an error :
>
> Mon Jan 9 11:22:02 2017 : Error: rlm_sql (sql): rlm_sql_mysql: ERROR
> 1054 (Unknown column 'id' in 'field list'): 42S22
> Mon Jan 9 11:22:02 2017 : Error: Failed to load clients from SQL
> Mon Jan 9 11:22:02 2017 : Error: raddb//mods-enabled/sql[23]:
> Instantiation failed for module "sql"
>
> As the message is not really explicit, I wasn't able to find the
> problem in the database structure. Any idea ?
>
I tried to drop all the tables, run the assistant, and radiusd started.
But when I import 4.6 base and upgraded it, it stopped.
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
