Need a Local Data Base Server in EPIC

Hi All,

Can we install the MySQL Server in EPIC? Which version of MySQL is suitable for the EPIC?

Sqlite3 is already installed. Would that work for you?

Thatā€™s an interesting tidbit.

Groov, uses Sqlite so EPIC would need it for that. Can the user have direct access to it (Node-RED?) without signing their life away for shell access?

2 Likes

Yes. Node-RED can access it.

itā€™s great the Sqlite3 is already installed in EPIC!
How about the user name and password of the root or admin?
Has any document in EPIC?

Has any Sqlite3 GUI manager in EPIC?

Whoa, opened the flood gates hereā€¦ :grinning:

No user pass, its wide open. (As I recall, could be wrong, butā€¦)
No, no docs because we donā€™t support it. Its like shell access, you use it, and break it, donā€™t call support, reset to factory and if it all works Ok, then it was your code that broke it. aka, we cant and donā€™t support your code.
Ask in the forums, but thatā€™s it.

No, there is no GUI for adminā€™ing it, its all command line. (Yum).

Thanks Beno. We know Opto 22 donā€™t support the shell access.
May somebody has this experience can teach us.

Firefox Addons SQLite Managerā€¦

Great news for this topic.
You can now install either MariaDB or PostgreSQL on EPIC through SSH.

1 Like

sooooooā€¦ I have started playing with SSH (yum)

I updated to EPIC firmware 1.5 today and when doing apt update to install Mariadb I get errors:

Ign:1 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all InRelease
Ign:2 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon InRelease
Ign:3 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl InRelease
Ign:4 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio InRelease
Ign:5 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Release
Ign:6 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Release
Ign:7 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Release
Ign:8 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Release
Ign:9 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Packages
Ign:10 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en_US
Ign:11 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en
Ign:12 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Packages
Ign:13 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en_US
Ign:14 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en
Ign:15 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Packages
Ign:16 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en_US
Ign:17 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en
Ign:18 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Packages
Ign:19 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en_US
Ign:20 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en
Ign:9 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Packages
Ign:10 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en_US
Ign:11 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en
Ign:12 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Packages
Ign:13 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en_US
Ign:14 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en
Ign:15 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Packages
Ign:16 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en_US
Ign:17 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en
Ign:18 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Packages
Ign:19 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en_US
Ign:20 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en
Ign:9 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Packages
Ign:10 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en_US
Ign:11 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en
Ign:12 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Packages
Ign:13 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en_US
Ign:14 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en
Ign:15 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Packages
Ign:16 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en_US
Ign:17 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en
Ign:18 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Packages
Ign:19 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en_US
Ign:20 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en
Err:9 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Packages
404 Not Found
Ign:10 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en_US
Ign:11 http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Translation-en
Err:12 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Packages
404 Not Found
Ign:13 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en_US
Ign:14 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Translation-en
Err:15 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Packages
404 Not Found
Ign:16 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en_US
Ign:17 http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Translation-en
Err:18 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Packages
404 Not Found
Ign:19 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en_US
Ign:20 http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Translation-en
Reading package listsā€¦ Done
W: The repository ā€˜http://archive.opto22.com/packages/grv-epic-pr1/1.5/all Releaseā€™ does not have a Release file.
N: Data from such a repository canā€™t be authenticated and is therefore potentially dangerous to use.
N: See apt-secure(8) manpage for repository creation and user configuration details.
W: The repository ā€˜http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon Releaseā€™ does not have a Release file.
N: Data from such a repository canā€™t be authenticated and is therefore potentially dangerous to use.
N: See apt-secure(8) manpage for repository creation and user configuration details.
W: The repository ā€˜http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl Releaseā€™ does not have a Release file.
N: Data from such a repository canā€™t be authenticated and is therefore potentially dangerous to use.
N: See apt-secure(8) manpage for repository creation and user configuration details.
W: The repository ā€˜http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio Releaseā€™ does not have a Release file.
N: Data from such a repository canā€™t be authenticated and is therefore potentially dangerous to use.
N: See apt-secure(8) manpage for repository creation and user configuration details.
E: Failed to fetch http://archive.opto22.com/packages/grv-epic-pr1/1.5/all/Packages 404 Not Found
E: Failed to fetch http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon/Packages 404 Not Found
E: Failed to fetch http://archive.opto22.com/packages/grv-epic-pr1/1.5/cortexa9hf-vfp-neon-mx6qdl/Packages 404 Not Found
E: Failed to fetch http://archive.opto22.com/packages/grv-epic-pr1/1.5/imx6qnxtio/Packages 404 Not Found
E: Some index files failed to download. They have been ignored, or old ones used instead.

