0001529: web configurator - PacketFence

(0002962)
francis (administrator)
2012-08-24 10:29

At which step are you having the problem? Database? If so, have you succeed in creating both the database and the database account?

(0002963)
suenall (reporter)
2012-08-24 11:53

had been using IE.
Rolled back VM to pre configuration snapshot, restarted configurator in Chrome.
selected VLAN enforcement and deselected Inline, clicking continue takes me to networks page, but the only interface type options are mgmt, inline, and other.
the interface types necessary for vlan enforcement are not there.

(0002964)
suenall (reporter)
2012-08-24 11:55

also, in anser to your question, no the database and user were not created. When we tried (pre rollback) to create manually, ran into issues getting PF to talk to the db, causing the rollback and subsequent switch to chrome.

(0002965)
obilodeau (reporter)
2012-08-27 09:42

What version of IE?

Also, the log you provided, is it for the first problem (continue resets the page) or the second one (missing interface types)?

(0002968)
obilodeau (reporter)
2012-08-27 11:38

Adding information received by email:

We're using IE 9. And the log was for the first issue (continue resets the page). I didn't take a log for the other, just muddled thru and got PF services started and went to the main PF Web interface.

Cheers,
Sue

(0002977)
obilodeau (reporter)
2012-08-28 09:38

Extracted relevant pieces of log:

Aug 22 14:41:32 pfappserver_server.pl(0) WARN: 10.17.10.0.type does not exists (pfappserver::Model::Config::Networks::read_value)
...

Aug 22 14:52:06 pfappserver_server.pl(0) ERROR: DBI connect('dbname=pf;host=localhost;port=3306','pf',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (
2) at /usr/local/pf/html/pfappserver/script/../lib/pfappserver/Model/DB.pm line 83. (pfappserver::__ANON__)
Aug 22 14:52:06 pfappserver_server.pl(0) WARN: Error in connection to the database pf with user pf | Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (pfappserve
r::Model::DB::connect)
...
Aug 23 15:41:04 pfappserver_server.pl(0) INFO: Loaded existing /usr/local/pf/conf/networks.conf file (pfappserver::Model::Config::Networks::_load_networks_conf)
Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 10.17.10.0.type does not exists (pfappserver::Model::Config::Networks::read_value)
Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 172.20.0.0.type does not exists (pfappserver::Model::Config::Networks::read_value)
Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 172.20.2.0.type does not exists (pfappserver::Model::Config::Networks::read_value)
Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 172.20.3.0.type does not exists (pfappserver::Model::Config::Networks::read_value)

Regarding first issue, could we have javascript issues with IE 9?

Regarding second issue, we should try to reproduce the problem in the lab with the exact step.

Also it feels like the code to start the database server never worked.

(0002978)
obilodeau (reporter)
2012-08-28 09:41

Adding information received by email:

True, we did have to start the mysql server by hand in the linux cli.

Cheers,
Sue

(0002979)
obilodeau (reporter)
2012-08-28 09:47

Reminder sent to: fdurand

Fabrice, have you found any issues (besides the one you already fixed in documentation) regarding the web configurator on a pure RHEL6 install? Problems with MySQL starting?

(0002980)
fdurand (administrator)
2012-08-28 09:56

I installed a new pure RHEL 6 server, and the only thing i remark is that you must set NM_CONTROLLED to no in your network interface configuration file to prevent the network disconnection.

For MySQL i don´t know, but each time i have installed packetfence, i must have to start it by hand just after installing packetfence.

(0002981)
obilodeau (reporter)
2012-08-28 10:01

Well, web configurator is supposed to be able to start it.. so it's a bug. On your next install, get one of the devs to look at it please. Thanks.

(0003085)
milkmansson (reporter)
2012-09-20 10:07
edited on: 2012-09-20 10:12

The issue exists for the ZEN 3.5.1 ESX image.... 'Contine' and 'save' buttons do not work in IE 8/9, but functionality does work on Firefox 13.0. IE displays the error exclamation on the lower left corner of the window. Hope this helps!

Edit: In addition, the logic for the coding of the Enabled/Disabled buttons seems to be a little out - the text remains correct, but running your mouse over them repeatedly makes them change colour (red/green) with no action occurring - in case this is linked!

(0003086)
obilodeau (reporter)
2012-09-20 10:18

Reminder sent to: francis

front-end problems for you Francis ;)

(0003106)
francis (administrator)
2012-09-28 09:13

I just fixed a call to a JavaScript function that was causing an error under IE8:

https://github.com/inverse-inc/packetfence/commit/b2e36e8c879c1ed235ddf2f437181b76a96f8d8a [^]

Other question : is the date on your virtual machine properly set? Very important since we're using web cookies.

(0003107)
candlerb (reporter)
2012-09-28 12:58

> selected VLAN enforcement and deselected Inline, clicking continue takes me to networks page, but the only interface type options are mgmt, inline, and other.

I saw exactly the same problem when installing PacketFence last week:

