Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Stuck loading tables with varbinary? #278

Open
elpardua opened this issue Apr 13, 2018 · 0 comments
Open

Stuck loading tables with varbinary? #278

elpardua opened this issue Apr 13, 2018 · 0 comments

Comments

@elpardua
Copy link

Hi Jason, first of all, amazing job you did with this project. I left programming like 20 years ago, and phreeze made my life easier doing an app to control kea dhcp and radius daemons. I'm having a problem with two tables of kea, when they were empty the lists appeared ok (at least column names). Now that kea populates them with values, when i click on that table, the rendering gets stuck and all i got is the table name and the blue loading bar running forever. I've tried turning logging on on my php.ini, but i can't see any error. I know phreeze doesn't know how to represent a value differently than in the way it's stored. Can anyone tell me where to look for?
This is the problematic table:
mysql> describe lease4;
+----------------+------------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+-------------------+-----------------------------+
| address | int(10) unsigned | NO | PRI | NULL | |
| hwaddr | varbinary(20) | YES | MUL | NULL | |
| client_id | varbinary(128) | YES | MUL | NULL | |
| valid_lifetime | int(10) unsigned | YES | | NULL | |
| expire | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| subnet_id | int(10) unsigned | YES | | NULL | |
| fqdn_fwd | tinyint(1) | YES | | NULL | |
| fqdn_rev | tinyint(1) | YES | | NULL | |
| hostname | varchar(255) | YES | | NULL | |
| state | int(10) unsigned | YES | MUL | 0 | |
+----------------+------------------+------+-----+-------------------+-----------------------------+
10 rows in set (0.01 sec)

mysql> select * from lease4 limit 1;
+------------+--------+-----------+----------------+---------------------+-----------+----------+----------+----------------------------+-------+
| address | hwaddr | client_id | valid_lifetime | expire | subnet_id | fqdn_fwd | fqdn_rev | hostname | state |
+------------+--------+-----------+----------------+---------------------+-----------+----------+----------+----------------------------+-------+
| 3036741892 | �v��W | ��v��W | 3600 | 2018-04-13 16:10:04 | 1 | 1 | 1 | atadeviced4:76:ea:d0:0e:56 | 0 |
+------------+--------+-----------+----------------+---------------------+-----------+----------+----------+----------------------------+-------+
1 row in set (0.00 sec)

My guess is that it has to do something with the encoding and php, but as i said, i can't get any error messages.
According to kea documentation, i must run the HEX function in the hwaddr field, and INET_NTOA in the address field to visualize properly the information.

Thanks in advance.
Pablo
P.S: Sorry for my english, i'm from Argentina.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant