Not seeing submit logs in DB

[adier777]

Hi,
Have installed jasmin-submit-logs and is running(seen in jasmin-web-panel).
Problem: not seeing anything being written to submit_log table, when send SMS. Do see in jasmin log files.

Anything you can point to ?

jasmin_web_db=# select * from submit_log;
id | msgid | source_connector | routed_cid | source_addr | destination_addr | rate | pdu_count | short_message | binary_message | status | uid | trials | created_at
| status_at
(0 rows)

[adier777]

Actually found i need to activate the publish_submit_sm_resp in jasmin.cfg
Restarted and now see them in GUI -
thank you.

[dragelecpc]

Actually found i need to activate the publish_submit_sm_resp in jasmin.cfg Restarted and now see them in GUI - thank you.

Can you help me with this sir?

[rakibulinux]

Hi, @101t, @adier777, I have installed jamsin gui and submit log but not able to see the log. I try with edit value of publish_submit_sm_resp in jasmin.cfg and make it True also restart hole service but still no luck. Can you please let me know how to do it?

[101t]

You should ensure sms_submit_log up and running and connecting to rabbitmq which works with jasmin gateway.

[rakibulinux]

Once I send sms I get like this.

You should ensure sms_submit_log up and running and connecting to rabbitmq which works with jasmin gateway.

Hi, can you please take a look at this file? I am use same server for jasmin_web_panel and sms_submit_log. In this server, I have installed rabbitmq. I didn't do any configuration for rabbitmq just installed it and used it. Please let me know if I did anything wrong.

This is my .env file for submi_log

JASMIN_DB_NAME=jasmin_web_db
JASMIN_DB_USER=postgres
JASMIN_DB_PASS=123
JASMIN_DB_PORT=5432
JASMIN_DB_HOST=127.0.0.1
JASMIN_DB_OPTIONS=-c "client_min_messages=WARNING" -c "search_path=jasmin" -c "varchar=50"

AMQ_HOST=127.0.0.1
AMQ_PORT=5672
AMQ_VHOST=/
AMQ_USERNAME=guest
AMQ_PASSWORD=guest
AMQ_SPEC_FILE=/etc/jasmin/resource/amqp0-9-1.xml