Try using these following commands:

mysqlcheck --repair -u mythtv -pmythtv mythconverg
and
mysqlcheck --check -u mythtv -pmythtv mythconverg

Securing Mythweb with Apache

This method is slightly more efficient than the .htaccess method, but is complicated by the fact that you must restart Apache and mis-configuring the Apache configuration file will keep Apache from restarting.

Apache password file

We will start with creating an Apache password file. I put this in /etc/httpd/conf, as I back up this directory every night to one of my other systems.

htpasswd -c /etc/httpd/conf/httpd-passwords MYUSER1

Continue reading →

If you are looking to configure your Gargoyle router to load the files from another machine (remote boot), then telnet into your router and update dnsmasq.conf to read:

dhcp-boot=PXEClient/pxelinux.0,random.host.name,192.168.1.xx.

where ‘random.host.name’ is the TFTP server host name and ‘192.168.1.xx’ is the IP address of the same TFTP server.

References:

http://blog.steve.org.uk/my_linksys_router_now_runs_linux_and_almost_provides_pxe_.html

How to bypass WPA (Windows Activation) on Windows XP
Tested on Windows XP Professional SP2 and Windows Server 2003 R2.

Continue reading →

Edit the following file and save:

nano /etc/udev/rules.d/70-persistent-net.rules

Upgrading SheevaPlug’s U-Boot

This page describes how to install a new version of U-Boot on your SheevaPlug. U-Boot is the boot loader used on the SheevaPlug.

Version 3.4.19 integrates SD card support and improves support for FAT32 USB partitions (although USB support in general is still a bit flaky). Version 3.4.23 fixes a minor problem introduced in 3.4.19.

First of all, check which version of U-Boot is installed on your SheevaPlug to find out whether you have to perform this upgrade. Connect to U-Boot using the serial console and type:

version

Continue reading →

Here’s how to make your very own personal Dropbox replacement

1) Install the same version of ‘unison’ both on the server and client.  Install ‘inotify-tools’ on the client.  Create a folder on the client that you would like to use for syncing.

2) Install ‘openssh-server’ on the server.  Create a user on the server with the same name as the client that will be syncing to it.  Also create a sync folder in the user’s home folder.

3) To avoid being asked for the password all the time on the client:

1. Generate an RSA key pair used to authenticate with the server (instead of using a password): ssh-keygen -t rsa
2. Send your RSA key to your server: ssh-copy-id USERNAME@SERVER
3. Now SSH to your server and it shouldn’t ask for a password. If you get an “Agent admitted failure to sign using the key” error, try ‘ssh-add’ and repeat this step.

Continue reading →

This guide attempts to walk you through installing a faxing solution on top of Asterisk that has FreePBX as it’s frontend GUI/dialplan generator.

So for it to work, you need to be

1) Using Debian (this is a Debian guide btw)
2) Have a working Asterisk
3) Running FreePBX 2.7 or higher (don’t need that if you do manual dialplans tho)

The process is as follows:

Continue reading →

How to Change MySQL passwords: Follow each step in order !

Step 1) mysql -u root –p [ENTER]
Step 2) Enter password: passw0rd [ENTER]

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 3743 to server version: 5.0.22

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.

Continue reading →

Configure postfix with Gmail via Webmin

This assumes the user has webmin installed and understands how to log in and use it. (Usually bring it up in a browser at https://localhost:10000 )

• Make sure that postfix is installed. In Webmin this is done by going to “System”, “Software Packages” then clicking on “Package from APT” and entering “postfix”. And you may want to install “mailutils” to test the mail system out.
  • Click on Webmin “Refresh Modules” to get Postfix to show up.
• In Webmin click on “Servers”, “Postfix Mail Server”, “SMTP Authentication And Encryption”.
  • Enter “[smtp.gmail.com]:587 in the “Send outgoing email via host” entry box.
  • Check “Login as” and enter your Gmail user name and password.  (add @gmail.com to your username, if using google apps then add @.com)
• Return to Postfix main page and click on “Virtual Domains”. Add a lookup table by clicking on the “…” next to “Map specifications”.
  • Check and enter a “Mapping file” of “/etc/postfix/generic”, then click “Save”. Click “Save and Apply”.
  • Now go to the “Virtual Domains” page again and click “Add a new mapping.”. Enter the local address to remote address mapping, for example “asterisk@plugpbx.lan” to “my_user@gmail.com” (or @.com if using google apps). An entry should be added for each user that is expected to send mail.
• Modify Config FilesClick on “Edit Config Files”. It should be editing “/etc/postfix/mail.cf” by default. Add this line above “smtp_sasl_password_maps=…” (order of entries seems to matter):

  1	smtp_sasl_auth_enable=yes

  Add this to the bottom of the “main.cf” file and click “Save” (make sure there is a new-line at the end):

  1 2 3 4 5

  ##### client TLS parameters ##### smtp_tls_loglevel=1 smtp_tls_security_level=encrypt smtp_sasl_security_options = noanonymous smtp_generic_maps = hash:/etc/postfix/generic smtp_tls_CAfile = /etc/ssl/certs/ca-certificates.crt

• The easiest way to test sending email is to use the ‘mail’ program:

  1 2 3 4

  sudo apt–get install mailutils echo “test” | mail –s ‘Test 1’ user@testaddress.com # Then check the logs to see if it bounced or had a problem tail /var/log/mail.log

References

http://brakertech.com/configure-postfix-with-gmail-via-webmin