call menu greeting counter

[bramid]

I am setting up a new server from a 32 bit to a 64 bit machine . I manually copied every table over .
but My boss is concerned about the call menu recording which is going to reset to zero on the new machine I am talking about the 851XXXXX file number when you dial 8168 to record your greeting

how can I tweak that in the new machine , or how should I deal with this situation

[williamconley]

1) Welcome to the Party!

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method (7.X.X?) and vicidial version with build (VERSION: 2.X-XXXx ... BUILD: #####-####).

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "manual/from scratch" you must post your operating system with version (and the .iso version from which you installed your original operating system) plus a link to the installation instructions you used. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) You don't need to copy table by table. Mysqldump is not "32/64" bit dependent. Dump from one, load on the other, upgrade the DB if the code on the new server is more recent and voila! Instructions in /usr/src/astguiclient/trunk/UPGRADE

4) It's in a text file:

Code: Select all

cat /prompt_count.txt

[bramid]

Thank u

here is what I could gather
if something is missing (I am sure it is ) please let me know how to gather it
I mean the syntax to query it from CLI

Asterisk 13.21.1-vici, Copyright (C) 1999 - 2014, Digium, Inc.

grep "build = '" /srv/www/htdocs/vicidial/admin.php -n -R
4494:$build = '190329-1909';

dmidecode | grep Product
Product Name: Precision T1650
Product Name: 0C3YXR

I dont know how to get my configuration though

[bramid]

VERSION: 2.14-706a
BUILD: 190329-1909

[mflorell]

back in 2016 the recording prompt counter was moved into the database from being stored in a text file.

[bramid]

I want my counter to start from 85100135 and not 85100001 on the new machine , where can I set it

[mflorell]

It is stored in the database, you can see what it is currently set to by going to the Admin -> System Settings page and looking for "Recording Prompt Count" near the top(keep in mind this is the base counter, and you would need to add 85100000 to it to calculate what the last audio filename would be).

[bramid]

I can see that ..But there is no way for me to change it ....it shows a number and it is solid

[mflorell]

You can change it directly through MySQL command-line client.

[williamconley]

You can change it directly through MySQL command-line client.

or phpMyAdmin for those of us who are Lazy.

[bramid]

I really would appreciate it if u guys could be a little more precise to explain , how would I achieve that
as I am new to this platform . I mean steps that are involved plz

[williamconley]

Code: Select all

mysql -u cron -p1234 asterisk -e "update system_settings set rec_prompt_count='135'"

[bramid]

Phenomenon , Much appreciated William
It worked , I recorded a test and it gave me 85100136 that is exactly what I want
I am so happy ,after two weeks of rummaging through internet resources finally it worked
Again , thanx a million

[bramid]

I have another issue now ... when I go to Admin -> Phones I see all phones which I copied over from another server but when I click any phones to set some of their attribute there is nothing any where it is simply blank every where in any data point entry any idea why it is happening and how to resolve it ..plz

[williamconley]

which I copied over from another server ... which didn't have the same version. look at those records in the phones table of the asterisk database and compare them to the ones that were there originally for the difference.

if you pulled them all, and dumped the existing ones in favor of the ones you imported you have to go back or find the specific differences to that table in your version of vicidial.

you can not take a table from one vicidial VERSION and drop it into another server with a different VERSION of the DB structure.

if necessary, you CAN get the command that creates the phones table from your version and either make appropriate changes to this one or just start over with that one and this time when you import, delete the DROP TABLE command from the import sql file.

[bramid]

ok then, silly of me
so that means I have to build the machine again or is there a command to create the phone table only ...
if there is please instruct me like before u did with the command ....thnx

[williamconley]

in the /usr/src/astguiclient/trunk/extras folder MySQL_AST_CREATE_tables.sql and first_server_install.sql have the table and record creation commands. A little time with a text editor and you should be good to go.

Good luck to you, sir!

[bramid]

I really dont mean to be asking lots of questions but sql is not my strong point I found the MySQL_AST_CREATE_tables.sql
but I dont know how to use it to recreate the phone table

[williamconley]

find the command to create the phones table. use a text editor. then find the commands in the other file that populate the phones table. there's NOT a lot of mysql lines involved in this process.

OR you could start over. if this is your first install, starting over is a great idea. i recommend newbies install several times to get rid of that magic feeling. be comfortable with the process. learn.

[bramid]

