#19 dalo only showing 14 pages

[Anonymous]

Liran,

we have reached 14 pages on the dalo accounts, it seems interface will not read to see the new accounts added.. Can you email me rmueller at esu3 dot org? is there something I can do to fix it?

Rex Mueller
Education Service Unit #3, LaVista Nebraska

[Rex M]

still having problems, was able to find a count error between userinfo and radcheck and fixed it by creating a load file from userinfo,

mysql> select id, username, "Auth-Type","=","Accept" from userinfo ORDER BY id into outfile '/tmp/radchecknew.csv' FIELDS ENCLOSED BY '"' TERMINATED BY '|' ESCAPED BY '"' LINES TERMINATED BY '\r\n';

then
mysql> truncate radcheck

then
mysql> LOAD DATA INFILE '/tmp/radchecknew.csv' INTO TABLE radcheck FIELDS enclosed by '\"' TERMINATED BY '|' lines terminated by '\r\n';

Now however when we delete from the web interface the interface throws and error:

adding new accounts still do not appear on list and get the following error when deleting.
db error no such field delete from radpostauth

[Liran Tal]

So I'm not really sure what you fixed exactly.
Is that really a count error on daloRADIUS's fault or were your users not created correctly?

[Rex M]

Liran,

I do not know either... It was odd, we create "accounts" using the interface, and I believe one of our team deleted an account and there was a mismatch count between the radccheck and userinfo table.
I created a SQL script to pull info from the user table, dropped the radcheck and reloaded it with the data, and paging began to work again.

It has to so with something when we checked the account from the list page and hit the delete button.
We, using the Add New User then we add MAC Address Authentication:

[cid:image001.png@01CF95DB.86AE9AC0]

The account is created then
[cid:image002.png@01CF95DB.86AE9AC0]

Then we click on User Info tab and add "Last Name" Entry.

[cid:image004.png@01CF95DC.6E95D290]

Then we list to verify the account is displaying correctly, now we can allow the user to connect.

[cid:image005.png@01CF95DC.6E95D290]

IF we Click on the "Check BOX, (for the account in question) and click the Delete:
[cid:image003.png@01CF95DC.F66DF9E0]

Our work around at this point is to not remove accounts.

Are you still maintaining the code? It the "delete" actually deleting?

It is not a big deal at this point, we are ok. I wanted to make you aware of this in the event you are still maintaining the code.

Rex Mueller

---

Educational Service Unit #3
Rex Mueller - Unix and Finance Systems Administrator
6949 S 110th Street
LaVista, Nebraska 68128
(402)597-4863
rmueller@esu3.orgrmueller@esu3.org

---

From: Liran Tal [mailto:lirantal@users.sf.net]
Sent: Wednesday, July 02, 2014 6:21 AM
To: [daloradius:support-requests]
Subject: [daloradius:support-requests] #19 dalo only showing 14 pages

So I'm not really sure what you fixed exactly.
Is that really a count error on daloRADIUS's fault or were your users not created correctly?

---

[support-requests:#19]http://sourceforge.net/p/daloradius/support-requests/19/ dalo only showing 14 pages

Status: closed
Group: v1.0_(example)
Created: Tue Jun 17, 2014 03:18 PM UTC by Anonymous
Last Updated: Wed Jul 02, 2014 11:19 AM UTC
Owner: Liran Tal

Liran,

we have reached 14 pages on the dalo accounts, it seems interface will not read to see the new accounts added.. Can you email me rmueller at esu3 dot org? is there something I can do to fix it?

Rex Mueller
Education Service Unit #3, LaVista Nebraska

---

Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/daloradius/support-requests/19/

To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/

[Liran Tal]

Hey Rex,

Definitely. I'm still maintaining the code so if you find the actual cause for the problem or you are fixing it in your install please send me the information and I'll apply this fix for daloRADIUS.