Groups | Search | Server Info | Login | Register
Groups > comp.databases.mysql > #7681
| From | "J.O. Aho" <user@example.net> |
|---|---|
| Newsgroups | comp.databases.mysql |
| Subject | Re: From bash script (Debian Bookworm) login and query to MariaDB |
| Date | 2023-11-05 12:56 +0100 |
| Message-ID | <kqpe7cF4dqaU1@mid.individual.net> (permalink) |
| References | (5 earlier) <ui30rp$2qj1q$1@dont-email.me> <ui3834$2rqcr$1@dont-email.me> <ui505g$39s7l$1@dont-email.me> <kqmg25Ftbq5U3@mid.individual.net> <ui7qe2$3uuvf$1@dont-email.me> |
On 05/11/2023 11:23, ^Bart wrote:
>> Did you look at the mail from crontab? by default it goes to the
>> localhost root user (you can change that with setting the MAILTO
>> variable), if something wen t wrong while running the mysql command it
>> will be in that mail (if no output, no mail).
>>
>> You could check your /var/log/mysql/mysql.{err,log} too
>>
>> I hope the "-u MY_USER" was a typo, otherwise loose the space after '-u'.
>
> I found this solutions:
>
> */5 * * * * /home/itoffice/job01.sh
>
> This is job01.sh
>
> #!/bin/bash
> #sostituisce tutte le virgole presenti nel file con dei punti
> sed -i -e 's/,/./gip' /home/itoffice/data_bridge/articoli.txt
Yes, the root will not have the same LANG settings as your user and
those you need to change the comma to full stop for decimal values.
You could have added the same LANG/LC to the cron and this hadn't been a
issue.
> But now I need to do other things in my company so... I know it's a
> dirty way to use a *.sh file but I dont't have free time to fix it maybe
> next weeks... ;)
Tend to become one of those things that will be never fixed and next
time another ad-hoc solution is used to fix next issue.
--
//Aho
Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar
From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-10-31 16:42 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB The Natural Philosopher <tnp@invalid.invalid> - 2023-10-31 20:00 +0000
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 09:39 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 11:46 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-02 12:22 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 15:07 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-02 15:57 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB Jerry Stuckle <stuckle.jerry@gmail.com> - 2023-11-02 12:06 -0400
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-03 15:42 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB The Natural Philosopher <tnp@invalid.invalid> - 2023-11-03 16:45 +0000
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <none@none.it> - 2023-11-04 09:42 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-04 10:09 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB Jerry Stuckle <stuckle.jerry@gmail.com> - 2023-11-04 12:56 -0400
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-05 11:23 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-05 12:56 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB Marco Moock <mm+usenet-es@dorfdsl.de> - 2023-10-31 21:01 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 09:40 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB Jerry Stuckle <stuckle.jerry@gmail.com> - 2023-10-31 19:06 -0400
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 09:50 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-02 12:03 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB "J.O. Aho" <user@example.net> - 2023-11-01 08:04 +0100
Re: From bash script (Debian Bookworm) login and query to MariaDB ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-02 10:09 +0100
csiph-web