How do i fix registering log in error

Ramzu Yunus Posted in Technical Support 8 years ago

Hi,
Can anyone tell me how to fix the log in error that some people get when trying to register?
Thanks

Replies
us Ramzu Yunus Replied 8 years ago

@Arsalan. Thanks a lot. I am now switching back from CloudFlare and am upgrading to new version. Though i never solved the registration problem. MySql may be the problem. I have the slightest idea

Indonesian Arsalan Shah Replied 8 years ago

@Ramzu, I saw you comment on github , it seems you solved the issue with login.

Don't use the cloudflare , it will make your website slower. You server is good enough. Try to re-install mysql server again. and please upgrade your website to v3.9 as we improved the speed issues in v3.x.

Ossn v4.0-development is tested on small size server (512MB RAM, 10GB, 1 VCPU) having ubuntu and it worked faster.

@Antonis, cloudflare won't Minify your Ossn dynamic css/js files. And if you enable cache in your Ossn admin settings, Ossn automatically minify your css/js files.

@All, if anyone is using v1.x or 2.x please upgrade your website to latest version. After v4.0 release support for 1.x and 2.x will be ended.

German Michael Zülsdorff Replied 8 years ago

Basically of course it makes sense to optmize everything, no question. But here, it seems that MYSQL is the bottleneck.

That's why I would try to focus on how to get faster SQL responses, first.
A good starting point can be: http://dev.mysql.com/doc/refman/5.7/en/optimizing-the-server.html

us Ramzu Yunus Replied 8 years ago

Thanks Antonis lim. I actually just started using CloudFlare yesterday as a way to try and remedy the problem of people not being able register except maybe 10 out of 70. I have :
Server Software : CentOS 6 with Parallels Plesk Panel 12 (64-bit)
Dedicated Server
AMD Hexa-Core
6 Cores x 2.8 GHz
(3.3 GHz Turbo Core)
16 GB
DDR3 ECC
1,000 GB
(2 x 1,000 SATA)
Software RAID 1

us Ramzu Yunus Replied 8 years ago

thanks a lot Zet Man! I am on top of it now! When you say unnecessary service, can you give me an example of what you mean? thanks

German Michael Zülsdorff Replied 8 years ago

Thanks for providing information.
So I've had a look at your site today (14.12 between 17:00 and 17:45 GMT+1) and everything looks like your machine is simply not powerful enough to handle such a large community.

  1. already when calling the homepage the response time varies between 23s and 1:50
  2. nevertheless I've been able to create an account (Honey Honey)
  3. Loggin in takes 1:15, subsequently calling home varies between 30s and 1:30
    (you are using unnecessary large pics for the adds, which take extra loading time BTW)
  4. The interesting part starts when searching for users
    http://www.nationtime.org/search?q=honey => 4 users / 16s
    http://www.nationtime.org/search?q=hone => 8 users / 28s
    http://www.nationtime.org/search?q=hon => 60 users / 45s
    http://www.nationtime.org/search?q=ho => 2000users / > 1:45, most often timing out

As we can see, it needs only one user issuing a request like that to force such a massive overload, that other requests like creating an account or loggin in can't be handled reliable simultaneously.

Have a look at your server messages and process listing. Perhaps you are able to free some resources by stopping unnecesary services. If not, the only solution is to choose a more powerful machine.

us Ramzu Yunus Replied 8 years ago

i am using version 2.3. my url is www.nationtime.org. alot of users cant register

us Ramzu Yunus Replied 8 years ago

i have a dedicated server from 1and1.com

German Michael Zülsdorff Replied 8 years ago

Please provide the necessary details for reporting a problem.
see --> https://www.opensource-socialnetwork.org/wiki/view/1101/how-to-report-a-bug

Basically: since the program code doesn't change temporarely, problems like yours point to a temporary server overload or networking issues. Who is hosting your site?

us Ramzu Yunus Replied 8 years ago

thanks. what am i supposed to see there?