do_update_event() cron hook fails

  • Resolved kaizushi

    (@kaizushi)


    5 years, 4 months ago

    The latest version of this extension seems to now use cron which is pretty cool. The thing is cron appears to work on my server, I tested if I can reach cryptocompare from a shell on the webserver, but the table in the MySQL database for rates monero_gateway_live_rates() puts nothing in the database for some reason. This has broke my customers site which is kind of sad really, and it needs to be fixed.

    I noticed there is no $wpdb->commit() after the INSERT query but adding it hasn’t done a damn thing. Please fix this, I can’t figure out what is wrong. I am only a novice PHP programmer with limited experience. At present the extension is clearly broken…

    SELECT * FROM wp_monero_gateway_live_rates
    MySQL returned an empty result set (i.e. zero rows). (Query took 0.0005 seconds.)

    The cron hook is there but this function do_update_event() is plainly broken when it comes to updating the exchange rates.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author SerHack

    (@serhack)

    Hi,

    The function do_update_event() is using cURL to fetch updates from https://min-api.cryptocompare.com/data/price. May you check if the firewall blocks the website? Do you have cURL enabled? What version of php do you have?

    In my web server, hosted on monerointegrations.com, it seems it didn’t have any problems. But I’ll recheck for sure.

    Let me know,
    SerHack

    Thread Starter kaizushi

    (@kaizushi)

    Curl is enabled, I copypasted your price fetch to make it run on the CLI. PHP can get the data fine through curl. The prices are not being committed the datanase. I manually ran the hook for curl with the Dashboard for it. It didn’t do anything either, and there are no errors displayed. The problem remains elusive.

    Plugin Author SerHack

    (@serhack)

    Any updates? May you retry with 3.0.2?

    Thread Starter kaizushi

    (@kaizushi)

    I fixed it, it was my fault all along, sorry for wasting your time. SELinux was preventing PHP from reading the ca-certificates in /etc and this meant SSL verification didn’t work, and monerowp couldn’t connect to the third party services it uses.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘do_update_event() cron hook fails’ is closed to new replies.