>Please see http://sipx-wiki.calivia.com/index.php/SipX_ConfigServer_How_to_change_d atabase_schema
Thanks! Laurentiu Followed the steps but still not seeing the table getting added (attached list of tables). Steps: 1.Added a new table(alarm_group_snmpcontacts) in alarm-groups.sql (attached). 2.Did a 'ant reset-db'(attached log) as the db-patch for alarm-groups was already present. From the log it can be seen that the new table that is added is getting picked up. It says "6 of 6 SQL statements executed successfully" now earlier it was 5 (without the new table). I tried these commands too : 'srestart', 'service postgresql start', '/etc/init.d/postgresql reload' but no change. I am I missing something here? Note: alarm_group_snmpcontacts table gets created if the table is pasted directly(SQL command) into the psql prompt. Thanks, Seshu
alarm-groups.sql
Description: alarm-groups.sql
Buildfile: build.xml
reset-acd-history-db:
[pgsql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/report/etc/schema.sql
[pgsql] 4 of 4 SQL statements executed successfully
[pgsql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/report/etc/enable_upgrades.sql
[pgsql] 4 of 4 SQL statements executed successfully
[pgsql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/report/etc/location_fqdn.sql
[pgsql] 2 of 2 SQL statements executed successfully
[pgsql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/test/org/sipfoundry/sipxconfig/acd/stats/history-seed.sql
[pgsql] 34 of 34 SQL statements executed successfully
reset-db:
drop-index:
drop:
createdb:
schema:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/schema.sql
[sipx-sql] 267 of 267 SQL statements executed successfully
create:
patches:
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
[delete] Deleting:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/patches.properties
version1:
version2:
version3:
version4:
version5:
version6:
version7:
version8:
version9:
version10:
speeddial_group:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/speeddial_group.sql
[sipx-sql] 5 of 5 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add_addressbook_entry_info:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add_addressbook_entry_info.sql
[sipx-sql] 3 of 3 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add-user-shared-field:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add-user-shared-field.sql
[sipx-sql] 4 of 4 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add_addressbook_entry_info_2:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add_addressbook_entry_info_2.sql
[sipx-sql] 5 of 5 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add-saa-service:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add-saa-service.sql
[sipx-sql] 1 of 1 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add_phonebook_file_entry:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add_phonebook_file_entry.sql
[sipx-sql] 5 of 5 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
special-attendant:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/special-attendant.sql
[sipx-sql] 2 of 2 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
branch:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/branch.sql
[sipx-sql] 16 of 16 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
private-user-key:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/private-user-key.sql
[sipx-sql] 3 of 3 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add_addressbook_imDisplayName:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add_addressbook_imDisplayName.sql
[sipx-sql] 1 of 1 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
branch-address:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/branch-address.sql
[sipx-sql] 7 of 7 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
remove-legacy-media-server:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/remove-legacy-media-server.sql
[sipx-sql] 5 of 5 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
phonebook-add-user:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/phonebook-add-user.sql
[sipx-sql] 2 of 2 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add_addrbookentry_use_brnch_addr:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add_addrbookentry_use_brnch_addr.sql
[sipx-sql] 4 of 4 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
alarm-groups:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/alarm-groups.sql
[sipx-sql] 6 of 6 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add_branch_office_designation:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add_branch_office_designation.sql
[sipx-sql] 1 of 1 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add-im-password:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add-im-password.sql
[sipx-sql] 1 of 1 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
add-addressbook-email:
[sipx-sql] Executing resource:
/home/admin1/WORKING/main/sipXconfig/neoconf/etc/database/add-addressbook-email.sql
[sipx-sql] 3 of 3 SQL statements executed successfully
[sipx-sql] Executing commands
[sipx-sql] 1 of 1 SQL statements executed successfully
upgrade-no-init:
unittest-reset:
BUILD SUCCESSFUL
Total time: 11 seconds
SIPXCONFIG=# \dt
List of relations
Schema | Name | Type | Owner
--------+---------------------------------+-------+----------
public | acd_agent | table | postgres
public | acd_agent_queue | table | postgres
public | acd_line | table | postgres
public | acd_line_queue | table | postgres
public | acd_queue | table | postgres
public | acd_queue_agent | table | postgres
public | acd_server | table | postgres
public | address_book_entry | table | postgres
public | alarm_contacts | table | postgres
public | alarm_group | table | postgres
public | alarm_group_emailcontacts | table | postgres
public | alarm_group_smscontacts | table | postgres
public | alarm_server | table | postgres
public | attendant_dialing_rule | table | postgres
public | attendant_group | table | postgres
public | attendant_menu_item | table | postgres
public | attendant_special_mode | table | postgres
public | attendant_working_hours | table | postgres
public | auto_attendant | table | postgres
public | backup_plan | table | postgres
public | branch | table | postgres
public | call_group | table | postgres
public | cron_schedule | table | postgres
public | custom_dialing_rule | table | postgres
public | custom_dialing_rule_permission | table | postgres
public | daily_backup_schedule | table | postgres
public | dial_pattern | table | postgres
public | dial_plan | table | postgres
public | dialing_rule | table | postgres
public | dialing_rule_gateway | table | postgres
public | discovered_devices | table | postgres
public | domain | table | postgres
public | domain_alias | table | postgres
public | emergency_dialing_rule | table | postgres
public | extension_pool | table | postgres
public | ftp_configuration | table | postgres
public | fxo_port | table | postgres
public | gateway | table | postgres
public | group_storage | table | postgres
public | group_weight | table | postgres
public | holiday_dates | table | postgres
public | initialization_task | table | postgres
public | intercom | table | postgres
public | intercom_phone_group | table | postgres
public | internal_dialing_rule | table | postgres
public | international_dialing_rule | table | postgres
public | job | table | postgres
public | ldap_attr_map | table | postgres
public | ldap_connection | table | postgres
public | ldap_selected_object_classes | table | postgres
public | ldap_user_property_to_ldap_attr | table | postgres
public | line | table | postgres
public | line_group | table | postgres
public | local_dialing_rule | table | postgres
public | localization | table | postgres
public | location | table | postgres
public | location_bundle | table | postgres
public | location_specific_service | table | postgres
public | long_distance_dialing_rule | table | postgres
public | meetme_bridge | table | postgres
public | meetme_conference | table | postgres
public | meetme_participant | table | postgres
public | paging_group | table | postgres
public | paging_server | table | postgres
public | park_orbit | table | postgres
public | park_orbit_group | table | postgres
public | patch | table | postgres
public | permission | table | postgres
public | personal_attendant | table | postgres
public | personal_attendant_menu_item | table | postgres
public | phone | table | postgres
public | phone_group | table | postgres
public | phonebook | table | postgres
public | phonebook_consumer | table | postgres
public | phonebook_file_entry | table | postgres
public | phonebook_member | table | postgres
public | private_user_key | table | postgres
public | ring | table | postgres
public | sbc | table | postgres
public | sbc_device | table | postgres
public | sbc_route_domain | table | postgres
public | sbc_route_subnet | table | postgres
public | schedule | table | postgres
public | schedule_hours | table | postgres
public | service | table | postgres
public | setting_value | table | postgres
public | sipx_service | table | postgres
public | site_to_site_dial_pattern | table | postgres
public | site_to_site_dialing_rule | table | postgres
public | special_user | table | postgres
public | speeddial | table | postgres
public | speeddial_button | table | postgres
public | speeddial_group | table | postgres
public | speeddial_group_button | table | postgres
public | supervisor | table | postgres
public | timezone | table | postgres
public | upload | table | postgres
public | user_alarm_group | table | postgres
public | user_alias | table | postgres
public | user_group | table | postgres
public | user_paging_group | table | postgres
public | user_ring | table | postgres
public | users | table | postgres
public | value_storage | table | postgres
public | version_history | table | postgres
_______________________________________________ sipx-dev mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-dev Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev sipXecs IP PBX -- http://www.sipfoundry.org/
