Nie otwiera si

goska_23 · Post autor: **goska_23** » 17 lipca 2013, 14:32

Nie ma. Sprawdzałam to archiwum pod mc --- F3 + F7 (mysql.sample). Pobrałam iRedMail-0.8.5.tar.bz2 - to jest aktualny pakiet.

mariaczi · Post autor: **mariaczi** » 17 lipca 2013, 14:35

iRedMail to pakiet - składanka, która konfiguruje usługi i powinna zainstalować wymagane oprogramowanie. Ty piszesz, że nie działa Ci iRedAdmin - panel do zarządzania, i o jego pobranie prosiłem i instalację: http://www.iredmail.org/yum/misc/

goska_23 · Post autor: **goska_23** » 17 lipca 2013, 15:45

Zainstalowałam teraz ten pakiet i poszło bez problemu. Jednak dalej pisze, że dostęp jest zabroniony.

Mam problem co poprawić w settings.ini

Kod: Zaznacz cały

[general]
# Site webmaster's mail address.
webmaster = zhb@iredmail.org

# Debug mode: True, False.
# Warning: Do *NOT* enable debug in product server.
debug = True

# Mail detail message of '500 internal server error' to webmaster: True, False.
# If set to True, iredadmin will mail detail error to webmaster when
# it catches 'internal server error' via LOCAL mail server to aid
# in debugging production servers.
mail_error_to_webmaster = False

# Default language.
lang = en_US

# Database backend: mysql.
backend = mysql

# Base directory used to store all mail data.
# iRedMail uses '/var/vmail/vmail1' as default storage directory.
# Tip: You can set a per-domain storage directory in domain profile page.
storage_base_directory = /var/vmail/vmail1

# Default mta transport.
# iRedMail uses 'dovecot' as defualt transport.
# Tip: You can set a per-domain or per-user transport in domain or user
#      profile page.
mtaTransport = dovecot

# Show user login date instead of created date: True, False.
# Please refer to iRedAdmin FAQ if you don't know how to track user last
# login data: http://www.iredmail.org/admin_faq.html
show_login_date = False

# Min/Max admin password length.
#   - min_passwd_length: 0 means unlimited, but at least 1 character
#                        is required.
#   - max_passwd_length: 0 means unlimited.
# User password length is controlled in domain profile.
min_passwd_length = 0
max_passwd_length = 0

[iredadmin]
# Database used to store iRedAdmin data. e.g. sessions, log.
#-------------------tutaj poprawiłam - gośka_23 -----------------------------------
host = localhost
port = 443
db = iredadmin
user = iredadmin
passwd = mojehaslo1

############################################
# Database used to store mail accounts.
#
[vmaildb]
host = host_of_vmaildb_sql_server
port = port_of_vmaildb_sql_server
db = vmail
user = vmailadmin
passwd = mojehaslo2

#################################################################
# Settings used for Policyd (1.8.x) integration. Provides global
# white-/blacklist, sender/recipient throttling, etc.
#
[policyd]

# Enable policyd integration: True, False.
enabled = True

# SQL Database used to store policyd data, eg. whitelist, blacklist.
# You can find related information in policyd config files:
#   - On RHEL/CentOS:   /etc/policyd.conf
#   - On Debian/Ubuntu: /etc/postfix-policyd.conf
#   - On FreeBSD:       /usr/local/etc/policyd.conf
# Related parameters:
#   host    -> MYSQLHOST
#   port    -> 3306 (Default)
#   db      -> MYSQLDBASE
#   user    -> MYSQLUSER
#   passwd  -> MYSQLPASS
host = host_of_policyd_sql_server
port = port_of_policyd_sql_server
db = policyd
user = policyd
passwd = password_of_policyd_db

##############################################################################
# Settings used for Amavisd-new integration. Provides spam/virus quaranting,
# releasing, etc.
#
[amavisd]

########### Logging into SQL (@storage_sql_dsn) ##########
# Logging into SQL: True, False.
# Log info of incoming/outgoing emails into SQL.
# It's @storage_sql_dsn setting in amavisd. You can find this setting
# in amavisd-new config files:
#   - On RHEL/CentOS:   /etc/amavisd.conf
#   - On Debian/Ubuntu: /etc/amavis/conf.d/50-user.conf
#   - On FreeBSD:       /usr/local/etc/amavisd.conf
# Reference:
# http://www.iredmail.org/wiki/index.php?title=IRedMail/FAQ/Integrate.MySQL.in.Amavisd
logging_into_sql = True

host = host_of_amavisd_sql_server
port = port_of_amavisd_sql_server
db = amavisd
user = amavisd
passwd = password_of_amavisd_db

