vB Optimise v2.6.0 Beta 4

Integration With Other DBTech Products

• Support for caching of the [DBTech] vBAnswers "Latest X" (Landing Page) (Requires [DBTech] vBAnswers v2.0.0 - not yet released)

Fillip

While doing a quick security audit on an inherited installation of vBulletin, we were looking for recently modified .php files in the application folder and noticed that there is a file in the dbtech/vboptimise/filecache/ directory with a .php extension. (Specifically, the filename is what appears to be hexidecimal hash of some sort, followed by that .php ending.) The file appears to have no actual PHP logic in it, simply exiting from PHP and outputting a JSON object via normal text. (Object parts include what appear to be a "time" and a "value.") The file was modified today and is owned by the user that our webserver runs as.

In the interest of establishing a baseline against which we can do future audits: Is the creation of a .php file in the cache directory a normal behavior for this plugin?

If you are using file system cache (datastore) (vs Memory such as memcached, xcache etc.) then this will be normal as it writes a file to store the cached data and it will vary as the cache changes.

The component doing the writing of this file is ./upload/dbtech/vboptimise/includes/operators/filecache.php:

Thanks! That's very good to know.

To elaborate; the reason why the files are .php as opposed to blank extension or some such, is because .php files can be cached by opcode cachers :)

The filenames are MD5 hashes, btw :)


Fillip

Update

Hotfix: PHP 5.4 Compatibility fixes


This does not guarantee the mod is error free on PHP 5.4, but it will take care of the reported errors. Thank you all for your reports :)



Fillip

I'm still having problems with xcache setting. When i change the opcache operator to xcache and turning on xcache authentication i'm start getting white pages. I've added my xcache username and password into cache.php

Are you sure you put your xcache password in plaintext in the config.php file for vB Optimise, and not the md5 hash?

Fillip

Back in post #178 I was wondering if you ever found a solution to as why the Resource Stats weren't showing except on the forum home. I have the same issue. Everything seems to be working fine - just doesn't report the savings (although the total savings increases every minutes on the What's Going On/forum home).

Thanks. I really like this new version and will be getting the pro version - the guest cache seems like a winner.

Unfortunately not, would you be willing to share your FTP / AdminCP details for me to look into this? Remember to link back to this post to remind me of the issue :)


Fillip

I've installed the lite version and everything seemed to go OK and I plan to get the pro version however I have a couple of questions before I do.

It has been running on my forum for about a day now and the stat at the bottom of the index page is:

MySQL Queries vB Optimise has saved this forum 0

Does this mean it's not actually doing anything for some reason, or is one day too soon for any meaningful number to appear?

If I go into the resource saving statistics in AdminCP the graph tells me it has saved 10000
However what does 10000 mean, and is that likely to be a good number for a forum with around 80 to 100 concurrent users on average?

I'm just trying to get an idea if this thing is working well and a definite benefit to the forum.

Thanks

I have to wonder if the developer has any further interest in this mod or, for that matter, taking some money from me!

Can you please show me a screenshot of your graph?

1 day without response is hardly a reason to jump to that conclusion, especially considering (as stated in the response to your PM) that we offer priority support @ our website :)


Fillip

I had a similar issue with the graph and I discovered some of the files were in my admincp directory and I had renamed it earlier to admincpsecure. I just moved the files and it worked. Not sure if you had renamed your directory as well.

What is this graph actually telling me?

No, I haven't changed any filenames at all, especially anything to do with AdminCP, playing around with that makes me nervous. :)

He's not talking about files. He talking about having renamed the admincp folder itself, but since the product doesn't know admincp is renamed all the admincp files are not in the actual admincp folder.

vB Optimise v2.6.0 Gold

Bug Fixes And Issue Fixes:

• Fixed PHP 5.4 compatibility issues

Fillip

I am using vps and install Kloxo, how to turn off user and pass xcache?

It needs to be turned off in php.ini

find this line in php.ini under the xcache settings:
and change on to off

i can find php.ini in kloxo, i have edit file etc/php.ini but not see xcache in file

Any way to optimize db usage to overcome "max_user_connections" errors?

Also just wanted to check if I should enable the following setting:

Online / Offline:

This setting allows you to globally Enable or Disable vB Optimise.

Simply set this to Yes to enable vB Optimise globally.

This is a MYSQL setting that can be adjusted (if you have permissions/access from your hosting company). http://dev.mysql.com/doc/refman/5.5/...er_connections

This the main ON /OFF setting for this mod. A setting of "Yes" turns this modification on.

I figured it out, thanks.

