I was able to fix the upgrade script by editing ira_tool_lib.py to say:

    try:
        host_string=settings.__dict__[db + '_db_host']
        port=int(settings.__dict__[db + '_db_port'])
        host_string += ':'
        host_string += str(port)
        print 'Host string is ' + host_string
        conn = web.database(dbn=sql_dbn,
                            host=host_string,
                            db=settings.__dict__[db + '_db_name'],
                            user=settings.__dict__[db + '_db_user'],
                            pw=settings.__dict__[db + '_db_password'])

Hi.

[dwb7@package ~]$ python -c "import web; print web.__version__"
0.36

The documentation in the postgres driver module mentions using:

URLs are of the form `postgres://user:password@host:port/dbname[?key=value&key=value...]`.

python-sqlalchemy-0.5.5-3.el6_2.noarch

Hrm... my pyweb is coming from the iredmail yum repo:

http://iredmail.org/yum/rpms/6/

I do, however, I have your repo at a higher priority specifically so that other repos can't overrule your repo

Are you no longer maintaining the pkgs in your repo?

thanks.

Good to know.. I'll re-jigger my repo priorities so that EPEL can override iredmail, then.

So it looks like allowing EPEL to override iredmail would update the following RPMs to:

GeoIP.x86_64                     1.6.5-1.el6                epel               
arj.x86_64                       3.10.22-22.el6             epel               
awstats.noarch                   7.0-3.el6                  epel               
cabextract.x86_64                1.5-1.el6                  epel               
clamav.x86_64                    0.99.1-1.el6               epel               
clamav-db.x86_64                 0.99.1-1.el6               epel               
clamd.x86_64                     0.99.1-1.el6               epel               
fail2ban.noarch                  0.9.3-1.el6.1              epel               
libmspack.x86_64                 0.5-0.1.alpha.el6          epel               
p7zip.x86_64                     15.09-9.el6                epel               
perl-Convert-UUlib.x86_64        2:1.5-1.el6                epel               
perl-Mail-SPF.noarch             2.8.0-2.el6                epel               
perl-Net-Server.noarch           2.007-2.el6                epel               
python-webpy.noarch              0.37-2.el6                 epel               

Thoughts?

So, with the latest iredadmin pro, I'm still running into this on RHEL6. Even though I upgraded to WebPy 0.37 .

The problem appears to be in the python-sqlalchemy package, which on RHEL6, is python-sqlalchemy-0.5.5-3.el6_2.noarch (a base RedHat, Inc package).

In addition to modding the ira_tool_lib.py script as mentioned above, I had to edit:

libs/sqllib/__init__.py
libs/amavisd/core.py
libs/sqllib/__init__.py
libs/iredbase.py
libs/iredapd/__init__.py

and making the same change in each one. Essentially deleting, in the connection, the port= line and changing the host= line to something like:

host=settings.vmail_db_host + ':' + str(int(settings.vmail_db_port)),

as I mentioned before, this is per the python sql documentation.

So, are you using a different version of python sql?

thanks.

I looked at that, but it would appear that there is not a newer one available as a base package.

EPEL appears to have newer packages available that would install alongside the base RedHat package, but I would guess you would specifically have to load the newer module version?