Installation of Zabbix in Centos 7
-
I verified there by using this command
cd /usr/share/doc/zabbix-server-mysql-2.4.5/create/
ls
there are three files in it -
@Lakshmana said:
I verified there by using this command
cd /usr/share/doc/zabbix-server-mysql-2.4.5/create/
ls
there are three files in itThat's odd since that cd command does not work on that box. The directory is not there.
-
I verified this link and they have provided link for the soluton in it
https://www.zabbix.com/forum/showthread.php?t=48111
After seeing this i have done and the error comes is given below
lakshmana@dny-lnx-zabbix create]$ sudo mysql -uroot zabbix < schema.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) -
@Lakshmana said:
I verified this link and they have provided link for the soluton in it
The solution, I assume, was to use the correct version path, 2.4.6.
-
@Lakshmana said:
lakshmana@dny-lnx-zabbix create]$ sudo mysql -uroot zabbix < schema.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)You need to add the password since you set one earlier. Add a -p and the password and it should work fine.
-
How to login my SQL to check whether it is logging properly?
-
@Lakshmana said:
How to login my SQL to check whether it is logging properly?
Just use the command..
mysql -u root -p password
Where "password" is the actual password. Keep in mind that SQL is a language, you can't log into it. MariaDB is a relational database management system. So you can log into MariaDB and talk to it using the SQL language, but you can't log into a language.
-
when I used the above command i can login to the MariaDB but when i use the command to import the template the same error coming in the terminal
-
@Lakshmana said:
when I used the above command i can login to the MariaDB but when i use the command to import the template the same error coming in the terminal
Please provide the complete command.
-
And error too, of course.
-
Command properly done:
[lakshmana@dny-lnx-zabbix ~]$ mysql -u root -ppass
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 54
Server version: 5.5.44-MariaDB MariaDB ServerCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
Error while the command used like this
[lakshmana@dny-lnx-zabbix ~]$ mysql -u root -p pass
Enter password:
ERROR 1049 (42000): Unknown database 'pass'Error in the importing process:
[lakshmana@dny-lnx-zabbix ~]$ mysql -u zabbixuser -ppass < /usr/share/doc/zabbix-server-mysql-2.4.5/create/schema.sql
-bash: /usr/share/doc/zabbix-server-mysql-2.4.5/create/schema.sql: No such file or directory -
You are missing the database name in the command. It doesn't know where to run the SQL commands.
-
How to change the password for the zabbix user by the Maria DB
-
@Lakshmana said:
How to change the password for the zabbix user by the Maria DB
-
I have checked the details of the database and also teh username in mysql by the following command
[lakshmana@dny-lnx-zabbix ~]$ mysql -uroot -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 76
Server version: 5.5.44-MariaDB MariaDB ServerCopyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> select User from mysql.user;
+------------+
| User |
+------------+
| root |
| root |
| root |
| zabbixuser |
+------------+
4 rows in set (0.00 sec)I have also changed the password the of the zabbixuser and tried to import the template the same error as shown above that is the errror is shown as
-bash: /usr/share/doc/zabbix-server-mysql-2.4.5/create/schema.sql: No such file or directory -
@Lakshmana said:
I have also changed the password the of the zabbixuser and tried to import the template the same error as shown above that is the errror is shown as
-bash: /usr/share/doc/zabbix-server-mysql-2.4.5/create/schema.sql: No such file or directoryThese two things are not related. The user that you are using to import is root, not zabbix. The reason that the file does not exist is because it simply does not exist as we proved earlier.
The error is very explicit and obvious. The error tells you that the file does not exist. This should not have made you change a password.
-
I can access both root and user from the terminal.
MariaDB is able to login from the terminal -
@Lakshmana said:
I can access both root and user from the terminal.
MariaDB is able to login from the terminalSure, access isn't an issue. The only issue I see is that you are trying to use a file that does not exist. Check the path, your path has a typo.
-
I can see the files here in the path also
There are three files which can be accessed from the nano or vi editor[lakshmana@dny-lnx-zabbix create]$ cd /usr/share/doc/zabbix-server-mysql-2.4.6/create/
[lakshmana@dny-lnx-zabbix create]$ ls
data.sql images.sql schema.sql
[lakshmana@dny-lnx-zabbix create]$ -
@Lakshmana said:
I can see the files here in the path also
There are three files which can be accessed from the nano or vi editor[lakshmana@dny-lnx-zabbix create]$ cd /usr/share/doc/zabbix-server-mysql-2.4.6/create/
[lakshmana@dny-lnx-zabbix create]$ ls
data.sql images.sql schema.sql
[lakshmana@dny-lnx-zabbix create]$That's a different path than the one you used in the command! Use tab completion in your commands to help you get the paths correct.