[email protected] schrieb am 03.01.06 12:23:50:
Hello Flavio
> I try to intstall web-cyradm but on the script create_mysql.sql I got the
> following error
> ERROR 1046 (3D000) at line 17: No database selected
You tried to run the script without selecting a database where you want
to create the tables. That sound for me like you tried to something like
this:
--snip
$ mysql -uUSER -pPASS <create_mysql.sql
--snap
You must create the database and give rights to it before running the
script. Afterwards the better way(s) to run the script would be commands
like following:
--snip v1
$ mysql -uUSER -pPASS DB <create_mysql.sql
--snap
or
--snip v2
$ mysql -uUSER -pPASS
mysql> use DB
Database changed
mysql> source create_mysql.sql
--snap
--
Kind regards,
Roman Hochuli
Operations Manager
Hello,
thank you for your help. The first step is done.
Now I can't login. Is there a configuration error? Below my config.conf.
There is no logs in the logfile web-cyradm-login.log
<?php
########################################################################################
#
# This is web-cyradm Version 0.5.4 CVS
#
#
#########################################################################################
// Set Default language
$DEFAULTLANG = "en_EN";
# The Cyrus login stuff
$CYRUS = array(
'HOST' => 'localhost',
'PORT' => 143,
'ADMIN' => 'cyrus',
'PASS' => 'secret'
);
/* DB_TYPE
Possible Values are:
o mysql
o pgsql
To operate a mailsystem with postgreSQL you will need a patch for
Postfix.
Other Databases need to be supported by PAM and postfix
*/
$DB = array(
'TYPE' => 'mysql',
'USER' => 'mail',
'PASS' => 'secret',
'PROTO' => 'unix', // set to "tcp" for TCP/IP
'HOST' => 'localhost',
'NAME' => 'mail'
);
$DB['DSN'] = sprintf('%s://%s:[EMAIL PROTECTED]/%s', $DB['TYPE'],
$DB['USER'],
$DB['PASS'], $DB['PROTO'],
$DB['HOST'], $DB['NAME']);
# Where should web-cyradm write its log to?
$LOG_DIR = "/var/log/web-cyradm/";
# The default timeout in seconds for a session, after that you have to login
again
$SESS_TIMEOUT = 1000;
# The default quota sets the default quota for new domains
$DEFAULT_QUOTA = 20000;
# Defines if passwords are encrypted or not.
# Valid Values:
# - plain 0 No encription is used
# - crypt 1 (shadow compatible encription)
# - mysql 2 (MySQL PASSWORD function)
# - md5 3 (MD5 digest)
$CRYPT = "crypt";
# web-cyradm is compatible with cyrus-imapd-2.0.16 (and earlier?)
# however, if you are using 2.1.x and wish to use email addresses
# with .'s in them such as '[EMAIL PROTECTED]' you can set this
# option DOMAIN_AS_PREFIX to '1'. NOTE: you also have to add this
# line to your imapd.conf file:
#### imapd.conf: ####
# unixhierarchysep: yes
####
$DOMAIN_AS_PREFIX = 0;
# At the moment, web-cyradm supports two methods of password change:
# - through sql
# - poppassd
# sql is the default
$PASSWORD_CHANGE_METHOD = "sql";
# Turn up error reporting level. This overrides settings in your php.ini
#
# E_ALL - All errors and warnings
# E_ERROR - fatal run-time errors
# E_WARNING - run-time warnings (non-fatal errors)
# E_PARSE - compile-time parse errors
# E_NOTICE - run-time notices (these are warnings which often result
# from a bug in your code, but it's possible that it was
# intentional (e.g., using an uninitialized variable and
# relying on the fact it's automatically initialized to an
# empty string)
# E_CORE_ERROR - fatal errors that occur during PHP's initial startup
# E_CORE_WARNING - warnings (non-fatal errors) that occur during PHP's
# initial startup
# E_COMPILE_ERROR - fatal compile-time errors
# E_COMPILE_WARNING - compile-time warnings (non-fatal errors)
# E_USER_ERROR - user-generated error message
# E_USER_WARNING - user-generated warning message
# E_USER_NOTICE - user-generated notice message
error_reporting(E_ALL);
$VERSION="0.5.4";
# Define reserved Emailadresses (Separated by comma):
$RESERVED="postmaster,root";
#%PAM-1.0
auth sufficient pam_mysql.so user=mail passwd=secret host=localhost db=mail
table=accountuser usercolumn=username passwdcolumn=password crypt=1
logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host
logpidcolumn=pid logtimecolumn=time
auth sufficient pam_unix_auth.so
account required pam_mysql.so user=mail passwd=secret host=localhost db=mail
table=accountuser usercolumn=username passwdcolumn=password crypt=1
logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host
logpidcolumn=pid logtimecolumn=time
account sufficient pam_unix_acct.so
I would appreciate for any help
regards F.MINI
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
