Raspberry Pi 4B unable to start installing MySQL

J

jymetin

Code: 
root@freebsd:/ # sysrc mysql_enable="yes"
mysql_enable:  -> yes
root@freebsd:/ # service mysql-server start
/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql
root@freebsd:/ #

freebsd.err
Code: 
240729 05:54:36 mysqld_safe Logging to '/var/db/mysql/freebsd.err'.
240729 05:54:36 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
/usr/local/libexec/mysqld: 1: Syntax error: ")" unexpected
/usr/local/libexec/mysqld: 1: Syntax error: Error in command substitution
240729 05:54:36 mysqld_safe mysqld from pid file /var/db/mysql/freebsd.pid ended

I tested FREEBSD13.4, MySQL 8.0, 8.1, and 5.6 using Raspberry Pi 4B and found that they all failed to start

Unable to locate the problem.
 
freebsd.err
Code: 
240729 05:54:36 mysqld_safe Logging to '/var/db/mysql/freebsd.err'.
240729 05:54:36 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
/usr/local/libexec/mysqld: 1: Syntax error: ")" unexpected
/usr/local/libexec/mysqld: 1: Syntax error: Error in command substitution
240729 05:54:36 mysqld_safe mysqld from pid file /var/db/mysql/freebsd.pid ended
 
SirDice said:
What else is in /etc/rc.conf?
Click to expand...
Code: 
hostname="freebsd"
ifconfig_DEFAULT="DHCP inet6 accept_rtadv"
sshd_enable="YES"
sendmail_enable="NONE"
sendmail_submit_enable="NO"
sendmail_outbound_enable="NO"
sendmail_msp_queue_enable="NO"
growfs_enable="YES"
powerd_enable="YES"
# Set dumpdev to "AUTO" to enable crash dumps, "NO" to disable
dumpdev="AUTO"
mysql_enable="yes"
 
Alright, thought there may have been a typo or missing quote that could cause such an error. But this looks ok.

Code: 
sendmail_enable="NONE"
sendmail_submit_enable="NO"
sendmail_outbound_enable="NO"
sendmail_msp_queue_enable="NO"
Not related to the error but sendmail_enable="NONE" sets all the others to NO, so you don't need to explicitly add those.

Code: 
case ${sendmail_enable} in
[Nn][Oo][Nn][Ee])
        sendmail_enable="NO"
        sendmail_submit_enable="NO"
        sendmail_outbound_enable="NO"
        sendmail_msp_queue_enable="NO"
        ;;
esac
 
SirDice said:
Alright, thought there may have been a typo or missing quote that could cause such an error. But this looks ok.

Code: 
sendmail_enable="NONE"
sendmail_submit_enable="NO"
sendmail_outbound_enable="NO"
sendmail_msp_queue_enable="NO"
Not related to the error but sendmail_enable="NONE" sets all the others to NO, so you don't need to explicitly add those.

Code: 
case ${sendmail_enable} in
[Nn][Oo][Nn][Ee])
        sendmail_enable="NO"
        sendmail_submit_enable="NO"
        sendmail_outbound_enable="NO"
        sendmail_msp_queue_enable="NO"
        ;;
esac
Click to expand...
May I ask if it is related to arm64 bit CPU? AMD64 is normal.
 
SirDice said:
Alright, thought there may have been a typo or missing quote that could cause such an error. But this looks ok.

Code: 
sendmail_enable="NONE"
sendmail_submit_enable="NO"
sendmail_outbound_enable="NO"
sendmail_msp_queue_enable="NO"
Not related to the error but sendmail_enable="NONE" sets all the others to NO, so you don't need to explicitly add those.

Code: 
case ${sendmail_enable} in
[Nn][Oo][Nn][Ee])
        sendmail_enable="NO"
        sendmail_submit_enable="NO"
        sendmail_outbound_enable="NO"
        sendmail_msp_queue_enable="NO"
        ;;
esac
Click to expand...
root@freebsd:~ # /usr/local/bin/mysql_install_db --user=mysql --basedir=/usr/local/ --datadir=/var/db/mysql &
[1] 2012

root@freebsd:~ # sh: /usr/local//bin/my_print_defaults: Exec format error


FATAL ERROR: Neither host 'freebsd' nor 'localhost' could be looked up with
/usr/local//bin/resolveip
Please configure the 'hostname' command to return a correct
hostname.
If you want to solve this at a later stage, restart this script
with the --force option

[1] Exit 1 /usr/local/bin/mysql_install_db --user=mysql --basedir=/usr/local/ --datadir=/var/db/mysql
 
I don't think the architecture has anything do with it.

I'm wondering about this message though:
Code: 
/usr/local/libexec/mysqld: 1: Syntax error: Error in command substitution

jymetin said:
MySQL 8.0, 8.1, and 5.6 using Raspberry Pi 4B
Click to expand...
You mentioned 5.6 here, how did you install MySQL 5.6? That port disappeared more than a year ago.
 
SirDice said:
I don't think the architecture has anything do with it.

I'm wondering about this message though:
Code: 
/usr/local/libexec/mysqld: 1: Syntax error: Error in command substitution


You mentioned 5.6 here, how did you install MySQL 5.6? That port disappeared more than a year ago.
Click to expand...
pkg
 
You must log in or register to reply here.
Back
Top