I was able to run create table phone from MySQL_AST_CREATE_tables.sql
and used this
INSERT INTO phones (extension, dialplan_number, voicemail_id, phone_ip, computer_ip, server_ip, login, pass, status, active, phone_type, fullname, company, picture, messages, old_messages, protocol,template_id) values('gs102','102','102','10.10.10.16','10.10.9.16','10.10.10.15','gs102','test', 'ADMIN','Y','Grandstream BT 102','Test Admin Phone','TEST','','0','0','SIP','');
INSERT INTO phones (extension, dialplan_number, voicemail_id, phone_ip, computer_ip, server_ip, login, pass, status, active, phone_type, fullname, company, protocol,template_id) values('callin','8300','8300','10.10.10.15','10.10.10.15','10.10.10.15','callin','test', 'ACTIVE','Y','Dial-in agent phone','Dial-in Agent Phone','TEST','EXTERNAL','');

from the other file no luck yet
and I can not reinstall the vici on this particular machine this one is in our Florida office and I am in Canada

[williamconley]

if the first file had both the create command and the insert commands, that was all there was.

now run the import .sql file you used originally but edit it first to remove any drop or create functions and ONLY include the insert into lines. then the structure will remain and the new entries will be present AND you can compare the imported phones to these ones you just added to see if there's a difference (if they don't work, which they may work just fine at this point).

[bramid]

I am going to be doing it . however now when I go to phones to manually add a phone , the first initial creation prompt lets me add entries but when I hit submit
nothing gets created ... I am wondering why .

another Qs ... I am going to install a vici server as a virtual machine so if in the future anything goes wrong with it like this one ... I should be able to install a new one
do u think it is a good Idea or not ?

[williamconley]

I am going to be doing it . however now when I go to phones to manually add a phone , the first initial creation prompt lets me add entries but when I hit submit
nothing gets created ... I am wondering why .

that is what error message are for (literally). Do you GET an error message on the screen? Or a success message that is incorrect? Or (my personal favorite) are you trying to create a phone that already exists?

I am going to install a vici server as a virtual machine so if in the future anything goes wrong with it like this one ... I should be able to install a new one
do u think it is a good Idea or not ?

Virtual is ONLY viable for testing, development, or a single agent. Beyond that it will not be usable for production. Once Virtual Vicidial exceeds 3 or 4 simultaneous calls (including the agents in the meetme rooms ...) it becomes unstable quickly. But with one agent and 1 or 2 calls, it's marvelous (thus perfect for sandboxing/testing/development).

[bramid]

I decided not to import any user instead configure them manually , however when I check the sip-vicidial.conf file I can see the user is being created but on GUI all the entries are blank

[bramid]

I mean I created one phone as a test on GUI .. it gets created but when I go to tweak it further after creation all the entries are blank

[williamconley]

mismatch db schema vs code in scripts. start over ...

[bramid]

this is the third time I dropes the phones table , created it with the command in that MySQL_AST_CREATE_tables.sql and inserted from first_server_install.sql file
and rebooted the system .... no luck yet

[bramid]

this is the create table command that I am using

