Страница 1 из 2
roundcube mysql
Добавлено: 2008-04-28 18:25:58
trop1k
Установил roundcube из портов. Далее питаюсь запустить запрос на MYSQL пишу:
Код: Выделить всё
localhost# /usr/local/www/roundcube/SQL/mysql.initial.sql
/usr/local/www/roundcube/SQL/mysql.initial.sql: Permission denied.
localhost# chmod 644 /usr/local/www/roundcube/SQL/mysql.initial.sql
localhost# /usr/local/www/roundcube/SQL/mysql.initial.sql
/usr/local/www/roundcube/SQL/mysql.initial.sql: Permission denied.
localhost# chmod 777 /usr/local/www/roundcube/SQL/mysql.initial.sql
localhost# /usr/local/www/roundcube/SQL/mysql.initial.sql
--: not found
--: not found
--: not found
--: not found
--: not found
cache: not found
--: not found
--: not found
/usr/local/www/roundcube/SQL/mysql.initial.sql: 11: Syntax error: "(" unexpected
localhost#
Вообшем чтото непонятное видаёт.
Re: roundcube mysql
Добавлено: 2008-04-28 19:40:30
lodErunnEr
а зачем Вы так запускаете запрос?
mysql -u root -p roundcube < файл_с_тейблами.sql - будет правильнее
Re: roundcube mysql
Добавлено: 2008-04-28 20:12:25
trop1k
Я уже дозапускался что пхп5 отказасля работать. В том смисле что апатч незапускается еслистоят вот ети закоментированые строчки, раньше работало, а теперь нет, некто не вкурсе из за чего может быть, повторная переустановка непомогает.
Код: Выделить всё
#LoadModule php5_module libexec/apache/libphp5.so
#AddModule mod_php5.c
Re: roundcube mysql
Добавлено: 2008-04-28 20:13:32
lodErunnEr
а что в логах?
Re: roundcube mysql
Добавлено: 2008-04-28 20:46:09
trop1k
Код: Выделить всё
localhost# apachectl start
/usr/local/sbin/apachectl start: httpd started
localhost# apachectl start
/usr/local/sbin/apachectl start: httpd started
localhost# apachectl start
/usr/local/sbin/apachectl start: httpd started
localhost# apachectl stop
/usr/local/sbin/apachectl stop: httpd (pid 1707?) not running
localhost# apachectl start
/usr/local/sbin/apachectl start: httpd started
localhost# apachectl stop
/usr/local/sbin/apachectl stop: httpd (pid 1718?) not running
httpd-error.log
Код: Выделить всё
[Mon Apr 28 15:42:28 2008] [warn] pid file /var/run/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Mon Apr 28 15:42:28 2008] [warn] pid file /var/run/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Mon Apr 28 15:42:29 2008] [warn] pid file /var/run/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Mon Apr 28 15:42:29 2008] [warn] pid file /var/run/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
Re: roundcube mysql
Добавлено: 2008-04-28 21:19:35
lodErunnEr
хм.. действительно дозапускался
ну кидай тогда содержимое "скриптов"
Re: roundcube mysql
Добавлено: 2008-04-28 23:59:28
trop1k
Включил заново комп заработал апаче, потом изменил документ роот директориюсделал/usr/local/sbin/apachctl stop, потом /usr/local/sbin/apachectl start и невклучился апач :
Код: Выделить всё
localhost# sockstat -4
USER COMMAND PID FD PROTO LOCAL ADDRESS FOREIGN ADDRESS
root kget 1283 10 udp4 *:* *:*
root Xorg 1173 3 tcp4 *:6000 *:*
root sshd 1087 4 tcp4 *:22 *:*
root couriertcp 1062 3 tcp4 *:110 *:*
root master 1007 11 tcp4 *:25 *:*
root master 1007 84 tcp4 127.0.0.1:10025 *:*
vscan perl5.8.8 998 6 tcp4 127.0.0.1:10024 *:*
vscan perl5.8.8 997 6 tcp4 127.0.0.1:10024 *:*
vscan perl5.8.8 930 6 tcp4 127.0.0.1:10024 *:*
root perl5.8.8 929 5 tcp4 127.0.0.1:783 *:*
root perl5.8.8 928 5 tcp4 127.0.0.1:783 *:*
root perl5.8.8 920 5 tcp4 127.0.0.1:783 *:*
www httpd 918 16 tcp4 *:443 *:*
www httpd 918 17 tcp4 *:80 *:*
www httpd 917 16 tcp4 *:443 *:*
www httpd 917 17 tcp4 *:80 *:*
www httpd 916 16 tcp4 *:443 *:*
www httpd 916 17 tcp4 *:80 *:*
www httpd 915 16 tcp4 *:443 *:*
www httpd 915 17 tcp4 *:80 *:*
www httpd 914 16 tcp4 *:443 *:*
www httpd 914 17 tcp4 *:80 *:*
root httpd 908 16 tcp4 *:443 *:*
root httpd 908 17 tcp4 *:80 *:*
root nfsd 813 3 tcp4 *:2049 *:*
root mountd 811 4 udp4 *:956 *:*
root mountd 811 5 tcp4 *:686 *:*
root rpcbind 767 9 udp4 *:111 *:*
root rpcbind 767 10 udp4 *:692 *:*
root rpcbind 767 11 tcp4 *:111 *:*
root syslogd 747 7 udp4 *:514 *:*
localhost# /usr/local/sbin/apachectl stop
/usr/local/sbin/apachectl stop: httpd stopped
localhost# /usr/local/sbin/apachectl start
/usr/local/sbin/apachectl start: httpd started
localhost# sockstat -4
USER COMMAND PID FD PROTO LOCAL ADDRESS FOREIGN ADDRESS
root kget 1283 10 udp4 *:* *:*
root Xorg 1173 3 tcp4 *:6000 *:*
root sshd 1087 4 tcp4 *:22 *:*
root couriertcp 1062 3 tcp4 *:110 *:*
root master 1007 11 tcp4 *:25 *:*
root master 1007 84 tcp4 127.0.0.1:10025 *:*
vscan perl5.8.8 998 6 tcp4 127.0.0.1:10024 *:*
vscan perl5.8.8 997 6 tcp4 127.0.0.1:10024 *:*
vscan perl5.8.8 930 6 tcp4 127.0.0.1:10024 *:*
root perl5.8.8 929 5 tcp4 127.0.0.1:783 *:*
root perl5.8.8 928 5 tcp4 127.0.0.1:783 *:*
root perl5.8.8 920 5 tcp4 127.0.0.1:783 *:*
root nfsd 813 3 tcp4 *:2049 *:*
root mountd 811 4 udp4 *:956 *:*
root mountd 811 5 tcp4 *:686 *:*
root rpcbind 767 9 udp4 *:111 *:*
root rpcbind 767 10 udp4 *:692 *:*
root rpcbind 767 11 tcp4 *:111 *:*
root syslogd 747 7 udp4 *:514 *:*
localhost#
mailog:
Код: Выделить всё
[Mon Apr 28 18:38:06 2008] [notice] Apache/1.3.39 (Unix) PHP/5.2.5 with Suhosin-Patch mod_ssl/2.8.30 OpenSSL/0.9.8g configured -- resuming normal operations
[Mon Apr 28 18:38:06 2008] [notice] Accept mutex: flock (Default: flock)
[Mon Apr 28 18:42:14 2008] [error] [client 62.205.227.97] File does not exist: /usr/local/www/data/images/bg1top1.jpg
[Mon Apr 28 18:42:14 2008] [error] [client 62.205.227.97] File does not exist: /usr/local/www/data/favicon.ico <<<<work
[Mon Apr 28 18:43:37 2008] [notice] caught SIGTERM, shutting down <<after don't work
httpd.conf
Код: Выделить всё
localhost# cat /usr/local/etc/apache/httpd.conf | grep -v ^# | grep -v ^$
ServerType standalone
ServerRoot "/usr/local"
PidFile /var/run/httpd.pid
ScoreBoardFile /var/run/httpd.scoreboard
ResourceConfig /dev/null
AccessConfig /dev/null
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 150
MaxRequestsPerChild 0
LoadModule mmap_static_module libexec/apache/mod_mmap_static.so
LoadModule vhost_alias_module libexec/apache/mod_vhost_alias.so
LoadModule env_module libexec/apache/mod_env.so
LoadModule define_module libexec/apache/mod_define.so
LoadModule config_log_module libexec/apache/mod_log_config.so
LoadModule mime_magic_module libexec/apache/mod_mime_magic.so
LoadModule mime_module libexec/apache/mod_mime.so
LoadModule negotiation_module libexec/apache/mod_negotiation.so
LoadModule status_module libexec/apache/mod_status.so
LoadModule info_module libexec/apache/mod_info.so
LoadModule includes_module libexec/apache/mod_include.so
LoadModule autoindex_module libexec/apache/mod_autoindex.so
LoadModule dir_module libexec/apache/mod_dir.so
LoadModule cgi_module libexec/apache/mod_cgi.so
LoadModule asis_module libexec/apache/mod_asis.so
LoadModule imap_module libexec/apache/mod_imap.so
LoadModule action_module libexec/apache/mod_actions.so
LoadModule speling_module libexec/apache/mod_speling.so
LoadModule userdir_module libexec/apache/mod_userdir.so
LoadModule alias_module libexec/apache/mod_alias.so
LoadModule rewrite_module libexec/apache/mod_rewrite.so
LoadModule access_module libexec/apache/mod_access.so
LoadModule auth_module libexec/apache/mod_auth.so
LoadModule anon_auth_module libexec/apache/mod_auth_anon.so
LoadModule db_auth_module libexec/apache/mod_auth_db.so
LoadModule digest_module libexec/apache/mod_digest.so
LoadModule proxy_module libexec/apache/libproxy.so
LoadModule cern_meta_module libexec/apache/mod_cern_meta.so
LoadModule expires_module libexec/apache/mod_expires.so
LoadModule headers_module libexec/apache/mod_headers.so
LoadModule usertrack_module libexec/apache/mod_usertrack.so
LoadModule log_forensic_module libexec/apache/mod_log_forensic.so
LoadModule unique_id_module libexec/apache/mod_unique_id.so
LoadModule setenvif_module libexec/apache/mod_setenvif.so
<IfDefine SSL>
LoadModule ssl_module libexec/apache/libssl.so
</IfDefine>
LoadModule php5_module libexec/apache/libphp5.so
ClearModuleList
AddModule mod_mmap_static.c
AddModule mod_vhost_alias.c
AddModule mod_env.c
AddModule mod_define.c
AddModule mod_log_config.c
AddModule mod_mime_magic.c
AddModule mod_mime.c
AddModule mod_negotiation.c
AddModule mod_status.c
AddModule mod_info.c
AddModule mod_include.c
AddModule mod_autoindex.c
AddModule mod_dir.c
AddModule mod_cgi.c
AddModule mod_asis.c
AddModule mod_imap.c
AddModule mod_actions.c
AddModule mod_speling.c
AddModule mod_userdir.c
AddModule mod_alias.c
AddModule mod_rewrite.c
AddModule mod_access.c
AddModule mod_auth.c
AddModule mod_auth_anon.c
AddModule mod_auth_db.c
AddModule mod_digest.c
AddModule mod_proxy.c
AddModule mod_cern_meta.c
AddModule mod_expires.c
AddModule mod_headers.c
AddModule mod_usertrack.c
AddModule mod_log_forensic.c
AddModule mod_unique_id.c
AddModule mod_so.c
AddModule mod_setenvif.c
<IfDefine SSL>
AddModule mod_ssl.c
</IfDefine>
AddModule mod_php5.c
Port 80
<IfDefine SSL>
Listen 80
Listen 443
</IfDefine>
User www
Group www
ServerAdmin you@your.address
DocumentRoot "/usr/local/www/"
<Directory />
Options FollowSymLinks
AllowOverride None
</Directory>
<Directory "/usr/local/www/">
Options Indexes FollowSymLinks MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
<IfModule mod_userdir.c>
UserDir public_html
</IfModule>
<IfModule mod_dir.c>
<IfModule mod_php3.c>
<IfModule mod_php4.c>
DirectoryIndex index.php index.php3 index.html
</IfModule>
<IfModule !mod_php4.c>
DirectoryIndex index.php3 index.html
</IfModule>
</IfModule>
<IfModule !mod_php3.c>
<IfModule mod_php4.c>
DirectoryIndex index.php index.html
</IfModule>
<IfModule !mod_php4.c>
DirectoryIndex index.html
</IfModule>
</IfModule>
</IfModule>
<IfModule mod_php5.c>
DirectoryIndex index.php index.html
</IfModule>
<IfModule mod_php5.c>
AddType application/x-httpd-php .php
AddType application/x-httpd-php-source .phps
</IfModule>
AccessFileName .htaccess
<Files ~ "^\.ht">
Order allow,deny
Deny from all
Satisfy All
</Files>
UseCanonicalName On
<IfModule mod_mime.c>
TypesConfig /usr/local/etc/apache/mime.types
</IfModule>
DefaultType text/plain
<IfModule mod_mime_magic.c>
MIMEMagicFile /usr/local/etc/apache/magic
</IfModule>
HostnameLookups Off
ErrorLog /var/log/httpd-error.log
LogLevel warn
LogFormat "%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined
LogFormat "%h %l %u %t \"%r\" %>s %b" common
LogFormat "%{Referer}i -> %U" referer
LogFormat "%{User-agent}i" agent
CustomLog /var/log/httpd-access.log combined
ServerSignature On
<IfModule mod_alias.c>
#
# Note that if you include a trailing / on fakename then the server will
# require it to be present in the URL. So "/icons" isn't aliased in this
# example, only "/icons/". If the fakename is slash-terminated, then the
# realname must also be slash terminated, and if the fakename omits the
# trailing slash, the realname must also omit it.
#
Alias /icons/ "/usr/local/www/icons/"
<Directory "/usr/local/www/icons">
Options Indexes MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
# This Alias will project the on-line documentation tree under /manual/
# even if you change the DocumentRoot. Comment it if you don't want to
# provide access to the on-line documentation.
#
Alias /manual/ "/usr/local/share/doc/apache/"
<Directory "/usr/local/share/doc/apache">
Options Indexes FollowSymlinks MultiViews
AllowOverride None
Order allow,deny
Allow from all
</Directory>
#
# ScriptAlias: This controls which directories contain server scripts.
# ScriptAliases are essentially the same as Aliases, except that
# documents in the realname directory are treated as applications and
# run by the server when requested rather than as documents sent to the client.
# The same rules about trailing "/" apply to ScriptAlias directives as to
# Alias.
#
ScriptAlias /cgi-bin/ "/usr/local/www/cgi-bin/"
#
# "/usr/local/www/cgi-bin" should be changed to whatever your ScriptAliased
# CGI directory exists, if you have that configured.
#
<Directory "/usr/local/www/cgi-bin">
AllowOverride None
Options None
Order allow,deny
Allow from all
</Directory>
</IfModule>
<IfModule mod_autoindex.c>
#
# FancyIndexing is whether you want fancy directory indexing or standard
#
IndexOptions FancyIndexing
#
# AddIcon* directives tell the server which icon to show for different
# files or filename extensions. These are only displayed for
# FancyIndexed directories.
#
AddIconByEncoding (CMP,/icons/compressed.gif) x-compress x-gzip
AddIconByType (TXT,/icons/text.gif) text/*
AddIconByType (IMG,/icons/image2.gif) image/*
AddIconByType (SND,/icons/sound2.gif) audio/*
AddIconByType (VID,/icons/movie.gif) video/*
AddIcon /icons/binary.gif .bin .exe
AddIcon /icons/binhex.gif .hqx
AddIcon /icons/tar.gif .tar
AddIcon /icons/world2.gif .wrl .wrl.gz .vrml .vrm .iv
AddIcon /icons/compressed.gif .Z .z .tgz .gz .zip
AddIcon /icons/a.gif .ps .ai .eps
AddIcon /icons/layout.gif .html .shtml .htm .pdf
AddIcon /icons/text.gif .txt
AddIcon /icons/c.gif .c
AddIcon /icons/p.gif .pl .py
AddIcon /icons/f.gif .for
AddIcon /icons/dvi.gif .dvi
AddIcon /icons/uuencoded.gif .uu
AddIcon /icons/script.gif .conf .sh .shar .csh .ksh .tcl
AddIcon /icons/tex.gif .tex
AddIcon /icons/bomb.gif core
AddIcon /icons/back.gif ..
AddIcon /icons/hand.right.gif README
AddIcon /icons/folder.gif ^^DIRECTORY^^
AddIcon /icons/blank.gif ^^BLANKICON^^
#
# DefaultIcon is which icon to show for files which do not have an icon
# explicitly set.
#
DefaultIcon /icons/unknown.gif
#
# AddDescription allows you to place a short description after a file in
# server-generated indexes. These are only displayed for FancyIndexed
# directories.
# Format: AddDescription "description" filename
#
#AddDescription "GZIP compressed document" .gz
#AddDescription "tar archive" .tar
#AddDescription "GZIP compressed tar archive" .tgz
#
# ReadmeName is the name of the README file the server will look for by
# default, and append to directory listings.
#
# HeaderName is the name of a file which should be prepended to
# directory indexes.
#
ReadmeName README.html
HeaderName HEADER.html
#
# IndexIgnore is a set of filenames which directory indexing should ignore
# and not include in the listing. Shell-style wildcarding is permitted.
#
IndexIgnore .??* *~ *# HEADER* README* RCS CVS *,v *,t
</IfModule>
<IfModule mod_mime.c>
#
# AddLanguage allows you to specify the language of a document. You can
# then use content negotiation to give a browser a file in a language
# it can understand.
#
# Note 1: The suffix does not have to be the same as the language
# keyword --- those with documents in Polish (whose net-standard
# language code is pl) may wish to use "AddLanguage pl .po" to
# avoid the ambiguity with the common suffix for perl scripts.
#
# Note 2: The example entries below illustrate that in quite
# some cases the two character 'Language' abbreviation is not
# identical to the two character 'Country' code for its country,
# E.g. 'Danmark/dk' versus 'Danish/da'.
#
# Note 3: In the case of 'ltz' we violate the RFC by using a three char
# specifier. But there is 'work in progress' to fix this and get
# the reference data for rfc1766 cleaned up.
#
# Danish (da) - Dutch (nl) - English (en) - Estonian (ee)
# French (fr) - German (de) - Greek-Modern (el)
# Italian (it) - Korean (kr) - Norwegian (no) - Norwegian Nynorsk (nn)
# Portugese (pt) - Luxembourgeois* (ltz)
# Spanish (es) - Swedish (sv) - Catalan (ca) - Czech(cs)
# Polish (pl) - Brazilian Portuguese (pt-br) - Japanese (ja)
# Russian (ru)
#
AddLanguage da .dk
AddLanguage nl .nl
AddLanguage en .en
AddLanguage et .ee
AddLanguage fr .fr
AddLanguage de .de
AddLanguage el .el
AddLanguage he .he
AddCharset ISO-8859-8 .iso8859-8
AddLanguage it .it
AddLanguage ja .ja
AddCharset ISO-2022-JP .jis
AddLanguage kr .kr
AddCharset ISO-2022-KR .iso-kr
AddLanguage nn .nn
AddLanguage no .no
AddLanguage pl .po
AddCharset ISO-8859-2 .iso-pl
AddLanguage pt .pt
AddLanguage pt-br .pt-br
AddLanguage ltz .lu
AddLanguage ca .ca
AddLanguage es .es
AddLanguage sv .sv
AddLanguage cs .cz .cs
AddLanguage ru .ru
AddLanguage zh-TW .zh-tw
AddCharset Big5 .Big5 .big5
AddCharset WINDOWS-1251 .cp-1251
AddCharset CP866 .cp866
AddCharset ISO-8859-5 .iso-ru
AddCharset KOI8-R .koi8-r
AddCharset UCS-2 .ucs2
AddCharset UCS-4 .ucs4
AddCharset UTF-8 .utf8
# LanguagePriority allows you to give precedence to some languages
# in case of a tie during content negotiation.
#
# Just list the languages in decreasing order of preference. We have
# more or less alphabetized them here. You probably want to change this.
#
<IfModule mod_negotiation.c>
LanguagePriority en da nl et fr de el it ja kr no pl pt pt-br ru ltz ca es sv tw
</IfModule>
#
# AddType allows you to tweak mime.types without actually editing it, or to
# make certain files to be certain types.
#
AddType application/x-tar .tgz
#
# AddEncoding allows you to have certain browsers uncompress
# information on the fly. Note: Not all browsers support this.
# Despite the name similarity, the following Add* directives have nothing
# to do with the FancyIndexing customization directives above.
#
AddEncoding x-compress .Z
AddEncoding x-gzip .gz .tgz
#
# If the AddEncoding directives above are commented-out, then you
# probably should define those extensions to indicate media types:
#
#AddType application/x-compress .Z
#AddType application/x-gzip .gz .tgz
#
# AddHandler allows you to map certain file extensions to "handlers",
# actions unrelated to filetype. These can be either built into the server
# or added with the Action command (see below)
#
# If you want to use server side includes, or CGI outside
# ScriptAliased directories, uncomment the following lines.
#
# To use CGI scripts:
#
#AddHandler cgi-script .cgi
#
# To use server-parsed HTML files
#
#AddType text/html .shtml
#AddHandler server-parsed .shtml
#
# Uncomment the following line to enable Apache's send-asis HTTP file
# feature
#
#AddHandler send-as-is asis
#
# If you wish to use server-parsed imagemap files, use
#
#AddHandler imap-file map
#
# To enable type maps, you might want to use
#
#AddHandler type-map var
</IfModule>
<IfModule mod_setenvif.c>
#
# The following directives modify normal HTTP response behavior.
# The first directive disables keepalive for Netscape 2.x and browsers that
# spoof it. There are known problems with these browser implementations.
# The second directive is for Microsoft Internet Explorer 4.0b2
# which has a broken HTTP/1.1 implementation and does not properly
# support keepalive when it is used on 301 or 302 (redirect) responses.
#
BrowserMatch "Mozilla/2" nokeepalive
BrowserMatch "MSIE 4\.0b2;" nokeepalive downgrade-1.0 force-response-1.0
#
# The following directive disables HTTP/1.1 responses to browsers which
# are in violation of the HTTP/1.0 spec by not being able to grok a
# basic 1.1 response.
#
BrowserMatch "RealPlayer 4\.0" force-response-1.0
BrowserMatch "Java/1\.0" force-response-1.0
BrowserMatch "JDK/1\.0" force-response-1.0
</IfModule>
<IfDefine SSL>
AddType application/x-x509-ca-cert .crt
AddType application/x-pkcs7-crl .crl
</IfDefine>
<IfModule mod_ssl.c>
SSLPassPhraseDialog builtin
SSLSessionCache dbm:/var/run/ssl_scache
SSLSessionCacheTimeout 300
SSLMutex file:/var/run/ssl_mutex
SSLRandomSeed startup builtin
SSLRandomSeed connect builtin
SSLLog /var/log/ssl_engine_log
SSLLogLevel info
</IfModule>
<IfDefine SSL>
<VirtualHost _default_:443>
DocumentRoot "/usr/local/www/data"
ServerName new.host.name
ServerAdmin you@your.address
ErrorLog /var/log/httpd-error.log
TransferLog /var/log/httpd-access.log
SSLEngine on
SSLCipherSuite ALL:!ADH:!EXPORT56:RC4+RSA:+HIGH:+MEDIUM:+LOW:+SSLv2:+EXP:+eNULL
SSLCertificateFile /usr/local/etc/apache/ssl.crt/server.crt
SSLCertificateKeyFile /usr/local/etc/apache/ssl.key/server.key
<Files ~ "\.(cgi|shtml|phtml|php3?)$">
SSLOptions +StdEnvVars
</Files>
<Directory "/usr/local/www/cgi-bin">
SSLOptions +StdEnvVars
</Directory>
SetEnvIf User-Agent ".*MSIE.*" \
nokeepalive ssl-unclean-shutdown \
downgrade-1.0 force-response-1.0
CustomLog /var/log/ssl_request_log \
"%t %h %{SSL_PROTOCOL}x %{SSL_CIPHER}x \"%r\" %b"
</VirtualHost>
</IfDefine>
localhost#
Re: roundcube mysql
Добавлено: 2008-04-29 8:03:58
trop1k
Создал юзера roundcube с паролём roundcube( GRANT ALL PRIVELEGES ON *.* TO roundcube@"%" IDENTIFIED BY 'roundcube' WITH GRANT OPTION; ), потом создал базу даннных roundcube( mysqladmin -u root -p create roundcube), потом сделал запрос на www/rouncube/SQL/mysql.initial.sql. Потом захожу на апача сервер в директорию roundcube ( 62.205.227.97:80/roundcube/) и пишет мне:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
П.с. делал всё по статье начиная с установки roundcube
http://www.lissyara.su/?id=1543 только виртуальный хост недобовлял.
После чего идем редактировать конфиги.
В /usr/local/www/rouncube/configs/db.inc.php добавляем информацию о postgres по примеру:
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';
Объясните эту строку что тут пароль, логин и база.
Re: roundcube mysql
Добавлено: 2008-04-29 9:14:40
trop1k
trop1k писал(а):Создал юзера roundcube с паролём roundcube( GRANT ALL PRIVELEGES ON *.* TO roundcube@"%" IDENTIFIED BY 'roundcube' WITH GRANT OPTION; ), потом создал базу даннных roundcube( mysqladmin -u root -p create roundcube), потом сделал запрос на www/rouncube/SQL/mysql.initial.sql. Потом захожу на апача сервер в директорию roundcube ( 62.205.227.97:80/roundcube/) и пишет мне:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
П.с. делал всё по статье начиная с установки roundcube
http://www.lissyara.su/?id=1543 только виртуальный хост недобовлял.
После чего идем редактировать конфиги.
В /usr/local/www/rouncube/configs/db.inc.php добавляем информацию о postgres по примеру:
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';
Объясните эту строку что тут пароль, логин и база.
Помогите плз.
Re: roundcube mysql
Добавлено: 2008-04-29 9:59:51
moadip
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';
где:
roundcube имя
pass пароль
localhost куда коннект
roundcubemail имя БД
Re: roundcube mysql
Добавлено: 2008-04-29 12:42:44
lodErunnEr
trop1k писал(а):Создал юзера roundcube с паролём roundcube( GRANT ALL PRIVELEGES ON *.* TO roundcube@"%" IDENTIFIED BY 'roundcube' WITH GRANT OPTION; ), потом создал базу даннных roundcube( mysqladmin -u root -p create roundcube), потом сделал запрос на www/rouncube/SQL/mysql.initial.sql. Потом захожу на апача сервер в директорию roundcube ( 62.205.227.97:80/roundcube/) и пишет мне:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
П.с. делал всё по статье начиная с установки roundcube
http://www.lissyara.su/?id=1543 только виртуальный хост недобовлял.
После чего идем редактировать конфиги.
В /usr/local/www/rouncube/configs/db.inc.php добавляем информацию о postgres по примеру:
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';
Объясните эту строку что тут пароль, логин и база.
попробуйте сделать вот так:
1. Зайди сюда:
http://www.roundcube.net/downloads - скачай последнюю версию roundcube
2. Разархивируй ее в папку, доступную апачу. Выдай необходимые права (chown -R www:www ./roundcube)
3. Зайди броузером http:\\хост_где_лежит_раункуб\installer
4. Следуй инструкциям
Re: roundcube mysql
Добавлено: 2008-04-29 13:13:26
trop1k
Спасибо у меня уже работает, только немогу связать с базой MYSQL postfix.
2) virtuser_query (SQL)
$rcmail_config['virtuser_query'] = "SELECT email_address FROM database.table WHERE login = '%u'";
If you are using postfix and/or some kind of hosting panel, chances are your email accounts are already stored in a SQL table. If that is the case, you want to lookup the emails with a virtuser_query. The parts of the example query:
// email_address - the first column returned by the query must be the complete email address
// database - name of the database where your table is located, the roundcube db user must have read access
// table - name of the table where your email addresses are stored
// login - name of the field that contains the username that is used to log in to roundcube (and send/receive email)
У себя пишу main.inc.php:
// Query to resolve user names and e-mail addresses from the database
// %u will be replaced with the current username for login.
// The query should select the user's e-mail address as first col
$rcmail_config['virtuser_query'] = "SELECT email_address FROM postfix.mailbox WHERE login = '%u'";
и неработает.База postfix, таблица mailbox.
Database: postfix Table: mailbox
+----------+--------------+-------------------+------+-----+---------------------+-------+---------------------------------+---------+
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
+----------+--------------+-------------------+------+-----+---------------------+-------+---------------------------------+---------+
| username | varchar(255) | latin1_swedish_ci | NO | PRI | | | select,insert,update,references | |
| password | varchar(255) | latin1_swedish_ci | NO | | | | select,insert,update,references | |
| name | varchar(255) | latin1_swedish_ci | NO | | | | select,insert,update,references | |
| maildir | varchar(255) | latin1_swedish_ci | NO | | | | select,insert,update,references | |
| quota | int(10) | | NO | | 0 | | select,insert,update,references | |
| domain | varchar(255) | latin1_swedish_ci | NO | | | | select,insert,update,references | |
| created | datetime | | NO | | 0000-00-00 00:00:00 | | select,insert,update,references | |
| modified | datetime | | NO | | 0000-00-00 00:00:00 | | select,insert,update,references | |
| active | tinyint(1) | | NO | | 1 | | select,insert,update,references | |
+----------+--------------+-------------------+------+-----+---------------------+-------+---------------------------------+---------+
localhost#
Re: roundcube mysql
Добавлено: 2008-04-29 13:33:18
lodErunnEr
а зачем ему с базой постфикса связываться? он через imap|smtp с постфиксом работает. попробуй сделай, как я предложил.. installer все протестирует и скажет, где у тебя лажа.
Re: roundcube mysql
Добавлено: 2008-04-29 13:51:33
trop1k
Checking php.ini/.htaccess settings
file_uploads: OK
session.auto_start: OK
magic_quotes_gpc: NOT OK(is '1', should be '0')
magic_quotes_sybase: OK
Sorry but your webserver does not meet the requirements for RoundCube!
Please install the missing modules or fix the php.ini settings according to the above check results.
Hint: only checks showing NOT OK need to be fixed.
Re: roundcube mysql
Добавлено: 2008-04-29 14:28:21
lodErunnEr
trop1k писал(а):Checking php.ini/.htaccess settings
file_uploads: OK
session.auto_start: OK
magic_quotes_gpc: NOT OK(is '1', should be '0')
magic_quotes_sybase: OK
Sorry but your webserver does not meet the requirements for RoundCube!
Please install the missing modules or fix the php.ini settings according to the above check results.
Hint: only checks showing NOT OK need to be fixed.
Во!
1. cd /usr/local/etc
2. cp php.ini-dist php.ini
3. ee php.ini
4. ищем параметр magic_quotes_gpc
5. Изменяем On на Off
6. Сохраняемся
7. apachectl restart
8. рефрешим страницу, которая говорила про magic_quotes_gpc: NOT OK(is '1', should be '0')
Re: roundcube mysql
Добавлено: 2008-04-29 14:33:37
trop1k
Re: roundcube mysql
Добавлено: 2008-04-29 14:40:26
lodErunnEr
а через телнет imap работает?
Re: roundcube mysql
Добавлено: 2008-04-29 14:57:04
trop1k
Работает вроде:
Код: Выделить всё
localhost# telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK Hello there.
user proverka@belka.lv
+OK Password required.
pass proverka
+OK logged in.
Поменял порт на 110 зависает и долго думает, нечего непишет потом в логе появляется mailog:
Код: Выделить всё
Apr 29 09:55:52 localhost courier-imap: TIMEOUT, user=proverka@belka.lv, ip=[127.0.0.1], port=[53756], top=0, retr=0, rcvd=0, sent=16, time=311
Re: roundcube mysql
Добавлено: 2008-04-29 15:07:47
lodErunnEr
хм .. при чем тут 110.. нам имап ж ведь нужен. имап - 143
Re: roundcube mysql
Добавлено: 2008-04-29 15:17:16
trop1k
Ети процесы запушени вроде в них имап нету:
Код: Выделить всё
localhost# telnet localhost 143
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
Trying ::1...
telnet: connect to address ::1: Connection refused
telnet: Unable to connect to remote host
localhost# sockstat -4
USER COMMAND PID FD PROTO LOCAL ADDRESS FOREIGN ADDRESS
root kget 1223 10 udp4 *:* *:*
root Xorg 1113 3 tcp4 *:6000 *:*
root sshd 1032 4 tcp4 *:22 *:*
vscan perl5.8.8 1026 6 tcp4 127.0.0.1:10024 *:*
vscan perl5.8.8 1025 6 tcp4 127.0.0.1:10024 *:*
root couriertcp 1005 3 tcp4 *:110 *:*
root master 951 11 tcp4 *:25 *:*
root master 951 84 tcp4 127.0.0.1:10025 *:*
vscan perl5.8.8 876 6 tcp4 127.0.0.1:10024 *:*
root perl5.8.8 875 5 tcp4 127.0.0.1:783 *:*
root perl5.8.8 874 5 tcp4 127.0.0.1:783 *:*
root perl5.8.8 866 5 tcp4 127.0.0.1:783 *:*
www httpd 864 16 tcp4 *:443 *:*
www httpd 864 17 tcp4 *:80 *:*
www httpd 863 16 tcp4 *:443 *:*
www httpd 863 17 tcp4 *:80 *:*
www httpd 862 16 tcp4 *:443 *:*
www httpd 862 17 tcp4 *:80 *:*
www httpd 861 16 tcp4 *:443 *:*
www httpd 861 17 tcp4 *:80 *:*
www httpd 860 16 tcp4 *:443 *:*
www httpd 860 17 tcp4 *:80 *:*
root httpd 854 16 tcp4 *:443 *:*
root httpd 854 17 tcp4 *:80 *:*
root nfsd 759 3 tcp4 *:2049 *:*
root mountd 757 4 udp4 *:988 *:*
root mountd 757 5 tcp4 *:830 *:*
root rpcbind 713 9 udp4 *:111 *:*
root rpcbind 713 10 udp4 *:635 *:*
root rpcbind 713 11 tcp4 *:111 *:*
root syslogd 693 7 udp4 *:514 *:*
Courier-imap это нето?
# /usr/local/etc/rc.d/courier-imap-pop3d.sh start
Starting courier_imap_pop3d.
Re: roundcube mysql
Добавлено: 2008-04-29 15:22:07
lodErunnEr
эх..... у тебя не работает imap сервер. т.е. настраивай сначала imap, а потом возвращайся к установке roundcube.
Re: roundcube mysql
Добавлено: 2008-04-29 15:24:48
trop1k
Ссылки нет случаем на настройку?
Re: roundcube mysql
Добавлено: 2008-04-29 15:42:14
lodErunnEr
trop1k писал(а):Ссылки нет случаем на настройку?
есть=)
http://www.google.com
еще вот тут было очень подробно
http://www.sys-adm.org.ua
Re: roundcube mysql
Добавлено: 2008-04-29 15:43:23
trop1k
Всем спасибо за помошь. Есть ешё одна маленькая просьба, если кто знает почему konqueror открывая ссылки и страницы, пытается их скачать из за етого я немогу перейти на другие ссылки и страницы.
Re: roundcube mysql
Добавлено: 2008-04-29 19:20:46
trop1k
Postfixadmin конфликтует с roundcube пишет:
Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in /usr/local/www/postfixadmin/functions.inc.php on line 132
functions.inc.php
Код: Выделить всё
function escape_string ($string)
{
global $CONF;
if (get_magic_quotes_gpc () == 0)
{
if ($CONF['database_type'] == "mysql") $escaped_string = mysql_real_escape_string ($string);
if ($CONF['database_type'] == "mysqli") $escaped_string = mysqli_real_escape_string ($string); <<<132
if ($CONF['database_type'] == "pgsql") $escaped_string = pg_escape_string ($string);
}
else
{
$escaped_string = $string;
}
return $escaped_string;
}
Блин чтож делать, как создавать новых пользователей и алиасы тогда неработают.
Также неотсилает письма, ранше отсилал а теперй нет вот лог:
Код: Выделить всё
Apr 29 14:48:21 localhost postfix/qmgr[1011]: F39CD6768: from=<proverka@belka.lv>, size=955, nrcpt=1 (queue active)
Apr 29 14:48:21 localhost amavis[953]: (00953-04) Passed CLEAN, MYNETS LOCAL [127.0.0.1] [127.0.0.1] <proverka@belka.lv> -> <anatolijsfedotovs@gmail.com>, Message-ID: <b7da269327eca5c71cd99a0ccdd9c51b@localhost>, mail_id: NcL9hKsY17+b, Hits: 1.94, size: 529, queued_as: F39CD6768, 2831 ms
Apr 29 14:48:21 localhost postfix/smtp[2075]: 27D465C59: to=<anatolijsfedotovs@gmail.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=2.9, delays=0.01/0.01/0/2.8, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as F39CD6768)
Apr 29 14:48:21 localhost postfix/qmgr[1011]: 27D465C59: removed
Apr 29 14:48:52 localhost postfix/smtp[2081]: connect to gmail.com[64.233.161.83]: Operation timed out (port 25)
Apr 29 14:49:19 localhost authdaemond: Authenticated: sysusername=<null>, sysuserid=1981, sysgroupid=1981, homedir=/var/spool/mail/, address=proverka@belka.lv, fullname=proverka, maildir=belka.lv/proverka@belka.lv/, quota=0, options=<null>
Apr 29 14:49:19 localhost authdaemond: Authenticated: clearpasswd=proverka, passwd=<null>
Apr 29 14:49:19 localhost imapd: LOGIN, user=proverka@belka.lv, ip=[127.0.0.1], port=[51545], protocol=IMAP
Apr 29 14:49:19 localhost imapd: LOGOUT, user=proverka@belka.lv, ip=[127.0.0.1], headers=0, body=0, rcvd=46, sent=432, time=0
Apr 29 14:49:22 localhost postfix/smtp[2081]: connect to gmail.com[72.14.253.83]: Operation timed out (port 25)
Apr 29 14:49:53 localhost postfix/smtp[2081]: connect to gmail.com[64.233.171.83]: Operation timed out (port 25)
Apr 29 14:49:53 localhost postfix/smtp[2081]: F39CD6768: to=<anatolijsfedotovs@gmail.com>, relay=none, delay=92, delays=0/0.01/92/0, dsn=4.4.1, status=deferred (connect to gmail.com[64.233.171.83]: Operation timed out)