vicidial.org

by **richardroi** » Wed Jan 08, 2014 4:49 am

Has anyone here tried flip1405 for failover? Any advice will be appreciated! Thanks!

by **williamconley** » Wed Jan 08, 2014 12:42 pm

Um ... nope. Simpler to push the backups from one server to the other and build yourself an automated restore / update ip script.

Then be sure your carrier has hunt or failover or whatever they want to call it to send your inbound calls to whichever server is LIVE.

Or put a watchdog script in the backup server to "self activate" if the primary server goes down.

Or don't let your server die (dual power supply, dual UPS and don't forget to UPS all network pathways to the ISP, raid 10 ...).

by **richardroi** » Fri Feb 14, 2014 10:55 am

"push the backups from one server to the other and build yourself an automated restore / update ip script."

Sir,

Want to learn this and put it to my setup but the issue is I don't know how and where to start!
Kindly share some light...Thank you.

by **williamconley** » Fri Feb 14, 2014 12:46 pm

have you activated the vicidial backup script yet?

Code: Select all: perl /usr/share/astguiclient/ADMIN_backup.pl --help

by **richardroi** » Mon Feb 17, 2014 4:25 pm

not yet. do you have "how to's?"
Kindly help. thank you.

by **richardroi** » Mon Feb 17, 2014 4:38 pm

MySql Backup and Restore for vicidial
To Backup

Login To PC using Putty or directly on the console prompt of the machine

At Root Prompt Type the following

mysqldump -uroot -pvicidialnow asterisk > asterisk.sql

Use WinSCP to Copy to Local Machine

To Restore

Use WinSCP to copy from Local PC to Traget PC
Login to Target PC using Putty or directly on the the console prompt,
Go to the folder where you copied the File and type the following

mysql -uroot -pvicidialnow asterisk < asterisk.sql

is this correct? not automated.

by **williamconley** » Mon Feb 17, 2014 5:53 pm

Seems like an awful lot of trouble to go to when you could use the admin backup script. But then again, may provide the same database in the end.

We use scp instead of WinSCP. Then you can copy directly from one to the other without getting personally involved. If you set up ssh keys to allow the receiving server to trust the sender, it can even be automated (cron job).

As opposed to someone who already uses the built-in script testing your manual version, it would be a novel idea if you were to test it yourself and see if you can get the newly copied database online in the new vicidial server.

Don't forget to run the ipupdate script with the old/new server IPs to update the db values in the ported database. And you may need to "drop" the previous database "create" a new asterisk database and then apply the data to the empty database to get your best result. Cleaner.

by **richardroi** » Tue Feb 18, 2014 5:04 am

How do I activate the script! Sorry but I just don't know where to begin.
I can setup ssh keys...what's next? Been looking at threads but no clear step by step for someone that don't know how.

Thank you.

by **williamconley** » Tue Feb 18, 2014 12:13 pm

Here's what we put in client boxes for the backup script:

Code: Select all: ## Vicidial Backup - without web files or sounds (change if you modify web files or recordings) ## Leave before midnight in case of "emergency backup" during the day ... don't overwrite LAST backup, make a new one! 45 23 * * * /usr/share/astguiclient/ADMIN_backup.pl --without-web --without-sounds >/dev/null 2>&1 #options: --db-only --db-without-logs --without-web --conf-only --without-db --without-conf --without-web --without-sounds # --without-voicemail --without-crontab --ftp-transfer --debugX --debug --test

This would be added to "crontab -e" at the bottom (anywhere will do, but we add it to the bottom for ease of later location by the client)

Note that this will cause the backup to run at 11:45 PM. These are stored by day of week. So running this again at Noon the next day (in a panic) will overwrite last week's, not last night's. If it fails (and has already begun), it will not have affected the backup that auto-ran last night with all of yesterday's data in it. Handy when a HD is dying and your IT guy tries to "quick run a backup" hoping to not lose any data.

NOTE: This does NOT back up client recordings. That is a completely separate system!

by **richardroi** » Tue Feb 18, 2014 2:02 pm

Thank you. How about to transfer the backup file on a different pc through ftp? I just want to do backup for now? because I'm still struggling with the restore part.

by **williamconley** » Tue Feb 18, 2014 6:39 pm

That's kind of eerie.

Look at this answer to another guy trying to do the same thing ...

viewtopic.php?f=4&t=32574#p109793

