Find Jobs
Hire Freelancers

linux script which will query mysql db, call a command with parameters, update db based on results

$30-250 USD

Stengt
Lagt ut over 5 år siden

$30-250 USD

Betalt ved levering
alter table [login to view URL] if the following cols dont exist add z_rech_code string 10 chars z_suc_msg string 100 chars z_min number like 999999.32 z_warn integer 2 dig default 1 Z_tries integer 2 digit default 0 z_last_topup_date date z_last_topup_run date default is create date z_enabled 0 or 1 z_ussd_1 string up to 100 dig z_ussd_1_return string up to 100 z_ussd_2 string up to 100 Z_ussd_2_return string up to 100 z_rech_notes string up to 200 select ip,channel,sim from [login to view URL] where balance_date > 10 min ago and balance < z_min and z_warn > z_tries you will receive values like [login to view URL] 5 1 [login to view URL] 5 5 [login to view URL] 4 1 etc for each entry received issue php /var/www/html/gateway/[login to view URL] --ussd --gw [IP] --ports [channel].[sim] --ussd-code [z_rech_code][card]# mark z_tries=z_tries+1 card we get by doing select card from goip.recharge_card where used='0' order by rand() limit 1; wait up to 3 minutes for a reply and write that reply to z_rech_notes if any part of the reply has a string that matches z_suc_msg - update recharge card and set its used='1' if you received a reply but the string does not match update recharge and set its used=2 if you recevied no reply, do not update used after 3 min wait check if there are entries in z_ussd_1 and z_ussd_2 entries can be like z_ussd_1 = *223#,*111#,#545* z_ussd_2 = '*4545#, *554# if entries are present issue them like php /var/www/html/gateway/[login to view URL] --ussd --gw [IP] --ports [channel].[sim] --ussd-code [value] php /var/www/html/gateway/[login to view URL] --ussd --gw [IP] --ports [channel].[sim] --ussd-code [value2] php /var/www/html/gateway/[login to view URL] --ussd --gw [IP] --ports [channel].[sim] --ussd-code [value3] etc each comma indicates a new value, in example above z_ussd_1 has 3 values and z_ussd_2 has 2 values Wait 30 seconds after you issue and if you get a reply, write this in z_ussd_[X]_return entries who have unique channels may be processed simultaneously Expect that the entire project will require 50% more work than stated here. Just in case i forgot anything. Sample script can be seen at [login to view URL]
Prosjekt-ID: 18313311

Om prosjektet

14 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
14 freelancers are bidding on average $202 USD for this job
Brukeravatar
Hello! I can help you to develop a Linux script according to your requirements. As for me I'm a professional system admin with 10+ years of experience. Check my reviews. Recently I've successfully completed several projects where created various bash and shell scripts. See references below: - script that can automatically install LAMP on Linux servers https://www.freelancer.com/projects/linux/Bash-script-setup-LAMP-stack/ - script that automatically creates proxy servers https://www.freelancer.com/projects/linux/Detailed-Guide-setup-proxies-IPv/ https://www.freelancer.com/projects/php/Squid-Proxy-Script-Multiple-with/ https://www.freelancer.com/projects/linux/Guide-Script-making-rotating-web/ https://www.freelancer.com/projects/linux/Proxy-script-with-luminati/ I'm a real expert on this. I can help you too. Let's discuss the details in private chat. Feel free to contact me.
$188 USD om 3 dager
4,8 (97 omtaler)
7,5
7,5
Brukeravatar
Hi ! I'm interested in your project. You need to query mysql and run specific actions on result. I can achieve this in the language you need. I work in Linux world for 20 years and can do this with shell / php, or replace shell by perl as you want (I'm a CPAN author / tester and I'm part of AUTHORS of Perl). Ping me for any question. Have a good day.
$222 USD om 3 dager
5,0 (66 omtaler)
6,9
6,9
Brukeravatar
Hey I'm a System Engineer with coding skills. I had coded tons of scripts for Linux environments. I have the required skills and experience in SQL, Shell scripting. I can help. Regards.
$250 USD om 3 dager
5,0 (44 omtaler)
5,7
5,7
Brukeravatar
Hello, I can write the below script in linux and i can run it with cron or manually as you want. Please let me know if you need anything. Waiting for your reply. Thank you
$155 USD om 3 dager
4,8 (48 omtaler)
5,7
5,7
Brukeravatar
Hello sir. Hope you are doing well. I have enough experience in linux shell and mysql. I can do it perfectly. Thanks regards.
$250 USD om 3 dager
5,0 (2 omtaler)
4,7
4,7
Brukeravatar
Hi I am an devops engineer experienced shell scripting, python scripting and PHP for more than 4 years. I am also experienced in using scrpting languages to query mysql database and automate processes. I can do this for you. Please message to discuss further on this. Thanks Note-please check my profile for past project and reviews.
$211 USD om 4 dager
5,0 (17 omtaler)
4,5
4,5
Brukeravatar
Hello This is an interesting project. I am working im PHP MySQL for many years. Can we directly talk on this requirement? Thanks
$180 USD om 3 dager
5,0 (10 omtaler)
4,0
4,0
Brukeravatar
Hi, I experienced on PHP, MYSQL and also Linux shell script. For your project description, I think I can combine it. I can create the script, I need the sample database And since I just finish on my last project, so I can start your project today.
$160 USD om 1 dag
5,0 (11 omtaler)
3,5
3,5
Brukeravatar
Hello. Not one year already working with databases and linux scripting. Can done this task without some big issues.
$170 USD om 5 dager
5,0 (3 omtaler)
2,8
2,8
Brukeravatar
Hi! I am IT expert and I have a lot of experience in creating scripts for linux. I used to develop scripts with bash, python, php, perl. I'll be glad to help you! Thank you!
$100 USD om 1 dag
5,0 (4 omtaler)
2,5
2,5
Brukeravatar
Hi i am interested for this project and i have good enough skills on writing shell script and accessing mysql database. Please have a look on my previous projects and let me know your interest. Thank you!
$100 USD om 3 dager
3,6 (4 omtaler)
2,9
2,9
Brukeravatar
I am confident I am the right candidate for this project as I have done many similar projects in the past. With years of experience in this field, I believe this project will be very easy for me.
$367 USD om 10 dager
5,0 (1 omtale)
2,2
2,2
Brukeravatar
Dear Sir, I like solving complicated problems and making the things easier for the other people. In order to achieve this, I have more than 18 years of experience as a IT professional. I have an extraordinary ability and motivation not to give when the situation becomes difficult. On the opposite, I become one with the situation and I find solutions where most of other professionals are holding themselves back. Please contact me for more details in order to discuss the way to move forward. Kind Regards Nikolaos
$250 USD om 7 dager
3,1 (2 omtaler)
2,7
2,7
Brukeravatar
Hello Client, Hope you are doing good. I am having 6 years of IT experience and currently on Christmas Vacation and looking forward to do some extra work. As mentioned earlier about my IT experience, I have been writing Shell and Batch Scripting for the leading MNC of the world. Looking upon my experience, I think I am the best possible match for this position. Please let me know if you would like to avail my services.
$222 USD om 2 dager
0,0 (0 omtaler)
0,0
0,0

Om klienten

UNITED STATESs flagg
dix hills, United States
5,0
140
Betalingsmetode bekreftet
Medlem siden aug. 24, 2006

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.