# #### Quarantining ####
# Release quarantined SPAM/Virus mails: True, False.
# iRedAdmin-Pro will connect to @quarantine_server to release quarantined mails.
# How to enable quarantining in Amavisd-new:
# http://www.iredmail.org/wiki/index.php?title=IRedMail/FAQ/Quarantining.SPAM
quarantine = True

# Port of Amavisd protocol 'AM.PDP-INET'. Default is 9998.
quarantine_port = 9998

mariaczi · Post autor: **mariaczi** » 18 lipca 2013, 08:30

Plik konfiguracyjny w apache (iredadmin.conf) wskazuje na katalog, gdzie zainstalowałaś iRedAdmin'a? Jakie są uprawnienia dla tego katalogu?
[staraj się wklejać wynik z konsoli zamiast obrazków, łatwiej przeglądać]

goska_23 · Post autor: **goska_23** » 18 lipca 2013, 08:53

Poprawiłam w nazwie katalogu na standardową nazwę:
/usr/share/apache2/iredadmin/ (zamiast:/usr/share/apache2/iRedAdmin-0.2.2 jak było od instalacji) i teraz plik konfiguracyjny iredadmin.conf pokazuje na poprawną ścieżkę.
Chyba jednak poprawiając w tę stronę jeszcze coś trzeba byłoby zmienić.

Uprawnienia do: /usr/share/apache2/iredadmin/ są chyba dobre
chown ---> ireadmin:ireadmin
chmod ----> 755

Teraz przy próbie otwarcia strony https://192.168.1.100/iredadmin jest taki kod błędów:

Kod: Zaznacz cały

<class '_mysql_exceptions.OperationalError'> at /
(1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")Python    /usr/lib/pymodules/python2.6/MySQLdb/connections.py in __init__, line 169
Web    GET http://192.168.1.100/iredadmin/

Traceback (innermost first)
/usr/lib/pymodules/python2.6/MySQLdb/connections.py in __init__ 
        super(Connection, self).__init__(*args, **kwargs2) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/MySQLdb/__init__.py in Connect 
    return Connection(*args, **kwargs) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _connect 
        return self.db_module.connect(**keywords) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _load_context 
            ctx.db = self._connect(self.keywords) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _getctx 
            self._load_context(self._ctx) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _db_cursor 
        return self.ctx.db.cursor() ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in delete 
        db_cursor = self._db_cursor() ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/session.py in cleanup 
        self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals()) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/session.py in _cleanup 
            self.store.cleanup(timeout) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/session.py in _processor 
        self._cleanup() ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/application.py in process 
                    return p(lambda: process(processors)) ...
▶ Local vars 
Request information
INPUT

No data.
COOKIESVariable    Value
6e1f02a963388c33d14941eea415ed27    '1D131642+1175858+C+71B5815575017485152+75D5C444F1449+3474B4E+E17+2135913+7+61863+5+75B+75B1116+E+5174A'
9a331182f61587153acad49f5b25b00b    'h3v3m5lb86276ibimug6vjguo4'
kide_config    'gmt=2;retardo=0'
roundcube_sessid    'o6gp3qv59kjkur8dfr1mjfhgn0'

METAVariable    Value
app_stack    [<web.application.application instance at 0x7f21cfd65f80>]
fullpath    u'/'
headers    []
home    u'http://192.168.1.100/iredadmin'
homedomain    u'http://192.168.1.100'
homepath    u'/iredadmin'
host    u'192.168.1.100'
ip    u'192.168.1.100'
method    u'GET'
output    u''
path    u'/'
protocol    u'http'
query    u''
realhome    u'http://192.168.1.100/iredadmin'
status    '200 OK'

ENVIRONMENTVariable    Value
DOCUMENT_ROOT    '/var/www'
GATEWAY_INTERFACE    'CGI/1.1'
HTTP_ACCEPT    'text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/webp, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1'
HTTP_ACCEPT_ENCODING    'gzip, deflate'
HTTP_ACCEPT_LANGUAGE    'pl-PL,pl;q=0.9,en;q=0.8'
HTTP_CONNECTION    'Keep-Alive'
HTTP_COOKIE    '6e1f02a963388c33d14941eea415ed27=1D131642+1175858+C+71B5815575017485152+75D5C444F1449+3474B4E+E17+2135913+7+61863+5+75B+75B1116+E+5174A; roundcube_sessid=o6gp3qv59kjkur8dfr1mjfhgn0; 9a331182f61587153acad49f5b25b00b=h3v3m5lb86276ibimug6vjguo4; kide_config=gmt%3D2%3Bretardo%3D0'
HTTP_HOST    '192.168.1.100'
HTTP_USER_AGENT    'Opera/9.80 (X11; Linux x86_64) Presto/2.12.388 Version/12.16'
PATH_INFO    '/'
PATH_TRANSLATED    '/var/www/index.html'
QUERY_STRING    ''
REMOTE_ADDR    '192.168.1.100'
REMOTE_PORT    '58078'
REQUEST_METHOD    'GET'
REQUEST_URI    '/iredadmin'
SCRIPT_FILENAME    '/usr/share/apache2/iredadmin/iredadmin.py'
SCRIPT_NAME    '/iredadmin'
SERVER_ADDR    '192.168.1.100'
 SERVER_ADMIN    'xxxxxxxxx@hotmail.com'
