NeDi Community

NeDi Software Specific => Installation => Topic started by: swepart on September 03, 2019, 10:37:05 pm

Title: Nedi 1.9
Post by: swepart 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
Title: Re: Nedi 1.9
Post by: rickli 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 :-)
Title: Re: Nedi 1.9
Post by: swepart on September 07, 2019, 02:39:50 am
Tnx,, that solved that issue.
Title: Re: Nedi 1.9
Post by: eviltrooper 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"
Title: Re: Nedi 1.9
Post by: eviltrooper on November 28, 2019, 01:04:51 pm
nobody ?? :(
Title: Re: Nedi 1.9
Post by: rickli 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...