* Deselect Inline enforcement, select VLAN enforcement
* On next page only "Management" and "Inline" are offered
* If I go back to the beginning, Inline enforcement is re-selected and VLAN enforcement de-selected

This was with Chrome and Safari under OSX, although Firefox was fine. Platform was PacketFence 3.5.1 under CentOS 6.3 x86_64

However I have now tried to replicate this using a VirtualBox VM with same flavour of CentOS and PacketFence, and I can't make it happen. With Chrome and Safari I get "Management", "Registration", "Isolation" as expected.

Most strange!

(0003108)
candlerb (reporter)
2012-09-28 13:13

Additional info:

* I can confirm that mysqld had to be started by hand on the command line (in both my original installation and the newly-created VM)

* In the original installation I got stuck in a state where pf had created the pf mysql user and database, but wouldn't let me continue. In the end I did a manual "drop database" to sort it out. I didn't have this problem when doing the VM install.

(0003126)
fgaudreault (viewer)
2012-10-19 11:14

I heard that some other client had the same issue yesterday.

Unselecting Inline, Selecting VLAN, and the customer had to configure Inline stuff. This differs from the original bug, maybe we should open a new bug entry to the Inline/VLAN part?

(0003127)
francis (administrator)
2012-10-19 11:15

I suspect a more general web session issue. No need to open a new ticket.

(0003129)
fgaudreault (viewer)
2012-10-19 11:17

Ok. Will put this into the "investigate" queue. Do you want to take the lead on this?

(0003312)
francis (administrator)
2013-06-03 08:43

Does this problem still persist in release 4.0.1?

Notes
(0002962) francis (administrator) 2012-08-24 10:29	At which step are you having the problem? Database? If so, have you succeed in creating both the database and the database account?

(0002963) suenall (reporter) 2012-08-24 11:53	had been using IE. Rolled back VM to pre configuration snapshot, restarted configurator in Chrome. selected VLAN enforcement and deselected Inline, clicking continue takes me to networks page, but the only interface type options are mgmt, inline, and other. the interface types necessary for vlan enforcement are not there.

(0002964) suenall (reporter) 2012-08-24 11:55	also, in anser to your question, no the database and user were not created. When we tried (pre rollback) to create manually, ran into issues getting PF to talk to the db, causing the rollback and subsequent switch to chrome.

(0002965) obilodeau (reporter) 2012-08-27 09:42	What version of IE? Also, the log you provided, is it for the first problem (continue resets the page) or the second one (missing interface types)?

(0002968) obilodeau (reporter) 2012-08-27 11:38	Adding information received by email: We're using IE 9. And the log was for the first issue (continue resets the page). I didn't take a log for the other, just muddled thru and got PF services started and went to the main PF Web interface. Cheers, Sue

(0002977) obilodeau (reporter) 2012-08-28 09:38	Extracted relevant pieces of log: Aug 22 14:41:32 pfappserver_server.pl(0) WARN: 10.17.10.0.type does not exists (pfappserver::Model::Config::Networks::read_value) ... Aug 22 14:52:06 pfappserver_server.pl(0) ERROR: DBI connect('dbname=pf;host=localhost;port=3306','pf',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' ( 2) at /usr/local/pf/html/pfappserver/script/../lib/pfappserver/Model/DB.pm line 83. (pfappserver::__ANON__) Aug 22 14:52:06 pfappserver_server.pl(0) WARN: Error in connection to the database pf with user pf \| Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) (pfappserve r::Model::DB::connect) ... Aug 23 15:41:04 pfappserver_server.pl(0) INFO: Loaded existing /usr/local/pf/conf/networks.conf file (pfappserver::Model::Config::Networks::_load_networks_conf) Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 10.17.10.0.type does not exists (pfappserver::Model::Config::Networks::read_value) Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 172.20.0.0.type does not exists (pfappserver::Model::Config::Networks::read_value) Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 172.20.2.0.type does not exists (pfappserver::Model::Config::Networks::read_value) Aug 23 15:41:04 pfappserver_server.pl(0) WARN: 172.20.3.0.type does not exists (pfappserver::Model::Config::Networks::read_value) Regarding first issue, could we have javascript issues with IE 9? Regarding second issue, we should try to reproduce the problem in the lab with the exact step. Also it feels like the code to start the database server never worked.

(0002978) obilodeau (reporter) 2012-08-28 09:41	Adding information received by email: True, we did have to start the mysql server by hand in the linux cli. Cheers, Sue

(0002979) obilodeau (reporter) 2012-08-28 09:47	Reminder sent to: fdurand Fabrice, have you found any issues (besides the one you already fixed in documentation) regarding the web configurator on a pure RHEL6 install? Problems with MySQL starting?

(0002980) fdurand (administrator) 2012-08-28 09:56	I installed a new pure RHEL 6 server, and the only thing i remark is that you must set NM_CONTROLLED to no in your network interface configuration file to prevent the network disconnection. For MySQL i don´t know, but each time i have installed packetfence, i must have to start it by hand just after installing packetfence.

(0002981) obilodeau (reporter) 2012-08-28 10:01	Well, web configurator is supposed to be able to start it.. so it's a bug. On your next install, get one of the devs to look at it please. Thanks.

(0003085) milkmansson (reporter) 2012-09-20 10:07 edited on: 2012-09-20 10:12	The issue exists for the ZEN 3.5.1 ESX image.... 'Contine' and 'save' buttons do not work in IE 8/9, but functionality does work on Firefox 13.0. IE displays the error exclamation on the lower left corner of the window. Hope this helps! Edit: In addition, the logic for the coding of the Enabled/Disabled buttons seems to be a little out - the text remains correct, but running your mouse over them repeatedly makes them change colour (red/green) with no action occurring - in case this is linked!

(0003086) obilodeau (reporter) 2012-09-20 10:18	Reminder sent to: francis front-end problems for you Francis ;)