Am I too soon/quick?

Let me check on this end and get back to youā€¦

1 Like

Ok, yeah, we needed to flip the switch at our end.
Should be all good now. (Sorry for the delay).

Thanks Ben. Just installed and happy to report all is working again!

I got everything installedā€¦ but now it does not recognize root user, access denied.
tried everything and followed optodev instructions to the tee.
Tried changing password as directed but it still wonā€™t allow access for root.

error: 'Access denied for user ā€˜rootā€™@ā€˜localhostā€™ (using password: NO)'

opto@opto-04-22-cd:~$ mysqladmin -u root -p status

Enter password:

mysqladmin: connect to server at ā€˜localhostā€™ failed

error: 'Access denied for user ā€˜rootā€™@ā€˜localhostā€™ (using password: NO)'

opto@opto-04-22-cd:~$ mysqladmin -u root -p status

Enter password:

mysqladmin: connect to server at ā€˜localhostā€™ failed

error: 'Access denied for user ā€˜rootā€™@ā€˜localhostā€™ (using password: YES)'

opto@opto-04-22-cd:~$ sudo nano /etc/my.cnf

Password:

opto@opto-04-22-cd:~ opto@opto-04-22-cd:~ sudo nano /etc/my.cnf

opto@opto-04-22-cd:~$ mysql -u root -p

Enter password:

ERROR 1045 (28000): Access denied for user ā€˜rootā€™@ā€˜localhostā€™ (using password: NO)

opto@opto-04-22-cd:~$ mysql -u root -p

Enter password:

ERROR 1045 (28000): Access denied for user ā€˜rootā€™@ā€˜localhostā€™ (using password: YES)

Its the same version as last time, we did not change anything (MariaDB is not our code) so the best I can suggest is something like StackOverflow; (Or uninstall and start again from fresh?).

Have done 3 start againsā€¦ same results.
Stackoverflow results are a little different as the environment is different. Some of the commands do not register/work

Do you know the root password?
I thought that creating a root user was the answer as the problem seems to be that it wants the root user. One cannot create a root user when registering SSH user on the EPIC. IT says it is reserved

I shall continue the slog. Someone must have gotten this right on the EPIC using SSH?

My understanding is that there is no root password (so no, I donā€™t know it).
I should get some time to revisit this today and see if I get the same issues as you.

Donā€™t confuse root on SSH with root in MariaDB, they are not the same.

Ok. Clearly there is something different with how I am doing it and how you areā€¦ everyting worked just as expected for me by following the developer.opto22.com instructions.

Here is what I did, follow it closely and see how it is different to what you do.

opto@epic-dc100:~$ sudo apt-get install mariadb

opto@epic-dc100:~$ sudo nano /etc/my.cnf
opto@epic-dc100:~$ mysqladmin -u root password "opto22";
opto@epic-dc100:~$ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.3.13-MariaDB Source distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'opto22' WITH GRANT OPTION;
Query OK, 0 rows affected (0.002 sec)

MariaDB [(none)]> exit
Bye

opto@epic-dc100:~$ sudo /etc/init.d/mysqld restart
Shutting down MariaDB.[  OK  ]
Starting MariaDB.191219 09:16:03 mysqld_safe Logging to '/var/log/mysqld.err'.
.191219 09:16:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[  OK  ]
opto@epic-dc100:~$

opto@epic-dc100:~$ mysqladmin -u root -p status
Enter password:
Uptime: 84  Threads: 2  Questions: 2  Slow queries: 0  Opens: 17  Flush tables: 1  Open tables: 10  Queries per second avg: 0.023
opto@epic-dc100:~$

wow - ok thanks for testing, Ben.

I did exactly that. Perhaps the fault lies within the my.cnf file? I see you donā€™t get asked for a password to access it?
Could you share what yours looks like after the edit?

as soon as I run:

mysqladmin -u root password ā€œopto22ā€;

I get this:

mysqladmin: connect to server at ā€˜localhostā€™ failed
error: ā€˜Access denied for user ā€˜rootā€™@ā€˜localhostā€™ (using password: NO)ā€™

[client]
#password                                       = password
port                                            = 3306
socket                                          = /var/lib/mysql/mysql.sock

[mysqld_safe]

[mysqld]
user                                            = mysql
port                                            = 3306
socket                                          = /var/lib/mysql/mysql.sock
pid-file                                        = /var/lib/mysql/mysqld.pid
log-error                                       = /var/log/mysqld.err
basedir                                         = /usr
datadir                                         = /var/lib/mysql
skip-external-locking
#skip-networking
ignore-builtin-innodb
default-storage-engine                          = myisam
bind-address                                    = 0.0.0.0

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d