Asterisk CLI And Database Problem

Home » Asterisk Users » Asterisk CLI And Database Problem
Asterisk Users 2 Comments

Hello,

I have a problem related to the Asterisk CLI, when I enter “asterisk -rv”, it cannot display the Asterisk CLI and instaed, I have this message “Unable to connect to remote asterisk (does /var/run/asterisk.ctl exist?).”

When I check with “locate asterisk.ctl”, it is indeed in the repertory “/var/run/”.

So after searching I have found we can enter “ps -A | grep asterisk” in order to find an asterisk “ghost” running and then kill it, and I have found:

1474 ? 00:00:14 asterisk
1615 pts/3 00:00:13 asterisk
31411 ? 00:00:00 safe_asterisk
31414 ? 01:08:53 asterisk

I don’t know if it’s the case and which one of these I should kill?

Furthermore, I can access to the CLI with “asterisk -cv” but I often got the following warning : “db.c:288 db_execute_sql: Error executing SQL (COMMIT): database is locked”. Otherwise, is there another way to fix my problem?

Thank you in advance!

2 thoughts on - Asterisk CLI And Database Problem

  • I would suspect that you have installed Asterisk in such a fashion that a particular user or user with certain permissions is required to access the
    /var/run directory, as well as other directories Asterisk uses (such as where it stores the AstDB).

    You are then probably running the safe_asterisk script under a user without sufficient permissions, and/or running/invoking the Asterisk CLI (via
    “asterisk -rv”) as a user with insufficient permissions.

    I would double check:
    (1) What user/groups own the various Asterisk directories (specified in your asterisk.conf)
    (2) What user/group you are running the safe_asterisk script under
    (3) What user/group you are running as when you attempt to connect to Asterisk

  • SGVsbG8sDQoNCkFmdGVyIEnigJl2ZSBjaGVja2VkLCBpdCB3YXMgaW4gZmFjdCBteSBmaWxlc3lz dGVtIOKAnHZhcuKAnSBmdWxsIG9mIGlub2Rlc+KApg0KDQpUaGFuayB5b3Ugc28gbXVjaCBmb3Ig dHlpbmcgdG8gaGVscCBtZS4NCg0KSGF2ZSBhIG5pY2UgZGF5LA0KUmVnYXJkcywNCg0KUGllcnJl DQoNCg0KDQoNCg0KDQpEZSA6IGFzdGVyaXNrLXVzZXJzLWJvdW5jZXNAbGlzdHMuZGlnaXVtLmNv bSBbbWFpbHRvOmFzdGVyaXNrLXVzZXJzLWJvdW5jZXNAbGlzdHMuZGlnaXVtLmNvbV0gRGUgbGEg cGFydCBkZSBNYXR0aGV3IEpvcmRhbg0KRW52b3nDqSA6IG1hcmRpIDIyIGTDqWNlbWJyZSAyMDE1
    IDIzOjM4DQrDgCA6IEFzdGVyaXNrIFVzZXJzIE1haWxpbmcgTGlzdCAtIE5vbi1Db21tZXJjaWFs IERpc2N1c3Npb24NCk9iamV0IDogUmU6IFthc3Rlcmlzay11c2Vyc10gQXN0ZXJpc2sgQ0xJIGFu ZCBkYXRhYmFzZSBwcm9ibGVtDQoNCg0KDQpPbiBUdWUsIERlYyAyMiwgMjAxNSBhdCAzOjQ4IEFN
    LCA8cGllcnJlLmd1eWFyZEBvcmFuZ2UuY29tPG1haWx0bzpwaWVycmUuZ3V5YXJkQG9yYW5nZS5j b20+PiB3cm90ZToNCkhlbGxvLA0KDQpJIGhhdmUgYSBwcm9ibGVtIHJlbGF0ZWQgdG8gdGhlIEFz dGVyaXNrIENMSSwgd2hlbiBJIGVudGVyICJhc3RlcmlzayAtcnYiLCBpdCBjYW5ub3QgZGlzcGxh eSB0aGUgQXN0ZXJpc2sgQ0xJIGFuZCBpbnN0YWVkLCBJIGhhdmUgdGhpcyBtZXNzYWdlICJVbmFi bGUgdG8gY29ubmVjdCB0byByZW1vdGUgYXN0ZXJpc2sgKGRvZXMgL3Zhci9ydW4vYXN0ZXJpc2su Y3RsIGV4aXN0PykuIg0KDQpXaGVuIEkgY2hlY2sgd2l0aCAibG9jYXRlIGFzdGVyaXNrLmN0bCIs IGl0IGlzIGluZGVlZCBpbiB0aGUgcmVwZXJ0b3J5ICIvdmFyL3J1bi8iLg0KDQpTbyBhZnRlciBz ZWFyY2hpbmcgSSBoYXZlIGZvdW5kIHdlIGNhbiBlbnRlciAicHMgLUEgfCBncmVwIGFzdGVyaXNr IiBpbiBvcmRlciB0byBmaW5kIGFuIGFzdGVyaXNrICJnaG9zdCIgcnVubmluZyBhbmQgdGhlbiBr aWxsIGl0LCBhbmQgSSBoYXZlIGZvdW5kOg0KDQoxNDc0ID8gICAgICAgIDAwOjAwOjE0IGFzdGVy aXNrDQoxNjE1IHB0cy8zICAgIDAwOjAwOjEzIGFzdGVyaXNrDQozMTQxMSA/ICAgICAgICAwMDow MDowMCBzYWZlX2FzdGVyaXNrDQozMTQxNCA/ICAgICAgICAwMTowODo1MyBhc3Rlcmlzaw0KDQpJ
    IGRvbid0IGtub3cgaWYgaXQncyB0aGUgY2FzZSBhbmQgd2hpY2ggb25lIG9mIHRoZXNlIEkgc2hv dWxkIGtpbGw/DQoNCkZ1cnRoZXJtb3JlLCBJIGNhbiBhY2Nlc3MgdG8gdGhlIENMSSB3aXRoIOKA
    nGFzdGVyaXNrIOKAk2N24oCdIGJ1dCBJIG9mdGVuIGdvdCB0aGUgZm9sbG93aW5nIHdhcm5pbmcg OiDigJxkYi5jOjI4OCBkYl9leGVjdXRlX3NxbDogRXJyb3IgZXhlY3V0aW5nIFNRTCAoQ09NTUlU
    KTogZGF0YWJhc2UgaXMgbG9ja2Vk4oCdLg0KT3RoZXJ3aXNlLCBpcyB0aGVyZSBhbm90aGVyIHdh eSB0byBmaXggbXkgcHJvYmxlbT8NCg0KVGhhbmsgeW91IGluIGFkdmFuY2UhDQoNCkkgd291bGQg c3VzcGVjdCB0aGF0IHlvdSBoYXZlIGluc3RhbGxlZCBBc3RlcmlzayBpbiBzdWNoIGEgZmFzaGlv biB0aGF0IGEgcGFydGljdWxhciB1c2VyIG9yIHVzZXIgd2l0aCBjZXJ0YWluIHBlcm1pc3Npb25z IGlzIHJlcXVpcmVkIHRvIGFjY2VzcyB0aGUgL3Zhci9ydW4gZGlyZWN0b3J5LCBhcyB3ZWxsIGFz IG90aGVyIGRpcmVjdG9yaWVzIEFzdGVyaXNrIHVzZXMgKHN1Y2ggYXMgd2hlcmUgaXQgc3RvcmVz IHRoZSBBc3REQikuDQpZb3UgYXJlIHRoZW4gcHJvYmFibHkgcnVubmluZyB0aGUgc2FmZV9hc3Rl cmlzayBzY3JpcHQgdW5kZXIgYSB1c2VyIHdpdGhvdXQgc3VmZmljaWVudCBwZXJtaXNzaW9ucywg YW5kL29yIHJ1bm5pbmcvaW52b2tpbmcgdGhlIEFzdGVyaXNrIENMSSAodmlhICJhc3RlcmlzayAt cnYiKSBhcyBhIHVzZXIgd2l0aCBpbnN1ZmZpY2llbnQgcGVybWlzc2lvbnMuDQpJIHdvdWxkIGRv dWJsZSBjaGVjazoNCigxKSBXaGF0IHVzZXIvZ3JvdXBzIG93biB0aGUgdmFyaW91cyBBc3Rlcmlz ayBkaXJlY3RvcmllcyAoc3BlY2lmaWVkIGluIHlvdXIgYXN0ZXJpc2suY29uZikNCigyKSBXaGF0
    IHVzZXIvZ3JvdXAgeW91IGFyZSBydW5uaW5nIHRoZSBzYWZlX2FzdGVyaXNrIHNjcmlwdCB1bmRl cg0KKDMpIFdoYXQgdXNlci9ncm91cCB5b3UgYXJlIHJ1bm5pbmcgYXMgd2hlbiB5b3UgYXR0ZW1w dCB0byBjb25uZWN0IHRvIEFzdGVyaXNrDQoNCi0tDQpNYXR0aGV3IEpvcmRhbg0KRGlnaXVtLCBJ
    bmMuIHwgRGlyZWN0b3Igb2YgVGVjaG5vbG9neQ0KNDQ1IEphbiBEYXZpcyBEcml2ZSBOVyAtIEh1
    bnRzdmlsbGUsIEFMIDM1ODA2IC0gVVNBDQpDaGVjayB1cyBvdXQgYXQ6IGh0dHA6Ly9kaWdpdW0u Y29tICYgaHR0cDovL2FzdGVyaXNrLm9yZw0KCl9fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KCkNlIG1lc3NhZ2UgZXQgc2VzIHBp ZWNlcyBqb2ludGVzIHBldXZlbnQgY29udGVuaXIgZGVzIGluZm9ybWF0aW9ucyBjb25maWRlbnRp ZWxsZXMgb3UgcHJpdmlsZWdpZWVzIGV0IG5lIGRvaXZlbnQgZG9uYwpwYXMgZXRyZSBkaWZmdXNl cywgZXhwbG9pdGVzIG91IGNvcGllcyBzYW5zIGF1dG9yaXNhdGlvbi4gU2kgdm91cyBhdmV6IHJl Y3UgY2UgbWVzc2FnZSBwYXIgZXJyZXVyLCB2ZXVpbGxleiBsZSBzaWduYWxlcgphIGwnZXhwZWRp dGV1ciBldCBsZSBkZXRydWlyZSBhaW5zaSBxdWUgbGVzIHBpZWNlcyBqb2ludGVzLiBMZXMgbWVz c2FnZXMgZWxlY3Ryb25pcXVlcyBldGFudCBzdXNjZXB0aWJsZXMgZCdhbHRlcmF0aW9uLApPcmFu Z2UgZGVjbGluZSB0b3V0ZSByZXNwb25zYWJpbGl0ZSBzaSBjZSBtZXNzYWdlIGEgZXRlIGFsdGVy ZSwgZGVmb3JtZSBvdSBmYWxzaWZpZS4gTWVyY2kuCgpUaGlzIG1lc3NhZ2UgYW5kIGl0cyBhdHRh Y2htZW50cyBtYXkgY29udGFpbiBjb25maWRlbnRpYWwgb3IgcHJpdmlsZWdlZCBpbmZvcm1hdGlv biB0aGF0IG1heSBiZSBwcm90ZWN0ZWQgYnkgbGF3Owp0aGV5IHNob3VsZCBub3QgYmUgZGlzdHJp YnV0ZWQsIHVzZWQgb3IgY29waWVkIHdpdGhvdXQgYXV0aG9yaXNhdGlvbi4KSWYgeW91IGhhdmUg cmVjZWl2ZWQgdGhpcyBlbWFpbCBpbiBlcnJvciwgcGxlYXNlIG5vdGlmeSB0aGUgc2VuZGVyIGFu ZCBkZWxldGUgdGhpcyBtZXNzYWdlIGFuZCBpdHMgYXR0YWNobWVudHMuCkFzIGVtYWlscyBtYXkg YmUgYWx0ZXJlZCwgT3JhbmdlIGlzIG5vdCBsaWFibGUgZm9yIG1lc3NhZ2VzIHRoYXQgaGF2ZSBi ZWVuIG1vZGlmaWVkLCBjaGFuZ2VkIG9yIGZhbHNpZmllZC4KVGhhbmsgeW91LgoK