SERVER_NAME    '192.168.1.100'
SERVER_PORT    '80'
SERVER_PROTOCOL    'HTTP/1.1'
SERVER_SIGNATURE    '<address>Apache/2.2.16 (Debian) Server at 192.168.1.100 Port 80</address>\n'
SERVER_SOFTWARE    'Apache/2.2.16 (Debian)'
mod_wsgi.application_group    'mail.computers-and-control.com|/iredadmin'
mod_wsgi.callable_object    'application'
mod_wsgi.handler_script    ''
mod_wsgi.input_chunked    '0'
mod_wsgi.listener_host    ''
mod_wsgi.listener_port    '80'
mod_wsgi.process_group    'iredadmin'
mod_wsgi.request_handler    'wsgi-script'
mod_wsgi.script_reloading    '1'
mod_wsgi.version    (3, 3)
wsgi.errors    <mod_wsgi.Log object at 0x7f21cf737f30>
wsgi.file_wrapper    <built-in method file_wrapper of mod_wsgi.Adapter object at 0x7f21cf72eeb8>
wsgi.input    <mod_wsgi.Input object at 0x7f21cf739170>
wsgi.multiprocess    False
wsgi.multithread    True
wsgi.run_once    False
wsgi.url_scheme    'http'
wsgi.version    (1, 1)


 You're seeing this error because you have web.config.debug set to True. Set that to False if you don't to see this.

mariaczi · Post autor: **mariaczi** » 18 lipca 2013, 08:56

Teraz, to jest błąd podłączenia się do bazy

Ustaw przez phpmyadmin'a odpowiednie uprawnienia dla użytkownika, którego podałaś w pliku konfiguracyjnym iRedAdmin'a (settings.ini) w sekcji "[iredadmin]". Skonfiguruj też sekcję "[vmaildb]" i sprawdź czy odpowiednie bazy istnieją. Jeśli nie, trzeba poszukać w instalatorze iRedMail'a skąd/jak owe bazy są tworzone i z "paluszka" je utworzyć.

goska_23 · Post autor: **goska_23** » 18 lipca 2013, 09:34

Nie jestem pewna co mam wpisać przy host i port.

Hasła dałam takie same i zmieniłam pod phpadminem, żeby były dobre.

Bazy iredadmin i vmail są i są dla nich uprawnienia do wskazanych użytkowników ( użytkownikowi vmailadmin dołożyłam komplet uprawnień do bazy bo miał tylko niektóre)

Nadal pokazuje, że nie łączy się z bazą.

Kod: Zaznacz cały

iredadmin]
# Database used to store iRedAdmin data. e.g. sessions, log.
host = localhost
port = 3306
db = iredadmin
user = iredadmin
passwd = mojehaslo1xxx

############################################
# Database used to store mail accounts.
#
[vmaildb]
host = localhost
port = 3306
db = vmail
user = vmailadmin
passwd = mojehaslo1xxx

Próbowałam z portem 443 w obu sekcjach ale też jest błąd:

Kod: Zaznacz cały

<class '_mysql_exceptions.OperationalError'> at /
(1045, "Access denied for user 'iredadmin'@'localhost' (using password: YES)")Python	/usr/lib/pymodules/python2.6/MySQLdb/connections.py in __init__, line 169
Web	GET https://localhost/iredadmin/

Traceback (innermost first)
/usr/lib/pymodules/python2.6/MySQLdb/connections.py in __init__ 
        super(Connection, self).__init__(*args, **kwargs2) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/MySQLdb/__init__.py in Connect 
    return Connection(*args, **kwargs) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _connect 
        return self.db_module.connect(**keywords) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _load_context 
            ctx.db = self._connect(self.keywords) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _getctx 
            self._load_context(self._ctx) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in _db_cursor 
        return self.ctx.db.cursor() ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/db.py in delete 
        db_cursor = self._db_cursor() ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/session.py in cleanup 
        self.db.delete(self.table, where="$last_allowed_time > atime", vars=locals()) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/session.py in _cleanup 
            self.store.cleanup(timeout) ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/session.py in _processor 
        self._cleanup() ...
