MRatWork Forum by Mustafa Ramadhan
Sawo Project - Kloxo-MR Discussions => Kloxo-MR Technical Helps => Topic started by: WISTFUL on 2013-02-19, 00:23:31
-
When I try http://webmail.domain.ltd/ (http://webmail.domain.ltd/), follow error appeared on Roundcube Webmail:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
-
you need 'sh /script/fixwebmail'. This issue appear when replace kloxo*.rpm with kloxomr*.rpm.
-
I try it but issue still not solved
-
How about other webmail (horde or others)?.
-
I changed Webmail System Default from General Settings and also domain but Roundcube is still running :?
-
Try 'sh /script/fixvpop' in found fail login.
-
It doesn't work. I've not change my kloxo and root password yet. Can you try it your self?
-
What you mean 'I changed Webmail System Default from General Settings and also domain but Roundcube is still running'?
-
After you said:
How about other webmail (horde or others)?.
, I try change my webmail script from Roundcube to horde via :
Kloxo Home > General Settings > Webmail System DefaultBut Roundcube still running when I try http://webmail.domain.ltd/ (http://webmail.domain.ltd/) (you can see my default domain on kloxo and test it your self)
-
After that, run 'sh /script/fixweb; service httpd restart; service nginx restart; service php-fpm restart'.
This bug also found on Kloxo Official.
-
Why not choose '--chooser--' rather than certain webmail apps?
-
Afterlogic:
Can't connect to database.
Horde:
A fatal error has occurred
DB Error: extension not found
Details have been logged for the administrator.
Roundcube:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Squirrelmail: no error
T-dah:
Login Error - You cannot Login with the Username and Password Entered.
Please check the Username and Password and try again.
Just Squirrelmail does work!
-
Try 'yum list kloxo*'. If you found 'kloxomr-' instead 'kloxo-' so run 'sh /script/fixwebmail'.
-
I found 'kloxomr-'
but already tryed 'sh /script/fixwebmail' and 'sh /script/fixvpop'
Issue still remains ...
-
I found the same issue after update to kloxomr*.rpm. But, running 'sh /script/fixwebmail' fixed this issue.
-
I sent you my server login details.
If this issue + FTP issue (http://forum.mratwork.com/viewtopic.php?f=5&t=1350) + djbdns issue (http://forum.mratwork.com/viewtopic.php?f=5&t=1335#p3173) can be resolved, today I can move my old server to new by kloxo-mr on it! :P
-
Sorry for djbdns. I will change this djbdns to powerdns. On your issue, change djbdns to bind/named via 'switch applications'
-
For pureftp, change /etc/xinetd.d/pureftp to:
service ftp
{
disable = no
socket_type = stream
wait = no
user = root
server = /usr/sbin/pure-ftpd
server_args = -A -c5000 -C8 -D -fftp -H -I15 -lpuredb:/etc/pure-ftpd/pureftpd.pdb -lunix -L2000:8 -m4 -s -p30000:50000 -U133:022 -u100 -Oclf:/var/log/kloxo/pureftpd.log -g/var/run/pure-ftpd.pid -k99 -Z -Y 1
groups = yes
flags = REUSE
}
and then restart xinetd with 'service xinetd restart'
-
For pureftp, change /etc/xinetd.d/pureftp to:
service ftp
{
disable = no
socket_type = stream
wait = no
user = root
server = /usr/sbin/pure-ftpd
server_args = -A -c5000 -C8 -D -fftp -H -I15 -lpuredb:/etc/pure-ftpd/pureftpd.pdb -lunix -L2000:8 -m4 -s -p30000:50000 -U133:022 -u100 -Oclf:/var/log/kloxo/pureftpd.log -g/var/run/pure-ftpd.pid -k99 -Z -Y 1
groups = yes
flags = REUSE
}
and then restart xinetd with 'service xinetd restart'
Unfortunately, the pureftp issue lingers on!
-
What' you mean 'lingers on!'.
In all my servers, I can access via ftp client (filezilla) to all my servers within protocol FTP (SFTP not work) with 'plain text' or 'Require explicit FTP over TLS' ('Require implicit FTP over TLS' not work).
-
My english is not good! Sometimes I get help from google translate. My mean was "The problem still remains"
I have not any problem by connecting via ftp. As I said on This topic (http://forum.mratwork.com/viewtopic.php?f=5&t=1350&p=3169#p3169), The problem occurs when I try to change FTP port.
When I try to change FTP port from 21 by this instruction: (http://forum.lxcenter.org/index.php?t=msg&goto=86473& ;amp ;: (http://forum.lxcenter.org/index.php?t=msg&goto=86473&:)) get follow email notification every 5min by koloxo System Monitor:
Host: xxx
Date: Feb-19 06:18
Port: 21
Action: /etc/init.d/xinetd restart
-
Changing port may not work because watchdog detect pureftp via port 21.
You can access ftp via 'require explicit ftp via tls' authentication. What's the meaning for this?. We know ftp, sftp and ftps. But pureftp only able for ftp but your authentication able with ssl via 'require explicit ftp via tls'. So, connection still non-ssl but authentication use ssl.
-
Changing port may not work because watchdog detect pureftp via port 21.
There isn't any way for changing FTP port from 21 to another in watchdog?
Many time ago I changed default FTP port in kloxo without any problem. (by this instruction (http://forum.lxcenter.org/index.php?t=msg&goto=86473&:))
I want to change it to prevent the penetration of hackers.
-
If you think ftp work with another port on Kloxo official, that mean watchdog not work.
Again, it's because watchdog detect ftp via port 21. You can change port in watchdog inside /usr/local/lxlabs/kloxo/etc/watchdog.conf.
You can see:
s:4:"port";s:2:"21";s:6:"action";s:26:"/etc/init.d/xinetd restart"
If want change port 21 to 21000 you must change to:
s:4:"port";s:5:"21000";s:6:"action";s:26:"/etc/init.d/xinetd restart"
-
wow! I think I've found the solution!
After changing FTP port, I disabled port 21 from watchdog by click on Servicename and uncheck Status without any problem and did not get anothe System Monitor email!
Is there any problem with my action?
-
wow! I think I've found the solution!
After changing FTP port, I disabled port 21 from watchdog by click on Servicename and uncheck Status without any problem and did not get anothe System Monitor email!
Is there any problem with my action?
It's ok. Disadvantage, your ftp not monitoring by watchdog.
-
Thanks mustafa!
Just one issue remains!
Why I can not login to my webmail?
-
Again, nothing problem on my servers after running 'sh /script/fixwebmail'.
-
Again, nothing problem on my servers after running 'sh /script/fixwebmail'.
I try all instruction on this topic (http://forum.lxcenter.org/index.php?t=msg&th=16280 (http://forum.lxcenter.org/index.php?t=msg&th=16280)) other than 'sh /script/upcp' that I think has conflict by kloxo-mr but none of them helped me.
-
Information from lxcenter forum irrelevant for Kloxo-MR because too old and not the same approach.
You can try 'yum reinstall kloxomr-webmail*; sh /script/fixwebmail'.
-
Information from lxcenter forum irrelevant for Kloxo-MR because too old and not the same approach.
You can try 'yum reinstall kloxomr-webmail*; sh /script/fixwebmail'.
Does not affected!
-
Again, nothing problem on my servers after running 'sh /script/fixwebmail'.
What do you have innodb settings on your /etc/my.cnf file?
-
Can it related to "Mysql Convert to myisam"?
I converted it again to innodb but does not help.
-
I am always use MyISAM.
-
After upgrade to kloxo-mr v6.5.0.c.2013021901 issue solved! ;)
-
wow! I think I've found the solution!
After changing FTP port, I disabled port 21 from watchdog by click on Servicename and uncheck Status without any problem and did not get anothe System Monitor email!
Is there any problem with my action?
That is not the solution. thanks for guided me to this topic.
After looking into all setting and configuration, I found a fix for this issues. atleast it work for me and no more annoying mail delivered to my mailbox.
Here the fix, after fresh installation of Kloxo MR. You need to disable "Anonymous Ftp". It located on
Server > FTP Config > UNTICK "Enable Anonymous Ftp" > Update
and you are done. no more email. again do not disable monitoring on watchdog. :)
-
I had the same issue after trying to install fresh kloxo-MR with current release Kloxo-MR 6.5.0.c.2013022603
as MR said I have tried to run script "sh /script/fixwebmail" but not resolve the problem, I try to run 'yum reinstall kloxomr-webmail*; sh /script/fixwebmail', I get same result.
Afterlogic:
Can't connect to database.
Horde:
A fatal error has occurred
DB Error: extension not found
Details have been logged for the administrator.
Roundcube:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
Squirrelmail: no error
T-dah:
Login Error - You cannot Login with the Username and Password Entered.
Please check the Username and Password and try again.
Just Squirrelmail does work!
Squirrelmail work but can not send/receive email, horde sometimes can login and send/receive email but many error messages
The preferences backend is currently unavailable and your preferences have not been loaded. You may continue to use the system with default settings.
ErrorDB Error: extension not found
MessageLast login: Never
is this problem related to qmail?
my vps config
- CentOS 6.3 (32)
- kloxo-mr v6.5.0.c.2013022601
- nginx-proxy
- bind
- php 5.4.11
- Php 5.2 As Secondary
- php-fpm event
- MyISAM
-
Nothing change code for qmail-toaster and webmail so far.
Try 'sh /script/sysinfo' and 'yum list dovecot' (because dovecot not official support until now and not work together with qmail).
-
result for "sh /script/sysinfo"
A. Kloxo-MR: 6.5.0.c.2013022603
B. OS: CentOS release 6.3 (Final) i686
C. Apps:
1. MySQL: mysql-5.5.29-1.el6.i686
2. PHP: php54-5.4.11-1.ius.el6.i686
3. Httpd: httpd-2.2.23-1.el6.i686
4. Lighttpd: --uninstalled--
5. Nginx: nginx-1.3.13-1.el6.i686
6. Qmail: qmail-toaster-1.03-1.3.22.mr.el6.i686
D. Php-type (for Httpd/proxy): php-fpm_event
E. Memory:
total used free shared buffers cached
Mem: 384 239 144 0 0 134
-/+ buffers/cache: 105 278
Swap: 384 0 383
and 'yum list dovecot'
Available Packages
dovecot.i686 1:2.1.15-1.mr.el6 kloxo-mr-release-version-arch
-
What's about when run 'sh /script/fixwebmail'?
-
result for 'sh /script/fixwebmail'
Preparing Horde database
- Fix MySQL commands in import files of Horde
- Generating password
- Add password to configuration file
- Database installed
Preparing RoundCube database
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
- Database installed
Preparing T-Dah Database
- No need database
Preparing Afterlogic database
- Fixing MySQL commands in import files
- Generating password
- Add Password to configuration file
- Database installed
Preparing Squirrelmail Database
- No need database
Install Webmail chooser
- Install process
-
Look like nothing wrong with your server.
Have you try again 'sh /script/cleanup'?. Because if softlimit for mail too lower it's possible fail to login.
-
Look like nothing wrong with your server.
Have you try again 'sh /script/cleanup'?. Because if softlimit for mail too lower it's possible fail to login.
I've tried your suggestion but the result is still the same.
Before I decided to re-use centos 5. Did Mr. mustafa want to see what's going on with my server? I will give you root access to the VPS and my kloxo panel, maybe this could help the development of future Kloxo-MR to be more stable. :)
-
Have you tried sent email from webmail. If you have (let say) admin@domain.com (http://mailto:admin@domain.com) to admin@domain.com and to remote mail (possible your yahoo or gmail account).
Inform here what's effect and log for send/smtp/submission (enough last 10 lines).
-
emails can be sent and successfully received
error after login
(http://forum.mratwork.com/download/file.php?mode=view&id=113&sid=e5fc305182eb1c479600a5d7a5260e92)
error after sent mail
(http://forum.mratwork.com/download/file.php?mode=view&id=112&sid=e5fc305182eb1c479600a5d7a5260e92)
-
Try with 'sh /scriptf/fixphp'. Error maybe php.ini not from Kloxo-MR.
File php.ini from Kloxo-MR just around 5KB but original php.ini around 70KB.
-
sh /script/fixphp
service kloxo restart
service httpd restart
service php-fpm restart
same result :cry:
I try to change default webmail client to roundcube from general setting but nothing change, still horde :cry:
-
I try to change default webmail client to roundcube from general setting but nothing change, still horde :cry:
Please try follows:
#sh /script/fixweb
#service httpd restart
#service nginx restart
#service php-fpm restart
-
So, I think you still using old upload.
For sure, run 'sh /script/sysinfo'.
Try update to latest version and then run 'sh /script/cleanup; sh /script/fixweb; sh /script/fixwebmail; sh /script/restart-services'.
-
sysinfo
A. Kloxo-MR: 6.5.0.c.2013022603
B. OS: CentOS release 6.3 (Final) i686
C. Apps:
1. MySQL: mysql-5.5.29-1.el6.i686
2. PHP: php54-5.4.11-1.ius.el6.i686
3. Httpd: httpd-2.2.23-1.el6.i686
4. Lighttpd: --uninstalled--
5. Nginx: nginx-1.3.13-1.el6.i686
6. Qmail: qmail-toaster-1.03-1.3.22.mr.el6.i686
D. Php-type (for Httpd/proxy): php-fpm_event
-
Try changing webmail to 'system default' on every domains and then run 'sh /script/fixweb; sh /script/restart-services'.
-
Try changing webmail to 'system default' on every domains and then run 'sh /script/fixweb; sh /script/restart-services'.
i try to reinstall and change php to php53u, horde and roundcube work good but aferlogic and squirrelmail can not login, and T-Dah can login but when try to sent mail I got error "It was not possible to send this Email, Check the Address and Try again. SMTP Error: Could not connect to SMTP host."
then I change back to php54, the problem before came again
new sysinfo
A. Kloxo-MR: 6.5.0.c.2013022706
B. OS: CentOS release 6.3 (Final) i686
C. Apps:
1. MySQL: mysql-5.5.29-1.el6.i686
2. PHP: php54-5.4.11-1.ius.el6.i686
3. Httpd: httpd-2.2.23-1.el6.i686
4. Lighttpd: --uninstalled--
5. Nginx: nginx-1.3.13-1.el6.i686
6. Qmail: qmail-toaster-1.03-1.3.22.mr.el6.i686
7. Dns: bind-9.9.2-2.P1.el6.i686
D. Php-type (for Httpd/proxy): php-fpm_event
I thought maybe the problem with the database connection, I try 'yum list php*-mysql*' it turns out the package php54-mysql is not installed. Is this source of the problem?
-
Yes, php54 have a problem with php54-mysql because conflict with php-mysqlnd.
Try 'yum remove php54-mysqnd; yum install php54-mysql; php54-mysqli'.
-
Or try create .htaccess file inside '/home/kloxo/httpd/webmail/roundcube' (example for roundcube) with content 'AddHandler x-httpd-php52 .php'. It's only work with httpd and nginx-/lighttpd-proxy with php-fpm_worker/_event and 'secondary php' enabled.
-
holaa..problem solved :mrgreen:
thanks Mr, I hope this problem can be solved in the next update..
-
Add above trick not good idea. Because no guarantee next version of webmail apps always running well on php 5.2 environment.
Above trick need condition where 'secondary php' enabled. Sadly, mod_php not work with secondary php.
-
Try only using '/home/kloxo/httpd/webmail/.htaccess' with content 'AddHandler x-httpd-php52 .php'. remove 'AddHandler x-httpd-php52 .php' in '.htaccess' under '/home/kloxo/httpd/webmail/' (example under './roundcube').
-
I mean not about about the trick, but about the package conflict. and one more problem that I encountered is that if we change the default webmail client from the panel, we still have to run the script "sh /script/fixwebmail; sh /script/fixweb; sh/ script/restart-services" for the changes to take effect.
-
I mean not about about the trick, but about the package conflict. and one more problem that I encountered is that if we change the default webmail client from the panel, we still have to run the script "sh /script/fixwebmail; sh /script/fixweb; sh/ script/restart-services" for the changes to take effect.
Packages conflict not our responsibility but packages maker. Not all packages serve by Kloxo-MR. Most packages taken from other sources (you can see /etc/yum.repos.d/kloxo-mr.repo).
About packages conflict not only occur on Kloxo/Kloxo-MR but also on CPanel and DirectAdmin (for example). And also occur between Centos version.
-
Same problem here. Can't login in webmail. Tryed roundcube, horde.
A. Kloxo-MR: 6.5.0.c.2013030104
B. OS: CentOS release 6.3 (Final) x86_64
C. Apps:
1. MySQL: mysql-5.5.29-1.el6.x86_64
2. PHP: php-5.3.21-1.el6.x86_64
3. Httpd: httpd-2.2.23-1.el6.x86_64
4. Lighttpd: --uninstalled--
5. Nginx: --uninstalled--
6. Qmail: qmail-toaster-1.03-1.3.22.mr.el6.x86_64
7. Dns: bind-9.9.2-2.P1.el6.x86_64
D. Php-type (for Httpd/proxy): php-fpm_event
But ... after I installed kloxo-mr I could login in webmail even send messege. This issue appeared after a restart services and while I was logged in roundcube. I've noticed an error like : Could not acces your storage and after that I could not re-login in webmail.
The last thinh I've done is to attach a ./htaccess on /home/kloxo/httpd/webmail/roundcube
-
Don't 'skip-innodb' when using mysql 5.5+.
-
Don't 'skip-innodb' when using mysql 5.5+.
Sorry ... what you mean?
BTW ... I have no :Webmail Application" in Kloxo Home ... somehow it disappeared.
-
Have you read your sysinfo where '1. MySQL: mysql-5.5.29-1.el6.x86_64'?
-
Yes ... still not get it!
Thanks.
-
That was an "500 Internal Server" Error on forum server????
-
That was an "500 Internal Server" Error on forum server????
It was.... php-fpm trouble?
-
It was what happend to me, too.
-
Have you read your sysinfo where '1. MySQL: mysql-5.5.29-1.el6.x86_64'?
... any light in this matter? ... please?
-
Same problem here. Can't login in webmail. Tryed roundcube, horde.
A. Kloxo-MR: 6.5.0.c.2013030104
B. OS: CentOS release 6.3 (Final) x86_64
C. Apps:
1. MySQL: mysql-5.5.29-1.el6.x86_64
2. PHP: php-5.3.21-1.el6.x86_64
3. Httpd: httpd-2.2.23-1.el6.x86_64
4. Lighttpd: --uninstalled--
5. Nginx: --uninstalled--
6. Qmail: qmail-toaster-1.03-1.3.22.mr.el6.x86_64
7. Dns: bind-9.9.2-2.P1.el6.x86_64
D. Php-type (for Httpd/proxy): php-fpm_event
But ... after I installed kloxo-mr I could login in webmail even send messege. This issue appeared after a restart services and while I was logged in roundcube. I've noticed an error like : Could not acces your storage and after that I could not re-login in webmail.
The last thing I've done is to attach a ./htaccess on /home/kloxo/httpd/webmail/roundcube
try this, and show me the result
yum list installed php*-fpm php*-mysql*
Don't 'skip-innodb' when using mysql 5.5+.
Sorry ... what you mean?
BTW ... I have no :Webmail Application" in Kloxo Home ... somehow it disappeared.
he mean about your mysql config
-
base | 3.7 kB 00:00
extras | 3.5 kB 00:00
kloxo-mr-centalt | 951 B 00:00
kloxo-mr-centosec | 2.6 kB 00:00
kloxo-mr-epel | 4.3 kB 00:00
kloxo-mr-ius | 2.2 kB 00:00
kloxo-mr-nginx | 1.3 kB 00:00
kloxo-mr-release-neutral-arch | 1.9 kB 00:00
kloxo-mr-release-neutral-noarch | 1.9 kB 00:00
kloxo-mr-release-version-arch | 1.9 kB 00:00
kloxo-mr-release-version-noarch | 1.9 kB 00:00
kloxo-mr-varnish-3.0 | 951 B 00:00
updates | 3.5 kB 00:00
0 packages excluded due to repository protections
Installed Packages
php-fpm.x86_64 5.3.21-1.el6 @kloxo-mr-centalt
php-mysql.x86_64 5.3.21-1.el6 @kloxo-mr-centalt
I have comment in /etc/my.cnf the line #skip-innodb but the rezult is the same.
-
I have read all posts regarding webmail and also I have tried all suggestions.
But still no access to the webmail: "Login Fail".
Please help.
-
I have read all posts regarding webmail and also I have tried all suggestions.
But still no access to the webmail: "Login Fail".
Please help.
I see that php installed on your vps for php-mysql and php-fpm is only default php 5.2, try this
yum install php53-fpm php53-mysql
if conflict with php-mysql/php-fpm try remove that package first
yum remove php-mysql php-fpm -y; yum install php53-mysql php53-fpm -y
-
I've tried even with php54 ... the error is the same: Login failed because your username or password was entered incorrectly.(Horde) and Roundcube (Login fail!).
There is something regards PHP for surely. I've tried to install owncloud 5.0 Beta2 and the result was "Internal Server Error" despite changing php settings in kloxo.
-
it seems you do not do what I suggest, as you have been using php54 then try this
yum install php54-fpm php54-mysql
and then show the result
-
I've followed your advice ... but no improuvment.
But ... I think I've got a sollution, at least for all my problems.
I've changed fpm_event to fpm_worker and php53u.
Now I can logon in webmail, my sites with phph no more "Internel Server Error" and even owncloud page is working.
Maybe this is "the solution"? :)
-
I've followed your advice ... but no improuvment.
But ... I think I've got a sollution, at least for all my problems.
I've changed fpm_event to fpm_worker and php53u.
Now I can logon in webmail, my sites with phph no more "Internel Server Error" and even owncloud page is working.
Maybe this is "the solution"? :)
the results of the previous show me that your system has been installed php-mysql and php-fpm but not for the type you choose, it is actually obvious solution is to install it according to your choice, I have experienced it and I have overcome , you said that it did not work but you do not show me the result, it's not that easy, then we need to know the results before the next step. it seems you just want the script to run on your system but for us not only how the script is running but also with the system that we want, if that is your intention, then good luck :)
-
I've followed your advice ... but no improuvment.
But ... I think I've got a sollution, at least for all my problems.
I've changed fpm_event to fpm_worker and php53u.
Now I can logon in webmail, my sites with phph no more "Internel Server Error" and even owncloud page is working.
Maybe this is "the solution"? :)
the results of the previous show me that your system has been installed php-mysql and php-fpm but not for the type you choose, it is actually obvious solution is to install it according to your choice, I have experienced it and I have overcome , you said that it did not work but you do not show me the result, it's not that easy, then we need to know the results before the next step. it seems you just want the script to run on your system but for us not only how the script is running but also with the system that we want, if that is your intention, then good luck :)
Ok ... I did not understand a word. Can you put all this in english. please?
Thanks.
-
I mean you are asking for help but you do not give us access to your problem. You just say "it does not work" and "it works" but what is the evidence? we do not know.