OPENSUSE-MYSQL INSTALLATION PROBLEMS

English Install/Boot/Login
#1

I’m kind of new to LINUX and after a little research and problems with Ubuntu, I decided to use OPENSUSE where I find updated applications, easily accessable by YAST.

My problem is in the installation / configuration of MySQL and FIREBIRD ( plan to have the 2 for SQL studies , etc.) .

MYSQL PROBLEMS

In terminal

SU
PASSWORD

(like root)

ZYPPER IN MYSQL-COMMUNITY-SERVER MYSQL-COMMUNITY-SERVER-CLIENT

RCMYSQL START

RCMYSQL STATUS

mysql.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled)
Active: active (running) since Wed 2015-06-17 17:28:25 BRT; 5s ago
Process: 7902 ExecStart=/usr/lib/mysql/rcmysql start (code=exited, status=0/SUCCESS)
Main PID: 8020 (mysqld_safe)
CGroup: /system.slice/mysql.service
├─8020 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --datadir=/var/lib/mysql
└─8212 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/linux-uifl.err --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock

Jun 17 17:28:24 linux-uifl rcmysql[7902]: Support MySQL by buying support/licenses at http://shop.mysql.com
Jun 17 17:28:24 linux-uifl rcmysql[7902]: New default config file was created as /usr/my.cnf and
Jun 17 17:28:24 linux-uifl rcmysql[7902]: will be used by default by the server when you start it.
Jun 17 17:28:24 linux-uifl rcmysql[7902]: You may edit this file to change server settings
Jun 17 17:28:24 linux-uifl rcmysql[7902]: WARNING: Default config file /etc/my.cnf exists on the system
Jun 17 17:28:24 linux-uifl rcmysql[7902]: This file will be read by default by the MySQL server
Jun 17 17:28:24 linux-uifl rcmysql[7902]: If you do not want to use this, either remove it, or use the
Jun 17 17:28:24 linux-uifl rcmysql[7902]: --defaults-file argument to mysqld_safe when starting the server
Jun 17 17:28:25 linux-uifl rcmysql[7902]: Starting service MySQL /usr/lib/mysql/rcmysql: line 40: test: -eq: unary operator expected
Jun 17 17:28:25 linux-uifl rcmysql[7902]: Something went wrong

/USR/BIN/MYSQL_SECURE_INSTALLATION

ROOT PASSWORD = ok
ANONYMOUS UERS = withdrawn
ROOT LOGIN REMOTELY = withdrawn
TEST DB = withdrawn
TABLE PREVILEGES = reloaded

RCMYSQL STATUS

mysql.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled)
Active: active (running) since Wed 2015-06-17 17:28:25 BRT; 4min 7s ago
Process: 7902 ExecStart=/usr/lib/mysql/rcmysql start (code=exited, status=0/SUCCESS)
Main PID: 8020 (mysqld_safe)
CGroup: /system.slice/mysql.service
├─8020 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --datadir=/var/lib/mysql
└─8212 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/linux-uifl.err --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock

Jun 17 17:28:24 linux-uifl rcmysql[7902]: Support MySQL by buying support/licenses at http://shop.mysql.com
Jun 17 17:28:24 linux-uifl rcmysql[7902]: New default config file was created as /usr/my.cnf and
Jun 17 17:28:24 linux-uifl rcmysql[7902]: will be used by default by the server when you start it.
Jun 17 17:28:24 linux-uifl rcmysql[7902]: You may edit this file to change server settings
Jun 17 17:28:24 linux-uifl rcmysql[7902]: WARNING: Default config file /etc/my.cnf exists on the system
Jun 17 17:28:24 linux-uifl rcmysql[7902]: This file will be read by default by the MySQL server
Jun 17 17:28:24 linux-uifl rcmysql[7902]: If you do not want to use this, either remove it, or use the
Jun 17 17:28:24 linux-uifl rcmysql[7902]: --defaults-file argument to mysqld_safe when starting the server
Jun 17 17:28:25 linux-uifl rcmysql[7902]: Starting service MySQL /usr/lib/mysql/rcmysql: line 40: test: -eq: unary operator expected
Jun 17 17:28:25 linux-uifl rcmysql[7902]: Something went wrong

Opening such a file in a text editor I have the following (L = line and number thereof):

L35 rc_check ()
L36 {
L37 _rc_status_ret=$?
L38 test “_rc_status_ret” || _rc_status_ret=0
L39 test $_rc_status_ret -eq 0 || _rc_status=$_rc_status_ret
L40 test $_rc_status -eq 0 || _rc_status_all=$_rc_status
L41 return 0$_rc_status_ret
L42 }

I 'm kind of new to LINUX and after a little research and problems with Ubuntu , I decided to use OPENSUSE where I find updated applications , easily accessable by YAST .

My problem is in the installation / configuration of MySQL and FIREBIRD ( plan to have the 2 for SQL studies , etc.) .

Opening such a file in a text editor I have the following (L = line and number thereof) :

In short , I’m no access to the database and the most annoying is that the same installation process worked in OPENSUSE 13.1 (but forgot the version of MySQL that was installed).

Does anyone know how to edit the file and where for the unary missing or how to change it to make it work somehow ?

PS : my OPT paste this 100 % empty if requesting viewing any file from there.

English version by Google.

