1 Topic by sckif (edited by sckif 2010-12-08 22:40:06)

  • sckif
  • Member
  • Offline
  • Registered: 2010-12-08
  • Posts: 4

Topic: iRedadmin+Apache trouble

dont work...
OS Freebsd 8.1
in browser i see
"Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, you@example.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log."

in logs
Traceback (most recent call last):
  File "/usr/local/lib/python2.6/site-packages/web/application.py", line 240, in process
     return p(lambda: process(processors))
   File "/usr/local/lib/python2.6/site-packages/web/session.py", line 55, in _processor
    self._cleanup()
   File "/usr/local/lib/python2.6/site-packages/web/session.py", line 135, in _cleanup
   self.store.cleanup(timeout)
   File "/usr/local/lib/python2.6/site-packages/web/session.py", line 280, in cleanup
    self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals())
   File "/usr/local/lib/python2.6/site-packages/web/db.py", line 864, in delete
     self._db_execute(db_cursor, q)
   File "/usr/local/lib/python2.6/site-packages/web/db.py", line 562, in _db_execute
     out = cur.execute(sql_query.query(paramstyle), sql_query.values())
   File "build/bdist.freebsd-8.1-RELEASE-i386/egg/MySQLdb/cursors.py", line 174, in execute
     self.errorhandler(self, exc, value)
   File "build/bdist.freebsd-8.1-RELEASE-i386/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
     raise errorclass, errorvalue
ProgrammingError: (1146, "Table 'iredadmin.sessions' doesn't exist")

Please tell me how to solve this problem?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: iRedadmin+Apache trouble

“Table ‘iredadmin.sessions’ doesn’t exist”)

Please import SQL template under iRedAdmin directory: docs/samples/iredadmin.sql.

$ mysql -uroot -p
mysql> USE iredadmin;
mysql> SOURCE /path/to/iRedAdmin/docs/samples/iredadmin.sql;

3 Reply by sckif

  • sckif
  • Member
  • Offline
  • Registered: 2010-12-08
  • Posts: 4

Re: iRedadmin+Apache trouble

Thank you !! all worked!
more question smile)
how create mail aliases from iredadmin?
If this is impossible, can i add postfixadmin ? and save the address book ?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: iRedadmin+Apache trouble

iRedAdmin open source edition doesn't support creating mail list and aliases. You can purchase iRedAdmin-Pro for these features: http://www.iredmail.org/admin_panel.html
You can try it in our demo sites: http://www.iredmail.org/admin_demo.html

If you don't want to purchase iRedAdmin-Pro, you should re-install iRedMail, choose MySQL to store mail accounts, and manage them with PostfixAdmin.

5 Reply by sckif

  • sckif
  • Member
  • Offline
  • Registered: 2010-12-08
  • Posts: 4

Re: iRedadmin+Apache trouble

this is all I read ...
but there may be ,another way to add an alias from shell, without disrupting the structure iredmail? with ldap structure?

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: iRedadmin+Apache trouble

You can find tutorial here:
http://iredmail.org/wiki/index.php?title=IRedMail/FAQ

* Howto add mail list account with phpLDAPadmin
* Howto add alias account with phpLDAPadmin

7 Reply by HM

  • HM
  • Member
  • Offline
  • Registered: 2011-01-22
  • Posts: 7

Re: iRedadmin+Apache trouble

Doesn't work for me too ...
CentOS-5.5
in browser I get "internal server error"

I made an upgrade to version Pro-1.3.0
The OpenSource edition was working well.

in logs:
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/web/application.py", line 239, in process
return p(lambda: process(processors))
File "/usr/lib/python2.4/site-packages/web/session.py", line 55, in _processor
self._cleanup()
File "/usr/lib/python2.4/site-packages/web/session.py", line 135, in _cleanup
self.store.cleanup(timeout)
File "/usr/lib/python2.4/site-packages/web/session.py", line 280, in cleanup
self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals())
File "/usr/lib/python2.4/site-packages/web/db.py", line 844, in delete
db_cursor = self._db_cursor()
File "/usr/lib/python2.4/site-packages/web/db.py", line 522, in _db_cursor
return self.ctx.db.cursor()
File "/usr/lib/python2.4/site-packages/web/db.py", line 463, in _getctx
self._load_context(self._ctx)
File "/usr/lib/python2.4/site-packages/web/db.py", line 474, in _load_context
ctx.db = self._connect(self.keywords)
File "/usr/lib/python2.4/site-packages/web/db.py", line 502, in _connect
return self.db_module.connect(**keywords)
File "/usr/lib/python2.4/site-packages/MySQLdb/__init__.py", line 75, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.4/site-packages/MySQLdb/connections.py", line 164, in __init__
super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")

Please, help me solve the problem.

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,082

Re: iRedadmin+Apache trouble

HM wrote:

super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")

Do you have correct password for mysql user 'iredadmin' in iRedAdmin-Pro config file settings.ini? in section '[iredadmin]'.

9 Reply by HM (edited by HM 2011-01-22 09:27:39)

  • HM
  • Member
  • Offline
  • Registered: 2011-01-22
  • Posts: 7

Re: iRedadmin+Apache trouble

ZhangHuangbin wrote:
HM wrote:

super(Connection, self).__init__(*args, **kwargs2)
OperationalError: (1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")

Do you have correct password for mysql user 'iredadmin' in iRedAdmin-Pro config file settings.ini? in section '[iredadmin]'.

I corrected the authentication setings for mysql, but it don't work ..
The settings don't match de settings.ini file in older directory iRedAdmin-0.1.3, at all.
Something i miss in update process?
......
OK. I guess I miss the point "Sync settings between open source edition and new settings.ini, ..., one by one" from the HowTo Migrate ...

Thank you.