CREATE TABLE phones (
extension VARCHAR(100),
dialplan_number VARCHAR(20),
voicemail_id VARCHAR(10),
phone_ip VARCHAR(15),
computer_ip VARCHAR(15),
server_ip VARCHAR(15),
login VARCHAR(15),
pass VARCHAR(100),
status VARCHAR(10),
active ENUM('Y','N'),
phone_type VARCHAR(50),
fullname VARCHAR(50),
company VARCHAR(10),
picture VARCHAR(19),
messages INT(4),
old_messages INT(4),
protocol ENUM('SIP','Zap','IAX2','EXTERNAL') default 'SIP',
local_gmt VARCHAR(6) default '-5.00',
ASTmgrUSERNAME VARCHAR(20) default 'cron',
ASTmgrSECRET VARCHAR(20) default '1234',
login_user VARCHAR(20),
login_pass VARCHAR(100),
login_campaign VARCHAR(10),
park_on_extension VARCHAR(10) default '8301',
conf_on_extension VARCHAR(10) default '8302',
VICIDIAL_park_on_extension VARCHAR(10) default '8301',
VICIDIAL_park_on_filename VARCHAR(10) default 'park',
monitor_prefix VARCHAR(10) default '8612',
recording_exten VARCHAR(10) default '8309',
voicemail_exten VARCHAR(10) default '8501',
voicemail_dump_exten VARCHAR(20) default '85026666666666',
ext_context VARCHAR(20) default 'default',
dtmf_send_extension VARCHAR(100) default 'local/8500998@default',
call_out_number_group VARCHAR(100) default 'Zap/g2/',
client_browser VARCHAR(100) default '/usr/bin/mozilla',
install_directory VARCHAR(100) default '/usr/local/perl_TK',
local_web_callerID_URL VARCHAR(255) default 'http://astguiclient.sf.net/test_callerid_output.php',
VICIDIAL_web_URL VARCHAR(255) default 'http://astguiclient.sf.net/test_VICIDIAL_output.php',
AGI_call_logging_enabled ENUM('0','1') default '1',
user_switching_enabled ENUM('0','1') default '1',
conferencing_enabled ENUM('0','1') default '1',
admin_hangup_enabled ENUM('0','1') default '0',
admin_hijack_enabled ENUM('0','1') default '0',
admin_monitor_enabled ENUM('0','1') default '1',
call_parking_enabled ENUM('0','1') default '1',
updater_check_enabled ENUM('0','1') default '1',
AFLogging_enabled ENUM('0','1') default '1',
QUEUE_ACTION_enabled ENUM('0','1') default '1',
CallerID_popup_enabled ENUM('0','1') default '1',
voicemail_button_enabled ENUM('0','1') default '1',
enable_fast_refresh ENUM('0','1') default '0',
fast_refresh_rate INT(5) default '1000',
enable_persistant_mysql ENUM('0','1') default '0',
auto_dial_next_number ENUM('0','1') default '1',
VDstop_rec_after_each_call ENUM('0','1') default '1',
DBX_server VARCHAR(15),
DBX_database VARCHAR(15) default 'asterisk',
DBX_user VARCHAR(15) default 'cron',
DBX_pass VARCHAR(15) default '1234',
DBX_port INT(6) default '3306',
DBY_server VARCHAR(15),
DBY_database VARCHAR(15) default 'asterisk',
DBY_user VARCHAR(15) default 'cron',
DBY_pass VARCHAR(15) default '1234',
outbound_cid VARCHAR(20),
enable_sipsak_messages ENUM('0','1') default '0',
email VARCHAR(100),
template_id VARCHAR(15) NOT NULL,
conf_override TEXT,
phone_context VARCHAR(20) default 'default',
phone_ring_timeout SMALLINT(3) default '60',
conf_secret VARCHAR(20) default 'test',
delete_vm_after_email ENUM('N','Y') default 'N',
is_webphone ENUM('Y','N','Y_API_LAUNCH') default 'N',
use_external_server_ip ENUM('Y','N') default 'N',
codecs_list VARCHAR(100) default '',
codecs_with_template ENUM('0','1') default '0',
webphone_dialpad ENUM('Y','N','TOGGLE','TOGGLE_OFF') default 'Y',
on_hook_agent ENUM('Y','N') default 'N',
webphone_auto_answer ENUM('Y','N') default 'Y',
voicemail_timezone VARCHAR(30) default 'eastern',
voicemail_options VARCHAR(255) default '',
user_group VARCHAR(20) default '---ALL---',
voicemail_greeting VARCHAR(100) default '',
voicemail_dump_exten_no_inst VARCHAR(20) default '85026666666667',
voicemail_instructions ENUM('Y','N') default 'Y',
on_login_report enum('Y','N') NOT NULL default 'N',
unavail_dialplan_fwd_exten VARCHAR(40) default '',
unavail_dialplan_fwd_context VARCHAR(100) default '',
nva_call_url TEXT,
nva_search_method VARCHAR(40) default 'NONE',
nva_error_filename VARCHAR(255) default '',
nva_new_list_id BIGINT(14) UNSIGNED default '995',
nva_new_phone_code VARCHAR(10) default '1',
nva_new_status VARCHAR(6) default 'NVAINS',
webphone_dialbox ENUM('Y','N') default 'Y',
webphone_mute ENUM('Y','N') default 'Y',
webphone_volume ENUM('Y','N') default 'Y',
webphone_debug ENUM('Y','N') default 'N',
outbound_alt_cid VARCHAR(20) default '',
conf_qualify ENUM('Y','N') default 'Y',
webphone_layout VARCHAR(255) default '',
index (server_ip),
index (voicemail_id),
index (dialplan_number),
unique index extenserver (extension, server_ip)
) ENGINE=MyISAM;

[bramid]

and this is the insert one

INSERT INTO phones (extension, dialplan_number, voicemail_id, phone_ip, computer_ip, server_ip, login, pass, status, active, phone_type, fullname, company, picture, messages, old_messages, protocol,template_id) values('gs102','102','102','10.10.10.16','10.10.9.16','10.10.10.15','gs102','test', 'ADMIN','Y','Grandstream BT 102','Test Admin Phone','TEST','','0','0','SIP','');

[bramid]

what is it that I am doing wrong ?

[williamconley]

don't drop the table. import the phones without that part of it. the phones table structure is correct after the intall, don't allow anything to happen that would alter the structure. look at each command being issued. avoid DROP or CREATE or any structure changes. Just insert into, nothing else.

and never post the full text of something that long when it's stock. we all have our own copies of that. don't need a copy of the constitution, either. lol