And for both of you, the restore is accomplished by copying the backup file to the new server and extracting the asterisk sql file from it (using tar -xzvf and/or tar -xvf ... note the filename, you'll need it), and then:

in mysql on the NEW server, to get a clean slate into which you can place this db:

Code: Select all: drop database asterisk create database asterisk

Then at the command line with that filename you noted earlier (full path if you are not already in that directory):

Code: Select all: mysql asterisk < xxxxxxxxxxx.sql

or (if your root user has a password)

Code: Select all: mysql -p "asterisk < xxxxxxxxxxx.sql

Then you perform the upgrade according to the upgrade rules of the how to and/or the UPGRADE.txt document in your /usr/src/astguiclient/trunk folder (assuming that's where your vicidial source code is for the version of vicidial you are running).

Commercial Announcement ... FYI: We charge $50 for a backup and $100 for a restore. Stock pricing, 2-5 day turnaround depending on our workload.

by **richardroi** » Wed Feb 19, 2014 9:14 am

Thank you so much.
Where should I put the backup file? and regarding ftp server from the other thread, I only used the archive server for recordings, I'm lost again!
Sorry for the questions... Just want to apply this on my work.

BTW: my running server used preload iso (all in one), should i use the preload iso also on my ftp server (new server/backup server) or the standard iso?

by **williamconley** » Wed Feb 19, 2014 7:23 pm

Where should I put the backup file

Depends on your goal. If your goal is "backup!" just get it off the server (ftp to the existing ftp server is fine). If your goal is to build a new server ... you'll need to move that backup file to the new server. If the new server happens to have ftp ... that's a convenient way to get the file to the new server.

We always use the standard iso, but either will do for this purpose.

by **richardroi** » Thu Feb 20, 2014 6:58 am

I mean the path where i should put the file. Yup, it is a new server and i want to do it with ftp.

by **williamconley** » Thu Feb 20, 2014 10:31 pm

if your goal is to build a new server, it matters not where you put the backup file. but i like to put it in /var/log/astguiclient/archive as if it were created by this server in the first place.

next you have to extract all the contents and put them where they were on the original machine.

then you have to restore the DB

then you have to run the admin update ip script

then you reboot

which steps do you need help with?

by **richardroi** » Fri Feb 21, 2014 1:01 pm

FTPing it to the new server. I know the ftping recordings, but how about the database? I know when you run the backup command it will go to archives.
There is no entry on the crontab for database for ftp.
Thank you so much for your time.

by **williamconley** » Fri Feb 21, 2014 5:00 pm

the backup script contains an option for ftp'ing. the credentials for that ftp push are the "reporting" credentials in astguiclient.conf. I posted all the options and the crontab entry you can use for running the backup script earlier.

Have you read the manual for instructions on backing up Vicidial?

by **richardroi** » Wed Feb 26, 2014 10:27 am

# FTP recording archive connection information
VARFTP_host => 192.168.150.153
VARFTP_user =>
VARFTP_pass =>
VARFTP_port => 21
VARFTP_dir => /recordings
VARHTTP_path => http://192.168.150.153/archive

# REPORT server connection information
VARREPORT_host => 192.168.150.153
VARREPORT_user => cron
VARREPORT_pass => test
VARREPORT_port => 21
VARREPORT_dir => REPORTS

This is my astguiclient.conf, recordings are forwarding to ftp server, but not the db backup. what else should I edit?

Found this BTW, Thank you for this also William, looks like i am on the right path. Just help ftping the db backup to my ftp server for storage.
2) copy backup file to 5.0.3 server
Everything from here is on the 5.0.3 server ...
3) extract sql file
4) drop asterisk DB
5) create asterisk DB
6) apply sql file to asterisk DB (now we have a copy of the 4.0.3 DB on the 5.0.3 server)
7) apply the "Nonexecuted" sql commands from the extras folder to the DB
* by this I mean find the db schema and search the sql files in the extras folder to find the db schema number. execute all commands after it in that file and then execute all the other files until you reach the end
8 ) admin update server IP (crucial step) with the old server ip and the new server ip
9) reboot

by **richardroi** » Wed Feb 26, 2014 12:57 pm

ftping db still doesn't work. full Backup and restore went fine, but when i go to conferences it is still using the old ip. Should i modify it manually or did i miss something?

"Server IP 192.168.150.154 does not have an entry in the servers table "----on mail, and when i go to user stats then recordings the ip is still using the old server, cannot download recordings, please advice.

Thank you.

by **richardroi** » Wed Feb 26, 2014 3:08 pm

when i run svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk
it gave me this "Checked out revision 2077"

