Search Results (Searched for: spam)

11 Aug 2010 22:14
I have an idea.. Or two:

First you need to check that jos_messages and jos_messages_text have primary keys. If not, it may be the cause of this issue.

There may also be issue with table integrity: mesages outside categories or thread, missing data etc..

I have a few queries I want you to run. Please check your private messages, but answer into here.
11 Aug 2010 03:12 - 11 Aug 2010 03:13
G'day, Sally, and welcome to Kunena.

As you see, I have merged your messages with others on the same subject. There are a lot of good suggestions in this discussion topic: suggestions about how to stop spam getting into your website in the first place and suggestions about what to do after you get spam postings.

If you have any specific questions on these suggestions then we're more than happy to try to help answer them as best we can. :)
11 Aug 2010 00:17
Hi

Have i posted this in the right section? Just wondered cause there were 44 people viewing the forum but noone seems to have seen this, wanted to find an answer out ASAP before my forum gets inundated with spam! Dont know if there is a way i can ask Kunena directly?
10 Aug 2010 08:30 - 10 Aug 2010 08:32
For comparison purposes, I've included a screenshot of a K 1.5 installation that you might be interested in seeing:


You might find this article helpful: dev.mysql.com/doc/refman/5.1/en/optimize-table.html

I looked at your site. The pertinent statistic is circled below:


I don't know why three-and-a-half thousand messages translates into 60,000 records. It might be useful for you to look into the database to see how those records relate to your forum.

Maybe someone else has some ideas?
10 Aug 2010 04:25
Phpmyadmin screenshot added.

10 Aug 2010 04:17
Space is being calculated by phpmyadmin, which reports the referenced table is over 300MB. It you goto the site (PM sent), you will see there is 50,000 posts (This is reported at the bottom by Kunena). If you actually look at the numbers reported by the subforums, you will see it is significantly less.

When I browse the database table, there are over 50,000 records shown. This makes be think that even after deletion, the records are staying in the database.
10 Aug 2010 03:10

rocketman007 wrote: I was previously using K 1.0, is that why the messages are still in the DB?

This is an unlikely cause. K 1.5 uses the same database structure as K 1.0.

What are you using to calculate the space used by the database?

Either you have 2,500 records or you have 50,0000+ records and I would like to know what we are discussing. If Kunena gives two different reports, can you please show me where: maybe a screen capture with the relevant areas highlighted?

Databases grow. When you delete records from databases, you don't normally get any release of disk space. To reclaim this "lost" disk space, you need to compact the database. Most database management software (like phpMyAdmin, for example) have features for compacting the database.
10 Aug 2010 02:42 - 10 Aug 2010 02:43
I was previously using K 1.0, is that why the messages are still in the DB?

As for the stats, the number of posts is shown and the bottom; while adding up posts while viewing the stats of individual forums from the forum homepage shows are 2,500. I realize this might not be the most accurate method for obtaining a post count, however it appears there is a 20 hidden posts/per 1 shown posts. We have deleted so much spam that I am lead to think that this is the cause.

Thanks for your help thus far, and I can PM you the site address if that would help.
10 Aug 2010 00:13
K 1.5 - deleted message records are removed from the database

K 1.6 - deleted messages are hidden from view; requires second step to permanently remove the records from the database.

Avatar images are files. Attachments are files. These files are not stored in the database; they are stored in the site file directory.

When you say that you have "stats" that report 50,000+ messages, how did you obtain that information? When you say that you have only about 2,500 real posts, where did you obtain that information? When we know the answers to these questions, we may be able to reconcile the different counts and what might be the cause.
09 Aug 2010 18:24
I recently upgraded one of my forums to Kunena 1.5x, and realized the database was nearly 400 MB. Currently jos_fb_messages_text is taking up almost 300MB, and I have only about 2500 real posts. I noticed my stats say I have over 50,000; which I assume is from spam posters.

My question is, do posts/threads that get deleted actually get removed from the database? Or are they just disabled from being viewed? Also, do avatars, images, and attachments get stored in the database? What else would cause mine to become so large with less than 3,000 posts?
08 Aug 2010 02:15

TheMuffinMan wrote: Hi,

just sent the issue to the security team. Thank you!

Regards,
Markus


Got it! Thanks a lot!

We will be looking into providing a fix.

Oliver
08 Aug 2010 01:23
Hi,

just sent the issue to the security team. Thank you!

Regards,
Markus
08 Aug 2010 01:06 - 08 Aug 2010 01:12
Hi TheMuffinMan,

thank you for not publishing critical data, send a email to security @ kunena.com with details of critical issue and we will do all necessary to solve this issue.

Thank you
Best Regards
08 Aug 2010 00:15
Hi,

I found a critical issue that enables spambots to post messages even if tools like Jollom or the new Kunena Spam Killer are active.

Is there somebody from the team I can talk about that before publishing details?

Regards,
Markus

crosstec.de
07 Aug 2010 16:00
Thanks to your comments, I think I have found the bottleneck.

For some reason, PHP mailer function isn't working properly on my webhost server, so I am using SMTP under Joomla's global configuration.

If I switch to the PHP mailer, the submit time on the Kunena noticeably improves, but the notification messages don't get delivered. :( :( :(

I am no expert in these matters, but it would appear that the PHP mailer serves to buffer outgoing mail, so the response improves. At the same time, I suspect smtp server is has some performance issues; maybe they are running Spamassassin and/or Clam AV, or some other Perl spam/virus software, which tend to be CPU intensive, and/or doing DNS lookups. On my desktop test system, I am also using a local smtp server, but the response is very fast, partly because it simply serves as a relay to Postfix running on my LAN gateway machine.

So, from what I understand from your reply, when a user posts a reply, the generation and sending of subscription notifications takes place within the posting process. Just curious: is there additional overhead associated with additional subscribers? IOW, the more subscribers, the longer it takes? Currently our test forum has five or six subscribers for various categories, but in due time when we introduce our Kunena forum to a larger group, this could easily be several hundred.

I will ask my webhost support about smtp performance and the PHP mailer issue.

Thanks.
Displaying 1546 - 1560 out of 1860 results.
Time to create page: 3.915 seconds