No settings other than Filecache work, so I'll stick to that. As for the /dbtech/vboptimise/filecache/ directory, does it need to be CHMOD 777 or can it just be CHMOD 755? (it defaulted to 755).

Also, should I enable all the Cache options? I.e. Styles/Templates/Datastore?

To gain the most benefit from this mod you need to install an opcode cacher along with this mod. An opcode cacher compiles the php code, saving your server the time of compiling the php files each time. Using an opcode cacher can have some significant benefits:

1. Reducing loading time
2. Less cpu usage (files are already pre-compiled)
3. Less ram usage (requests are done faster, new memory is available faster)
4. Ability to store data in the memory instead of fetching it in each request

I would recommended either Xcache or APC on a single server setup. You can compare their features here: http://en.wikipedia.org/wiki/List_of_PHP_accelerators

I personally have not used the "FileCache" setting, but 755 should be fine. I believe the built in System Test should show errors if it cannot read/write to the directory. You should also see files in the directory almost immediately if all is setup correctly and there is traffic on your site.

Yes, to gain the most benefit they all should be enabled.

Having issues with xcache Authentication. I have set it to on in php.ini and also my user and md5 password. did the same in config.php and restarted webserver.

It keeps telling me my user/pass is wrong. what could be the issue?

Also I used cloudflares cdn option. Adding another one from this mod is a good idea or not neccesary?

We use xCache ... but have Authentication off as we're on a VPS and not sharing anything

Filip?

I would strongly recommend turning off the authentication. You only need it enabled if you have the xcache-admin interface in a publicly available area, and even then you can use .htaccess passwords to control access.

If you absolutely must have it enabled, against our recommendations, you can try putting your password in cleartext in the config.php file for this mod, rather than md5.

Adding another one would certainly not be a good idea.

For priority support, please post @ our website. We'd appreciate it if you didn't bump your posts in that manner, as it will not get your query answered any sooner :)


Fillip

Thank you

vB Optimise v2.6.1

New Features:

(Pro) Plugin Cache

• Stores all plugins in a PHP file
• Improves performance for plugin execution
• Allows for plugin code to be cached by opcode cacher

Bug Fixes And Issue Fixes:

• "Variable passed by reference" errors should now be resolved
• (Pro) MS Azure CDN will now use the same URL Scheme as the forum, improving HTTPS support

Fillip

I installed the product and turned it on but when I go to do a system test it says it is offline, how come?

Had to set opcache and am using filecache. Working now, let's see how it runs.

If i installed APC server side, is it enough? or should I also use the APC in this mod?

Using APC in this mod as well will have additional benefits, such as being able to cache more information than vBulletin caches by default.

That being said, I would recommend XCache over APC, as APC has been discontinued and is no longer supported in newer PHP versions.

Fillip

XCache is the easiest I think. It's part of cPanel EasyApache as well

Hi Fillip,
Is there a reason why Resource Saving Statistic doesn't work properly?
I have a feeling vB Optimise (or my htaccess or something) is caching the swf chart.
Every time I load the Resource Saving Statistic, I need to do CTRL + F5 (cache refresh page) to see updated resource saving statistics. The weird part is, when I do CTRL + F5, I only get a partial update of the saving statistics.
For example,
I first clicked on " Resource Saving Statistic", but it said it had only saved me 3 queries today, October 2nd.
I knew this was wrong, so I did CTRL + F5. Now it said 42 queries.
I did CTRL + F5 again. Now it said 105 queries.
I did CTRL + F5 again. Now it says 198 queries.
I did CTRL + F5 again just now, and it says 219 queries.
I think I'm going to stop caching swf objects through my htaccess for a week, and set swf to not cache at all.

Perhaps this is the reason.

That seems like it's working perfectly fine - the statistics are updated via a Scheduled Task, which can only run if people are actually active on your site, every 10 minutes. It sounds reasonable that the statistics would then update on refresh :)


Fillip

Thanks.
Another question, Fillip.
You may not be able to help me with this because it's custom, but..
I have a table on my forum that selects rows from a table in the database and outputs them onto a table. Currently, there's about 300 rows in this table, and it's growing daily.
Is there a way to cache this table every hour, and only update if there's a new row?

This may be beyond your scope of work, but if it were to come in the pro version, or there's a webpage you could direct me to, or something, I'd be very appreciative. I love this modification.

Thanks

edit: nvm. I noticed xcache does this for me.

I have installed last version today, but in the admin interface, Cache options, when I set to yes cache styles/templates,datastore, and click SAVE the system return blank screen and when i go again to that screen no changes have been made.

Optimal settings return all ok
system test: all ok, but Flush cache don't finish, it continue thinking and thinking flushing cache,...

Any help?

Thanks,