AW: AW: [cobalt-users] Problems with cronjob

["Axel Denk" <cobaltlist@xxxxxxxx>]

Hello,

I changed the cronjob like you said to the full path. Unfortunately it
is still not working. The cronjob looks like that:

/etc/cron.daily/test.cron -u test -p test < /etc/cron.daily/test.sql

The error I get is that:

/etc/cron.daily/heissnerinfo.sql: connect: command not found
/etc/cron.daily/heissnerinfo.sql: DELETE: command not found
/etc/cron.daily/heissnerinfo.sql: LOAD: command not found

Someone has any other advice?

Thanks and best regards,

Axel

-----Ursprüngliche Nachricht-----
Von: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] Im Auftrag von Axel Denk
Gesendet: Sonntag, 21. April 2002 23:10
An: cobalt-users@xxxxxxxxxxxxxxx
Betreff: AW: AW: [cobalt-users] Problems with cronjob

Hi Brent!

Thank you very much vor your help, I will do as you tell me. It is a
good idea to move the password in the user home.

Take care and thanks again

Axel

-----Ursprüngliche Nachricht-----
Von: cobalt-users-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-users-admin@xxxxxxxxxxxxxxx] Im Auftrag von Brent Sims
Gesendet: Sonntag, 21. April 2002 22:32
An: cobalt-users@xxxxxxxxxxxxxxx
Betreff: Re: AW: [cobalt-users] Problems with cronjob

On Sun, 21 Apr 2002, Axel Denk wrote:

} Does anyone have another tip, please? I really need the cronjob to be
} running.

Script it, using the full Unix path to each and every item, ie:

#!/bin/sh
/path/to/mysql -u test -pPassword < /path/to/include/file.sql

	After the script does what you want chmod 700 <script name>
so you have some lttle bit of security then run the script from
cron. I donno if this is more secure or not but you can avoid
putting the password in the script if you create a file, in the
user's home directory, named:

	.my.cnf

	Which contains the following:

	[client]
	password = PassWord

	chmod 600 on .my.cnf then that user will be able to login to
mysql via: mysql -u UserName (no password required).

	Peace be with you,

	Brent Sims
	WebOkay Internet Services, LLC
	http://www.WebOkay.net
	mailto: Brent@xxxxxxxxxxx
	(719) 595-1427 (Voice/Fax)



_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users



_______________________________________________
cobalt-users mailing list
cobalt-users@xxxxxxxxxxxxxxx
To Subscribe or Unsubscribe, please go to:
http://list.cobalt.com/mailman/listinfo/cobalt-users