REQUIRED STEPS!!!

1. Check system_settings, make sure you are at DB Schema Version 1347 or higher
If not, run the instructions for 2.4 to 2.7 before this section.

2. upgrade the MySQL asterisk database(you have two options):
A. Running the upgrade file directly from Linux:
mysql -f --database=asterisk < /path/from/root/extras/upgrade_2.8.sql

B. Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.8.sql
quit

3. install new files:
perl ./install.pl
NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.

4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
page and set each one to "Rebuild conf files = Y" and click submit.
This will rebuild the conf files to ensure any changes are updated.

5. On one server only, update your phone codes data:
/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table --debug

am i still required to do all these?

by **williamconley** » Wed Feb 26, 2014 9:41 pm

richardroi wrote:ftping db still doesn't work. full Backup and restore went fine, but when i go to conferences it is still using the old ip. Should i modify it manually or did i miss something?

"Server IP 192.168.150.154 does not have an entry in the servers table "----on mail, and when i go to user stats then recordings the ip is still using the old server, cannot download recordings, please advice.

Thank you.

After moving the db to the new server, you must run the admin update ip script. This is noted on the welcome splash every time you log in via ssh.

by **richardroi** » Thu Feb 27, 2014 8:21 am

I tested backing up our production server and tested it on a test server, the ip on server, conferences, phones etc is still using the old ip. i run the " /usr/share/astguiclient/ADMIN_update_server_ip.pl" twice still no luck. how do i update mysql? I'm kinda lost on steps:

1. Check system_settings, make sure you are at DB Schema Version 1347 or higher
If not, run the instructions for 2.4 to 2.7 before this section.

2. upgrade the MySQL asterisk database(you have two options):
A. Running the upgrade file directly from Linux:
mysql -f --database=asterisk < /path/from/root/extras/upgrade_2.8.sql

B. Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.8.sql
quit

3. install new files:
perl ./install.pl
NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.

4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
page and set each one to "Rebuild conf files = Y" and click submit.
This will rebuild the conf files to ensure any changes are updated.

5. On one server only, update your phone codes data:
/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table --debug

should i run all the steps except number 4 coz i am using all in one?

by **richardroi** » Thu Feb 27, 2014 10:22 am

ERROR 1142 (42000) at line 3 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_state_call_times'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1142 (42000) at line 7 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_users'
ERROR 1142 (42000) at line 8 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_users'
ERROR 1142 (42000) at line 9 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_users'
ERROR 1142 (42000) at line 10 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_users'
ERROR 1142 (42000) at line 12 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'system_settings'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1142 (42000) at line 16 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_user_log'
ERROR 1142 (42000) at line 17 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_user_log'
ERROR 1142 (42000) at line 18 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'vicidial_user_log'
ERROR 1142 (42000) at line 20 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'system_settings'
ERROR 1142 (42000) at line 21 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': ALTER command denied to user 'cron'@'localhost' for table 'system_settings'
ERROR 1142 (42000) at line 23 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': INDEX command denied to user 'cron'@'localhost' for table 'vicidial_user_log'
ERROR 1142 (42000) at line 24 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': INDEX command denied to user 'cron'@'localhost' for table 'vicidial_user_log'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

this is what i got! please help.
Thank you.

by **williamconley** » Thu Feb 27, 2014 3:18 pm

you must execute the file as root, not cron

by **richardroi** » Thu Feb 27, 2014 3:43 pm

newserver:~ # mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
You have new mail in /var/mail/root

This is hard...Sorry.

by **richardroi** » Thu Feb 27, 2014 3:48 pm

MariaDB [asterisk]> mysql -f --database=asterisk < /usr/src/astguiclient/trunk/extras/upgrade_2.8.sql
-> \. /usr/src/astguiclient/trunk/extras/upgrade_2.8.sql
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 3 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'ct_holidays'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 7 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'failed_login_count'
ERROR 1060 (42S21) at line 8 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'last_login_date'
ERROR 1060 (42S21) at line 9 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'last_ip'
ERROR 1060 (42S21) at line 10 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'pass_hash'
ERROR 1060 (42S21) at line 12 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'pass_hash_enabled'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 16 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'phone_login'
ERROR 1060 (42S21) at line 17 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'server_phone'
ERROR 1060 (42S21) at line 18 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'phone_ip'
ERROR 1060 (42S21) at line 20 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'pass_key'
ERROR 1060 (42S21) at line 21 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'pass_cost'
ERROR 1061 (42000) at line 23 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate key name 'phone_ip'
ERROR 1061 (42000) at line 24 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate key name 'vuled'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 28 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'disable_auto_dial'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1050 (42S01) at line 32 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Table 'vicidial_monitor_calls' already exists
ERROR 1050 (42S01) at line 50 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Table 'vicidial_monitor_log' already exists
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 66 in file: '/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql': Duplicate column name 'template_statuses'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

