Problem with creating database schema

[dakkonz]

hi guys,
can anyone help me?
I trying to insert the database schema and the intial data values into the database....

from the manual i am suppose to run
cat schema.sql \mysql -u <username> -p <password> zabbix

for my case... once logged in as my user acct
I run
cat zabbix-1.0/create/mysql/schema.sql /usr/local/mysql/bin/mysql -u <username> zabbix

But the schema does not get into the databases

I have already granted all privileges to Mysql username and there is no password for Mysql login
The way i connect to mysql is 1) once logged in I will key
cd /usr/local/mysql/bin
then i will type
./mysql -u <username>
to enter to sql....

Think there is something wrong with my path for sql connection... can anyone help me solve this???

Thanks

[krusty]

Hi, do something like that:

cat zabbix-1.0/create/mysql/schema.sql |mysql -u <username> zabbix

or if you have set password

cat zabbix-1.0/create/mysql/schema.sql |mysql -u <username> -p<password> zabbix

This works fine.

Greez

[dakkonz]

Erm it still cant work.
I got the error
-bash: mysql: command not found

[krusty]

enter the console the following command

which mysql

now you know the path to mysql.

What happens if you type into the console mysql -u <user> -p <password> zabbix
Can you enter mysql?

[krusty]

which distribution or better which os you use?

[dakkonz]

[weekiat@samba ~]$ which mysql
/usr/bin/which: no mysql in (/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/weekiat/bin)

this is wat i got from keying in which mysql

[krusty]

[weekiat@samba ~]$ which mysql
/usr/bin/which: no mysql in (/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/weekiat/bin)

this is wat i got from keying in which mysql

ok, i think your installation of mysql was wrong. do you install mysql with os? If you install mysql after os do you use rpm or src Code for installation? Which os do you use?
Maybe you can link mysql manual. Let me look.

[Landstalker]

mysql is not in your path so you can't just execute it.

do find -name mysql and it should present you with where its installed to. Probably something like /usr/local/bin/ or something like that.

Then where it says |mysql in the above command, just insert the full location just after the pipe ( | ).

Try that.

[krusty]

cat zabbix-1.0/create/mysql/schema.sql |/usr/local/mysql/bin/mysql -u <username> zabbix

ok, maybe this works

try it

[dakkonz]

hmm tried it... but it seems not all tables are created...
only slightly more than half.....shall go and check what is wrong with the MYSQL code at that point

Thanks a lot guys.....
Great Help

[krusty]

you should have 42 tables in zabbix database.

[dakkonz]

hmmm i only got the following in the database
| actions |
| alarms |
| alerts |
| config |
| functions |
| graphs |
| graphs_items |
| groups |
| history |
| history_str |
| hosts |
| hosts_groups |
| items |
| media |
| media_type |
| services |
| services_links |
| sessions |
| sysmaps |
| sysmaps_hosts |
| sysmaps_links |
| trigger_depends |
| triggers |
| users |

and i have counted the tables in the schema.sql it only adds up to 33 tables
I am using the zabbix-1.0 stable version

[dakkonz]

I manage to create the database already... but it only contains 33 tables.
There appears to be a problem in the schema.sql file
CREATE TABLE rights (
rightid int(4) NOT NULL auto_increment,
userid int(4) DEFAULT '0' NOT NULL,
name char(255) DEFAULT '' NOT NULL,
permission char(1) DEFAULT '' NOT NULL,
id int(4),
PRIMARY KEY (rightid)
) type=InnoDB;

I added in the 0 for the userid default value and my schema.sql gets added in into mysql without any error.

[dakkonz]

I have proceeded in the installation till run server process
but i got an error when trying to run suckerd and trapperd

./zabbix_suckerd: error while loading shared libraries: libmysqlclient.so.15: cannot open shared object file: No such file or directory

can anyone guide me how to solve this?
Thanks

[krusty]

I manage to create the database already... but it only contains 33 tables.
There appears to be a problem in the schema.sql file
CREATE TABLE rights (
rightid int(4) NOT NULL auto_increment,
userid int(4) DEFAULT '0' NOT NULL,
name char(255) DEFAULT '' NOT NULL,
permission char(1) DEFAULT '' NOT NULL,
id int(4),
PRIMARY KEY (rightid)
) type=InnoDB;

I added in the 0 for the userid default value and my schema.sql gets added in into mysql without any error.

Ok, I use the 1.1beta and I had 42 tables. Maybe the stable version has only 33 Tables. I don´t know. I never installed the stable version.