NCID-MYSQL not recognizing mariadb

[Dale Bourne]

Installing 1.10 on raspberry pi B3+. But got the following when installing 'ncid-mysql_1.10-1_all.deb';
$ sudo apt install ncid-mysql_1.10-1_all.deb
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package ncid-mysql_1.10-1_all.deb
E: Couldn't find any package by glob 'ncid-mysql_1.10-1_all.deb'
E: Couldn't find any package by regex 'ncid-mysql_1.10-1_all.deb'
So I tried;
sudo dpkg -i ncid-mysql_1.10-1_all.deb
Selecting previously unselected package ncid-mysql.
(Reading database ... 111437 files and directories currently installed.)
Preparing to unpack ncid-mysql_1.10-1_all.deb ...
Unpacking ncid-mysql (1.10-1) ...
dpkg: dependency problems prevent configuration of ncid-mysql:
ncid-mysql depends on mysql; however:
Package mysql is not installed.

dpkg: error processing package ncid-mysql (--install):
dependency problems - leaving unconfigured
Processing triggers for man-db (2.7.6.1-2) ...
Errors were encountered while processing:
ncid-mysql

True, I don't have MYSQL, pi's utilize the mariadb.

Any suggestions?
Thnx,
Dale

[John L. Chmielewski]

The mariadb package should provide the mysql dependency.

The INSTALL or UPGRADE in the DEB Package Install for Ubuntu and Raspbian section of the user manual gives 4 methods that can install a NCID package downloaded from Sourceforge.

You used the first part of method 4:

sudo dpkg -i ncid-mysql_1.10-1_all.deb

If the module is still partially installed, do:

sudo apt-get install -f

Method 1 is the prefered method. Your apt line matches the line given in the user manual for modules but it is incorrect. A "./" is needed as shown::

sudo apt install ./ncid-mysql_1.10-1_all.deb

[Dale Bourne]

Thank your for your quick reply. Yep, I missed the './', however;
results of: sudo apt install ./ncid-mysql_1.10-1_all.deb

Reading package lists... Done
Building dependency tree
Reading state information... Done
Note, selecting 'ncid-mysql' instead of './ncid-mysql_1.10-1_all.deb'
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
ncid-mysql : Depends: mysql but it is not installable
E: Unable to correct problems, you have held broken packages.

I find this somewhat confusing in that I can access 'MySQL' via command line, PHP, and phpMyAdmin works fine.
Again, I really appreciate your help and will await further suggestions. Otherwise I suppose I'll have to use the default db.

Thnx again,
Dale

[Ed Attfield]

I tried searching for the error message "E: Unable to correct problems, you have held broken packages" and various sources are saying that your package manager is not entirely sane.
The suggested remedies seem to include running these commands to clean it up and get the latest of everything you already have

  sudo dpkg --configure -a
  sudo apt-get update
  sudo apt-get -f install
  sudo apt-get dist-upgrade
  sudo apt-get upgrade

[Clarence Lee]

I tried to replace the dependency string from mysql to mariadb-client or mysql-client in the ncid-mysql.deb . It works