Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2008, 06:34 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default error message database if the server never restarted the site

every visitors that visited to my forum for example :
500members and 800guest
and sometimes in a very short time the member and the guest will be come to 0.
maybe its because my server always do the restarted to my site.
if my server didnot do the restart it im always getting error message in my email.

vBulletin Database Error!
Database error in vBulletin :

Quote:
mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
/home/name/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Saturday, May 31st 2008 @ 03:20:06 PM
Error Date : Saturday, May 31st 2008 @ 03:20:08 PM
Script : http://site.com/forum/cron.php?rand=665205
Referrer : http://site.com/forum/indonesian-bugil-cover/
IP Address : 81.32.122.212
Username :
Classname : vB_Database
MySQL Version :
They support restart my database because :
Quote:
If we restart your services it is because the service has become available.
i take dedicated server for my host.


i have been call my support hosting to not do the restarted ever for my site
because every time they restarted then my visitors always back to 0.
how i can bypass this error message?

If i dont do anything with this issue.will be my database crush?
Reply With Quote
  #2  
Old 05-31-2008, 06:47 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You keep writing about this.... if it is a dedicated server, I strongly suggest to find out where you mysql errors logs are and check them out yourself. Or, open a shell and find out how long mysql has been 'up' so you can find out if it has recently been restarted. If it is restarting itself, it is because of a setting somewhere that is triggering the restart. It may be in your my.cnf file. However, you need to read your mysql error logs in order to find out if it really is restarting itself and what the reason is. If you don't know that, then you can't fix it.
Reply With Quote
  #3  
Old 05-31-2008, 06:54 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Im sorry about this Lynne,because my problem never solved until now.and im always getting any error messages.
btw may i know how i can check my.cnf file? its mean.how i can get the file?
im not familiar with vbulletin and dedicated server.thx
Reply With Quote
  #4  
Old 05-31-2008, 08:21 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

my.cnf is the mysql configuration file. I think it is in different places on different servers. I have a separate server that runs mysql and the file is in the /etc directory.

You may want to post in the Server Configuration forum on vb.com to get your server configured correctly. Or, since you are new to servers and may not know how to modify the php/mysql config files, you may want to look into hiring someone to deal with your server.
Reply With Quote
  #5  
Old 05-31-2008, 08:21 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

[mysqld]
max_connections = 500
safe-show-database
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M
thread_concurrency = 8
wait_timeout = 30

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

is anything wrong?
Reply With Quote
  #6  
Old 05-31-2008, 08:33 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't know. Without knowing for sure if mysql is restarting itself, and without seeing the error, no one can tell you what is wrong. Also, the my.cnf file will be different for every server. Every board is unique and needs tweeking in different ways.
Reply With Quote
  #7  
Old 05-31-2008, 08:48 PM
geevest.com geevest.com is offline
 
Join Date: Apr 2006
Posts: 709
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

and now,what should i do Lynne to solved my problem?
because until now my guest and my members always kickout from my site.
like i said before :
Quote:
every visitors that visited to my forum for example :
500members and 800guest
and sometimes in a very short time the member and the guest will be come to 0.
maybe its because my server always do the restarted to my site.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:07 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03692 seconds
  • Memory Usage 2,220KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (7)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete