Knowledge Base (All)

Home > Knowledge Base

Knowledge Base (All)

Welcome to e-Comm Enterprises, Inc. Knowledge Base

MySQL: Automate the Bin Log Cleanup

Wednesday, 26 May 2010 02:35 | Written by Administrator |

To automate the Bin Log Clean up you can do the following

mysql –u<USERNAME> –p<PASSWORD>

mysql> set global expire_logs_days=7;

mysql> show variables like “expire%”;

+------------------+-------+
|Variable_name | Value |
+------------------+-------+
|expire_logs_days | 7 |
+------------------+-------+
1 row in set (0.00 sec)

Mysql> quit;

this setting will remain until the server or the mysql service restarts then it will go back to 0, which is the defaut.

To make this change permanent, go to the my.cnf file and insert under the [mysqld] section

expire_logs_days=7

NOTE: Some users claim that this does not work, however it worked for me under Windows and Linux environment, but it is possible that this is Version / Platform specific.

Joomla - Issue after user login

Friday, 14 May 2010 05:08 | Written by WDM |

Joomla Login HTTPS

After user login, a Certificate invalid page is displayed and then, a 404 page not found is displayed.

If you look the URL is showing HTTPS://yourdomain.com/, that means that the login is re-routing the user to an encryptes/secure area which means that the issue is not a bad login script, it is just that your site does not exists under the httpdocs.

To solve this issue you have two options:

1- Create a secure site inside the https area, most Linux server has the forlders setup as “httpdocs” or “httpsdocs”

2- Go to your administrator section select Extensions >> Module Manager >> “Your Login Module” inside your login module look for “Encrypt Login Form” and select “No”.

This should solve that problem.

Issue with http Port - No listening sockets available

Friday, 14 May 2010 04:58 | Written by WDM |

Fedora / Linux / HTTP / Apache

Issue with http Port - No listening sockets available

(98)Address already in use:make_sock:could not bind to address 127.0.0.1:80
no listening sockets available, shutting down

- I tried using just port 80

- I tried putting an actual IP Address

Listen 12.34.56.78:80
Listen 127.0.0.1:80

where 12.34.56.78 is my ip address.

Could not bind to address 127.0.0.1:80 no listening sockets available, shutting down

Nothing was successful until I found out that the problem started when I installed the system-config-httpd, this tool although it makes it easy to modify the settings for Apache, it also causes problems that unless you are an Apache expert you can’t figure it out (Obviously if you were an Apache expert, you wouldn’t need a GUI to configure Apache J )

Last Updated (Friday, 14 May 2010 05:08)

e-Comm Enterprises, Inc.