I'm redoing it! is this correct "< /usr/src/astguiclient/trunk/extras/upgrade_2.8.sql"?

2. upgrade the MySQL asterisk database(you have two options):
A. Running the upgrade file directly from Linux:
mysql -f --database=asterisk < /path/from/root/extras/upgrade_2.8.sql

B. Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.8.sql
quit
Question: Should I do both of the options? A and B?

by **richardroi** » Thu Feb 27, 2014 4:27 pm

Query OK, 1 row affected (0.06 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

MariaDB [asterisk]> quit
Bye
You have new mail in /var/mail/root
newtestserver:~ # perl ./install.pl
Can't open perl script "./install.pl": No such file or directory

"now im lost again"
This are the steps im following:
1. Check system_settings, make sure you are at DB Schema Version 1347 or higher
If not, run the instructions for 2.4 to 2.7 before this section.

2. upgrade the MySQL asterisk database(you have two options):
A. Running the upgrade file directly from Linux:
mysql -f --database=asterisk < /path/from/root/extras/upgrade_2.8.sql

B. Going into mysql and executing the upgrade sql file:
mysql
use asterisk
\. /path/from/root/extras/upgrade_2.8.sql
quit

3. install new files:
perl ./install.pl
NOTES: If you have customized any scripts in the bin or agi folders,
then make sure you back them up before running the install.pl script.
This script will replace existing files in the astguiclient installation.

4. For each of your ViciDial servers, go the Admin -> Servers -> Modify Server
page and set each one to "Rebuild conf files = Y" and click submit.
This will rebuild the conf files to ensure any changes are updated.

5. On one server only, update your phone codes data:
/usr/share/astguiclient/ADMIN_area_code_populate.pl --purge-table --debug

" btw before i ran the steps, I checked all the settings in the admin webgui, everything is there except that it is still using the old ip. I did run the update server ip, that is why i think I need to upgrade."
Am i correct?

by **williamconley** » Thu Feb 27, 2014 5:20 pm

you seem to have a basic linux command line problem. not finding "install.pl" would indicate you are in the wrong folder. If you want to execute a perl script, you should do so from the folder that actually contains the perl script. Note that ".pl" files are not programs, but scripts. They are just files. They must be present for the "perl" application to find them and execute their contents.

install.pl is traditionally located in /usr/share/astguiclient/trunk

This would be a much more appropriate location from which to execute it.

Code: Select all: cd /usr/share/astguiclient/trunk perl install.pl

by **richardroi** » Fri Feb 28, 2014 8:18 am

newtestserver:/usr/share/astguiclient # ls
ADMIN_adjust_GMTnow_on_leads.pl AST_conf_update_3way.pl
ADMIN_archive_log_tables.pl AST_dialer_inventory_snapshot.pl
ADMIN_area_code_populate.pl AST_email_web_report.pl
ADMIN_audio_store_sync.pl AST_flush_DBqueue.pl
ADMIN_backup.pl AST_inbound_email_parser.pl
ADMIN_bcrypt_convert.pl AST_manager_kill_hung_congested.pl
ADMIN_keepalive_ALL.pl AST_manager_listen.pl
ADMIN_qm_sync.pl AST_manager_send.pl
ADMIN_reset_failed_count.pl AST_phone_update.pl
ADMIN_restart_roll_logs.pl AST_recordings_export.pl
ADMIN_timeclock_auto_logout.pl AST_reset_mysql_vars.pl
ADMIN_update_archive_url.pl AST_send_URL.pl
ADMIN_update_server_ip.pl AST_send_action_child.pl
AST_CRON_GSM_SALE_recordings.pl AST_sourceID_summary_export.pl
AST_CRON_audio_1_move_VDonly.pl AST_timecheck.pl
AST_CRON_audio_1_move_mix.pl AST_twoday_tables_control.pl
AST_CRON_audio_2_compress.pl AST_update.pl
AST_CRON_audio_3_ftp.pl AST_vm_update.pl
AST_CRON_audio_3_newftp.pl FastAGI_log.pl
AST_CRON_audio_4_ftp2.pl GMT_USA_zip-latest.txt
AST_CRON_audio_4_ftp2_FTPSSL.pl LEADS_IN
AST_CRON_purge_recordings.pl MySQL_AST_CREATE_tables.sql
AST_DB_calltime_change.pl PREPROCESS
AST_DB_dead_cb_purge.pl QC_gather_records.pl
AST_DB_lead_status_change.pl UPDATE_IN
AST_DB_optimize.pl VD_email_inbound.pl
AST_DB_territory_populate.pl VICIDIAL_DEDUPE_leads.pl
AST_DB_tz_divide.pl VICIDIAL_IN_new_leads_file.pl
AST_SWAMPauto_dial.pl VICIDIAL_IN_preprocess_leads_file.pl
AST_VDadapt.pl VICIDIAL_UPDATE_leads_status_file.pl
AST_VDauto_dial.pl VICIDIAL_fix_list_statuses.pl
AST_VDauto_dial_FILL.pl VICIDIAL_fix_status_mismatch.pl
AST_VDhopper.pl VICIDIAL_last_local_call_time_UPDATE.pl
AST_VDlist_summary_export.pl VICIDIAL_rebuild_list_statuses.pl
AST_VDlist_summary_export_UK.pl VTIGER_IN
AST_VDremote_agents.pl Vtiger_IN_new_accounts_file.pl
AST_VDsales_export.pl Vtiger_IN_notes_activities_file.pl
AST_VDsales_export_SFTP.pl Vtiger_KILL_slow_queries.pl
AST_VDsales_export_SFTPSSH2.pl Vtiger_OUT_sync2VICIDIAL_file.pl
AST_VDweekly_agent_statuses_report.pl Vtiger_optimize_all_tables.pl
AST_agent_daily_SPH.pl build_translation_www_files.pl
AST_agent_daily_SPHfront.pl ip_relay
AST_agent_day.pl libs
AST_agent_logout.pl nanpa_type_filter.pl
AST_agent_week.pl nanpa_type_populate.pl
AST_agent_week_tally.pl nanpa_type_preload.pl
AST_call_log_export.pl phone_codes_GMT-latest-24.txt
AST_cleanup_agent_log.pl start_asterisk_boot.pl
AST_conf_update.pl
newtestserver:/usr/share/astguiclient #

newtestserver:~ # cd /usr/share/astguiclient/trunk
-bash: cd: /usr/share/astguiclient/trunk: No such file or directory

Error: what am i missing?

Question Sir: "mysql -f --database=asterisk < /path/from/root/extras/upgrade_2.8.sql , maybe what i entered is wrong "/usr/src/astguiclient/trunk/extras/upgrade_2.8.sql. coz i just copy it from an example i read on some other thread. and should i ran both steps A and the B option?

by **richardroi** » Fri Feb 28, 2014 8:39 am

I think I have to redo this again!
newtestserver:~ # screen -ls
There are screens on:
2002.ASTemail (Detached)
1998.ASTVDautoFILL (Detached)
1995.ASTfastlog (Detached)
1992.ASTVDadapt (Detached)
1847.asterisk (Detached)
5 Sockets in /var/run/screens/S-root.

This is hard but DOABLE! Thank you for sharing some light!

by **williamconley** » Fri Feb 28, 2014 10:16 pm

OK, it was a long night. /usr/src/astguiclient/trunk (src not share!)

by **richardroi** » Mon Mar 03, 2014 1:05 pm

- ViciBox Redux v.5.0.2-130821
newservertest:~ # mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 311
Server version: 5.5.32-MariaDB-log openSUSE package

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use asterisk;
Database changed
MariaDB [asterisk]> \. /usr/src/astguiclient/trunk/extras/upgrade_2.8.sql
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 3 in file: '/usr/src/astguiclient/trunk/extras/upgrad e_2.8.sql': Duplicate column name 'ct_holidays'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 7 in file: '/usr/src/astguiclient/trunk/extras/upgrad e_2.8.sql': Duplicate column name 'failed_login_count'
ERROR 1060 (42S21) at line 8 in file: '/usr/src/astguiclient/trunk/extras/upgrad e_2.8.sql': Duplicate column name 'last_login_date'
ERROR 1060 (42S21) at line 9 in file: '/usr/src/astguiclient/trunk/extras/upgrad e_2.8.sql': Duplicate column name 'last_ip'
ERROR 1060 (42S21) at line 10 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'pass_hash'
ERROR 1060 (42S21) at line 12 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'pass_hash_enabled'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 16 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'phone_login'
ERROR 1060 (42S21) at line 17 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'server_phone'
ERROR 1060 (42S21) at line 18 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'phone_ip'
ERROR 1060 (42S21) at line 20 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'pass_key'
ERROR 1060 (42S21) at line 21 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'pass_cost'
ERROR 1061 (42000) at line 23 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate key name 'phone_ip'
Query OK, 19206 rows affected (0.43 sec)
Records: 19206 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 28 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'disable_auto_dial'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1050 (42S01) at line 32 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Table 'vicidial_monitor_calls' already exists
ERROR 1050 (42S01) at line 50 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Table 'vicidial_monitor_log' already exists
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1060 (42S21) at line 66 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate column name 'template_statuses'
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1050 (42S01) at line 70 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Table 'nanpa_prefix_exchanges_master' already exists
ERROR 1050 (42S01) at line 82 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Table 'nanpa_prefix_exchanges_fast' already exists
ERROR 1061 (42000) at line 87 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Duplicate key name 'nanpaacprefix'
ERROR 1050 (42S01) at line 89 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Table 'nanpa_wired_to_wireless' already exists
ERROR 1050 (42S01) at line 93 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Table 'nanpa_wireless_to_wired' already exists
ERROR 1050 (42S01) at line 97 in file: '/usr/src/astguiclient/trunk/extras/upgra de_2.8.sql': Table 'vicidial_nanpa_filter_log' already exists
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 1 row affected (0.17 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 1 row affected (0.05 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.06 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 1 row affected (0.06 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.06 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.05 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.04 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.05 sec)
Records: 1 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

Query OK, 34206 rows affected (1.14 sec)
Records: 34206 Duplicates: 0 Warnings: 0

Query OK, 18325 rows affected (0.67 sec)
Records: 18325 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.16 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

ERROR 1050 (42S01) at line 147 in file: '/usr/src/astguiclient/trunk/extras/upgr ade_2.8.sql': Table 'vicidial_webservers' already exists
ERROR 1050 (42S01) at line 154 in file: '/usr/src/astguiclient/trunk/extras/upgr ade_2.8.sql': Table 'vicidial_urls' already exists
Query OK, 19206 rows affected (0.34 sec)
Records: 19206 Duplicates: 0 Warnings: 0

Query OK, 19206 rows affected (0.47 sec)
Records: 19206 Duplicates: 0 Warnings: 0

Query OK, 316 rows affected (0.21 sec)
Records: 316 Duplicates: 0 Warnings: 0

Query OK, 316 rows affected (0.05 sec)
Records: 316 Duplicates: 0 Warnings: 0

ERROR 1050 (42S01) at line 166 in file: '/usr/src/astguiclient/trunk/extras/upgr ade_2.8.sql': Table 'vicidial_api_log_archive' already exists

Sir William,
Am i doing this last step correctly? Error is still the same. It is still using the old ip. When I tried editing it manually, phones, carries ip can be changed but not the conference ip. no available sessions when im trying to login. hope you can help me. thank you.

BTW: when i do screen -ls i got this
newservertest:~ # screen -ls
There are screens on:
2004.ASTemail (Detached)
2001.ASTVDautoFILL (Detached)
1998.ASTfastlog (Detached)
1995.ASTVDadapt (Detached)
1846.asterisk (Detached)
5 Sockets in /var/run/screens/S-root.

whew! Please help.

by **richardroi** » Mon Mar 03, 2014 2:57 pm

got it working. I just noticed that crontab -e is not updated. please advice!

by **williamconley** » Wed Mar 05, 2014 11:07 am

richardroi wrote:Am i doing this last step correctly? Error is still the same. It is still using the old ip. When I tried editing it manually, phones, carries ip can be changed but not the conference ip. no available sessions when im trying to login. hope you can help me. thank you.

I'm not sure what you are "editing manually", but the ip update script is the only real method (that takes under an hour) to update the ip address in a vicidial server. Manual ip updates, as a rule, result in error. Unless, of course, you manually update by copying every line in the admin update ip script and executing them manually. If you have updated anything "manully" during a vicidial upgrade, usually this results in failure.

What instructions are you using for your upgrade experience?

richardroi wrote:got it working. I just noticed that crontab -e is not updated. please advice!

that's because crontab is not part of the update process.

by **richardroi** » Wed Mar 05, 2014 11:28 am

Thank you William. It is ok now. thank you for answering all my questions.

vicidial.org

flip1405

flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Re: flip1405

Who is online