▶ Local vars 
/usr/lib/pymodules/python2.6/web/application.py in process 
                    return p(lambda: process(processors)) ...
▶ Local vars 
Request information
INPUT

No data.
COOKIES

No data.
METAVariable	Value
app_stack	[<web.application.application instance at 0x7f21cfd65f80>]
fullpath	u'/'
headers	[]
home	u'https://localhost/iredadmin'
homedomain	u'https://localhost'
homepath	u'/iredadmin'
host	u'localhost'
ip	u'127.0.0.1'
method	u'GET'
output	u''
path	u'/'
protocol	u'https'
query	u''
realhome	u'https://localhost/iredadmin'
status	'200 OK'

ENVIRONMENTVariable	Value
DOCUMENT_ROOT	'/var/www'
GATEWAY_INTERFACE	'CGI/1.1'
HTTPS	'1'
HTTP_ACCEPT	'text/html, application/xml;q=0.9, application/xhtml+xml, image/png, image/webp, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1'
HTTP_ACCEPT_ENCODING	'gzip, deflate'
HTTP_ACCEPT_LANGUAGE	'pl-PL,pl;q=0.9,en;q=0.8'
HTTP_CACHE_CONTROL	'no-cache'
HTTP_CONNECTION	'Keep-Alive'
HTTP_HOST	'localhost'
HTTP_USER_AGENT	'Opera/9.80 (X11; Linux x86_64) Presto/2.12.388 Version/12.16'
PATH_INFO	'/'
PATH_TRANSLATED	'/var/www/index.html'
QUERY_STRING	''
REMOTE_ADDR	'127.0.0.1'
REMOTE_PORT	'34360'
REQUEST_METHOD	'GET'
REQUEST_URI	'/iredadmin'
SCRIPT_FILENAME	'/usr/share/apache2/iredadmin/iredadmin.py'
SCRIPT_NAME	'/iredadmin'
SERVER_ADDR	'127.0.0.1'
SERVER_ADMIN	'webmaster@localhost'
SERVER_NAME	'localhost'
SERVER_PORT	'443'
SERVER_PROTOCOL	'HTTP/1.1'
SERVER_SIGNATURE	'<address>Apache/2.2.16 (Debian) Server at localhost Port 443</address>\n'
SERVER_SOFTWARE	'Apache/2.2.16 (Debian)'
SSL_TLS_SNI	'localhost'
mod_wsgi.application_group	'mail.computers-and-control.com|/iredadmin'
mod_wsgi.callable_object	'application'
mod_wsgi.handler_script	''
mod_wsgi.input_chunked	'0'
mod_wsgi.listener_host	''
mod_wsgi.listener_port	'443'
mod_wsgi.process_group	'iredadmin'
mod_wsgi.request_handler	'wsgi-script'
mod_wsgi.script_reloading	'1'
mod_wsgi.version	(3, 3)
wsgi.errors	<mod_wsgi.Log object at 0x7f21cf737f30>
wsgi.file_wrapper	<built-in method file_wrapper of mod_wsgi.Adapter object at 0x7f21cf72eeb8>
wsgi.input	<mod_wsgi.Input object at 0x7f21cf739170>
wsgi.multiprocess	False
wsgi.multithread	True
wsgi.run_once	False
wsgi.url_scheme	'https'
wsgi.version	(1, 1)


 You're seeing this error because you have web.config.debug set to True. Set that to False if you don't to see this

mariaczi · Post autor: **mariaczi** » 18 lipca 2013, 09:46

Port ma być taki, jaki masz skonfigurowany w mysql'u. Jaki masz teraz komunikat na stronie - taki jaki był? Jeśli tak, to popraw konfigurację użytkownika iredadmin - ma miec prawo logowania z localhost z hasłem.

goska_23 · Post autor: **goska_23** » 18 lipca 2013, 09:53

w /etc/mysql/my.cnf mam port: 3306.

Chyba już coś jest - nie zrestartowałam apache2 po zmianach

mariaczi · Post autor: **mariaczi** » 18 lipca 2013, 09:56

Zatem możesz (powinnaś móc) zalogować się na konto admina iRedAdmin'a utworzone podczas instalacji (instalacji iRedMail). Jeśli będziesz korzystać, skonfiguruj pozostałe dwie sekcje z pliku settings.ini iRedAdmin'a. Możesz też sprawdzić, czy nie ma błędów w logach apache dla iRedAdmin'a.