> > Trying to start sipxconfig.sh manually with no arguments reveals a few > other problems... > > *** > sipxconfig.sh > could not change directory to "/root" > Failed to execute: alter table sbc_device add column port int4 not > null > > BUILD FAILED > /etc/sipxpbx/database/database.xml:266: The following error occurred > while > executing this line: > /etc/sipxpbx/database/database.xml:674: The following error occurred > while > executing this line: > /etc/sipxpbx/database/database.xml:949: > org.postgresql.util.PSQLException: > ERROR: column "port" contains null values > > Total time: 0 seconds > could not change directory to "/root" > Error: bad SIPXCONFIG database version. > Expected version 9, got version 8. > This database was created or modified by a newer version of > sipXconfig. > Exiting now. > *** > > On the lists there are now 3 or 4 different users trying to upgrade > (Centos 5, 3.10.3 to version 4) with this same issue. All have been > unsuccessful so far. > > Should an issue be raised at this point or should it be said "don't > upgrade, start new"? >
See this one: http://track.sipfoundry.org/browse/XX-5624 We have some code under review to address it. This should hopefully take care of the SSL cert generation issues. Not sure on the database issue you are seeing. What is very odd is I can take a 3.10.3 system with a database (like yours) and upgrade it ok in the lab. This has been the challenging part to this one. > >>> "Alfred Campbell" <[email protected]> 04/29/09 4:30 PM >>> > I was running a 3.10 (installed from 3..10.2 ISO and yummed to 3.10.3. > > In order to upgrade to 4.0, I assumed we were supposed to: > > > > 1. service sipxecs stop > > 2. update/replace the sipx repo > > 3. yum install sipxecs > > > > I followed the advice, stopped sipxpbx. Changed the REPO and did a > yum > > install sipxecs. > > > > > > Total download size: 142 M > > Is this ok [y/N]: y > > Downloading Packages: > > (1/40): sipxfreeswitch-4. 100% |=========================| 5.0 kB > > 00:00 > > (2/40): sipx-freeswitch-c 100% |=========================| 20 kB > > 00:00 > > (3/40): sipx-jasperreport 100% |=========================| 5.1 MB > > 00:11 > > (4/40): sipxecs-doc-4.0.0 100% |=========================| 32 kB > > 00:00 > > (5/40): curl-7.15.5-2.1.e 100% |=========================| 232 kB > > 00:00 > > (6/40): sipxcommserverlib 100% |=========================| 1.1 MB > > 00:01 > > (7/40): sipxmedialib-4.0. 100% |=========================| 238 kB > > 00:00 > > (8/40): sipxconfig-snmp-4 100% |=========================| 3.1 kB > > 00:00 > > (9/40): sipxpbx-4.0.0-015 100% |=========================| 29 MB > > 00:59 > > (10/40): sipxconfig-mrtg- 100% |=========================| 6.3 kB > > 00:00 > > (11/40): java-1.6.0-sun-1 100% |=========================| 41 MB > > 01:31 > > (12/40): sipx-freeswitch- 100% |=========================| 20 kB > > 00:00 > > (13/40): sipxcalllib-4.0. 100% |=========================| 497 kB > > 00:00 > > (14/40): sipx-freeswitch- 100% |=========================| 7.0 MB > > 00:14 > > (15/40): sipxconfig-repor 100% |=========================| 11 kB > > 00:00 > > (16/40): sipxbridge-4.0.0 100% |=========================| 308 kB > > 00:00 > > (17/40): sipxvxml-4.0.0-0 100% |=========================| 782 kB > > 00:01 > > (18/40): rubygems-1.2.0-2 100% |=========================| 661 kB > > 00:01 > > (19/40): sipxconfig-4.0.0 100% |=========================| 22 MB > > 00:47 > > (20/40): sipxregistry-4.0 100% |=========================| 205 kB > > 00:00 > > (21/40): sipxproxy-cdr-4. 100% |=========================| 48 kB > > 00:00 > > (22/40): sipxconfig-agent 100% |=========================| 38 kB > > 00:00 > > (23/40): sipxtacklib-4.0. 100% |=========================| 525 kB > > 00:00 > > (24/40): sipxpublisher-4. 100% |=========================| 50 kB > > 00:00 > > (25/40): sipxecs-4.0.0-01 100% |=========================| 2.4 kB > > 00:00 > > (26/40): sipxcommons-4.0. 100% |=========================| 5.6 MB > > 00:18 > > (27/40): sipxportlib-4.0. 100% |=========================| 254 kB > > 00:00 > > (28/40): sipxproxy-4.0.0- 100% |=========================| 346 kB > > 00:00 > > (29/40): sipx-freeswitch- 100% |=========================| 19 kB > > 00:00 > > (30/40): sipxsupervisor-4 100% |=========================| 130 kB > > 00:00 > > (31/40): sipxconfig-tftp- 100% |=========================| 2.1 kB > > 00:00 > > (32/40): sipxacd-4.0.0-01 100% |=========================| 470 kB > > 00:03 > > (33/40): sipxmediaadapter 100% |=========================| 36 kB > > 00:00 > > (34/40): sipxcommserverli 100% |=========================| 442 kB > > 00:00 > > (35/40): sipxtools-4.0.0- 100% |=========================| 25 MB > > 00:53 > > (36/40): ruby-rdoc-1.8.5- 100% |=========================| 136 kB > > 00:00 > > (37/40): libidn-0.6.5-1.1 100% |=========================| 194 kB > > 00:00 > > (38/40): sipxconfig-ftp-4 100% |=========================| 3.3 kB > > 00:00 > > (39/40): sipxivr-4.0.0-01 100% |=========================| 112 kB > > 00:01 > > (40/40): sipxpage-4.0.0-0 100% |=========================| 417 kB > > 00:01 > > warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID > > fea2409e > > Importing GPG key 0xFEA2409E "Pingtel <[email protected]>" from > > https://secure2.pingtel.com/RPM-GPG-KEY-pingtel > > Is this ok [y/N]: y > > Running rpm_check_debug > > Running Transaction Test > > Finished Transaction Test > > Transaction Test Succeeded > > Running Transaction > > Updating : sipxportlib ####################### [ > > 1/61] > > Updating : sipxtacklib ####################### [ > > 2/61] > > Updating : sipxmedialib ####################### [ > > 3/61] > > Updating : sipxmediaadapterlib ####################### [ > > 4/61] > > Updating : sipxcalllib ####################### [ > > 5/61] > > Installing: java-1.6.0-sun ####################### [ > > 6/61] > > Installing: sipxcommons ####################### [ > > 7/61] > > Installing: sipxcommserverlib-doc ####################### [ > > 8/61] > > Updating : sipxcommserverlib ####################### [ > > 9/61] > > Updating : sipxtools ####################### > > [10/61] > > Updating : sipxpbx ####################### > > [11/61] > > 76748 semi-random bytes loaded > > 2048 semi-random bytes loaded > > Generating RSA private key, 1024 bit long modulus > > > ....................................................................... > > .................................++++++ > > .........++++++ > > e is 65537 (0x10001) > > Signature ok > > > subject=/C=US/ST=Virginia/L=Charlottesville/O=mydomain/OU=VoIP_Services > > /CN=pbx.mydomain.net/[email protected] > > Getting CA Private Key > > CA certificate and CA private key do not match > > 17754:error:0B080074:x509 certificate > > routines:X509_check_private_key:key values mismatch:x509_cmp.c:392: > > gen-ssl-keys.sh:Error: Failed to generate X.509 certificate > > unable to load certificate > > 17761:error:0906D06C:PEM routines:PEM_read_bio:no start > > line:pem_lib.c:644:Expecting: TRUSTED CERTIFICATE > > SSL Certificate '/var/sipxdata/certdb/pbx.mydomain.net.crt' is > invalid > > as client certificate. > > unable to load certificate > > 17768:error:0906D06C:PEM routines:PEM_read_bio:no start > > line:pem_lib.c:644:Expecting: TRUSTED CERTIFICATE > > SSL Certificate '/var/sipxdata/certdb/pbx.mydomain.net.crt' is > invalid > > as server certificate. > > unable to load certificate > > 17773:error:0906D06C:PEM routines:PEM_read_bio:no start > > line:pem_lib.c:644:Expecting: TRUSTED CERTIFICATE > > unable to load certificate > > 17779:error:0906D06C:PEM routines:PEM_read_bio:no start > > line:pem_lib.c:644:Expecting: TRUSTED CERTIFICATE > > SSL certificate '/var/sipxdata/certdb/pbx.mydomain.net.crt' expired: > > SSL certificates: /var/sipxdata/certdb/pbx.mydomain.net.crt > > Check failed for /var/sipxdata/certdb/pbx.mydomain.net.crt > > /var/sipxdata/certdb/pbx.mydomain.net.crt > > /var/sipxdata/certdb/pbx.mydomain.net.crt > > > > ! Check failed - certificate and key not installed. > > warning: /etc/sipxpbx/httpd-sipxchange-common-ssl.conf saved as > > /etc/sipxpbx/httpd-sipxchange-common-ssl.conf.rpmorig > > warning: /usr/share/www/doc/vm_vxml/forwardmessage.vxml created as > > /usr/share/www/doc/vm_vxml/forwardmessage.vxml.rpmnew > > warning: /usr/share/www/doc/vm_vxml/login.vxml created as > > /usr/share/www/doc/vm_vxml/login.vxml.rpmnew > > warning: /usr/share/www/doc/vm_vxml/login_no_autoattendant.vxml > created > > as /usr/share/www/doc/vm_vxml/login_no_autoattendant.vxml.rpmnew > > warning: /usr/share/www/doc/vm_vxml/savemessage.vxml created as > > /usr/share/www/doc/vm_vxml/savemessage.vxml.rpmnew > > warning: /usr/share/www/doc/vm_vxml/savemessage_no_operator.vxml > > created as > > /usr/share/www/doc/vm_vxml/savemessage_no_operator.vxml.rpmnew > > Updating : sipxproxy ####################### > > [12/61] > > Updating : sipxregistry ####################### > > [13/61] > > Installing: libidn ####################### > > [14/61] > > Installing: curl ####################### > > [15/61] > > Installing: sipx-freeswitch ####################### > > [16/61] > > Installing: sipx-freeswitch-codec-passth ####################### > > [17/61] > > Installing: sipx-freeswitch-codec-passth ####################### > > [18/61] > > Installing: sipx-freeswitch-codec-passth ####################### > > [19/61] > > Installing: sipxfreeswitch ####################### > > [20/61] > > Updating : sipxacd ####################### > > [21/61] > > Installing: sipxsupervisor ####################### > > [22/61] > > Updating : sipxpublisher ####################### > > [23/61] > > Updating : sipxvxml ####################### > > [24/61] > > Installing: sipxpage ####################### > > [25/61] > > Installing: sipxivr ####################### > > [26/61] > > Installing: sipxbridge ####################### > > [27/61] > > Installing: sipxecs-doc ####################### > > [28/61] > > Installing: sipx-jasperreports-deps ####################### > > [29/61] > > Installing: sipxconfig-snmp ####################### > > [30/61] > > Updating : sipxconfig-tftp ####################### > > [31/61] > > Installing: ruby-rdoc ####################### > > [32/61] > > Installing: rubygems ####################### > > [33/61] > > Updating : sipxconfig ####################### > > [34/61] > > warning: /etc/sipxpbx/polycom/mac-address.d/sip.cfg.vm created as > > /etc/sipxpbx/polycom/mac-address.d/sip.cfg.vm.rpmnew > > warning: /etc/sipxpbx/sipxconfig.properties created as > > /etc/sipxpbx/sipxconfig.properties.rpmnew > > Updating : sipxconfig-mrtg ####################### > > [35/61] > > Updating : sipxconfig-agent ####################### > > [36/61] > > Updating : sipxproxy-cdr ####################### > > [37/61] > > Updating : sipxconfig-report ####################### > > [38/61] > > Updating : sipxconfig-ftp ####################### > > [39/61] > > Installing: sipxecs ####################### > > [40/61] > > Cleanup : sipxtools ####################### > > [41/61] > > Cleanup : sipxcommserverlib ####################### > > [42/61] > > warning: /etc/sipxpbx/config.defs saved as > > /etc/sipxpbx/config.defs.rpmsave > > Cleanup : sipxmediaadapterlib ####################### > > [43/61] > > Cleanup : sipxacd ####################### > > [44/61] > > Cleanup : sipxproxy ####################### > > [45/61] > > warning: /etc/sipxpbx/sipXproxy-config.in saved as > > /etc/sipxpbx/sipXproxy-config.in.rpmsave > > warning: /etc/sipxpbx/forwardingrules.xml.in saved as > > /etc/sipxpbx/forwardingrules.xml.in.rpmsave > > warning: /etc/sipxpbx/authrules.xml.in saved as > > /etc/sipxpbx/authrules.xml.in.rpmsave > > Cleanup : sipxportlib ####################### > > [46/61] > > Cleanup : sipxpublisher ####################### > > [47/61] > > Cleanup : sipxtacklib ####################### > > [48/61] > > Cleanup : sipxconfig-agent ####################### > > [49/61] > > Cleanup : sipxproxy-cdr ####################### > > [50/61] > > warning: /etc/sipxpbx/callresolver-config.in saved as > > /etc/sipxpbx/callresolver-config.in.rpmsave > > Cleanup : sipxregistry ####################### > > [51/61] > > warning: /etc/sipxpbx/registrar-config.in saved as > > /etc/sipxpbx/registrar-config.in.rpmsave > > warning: /etc/sipxpbx/mappingrules.xml.in saved as > > /etc/sipxpbx/mappingrules.xml.in.rpmsave > > warning: /etc/sipxpbx/fallbackrules.xml.in saved as > > /etc/sipxpbx/fallbackrules.xml.in.rpmsave > > Cleanup : sipxconfig ####################### > > [52/61] > > warning: /etc/sipxpbx/sipxconfig.properties.in saved as > > /etc/sipxpbx/sipxconfig.properties.in.rpmsave > > Erasing : ruby-gems ####################### > > [53/61] > > Cleanup : sipxvxml ####################### > > [54/61] > > Cleanup : sipxconfig-report ####################### > > [55/61] > > Cleanup : sipxcalllib ####################### > > [56/61] > > Cleanup : sipxconfig-mrtg ####################### > > [57/61] > > Cleanup : sipxpbx ####################### > > [58/61] > > warning: /etc/sipxpbx/sipxrls-config.in saved as > /etc/sipxpbx/sipxrls- > > config.in.rpmsave > > warning: /etc/sipxpbx/sipxpresence-config.in saved as > > /etc/sipxpbx/sipxpresence-config.in.rpmsave > > warning: /etc/sipxpbx/sipxpark-config.in saved as > > /etc/sipxpbx/sipxpark-config.in.rpmsave > > warning: /etc/sipxpbx/sipxpage.properties.in saved as > > /etc/sipxpbx/sipxpage.properties.in.rpmsave > > Cleanup : sipxmedialib ####################### > > [59/61] > > > > Installed: rubygems.noarch 0:1.2.0-2 sipxecs.i386 0:4.0.0-015321 > > Dependency Installed: curl.i386 0:7.15.5-2.1.el5_3.4 java-1.6.0- > > sun.i586 0:1.6.0.7-1jpp libidn.i386 0:0.6.5-1.1 ruby-rdoc.i386 > 0:1.8.5- > > 5.el5_2.6 sipx-freeswitch.i386 0:1.0.3-1 sipx-freeswitch-codec- > > passthru-amr.i386 0:1.0.3-1 sipx-freeswitch-codec-passthru- > g723_1.i386 > > 0:1.0.3-1 sipx-freeswitch-codec-passthru-g729.i386 0:1.0.3-1 sipx- > > jasperreports-deps.noarch 0:1.0.0-2 sipxbridge.i386 0:4.0.0-015321 > > sipxcommons.i386 0:4.0.0-015321 sipxcommserverlib-doc.i386 0:4.0.0- > > 015321 sipxconfig-snmp.i386 0:4.0.0-015321 sipxecs-doc.noarch > 0:4.0.0- > > 015321 sipxfreeswitch.i386 0:4.0.0-015321 sipxivr.i386 0:4.0.0-015321 > > sipxpage.i386 0:4.0.0-015321 sipxsupervisor.i386 0:4.0.0-015321 > > Updated: sipxacd.i386 0:4.0.0-015321 sipxcalllib.i386 0:4.0.0-015321 > > sipxcommserverlib.i386 0:4.0.0-015321 sipxconfig.i386 0:4.0.0-015321 > > sipxconfig-agent.i386 0:4.0.0-015321 sipxconfig-ftp.i386 > 0:4.0.0-015321 > > sipxconfig-mrtg.i386 0:4.0.0-015321 sipxconfig-report.i386 0:4.0.0- > > 015321 sipxconfig-tftp.i386 0:4.0.0-015321 sipxmediaadapterlib.i386 > > 0:4.0.0-015321 sipxmedialib.i386 0:4.0.0-015321 sipxpbx.i386 0:4.0.0- > > 015321 sipxportlib.i386 0:4.0.0-015321 sipxproxy.i386 0:4.0.0-015321 > > sipxproxy-cdr.i386 0:4.0.0-015321 sipxpublisher.i386 0:4.0.0-015321 > > sipxregistry.i386 0:4.0.0-015321 sipxtacklib.i386 0:4.0.0-015321 > > sipxtools.i386 0:4.0.0-015321 sipxvxml.i386 0:4.0.0-015321 > > Replaced: ruby-gems.noarch 0:0.8.11-2 > > Complete! > > [r...@pbx yum.repos.d]# > > > > > > While I ran the ssl creation and installation manually (which did > > work), and changed the user:group on /etc/sipxpbx/httpd-sipxchange- > > common.conf to sipxchange, I also had to pause and go through all the > > rpmnew files, etc. > > > > After that was done I could start sipxecs with > > > > service sipxecs start > > > > Everything says [OK], but sipxconfig would not run. > > > > Fortunately I made a backup of the system before doing the upgrade > and > > was able to wipe and reinstall the system after uninstalling sipxecs > > and reinstalling it. > > > > I know others are having a similar issue with upgrades to 4.0, as > I've > > seen some postings. > > > > What I would like to know is if anyone has successfully upgraded or > not > > and whether my steps were the correct ones. This was a basic install > we > > use in our office and nothing is special or unusual about it. The > > install is less than 6 months old and the certificates had surely not > > expired yet and indicated above. I simply feel a step is missing > > somewhere and wanted to share it in the event someone can show an > > upgrade procedure that works for going from 3.10.3 to 4.0 (Centos). > > > > I have done at least 5 upgrades on the 3.10 to 4.0 on the open source > version. If you want to share you backup I can see if we can find out > what is wrong. _______________________________________________ sipx-dev mailing list [email protected] List Archive: http://list.sipfoundry.org/archive/sipx-dev Unsubscribe: http://list.sipfoundry.org/mailman/listinfo/sipx-dev
