TweezerMan
Members-
Posts
1,763 -
Joined
-
Last visited
Everything posted by TweezerMan
-
Oscommerce, Multiple Domains, And Email Questions
TweezerMan replied to mp_at_fuse's topic in Pre-Sales Questions
Yes, two virtual hosting accounts generally are cheaper than a single reseller account. I'm not entirely sure what you mean by "cross-reference the hyperlinks", but if you mean just have regular hyperlinks between the accounts, you might think about just parking the second domain on top of the first one. It would save you the cost of a second virtual hosting account, but it could not point directly at your OSCommerce store (it would point at the main page of your account). -
I'm not really familiar with restoring a database backup using CPanel - I use phpMyAdmin instead. Whether you use CPanel or phpMyAdmin, you should create the database first and add a user to that database before restoring a database backup. (This is required if you use phpMyAdmin to restore the database; I'm not sure if it is or not when using CPanel to restore the database.) After the empty database has been created, the database that a backup will be restored to is easily selectable in phpMyAdmin. (In fact, you have to tell phpMyAdmin which database to restore a backup to.) To restore a database using phpMyAdmin, you would select the database in the dropdown box on the left side of the page, then click the 'SQL' tab. Near the bottom of the page is a 'Location of the textfile:' box. Click the 'Browse' button to select the backup file (located on your PC), which will then be uploaded to the server and the data restored to the database. Hope this helps...
-
Oscommerce, Multiple Domains, And Email Questions
TweezerMan replied to mp_at_fuse's topic in Pre-Sales Questions
Welcome to the TCH forums, mp_at_fuse! TCH servers can and do run OSCommerce. It can be installed from CPanel, but I suspect you will probably want to install OSCommerce yourself. There are TCH customers who use OSCommerce, but I don't know who they are off the top of my head. Maybe one or more of them will see this thread and post about their experience with OSCommerce. With a virtual hosting account, pointing a domain at a subfolder of your TCH-hosted web site (mainsite.com.au/catalog) would be a violation of the Acceptable Use Policy. You would have to purchase a reseller account in order to do this. Unlimited mail accounts really means unlimited mail accounts. The practical limit here is that your account must not cause load issues on the server or negatively impact other users on the same server as you, but there is not a numerical limit on the number of e-mail accounts that you can set up. Hope this helps... -
I agree that adding bandwidth would not be much of a solution, if it were just going to be used up by the hotlinkers. In this case, since you've enabled hotlink protection, hopefully that would no longer be a problem, and adding bandwidth to your site would allow you and your legitimate visitors access back into your site. Considering that this is only the 5th of the month, and you've already used up your bandwidth allocation (20GB?), I do think that an analysis of your server logs would be in order to see where it all went.
-
A "typical" cookie path would be "/", which would make the cookie valid for your entire web site ("/" specifies the root directory of your web site). Make sure your browser is set to accept cookies from your site. Make sure that you log into phpBB using the same domain as what's configured in phpBB. Don't use a link to 'www.my-TCH-domain.com' to log in if phpBB is configured to use 'my-TCH-domain.com', as these are different domains as far as cookies are concerned. If you have any redirects set up on your site, they will cause any cookies that your browser is sending to be discarded. For example, if you log into 'www.my-TCH-domain.com', which redirects to 'my-TCH-domain.com', or you have a redirect from 'http://my-TCH-domain.com' to 'http://my-TCH-domain.com/phpBB/, the cookies sent by your browser would get lost in the redirect. Hope this helps...
-
Please Help With Mysql Backup (run W/ Cron Job)
TweezerMan replied to MarkMan's topic in Scripting Talk
Just changing 'mutt' to 'sendmail' won't work, as mutt and sendmail have different command lines and different options. Sendmail does not allow specifying the file name of an attachment in its command line, so the script would need to construct the e-mail itself (which would require lines of additional code) before calling sendmail. If mutt is not available on your server, and the Help Desk will not install it, and you'd like to be e-mailed your database backups, I'd suggest looking for a different script (probably one written in PHP, rather than a shell script). -
Welcome to the forums, Mickh! For this particular issue (people linking to your images on other web sites), hotlink protection is indeed the best way to stop those other sites from soaking up your bandwidth. myspace.com appears to be a community of personal sites somewhat like LiveJournal. The different 'friendID' parameters in the referer links are to different myspace.com pages. In the screenshot you posted, there were 7 hits from 7 different myspace.com sites in the space of 5 seconds. I'd say you're on the right track.
-
The path to the script needs to be specified as /home/cpanelName/public_html/full_backup.php, where 'cpanelName' is your CPanel username: >php /home/cpanelName/public_html/full_backup.php
-
It sounds like the path to your script isn't specified correctly in the cron job. If you post what you have for the cron job command, someone here should be able to tell you how to fix it.
-
I had to go back to Aug. 2005 to find an example of what you're describing: >http://www.aftertastebliss.com/archives/2005/08/ The sidebar is not appearing because the PHP include for it is not getting processed. This is in the HTML source for the Aug. 2005 monthly archive page: ><?php include "http://www.aftertastebliss.com/sidebar.php"; ?> As to why this is occurring: It appears that in some cases, you have both an index.html and an index.php version of your monthly archive pages. With URLs like you are using above (no file name at the end of the URL), if an index.html page exists, it will be retrieved even if an index.php page exists, and PHP code in the page will not be processed. Both of these pages exist on your server: >http://www.aftertastebliss.com/archives/2005/08/index.html http://www.aftertastebliss.com/archives/2005/08/index.php The index.html page does not display the right sidebar; the index.php page does display it. The easiest solution would be to delete the index.html versions of your monthly archive pages from server, leaving the index.php versions to be displayed. Hope this helps...
-
TCH does not support or install 3rd party scripts or manage databases for its customers. If you need to hire someone to performs these functions for you, you'll need to search for these people off of the forums.
-
Welcome to the forums, theluckyman! If your site is using some sort of forum software, these things may already be built into it, or available as an add-on module ('mod'). Otherwise, you'd have to write your own code to add these things to your site.
-
Please Help With Mysql Backup (run W/ Cron Job)
TweezerMan replied to MarkMan's topic in Scripting Talk
Welcome to the forums, MarkMan! -
Welcome to the forums, suzen!
-
Congratulations, and welcome to the TCH team, Aaron!
-
Help ! New Customer In Big Trouble !
TweezerMan replied to mangla_nsit's topic in Script Suggestions
Welcome to the forums, mangla_nsit! Insulting and complaining about the people you want help from is not a good way to get help with your issues. With that said... This statement is not accurate. IPB is compatible with both MySQL 4.0.x and 4.1.x. The problem here is that you are trying to import a MySQL 4.1.x database into a MySQL 4.0.x server, which generally will not work. You need to re-export your database from your old hosting account, making sure that the export is downgraded for use with a MySQL 4.0.x server. The MySQL documentation describes one method for exporting a downgraded database. If you phpMyAdmin available on your old hosting account, it may include the option to export a database and downgrade it to MySQL 4.0. That is one of the incompatibilites between MySQL 4.0 and 4.1 (but by no means the only one): In MySQL 4.0, timestamps are in the format of 'YYYYMMDDHHMMSS'. These formats are not compatible. I would fully expect errors to occur when importing timestamps in MySQL 4.1 format into a MySQL 4.0 database. There is nothing the Help Desk can do to assist you with this issue - they have no means to downgrade your data so it can be imported into a MySQL 4.0 server. You need to re-export and downgrade your data from your old hosting account while you still can. Otherwise, you are pretty much stuck. -
We'll Need A New "hurricane" Topic If This Keeps On!
TweezerMan replied to Deverill's topic in Open Discussion
Lo-Fi version of forums. -
As Tom said above, CPanel does not include files owned by 'nobody' in the 'Disk Usage' total on the CPanel main page.
-
Welcome to the forums, Peter!
-
Welcome to the forums, essenceofire!
-
Need Perl Header / Sendmail Program Location
TweezerMan replied to bconza's topic in Installing Scripts
Welcome to the forums, Brannon! -
This is what I found:
-
Welcome to the forums, jackaroo! From what I can tell by reading the WSH documentation, the methods you're using in your script do not support running a script via a URL, nor do they support remote execution of scripts on a non-Windows server. To run a script on your account by merely performing an HTTP 'GET' request on its URL, I believe the following script would do what you want: >Dim url 'URL to retrieve Dim sHTML 'String to hold HTML sent by server url = "http://www.MyWebSite.com/MyPath/MyScript.php" sHTML = HTTPGet(url) Function HTTPGet(strURL) Dim strReturn Dim objHTTP If Len(strURL) Then Set objHTTP = WScript.CreateObject("Microsoft.XMLHTTP") objHTTP.open "GET", strURL, False objHTTP.send strReturn = objHTTP.responseText End If HTTPGet = strReturn End Function
-
Welcome to the forums, anantha.krish!
-
Automating Backups & Visitor Logs
TweezerMan replied to miner2049er's topic in CPanel and Site Maintenance
You can do either one by setting up a mysqldump command in a cron job. I use the following to backup a single database: >mysqldump --quick --all --add-drop-table --add-locks --lock-tables --quote-names --user=cpanelname_username --password=mypassword cpanelname_dbname | gzip -c > /home/username/backup/mysql-backup.sql.gz a) Replace 'cpanelname_username' with your MySQL username. Replace 'mypassword' with your MySQL password. c) Replace 'cpanelname_dbname' with your MySQL database name. d) Replace '/home/username/backup/mysql-backup.sql.gz' with the path and file name you want to save the database backup to. You can backup all of your database by replacing the database name in the above command with the option '--all-databases'. (I'd probably also add the '--add-drop-database' option to the command as well.) There are also scripts available that can do the backup and can be run from a cron job. There was one discussed on the forums recently that could e-mail you the backup file if you wished. The database backups will go into whatever directory the command or script run by cron puts them in. I created a directory outside of my public_html directory for them (/home/username/backup) so they could not be accessed or downloaded from a browser. The server logs are stored in /home/username/logs (at least they are on my hosting account). I don't know what determines the cutoff of logs from one month to the next, but the monthly logs do not start at 12:00 AM on the 1st day of the month and end at 11:59 PM on the last day of the month. I took a look at my server logs for last month (October), and the first entry is September 30, around 1:00 AM, and the last entry is October 31, around 2:00 AM. You can store them on the server (counting against your disk space quota), but since the logs are saved as compressed files, you generally won't be able to view the actual log data from the server. You'd need to download the log file and extract the log, then you could view it in a text editor or use a script or application to process and analyze it.
