Tiny Core Linux
Tiny Core Extensions => TCE Q&A Forum => Topic started by: kataka on June 27, 2021, 01:14:07 PM
-
Hi, i have installed tcl, apache, php, ssl, as per guides from parkytowers (and others, i guess): https://www.parkytowers.me.uk/thin/Linux/TinycoreWS_1.shtml
I then installed mariadb-10.5.tcz and mariadb-10.5-client.tcz and got stuck. not any command is working. any help?
-
Hi kataka
Welcome to the forum.
Did you start mysql:
# /usr/local/etc/init.d/mysql startDon't include the # symbol in the command.
-
Have you tried this? http://forum.tinycorelinux.net/index.php/topic,22602.msg141609.html#msg141609 (http://forum.tinycorelinux.net/index.php/topic,22602.msg141609.html#msg141609)
-
Thanks Andy, that did something.. will feed back shortly
-
That seemed to have helped but no any idea what next..
-
warning cant create file /home/tc/mysql/data/server123.test (this directory is obviously wrong but i don't know where to set it)
-
fatal error: cant open and lock privilege tables mysql.db not exist
-
another thing i do not understand is that i have to enter
tce-load -i mariadb-10.5-client
after every reboot whiles for mariab-10.5 (server) i get a message that it is installed already
i tried adding tce-load -i mariadb-10.5-client to /opt/bootlocal.sh :o but it seems it is being ignored because entering tce-load -i mariadb-10.5-client after booting returns OK
-
You only need the mariadb client for a computer that will work with a database on a different computer. If you have only one computer then mariadb alone is enough. If I remember correctly you don't need the client for a computer using the PHP native mysql client extension even if it isn't on the same computer as the server, but I've never tested that.
I only build mariadb so that the extensions I maintain can be compiled with support for it. I only use it enough to build test databases so "make check" can verify the extensions work like they should. I used mariadb for a month or two, but I was an Oracle DBA for many years and I soon realized mariadb was to databases what windows is to operating systems. I switched to Postgresql and things just started working like they should, like when I switched to Linux (in the mid '90s).
I'm sorry, but I'm at the limit of what I know about mariadb. Every time this comes up I ask that someone who actually cares about it take over maintaining it, but you can see that hasn't happened yet so this is as good as it gets for now.
I maintain the PHP, Apache, and Nginx extensions also, and I test them against mariadb, Postgresql, MS SQL Server, and Oracle on both 32 and 64 bit.
-
Hi kataka
Click on the Apps icon at the bottom of the screen.
When the Apps utility appears, click Apps->Maintenance->OnBoot Maintenance.
Click on mariadb-10.5-client.tcz in the left pane.
Click the Add Item button.
mariadb-10.5-client.tcz should now load automatically when you boot.
-
Hi kataka
Click on the Apps icon at the bottom of the screen.
When the Apps utility appears, click Apps->Maintenance->OnBoot Maintenance.
Click on mariadb-10.5-client.tcz in the left pane.
Click the Add Item button.
mariadb-10.5-client.tcz should now load automatically when you boot.
Thank you that worked fine. But why did installing tce-load -wi did not achieve this?
-
You only need the mariadb client for a computer that will work with a database on a different computer. If you have only one computer then mariadb alone is enough. If I remember correctly you don't need the client for a computer using the PHP native mysql client extension even if it isn't on the same computer as the server, but I've never tested that.
I only build mariadb so that the extensions I maintain can be compiled with support for it. I only use it enough to build test databases so "make check" can verify the extensions work like they should. I used mariadb for a month or two, but I was an Oracle DBA for many years and I soon realized mariadb was to databases what windows is to operating systems. I switched to Postgresql and things just started working like they should, like when I switched to Linux (in the mid '90s).
I'm sorry, but I'm at the limit of what I know about mariadb. Every time this comes up I ask that someone who actually cares about it take over maintaining it, but you can see that hasn't happened yet so this is as good as it gets for now.
I maintain the PHP, Apache, and Nginx extensions also, and I test them against mariadb, Postgresql, MS SQL Server, and Oracle on both 32 and 64 bit.
Few minutes after your first reply yesterday, i was able to get into the mysql cli... but then i rebooted and was not able to repeat the same process (should have taken notes of what i did)... still trying to get it to work.
I never used postgre never had a problem with mysql or mariadb. any reasons i should?
-
When i click SERVICES in control panel and click mysql the green light goes on but goes off after few seconds. where i can i find an error about this?
-
Hi kataka
Welcome to the forum.
Did you start mysql:
# /usr/local/etc/init.d/mysql startDon't include the # symbol in the command.
returns: sh:cant kill pid no such process. Error!
-
The mariadb client extension is a few libraries and executables from the server extension. If you install mariadb you already have every file in the mariadb client extension, so there is no point to installing both. The executables for mariadb are in /usr/local/mysql/bin, so you will need to add this to your PATH variable, or fully qualify the path to the executable you wish to run. You will also either need to add /usr/local/mysql/lib to /etc/ld.so.conf, or specify LD_LIBRARY_PATH=/usr/local/mysql/lib whenever you run a mariadb executable.
-
Hi kataka
... But why did installing tce-load -wi did not achieve this?
The only reasons I can think of are:
You accidentally left out the i switch (tce-load -w).
While typing the i switch you stumbled and added an l switch (tce-load -wil).
While typing the i switch you missed and added an o switch instead (tce-load -wo).
-
Hi kataka
... But why did installing tce-load -wi did not achieve this?
The only reasons I can think of are:
You accidentally left out the i switch (tce-load -w).
While typing the i switch you stumbled and added an l switch (tce-load -wil).
While typing the i switch you missed and added an o switch instead (tce-load -wo).
hi thank you, no i'm pretty sure typed -wi.. and i tried several times. anyway thanks to Andy i know -client is not necessary ;-/
i receive mostly socket error now, i configured /tmp/mysql.sock but it seems i did that in the wrong place.
what do you do after booting? how do you login to mysql cli? (yesterday i logged in but it was late in the day and i forgot what i tried)
-
...
I used mariadb for a month or two, but I was an Oracle DBA for many years and I soon realized mariadb was to databases what windows is to operating systems. I switched to Postgresql and things just started working like they should, like when I switched to Linux (in the mid '90s).
I maintain the PHP, Apache, and Nginx extensions also, and I test them against mariadb, Postgresql, MS SQL Server, and Oracle on both 32 and 64 bit.
speaking of Oracle:
https://developers.slashdot.org/story/22/06/13/0231250/is-oracles-database-dominance-being-eroded-by-cloud-first-rivals
snippet/quote from slashdot story:
"The entire profit of the company comes from Oracle database maintenance," he said. With each contract negotiation, "you go from paying $20 million a year, to $30 million a year, to paying $50 million a year."
-
What you get with Oracle is support that nobody else matches, so it makes sense that they get their money from maintenance. The database software doesn't have an install or runtime license. if you ever need to call tech support a human answers when the phone rings and you get routed to a person who can answer questions and solve your problem without a script. Turnaround for bug fixes is a few days. The documentation is excellent. Sure, it's always possible to go with someone else to save money, as long as you're OK with getting what you pay for.
-
How ORACLE comes in a MariaDB topic especially as an argument to use another DB or referring to WINDOWS? Do not understand :(
-
re: databases
hat-tip slashdot:
https://developers.slashdot.org/story/22/07/04/1858241/sqlite-or-postgresql-its-complicated
twilio:
https://www.twilio.com/blog/sqlite-postgresql-complicated
sharing is caring