#2

This wouldn’t really have been necessary.
MariaDB (a drop-in replacement for MySQL by the original author) should be installed by default anyway I think.
But ok, you now have MySQL installed.

RCMYSQL START

This starts the MySQL server.

RCMYSQL STATUS

mysql.service - MySQL server
Loaded: loaded (/usr/lib/systemd/system/mysql.service; disabled)
Active: active (running) since Wed 2015-06-17 17:28:25 BRT; 5s ago
Process: 7902 ExecStart=/usr/lib/mysql/rcmysql start (code=exited, status=0/SUCCESS)
Main PID: 8020 (mysqld_safe)
CGroup: /system.slice/mysql.service
├─8020 /bin/sh /usr/bin/mysqld_safe --mysqld=mysqld --user=mysql --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock --datadir=/var/lib/mysql
└─8212 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/linux-uifl.err --pid-file=/var/run/mysql/mysqld.pid --socket=/var/run/mysql/mysql.sock

Jun 17 17:28:24 linux-uifl rcmysql[7902]: Support MySQL by buying support/licenses at http://shop.mysql.com
Jun 17 17:28:24 linux-uifl rcmysql[7902]: New default config file was created as /usr/my.cnf and
Jun 17 17:28:24 linux-uifl rcmysql[7902]: will be used by default by the server when you start it.
Jun 17 17:28:24 linux-uifl rcmysql[7902]: You may edit this file to change server settings
Jun 17 17:28:24 linux-uifl rcmysql[7902]: WARNING: Default config file /etc/my.cnf exists on the system
Jun 17 17:28:24 linux-uifl rcmysql[7902]: This file will be read by default by the MySQL server
Jun 17 17:28:24 linux-uifl rcmysql[7902]: If you do not want to use this, either remove it, or use the
Jun 17 17:28:24 linux-uifl rcmysql[7902]: --defaults-file argument to mysqld_safe when starting the server
Jun 17 17:28:25 linux-uifl rcmysql[7902]: Starting service MySQL /usr/lib/mysql/rcmysql: line 40: test: -eq: unary operator expected
Jun 17 17:28:25 linux-uifl rcmysql[7902]: Something went wrong

Everything’s fine there. The server is running and active.
If you are puzzled by that “Something went wrong” message, just ignore it. That’s a glitch in the start script, but mostly cosmetic.

If you want to have MySQL started automatically at boot, run “systemctl enable mysql” or enable it in YaST->System->Services Manager.

In short , I’m no access to the database

How did you try to access the database? According to the status output it should work.

#3

Hello and welcome to the openSUSE forums.

A few remarks though.

You posted this in a forum titled: “Looking for something other then support”. But to me it seems that you need support/help/assistance from your fellow openSUSE users.

I also see that you have two (2) different problems in one thread. That is not very efficient because you will get answers to one or both or the other question and in the end nobody, including you, will know anymore which reaction belongs to which problem.

And please do not use all capitals in your thread title. That is seen by many as shouting (which people do not like) and is often confusing also because Unix/Linux is case sensitive.

One of the first things people like to know is what software you use. Predominantly the version of openSUSE. So, please, never for get to mention that in your thread.

And there is one other thing, that you can not know when you post your first post here, but is very important to post things that are understandable: Can you please use CODE tags around copied/pasted computer text in a post. It is the # button in the tool bar of the post editor. When applicable copy/paste complete, that is including the prompt, the command, the output and the next prompt.

What I can do for you is move this thread to another forum, but it is not realy possible for me to split it and make two threads out of it. Thus it might be better to start two independent threads in Install/Boot/Login forum. Please post here if you are accepting this solution.

To all others: PLease do NOT post here, but wait for the threads apperaring. in the correct forum.

#4

There being now a reaction to the first part of this thread, it will be moved to Install/Boot/Login.
I will remove the second part of the first post. To the OP: please create a separate thread for it.

This is CLOSED for the moment.

#5

Move from Looking for somethong other then support and open again.

#6

I didn’t know that , I’ve read something in a post when I tried to find a solution but nothing specific about it = /

Start the program automatically is not really a problem at the moment, the problem is the access to the database when I use the command:

rcmysql -u root -p (old method of using the installation on 13.1)

Previously, I could connect to the program and create databases, tables, queries, now I get the following line in response.

Usage: rcmysql --help | --status-all | <service> <args>| --full-restart]]

After your answer I’ve tried to find the tutorial to review the connection process, but unfortunately I’ve lost it.

Endless excuses , I had some problems off the computer and posted the question with a short time, I promise to be more careful in the next posts, as well as improve my English and communication, I’m translating things using the Google translator for this time.

Unfortunately I did not find support or help in my native language for Open Suse - databases. 3 days 0 awsers.

And thanks very much for your support and patience.

Apologies > . <

#7

You are using the wrong command.
rcmysql ist for starting/stopping the server, not for accessing a database.
Try “mysql -u root -p” instead.

Or use something like mysql-workbench, which is included in the distribution. Just install it with YaST or zypper.

The server must work also because you were able to run mysql_secure_installation without error… :wink:

#8

Do you know when you fell like a dumbass? That’s me now. Sorry for open the post and tank you very much for all support, finally working with my databases now.

Its pretty good to know that I can find help and support in here anyway :slight_smile: