Hi All,
Can we install the MySQL Server in EPIC? Which version of MySQL is suitable for the 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?
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ā¦
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.
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ā¦
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