(0003106) francis (administrator) 2012-09-28 09:13	I just fixed a call to a JavaScript function that was causing an error under IE8: https://github.com/inverse-inc/packetfence/commit/b2e36e8c879c1ed235ddf2f437181b76a96f8d8a [^] Other question : is the date on your virtual machine properly set? Very important since we're using web cookies.

(0003107) candlerb (reporter) 2012-09-28 12:58	> selected VLAN enforcement and deselected Inline, clicking continue takes me to networks page, but the only interface type options are mgmt, inline, and other. I saw exactly the same problem when installing PacketFence last week: * Deselect Inline enforcement, select VLAN enforcement * On next page only "Management" and "Inline" are offered * If I go back to the beginning, Inline enforcement is re-selected and VLAN enforcement de-selected This was with Chrome and Safari under OSX, although Firefox was fine. Platform was PacketFence 3.5.1 under CentOS 6.3 x86_64 However I have now tried to replicate this using a VirtualBox VM with same flavour of CentOS and PacketFence, and I can't make it happen. With Chrome and Safari I get "Management", "Registration", "Isolation" as expected. Most strange!

(0003108) candlerb (reporter) 2012-09-28 13:13	Additional info: * I can confirm that mysqld had to be started by hand on the command line (in both my original installation and the newly-created VM) * In the original installation I got stuck in a state where pf had created the pf mysql user and database, but wouldn't let me continue. In the end I did a manual "drop database" to sort it out. I didn't have this problem when doing the VM install.

(0003126) fgaudreault (viewer) 2012-10-19 11:14	I heard that some other client had the same issue yesterday. Unselecting Inline, Selecting VLAN, and the customer had to configure Inline stuff. This differs from the original bug, maybe we should open a new bug entry to the Inline/VLAN part?

(0003127) francis (administrator) 2012-10-19 11:15	I suspect a more general web session issue. No need to open a new ticket.

(0003129) fgaudreault (viewer) 2012-10-19 11:17	Ok. Will put this into the "investigate" queue. Do you want to take the lead on this?

(0003312) francis (administrator) 2013-06-03 08:43	Does this problem still persist in release 4.0.1?

Issue History
Date Modified	Username	Field	Change
2012-08-24 10:25	suenall	New Issue
2012-08-24 10:25	suenall	File Added: packetfence.log
2012-08-24 10:29	francis	Note Added: 0002962
2012-08-24 11:53	suenall	Note Added: 0002963
2012-08-24 11:55	suenall	Note Added: 0002964
2012-08-27 09:42	obilodeau	Note Added: 0002965
2012-08-27 09:42	obilodeau	Priority	normal => high
2012-08-27 09:42	obilodeau	Severity	block => major
2012-08-27 11:38	obilodeau	Note Added: 0002968
2012-08-28 09:38	obilodeau	Note Added: 0002977
2012-08-28 09:41	obilodeau	Note Added: 0002978
2012-08-28 09:47	obilodeau	Note Added: 0002979
2012-08-28 09:56	fdurand	Note Added: 0002980
2012-08-28 10:01	obilodeau	Note Added: 0002981
2012-09-20 10:07	milkmansson	Note Added: 0003085
2012-09-20 10:12	milkmansson	Note Edited: 0003085
2012-09-20 10:18	obilodeau	Note Added: 0003086
2012-09-28 09:13	francis	Note Added: 0003106
2012-09-28 12:58	candlerb	Note Added: 0003107
2012-09-28 13:13	candlerb	Note Added: 0003108
2012-10-19 11:14	fgaudreault	Note Added: 0003126
2012-10-19 11:15	francis	Note Added: 0003127
2012-10-19 11:16	fgaudreault	Target Version	=> investigate
2012-10-19 11:17	fgaudreault	Note Added: 0003129
2012-10-19 11:18	francis	Status	new => assigned
2012-10-19 11:18	francis	Assigned To	=> francis
2013-06-03 08:43	francis	Note Added: 0003312

Relationships