Welcome, Guest. Please login or register.

Author Topic: Nedi 1.9  (Read 498 times)

swepart

  • Newbie
  • *
  • Posts: 37
    • View Profile
Nedi 1.9
« on: September 03, 2019, 10:37:05 PM »
Have tested 1.9 on a small scale and found something that might be a bug or some misconfiguration of my php

when running "noodle"  I get back data that is correct but this  at the same time I get this messages.

nodarp: Illegal mix of collations for operation 'concat'
nodnd: Illegal mix of collations for operation 'concat'
dns: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'concat'
iptrack: Illegal mix of collations for operation 'concat'

I am using
Centos 7
PHP ver 7.2.21
Mariadb mysql  Ver 15.1 Distrib 5.5.60-MariaDB
Apache 2.4.6

/swepart

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2711
    • View Profile
    • NeDi
Re: Nedi 1.9
« Reply #1 on: September 05, 2019, 02:33:58 PM »
This can be seen on various Nedi versions. I don't really know why it occurs, but apparently the encoding should be set upon creating the DB. I'll do this in coming NeDi versions from now on...

In order to fix exiting DBs (NeDi 2.0 will have templates in System-Database):
LTER DATABASE nedi DEFAULT COLLATE utf8_unicode_ci;

Then execute this for every table showing a warning (e.g. devices):
LTER TABLE devices CONVERT TO CHARACTER SET utf8;

Add an A at the beginning (can't post the proper query due to security :-)
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo

swepart

  • Newbie
  • *
  • Posts: 37
    • View Profile
Re: Nedi 1.9
« Reply #2 on: September 07, 2019, 02:39:50 AM »
Tnx,, that solved that issue.

eviltrooper

  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Nedi 1.9
« Reply #3 on: November 14, 2019, 02:29:23 PM »
can someone tell me how to install the Tool "Library"

over system files - update nedi (replace configuration) ???

an how i can now run the "cable-diagnostics"

eviltrooper

  • Newbie
  • *
  • Posts: 47
    • View Profile
Re: Nedi 1.9
« Reply #4 on: November 28, 2019, 01:04:51 PM »
nobody ?? :(

rickli

  • Administrator
  • Hero Member
  • *****
  • Posts: 2711
    • View Profile
    • NeDi
Re: Nedi 1.9
« Reply #5 on: December 03, 2019, 10:03:10 AM »
It's intended to copy parts of it into your devtools.php or iftools.php. I'm collection ideas and use cases for sharing with customers. Contact me, if you need any help...
Please consider Other-Invoices on your NeDi installation for an annual contribution, tx!
-Remo