Warning Mysql Messege !! While Installation VB Forum
Oct 25, 2007
i get anew VPS with Control Panel...
when i try to install the VB forum it's show me this warning Messege!
Code:
Error description: mysql_connect() [function.mysql-connect]: Access denied for user 'user_db'@'localhost' (using password:
YES) /home/*****/public_html/includes/class_core.php on line 274
The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the 'includes/config.php' file.
how can i fix this problem in Mysql USER ?
View 14 Replies
ADVERTISEMENT
Feb 16, 2008
I have a friend which owns a 2k alexa rank forum using VB
The server hangs and he gets mysql connection error in logs
Quote:
Database error in vBulletin : 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'
The server is a dual Pentium D with 4GB RAM
currently 600 users online and 20% RAM used
in rush hours there are 2000 users online and 50% RAM used
We want to optimize mysql - this is the current my.cnf
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 2000
key_buffer = 80M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 3M
table_cache = 2500
thread_cache_size = 384
wait_timeout = 15
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 8
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
old-passwords = 1
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 64M
write_buffer = 64M
[mysqlhotcopy]
interactive-timeout
View 7 Replies
View Related
May 11, 2009
Are there any services where an ADMIN can monitor DB usage on system and make some recommendations or even find SQL that is poorly written ...
I have a DUAL harpertown, 10GB RAM, and RAID
I have a typical, gallery, busy VB forum, and video script...
THe site traffic has not increased much but my Memory keeps getting chewed up... i already did some tuning that VBULLLETIN suggested... but the memory still goes... i need a tool or someone to just monitor the server for a day and grab as much diagnostic info as possible..
I suspect that its a single query giving problems cuz i have some custom coded pages...
I don't want to split the DB and HTTP request on diff servers cuz the traffic that i get shouldn't warrant it... for now...
View 12 Replies
View Related
Dec 19, 2008
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/.../public_html/enhu.com/includes/connection.php on line 5
Database connection failed: Access denied for user 'root'@'localhost' (using password: YES)
i'm using wamp.
how must i fix this error?
View 12 Replies
View Related
May 18, 2009
I originally installed XAMPP on my XP machine, but now I need to run an application using IIS.
Is it possible to use the XAMPP installation with IIS?
I installed IIS and I've disabled the apache service, PHP seems to be working fine but not MySQL?
View 2 Replies
View Related
May 22, 2009
Im trying to get 64bit MYSQL 5.1 installed on a CENTOS 5.2 64bit box. But after a week of wrangling with it I just dont seem to be able to get it running. I have tried both installing via the MYSQL.com RPM's and via a added YUM Repo.
Below is my error log.
Quote:
090522 15:33:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090522 15:33:04 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 472 error messages,
but it should contain at least 630 error messages.
Check that the above file is the right version for this program!
/usr/libexec/mysqld: Unknown error 1146
090522 15:33:04 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
090522 15:33:04 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
090522 15:33:04 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
090522 15:33:04 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
090522 15:33:04 InnoDB: Started; log sequence number 0 0
090522 15:33:04 [ERROR] Aborting
090522 15:33:04 InnoDB: Starting shutdown...
090522 15:33:05 InnoDB: Shutdown completed; log sequence number 0 46409
090522 15:33:05 [Warning] Forcing shutdown of 1 plugins
090522 15:33:05 [Note]
090522 15:33:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
View 5 Replies
View Related
Dec 12, 2007
Error: Missing Dependency: php = 4.3.9-3.22.9 is needed by package php-mysql
above is the error if i try to install php-mysql
tried several times:
yum install php-mysql
but i get the same error everytime
i am using Centos4 + PHP5 + mySQL5
View 7 Replies
View Related
Jul 29, 2012
Plesk has mysql installed with it to run properly and I need to upgrade that version to the latest. Now I am not talking about the mysql server that it provides for me to create databases on. I am talking about the version it uses to run.
View 3 Replies
View Related
Oct 15, 2014
Is it possible, that the script changes my admin password for MySQL? I can not connect to my MySQL Server any more.
View 1 Replies
View Related
Oct 15, 2014
on my Ubuntu 14.04 LTS server, I have ran the install script. This process stopped with the message: ERROR while trying to establish test connection. If you are installing Plesk on an already configured MySQL server, you need to specify the administrator's credentials to succeed with the installation.
To do this, you need to create a file - /root/.my.cnf with the 'client' section where you need to provide user and its password ("user = $admin_name" and "password = $admin_pass").
After installation is finished, the file /root/.my.cnf will be renamed to /root/.my.cnf.bak
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_installation.log), fix and try again
Accordingly, I have the existing my.conf copied to the ROOT directory and added the two missing lines in the client area. After that I started the plesk-installer.sh again. The process stopped at a line
"Installed product components are determined" and nothing still happend. The log files says nothing but the last information at the previous try.
View 1 Replies
View Related
Jun 25, 2007
I am trying to install Joomla on httpme.com but I seem to have problems with it recognising the username/password. Could it be a localhost issue or something?
I just can't seem to get a solution to this. I am referring to step 1 of the Joomla installation.
View 10 Replies
View Related
Jan 5, 2007
I just toke a Virtual dedicated server based on linux-vserver technology with 512Mo of ram burstable to 3 Go, to host my ipb active forum (20,000 registred members ~80 simultalinous)..
the probleme is the vds can't handle the forum due to bad memory Usage..
Look at the memstat output :
Quote:
root@xxxxxx:/etc/init.d# memstat
676k: PID 2303 (/dev/zero)
436k: PID 2308 (/lib/tls/libnss_files-2.3.2.so)
11956k: PID 4215 (/SYSV00000000)
244k: PID 4234 (/usr/lib/libdb3.so.3.0.2)
34500k: PID 4280 (/lib/tls/libnss_files-2.3.2.so)
252k: PID 4287 (/lib/tls/libc-2.3.2.so)
396k: PID 4527 (/usr/lib/libdb3.so.3.0.2)
264k: PID 4529 (/lib/tls/libc-2.3.2.so)
392k: PID 4558 (/usr/lib/libdb3.so.3.0.2)
264k: PID 4563 (/lib/tls/libc-2.3.2.so)
236k: PID 4569 (/usr/lib/libdb3.so.3.0.2)
3560k: PID 4714 (/lib/tls/libnss_files-2.3.2.so)
3556k: PID 4791 (/lib/tls/libcrypt-2.3.2.so)
3476k: PID 4792 (/lib/tls/libcrypt-2.3.2.so)
3588k: PID 4793 (/lib/tls/libcrypt-2.3.2.so)
3468k: PID 4794 (/lib/tls/libcrypt-2.3.2.so)
3564k: PID 4795 (/lib/tls/libcrypt-2.3.2.so)
3620k: PID 4796 (/lib/tls/libcrypt-2.3.2.so)
3472k: PID 4797 (/lib/tls/libcrypt-2.3.2.so)
3468k: PID 4819 (/lib/tls/libcrypt-2.3.2.so)
460k: PID 5064 (/lib/tls/libnss_files-2.3.2.so)
248k: PID 5087 (/lib/tls/libnss_files-2.3.2.so)
248k: PID 5090 (/lib/tls/libnss_files-2.3.2.so)
8532k: PID 6351 (/SYSV00000000)
320k: PID 7933 (/usr/lib/gconv/ISO8859-15.so)
307124k: PID 7969 (/lib/tls/libnss_files-2.3.2.so)
240k: PID 7970 (/usr/lib/locale/locale-archive)
980k: PID 12506 (/lib/tls/libc-2.3.2.so)
752k: PID 13316 (/lib/tls/libnss_nis-2.3.2.so)
664k: PID 17042 (/dev/zero)
404k: PID 17195 (/lib/tls/libnss_files-2.3.2.so)
3328k: PID 24943 (/SYSV00000000)
12248k: PID 25310 (/SYSV00000000)
11128k: PID 25311 (/SYSV00000000)
11772k: PID 25312 (/SYSV00000000)
11072k: PID 25313 (/SYSV00000000)
12028k: PID 25314 (/SYSV00000000)
12028k: PID 25316 (/SYSV00000000)
11688k: PID 25317 (/SYSV00000000)
12340k: PID 25318 (/SYSV00000000)
11224k: PID 25319 (/SYSV00000000)
11796k: PID 25320 (/SYSV00000000)
11548k: PID 25322 (/SYSV00000000)
12012k: PID 25323 (/SYSV00000000)
11736k: PID 25324 (/SYSV00000000)
11440k: PID 25325 (/SYSV00000000)
11540k: PID 25326 (/SYSV00000000)
9344k: PID 25327 (/SYSV00000000)
11164k: PID 25328 (/SYSV00000000)
12080k: PID 25329 (/SYSV00000000)
10136k: PID 25330 (/SYSV00000000)
12084k: PID 25331 (/SYSV00000000)
396k: PID 32054 (/lib/tls/libc-2.3.2.so)
428k: PID 32055 (/lib/tls/libc-2.3.2.so)
428k: PID 32073 (/lib/tls/libc-2.3.2.so)
428k: PID 32074 (/lib/tls/libc-2.3.2.so)
428k: PID 32075 (/lib/tls/libc-2.3.2.so)
428k: PID 32076 (/lib/tls/libc-2.3.2.so)
428k: PID 32077 (/lib/tls/libc-2.3.2.so)
396k: PID 32087 (/usr/lib/libdb3.so.3.0.2)
268k: PID 32090 (/lib/tls/libc-2.3.2.so)
396k: PID 32140 (/usr/lib/libdb3.so.3.0.2)
264k: PID 32142 (/lib/tls/libc-2.3.2.so)
724k: /SYSV00000000 4215 6351 24943 25310 25311 25312 25313 25314 25316 ...
1280k: /dev/zero 17042
1280k: /dev/zero 17042
1280k: /dev/zero 2303
1280k: /dev/zero 2303
68k: /usr/lib/courier/authlib/authdaemond.mysql 32055 32073 32074 32075...
612k: /bin/bash 7933 17195
64k: /usr/lib/libtasn1.so.2.0.10 4215 6351 24943 25310 25311 25312 2531...
1644k: /usr/lib/locale/locale-archive 7933 7970 17195
1124k: /usr/lib/libperl.so.5.8.4 4215 6351 24943 25310 25311 25312 25313 ...
12k: /lib/libcap.so.1.10 2303 13316 17042
8k: /lib/libcom_err.so.2.1 4215 6351 24943 25310 25311 25312 25313 253...
8k: /usr/bin/logger 7970
248k: /lib/libncurses.so.5.4 7933 17195
20k: /lib/libnss_db-2.2.so 2303 4215 4234 4527 4558 4569 6351 13316 170...
32k: /lib/libpam.so.0.76 2303 4215 5064 5090 6351 13316 17042 24943 253...
28k: /lib/libwrap.so.0.7.6 2303 4215 4287 5064 6351 7969 13316 17042 24...
12k: /lib/security/pam_env.so 2303 17042
12k: /lib/security/pam_limits.so 2303 17042
8k: /lib/security/pam_mail.so 2303 17042
4k: /lib/security/pam_motd.so 2303 17042
8k: /lib/security/pam_nologin.so 2303 17042
44k: /lib/security/pam_unix.so 2303 17042
12k: /sbin/portmap 4287
28k: /sbin/syslogd 4234
408k: /usr/lib/libgnutls.so.11.1.16 4215 6351 24943 25310 25311 25312 25...
80k: /usr/lib/libgssapi_krb5.so.2.2 4215 6351 24943 25310 25311 25312 2...
136k: /usr/lib/libk5crypto.so.3.0 4215 6351 24943 25310 25311 25312 2531...
416k: /usr/lib/libkrb5.so.3.2 4215 6351 24943 25310 25311 25312 25313 25...
1008k: /usr/lib/i686/cmov/libcrypto.so.0.9.7 2303 2308 4215 4280 4714 479...
196k: /usr/lib/i686/cmov/libssl.so.0.9.7 4215 4714 4791 4792 4793 4794 4...
12k: /usr/lib/perl/5.8.4/auto/Cwd/Cwd.so 4215 6351 24943 25310 25311 25...
68k: /usr/lib/libz.so.1.2.2 2303 2308 4215 5064 6351 7969 13316 17042 2...
View 4 Replies
View Related
Jan 10, 2009
I own a smf forum with usually 100-150 online users and sometimes it reaches 600-1000. My hosting refuses to host my forum anymore cause there is heavy cpu usage on their server.
So I want to ask you if there is any share web hosting provider that can host my forum with a reasonable prise.
View 8 Replies
View Related
Oct 25, 2009
My site has outgrown my current host and I'm strongly leaning towards a vps. I am relatively inexperienced with web hosting as for the last 18 months I've had very few issues with my current host (Stream101.com). They are currently saying my site is very memory and processor intensive which is why I'm going to have to leave them soon(I can't pay the dedicated server prices that would give my site the stability I desire).
About my site:
My site has 18,000+ users, its about 18 months old. 5,632 threads, 78,967 posts. It used about 150gig of bandwidth last month. The site is growing quickly (IMO). The site makes some money, but not enough to justify spending what it would cost for a dedicated server.
I'm happy to provide any other information, but what I am looking for is suggestions on:
1) Is a VPS the right choice for my site in your opinion.
2) What hosting company's would you suggest I look into.
3) How much ram/processor speed should I be looking for
4) any other information you feel I should know about this.
View 9 Replies
View Related
Feb 4, 2008
Our forum is under attack...and our host won't do anything except tell us that our load is too high and that they might turn off our account.
But, we've already turned off the forum...the only load is a note that says it's down for maintenance...no database...no html...nothing.
In a very short amount of time it has has over 300,000 page requests for the same three pages.
Is there anything on my side (since I don't run the server) that I can do to stop this or prevent it...etc?
View 10 Replies
View Related
Jun 21, 2008
"Can i host a small forum at a 64mb ram vps with lighttpd and mysql? How many users can i have online?" I said that he can do that.Is this answer true?
View 14 Replies
View Related
Jun 19, 2008
How much bandwidth does a forum take to run?
View 14 Replies
View Related
Dec 19, 2008
I want to host a invision forum. I have a lot of exp admining and modding but I have never run one myself.
I plan on using 15-30 gigs of material on site and the rest will be offsite storage.
I do not know how many members I will have it could be just a couple of hundred to a couple of thousand.
My question. I was planning on going with WiredTree because of all the great reiviews out there. And buying thier vps512 which has 60 gigs of storage and 800 monthly bandwith.
Will that be enough do you think? More, less? I would like to stay within 50-100 dollars. since I am mainly running this for recreation and not looking to make a profit.
I have never hosted a website or such before, but after reading here and doing research I do not really want a shared server.
View 5 Replies
View Related
Sep 3, 2008
After several stressful hours of reading these forums I have finally decided to post my own question. I have lurked and read here for months and picked my own reseller hosting after reading up on here.
I have a client with a problem with her SMF forum...
She set it up 6 months ago and needs to upgrade her hosting. Her current host is Ausweb and she has been suspended for abuse.
The scenario I need help with is SMF forum v.1.1.5
Traffic per month: 11-15 gbs
Hits per month: 10,000
Storage: 1084.8/2000 MB
Members: >200
She has been suspended 3 times last month, charged apparently for an upgrade and has forked out almost $1500 for 12 months from April, which I calculate to be $125 per month for 12 months... which should be a dedicated server!
Does she need a dedicated server?
Would a VPS suffice?
If she does.. who is economical as at this point it is non profit site although we are looking at changing that, through advertising.
What is the best scenario with the least added expense for this disillusioned forum owner who has a successful site but has had a horrendous experience with hosting?
View 14 Replies
View Related
Aug 25, 2008
I've got my new hosting provider choice narrowed down to two providers (ServIt & WiredTree) for a Managed VPS. From the reviews here they both seem to be very similiar in customer support and reliability. The only difference I have found is that ServIt does have a community forum and WiredTree does not have a forum. It's wierd to be choosing a hosting provider based on this, so I thought I would come get your opinions on this.
View 14 Replies
View Related
Oct 18, 2008
I am trying to create a phpbb3 forum that can hold like 100 members. I am looking for hosting that will support my forum, is a decent price, and if I don't have to lock in any months thats an added bonus.
View 11 Replies
View Related
Aug 27, 2008
We're setting up a vBulletin forum, and I'd like to know what we'll need from a vps. We expect 5000-10000 hits a day, maybe 30-60 users on at a time, and we'd like to keep quick load speeds.
So how much ram would we need to achieve fast speeds?
How many mysql database might we need (just roughly for such a sized forum)?
How much bandwidth will we need?
Plus any other info you can give!
I could also do with some VPS hosting recommendations. We'll be adding other sites (with less traffic) in the VERY near future, so we'd like them to be accomodated. A host with good support/ response time is a must, and one with excellent uptime to!
View 4 Replies
View Related
Dec 4, 2008
I have no experience in MySQL / database.. But I want to open a forum to learn some stuffs.
View 11 Replies
View Related
Jun 21, 2008
install a phpbb3 or a SMF forum on my template html file for my web hosting company, i basically just want the forum to be under my site banner
View 7 Replies
View Related
Apr 2, 2008
What kind of webhost will I need for phpBB forum?
Here are the requirements :
A webserver or web hosting account running on any major Operating System with support for PHP
A SQL database system, one of:
FireBird 2.0 or above
MySQL 3.23 or above
MS SQL Server 2000 or above (directly or via ODBC)
Oracle
PostgreSQL 7.x or above
SQLite
PHP 4.3.3 or above with support for the database you intend to use. The optional presence of the following modules within PHP will provide access to additional features, but they are not required.
zlib Compression support
Remote FTP support
XML support
Imagemagick support
Of course free hosts are preferred, but nothing too expensive will do fine aswell. n_n
View 7 Replies
View Related
Apr 3, 2008
I want to create a forum and have not got any idea in where to start. All I have at the moment is a PhpBB2 template which I would like to use.
The few questions I have are:
1: Do I need to purchase Webspace, if so which are recommended?
2: How would I install the template to the webspace and would the users login information get stored in a seperate database or would that come with the web hosting?
All help would be very much appriciated as i have no idea where to start and how to get it up and running.
View 8 Replies
View Related
Jun 26, 2007
I transfered my forum from one server to another. ips changed. Before the transfer, I closed the board and put an announcement. After the transfer I opened the board and started posting.
Now, there are other members who've posted after the transfer but I've noticed decrease in activity. One of the members emailed me and told me that the board is still closed for him with the announcement shown. That message is from the old and not the new server. So how is this happening? What should he or I do? I and some other members can access and post normally.
The forum is is the one in my sig.
Just see if it's closed for you or not.
View 6 Replies
View Related
Dec 6, 2007
running a vb forum around 400 members online and 300 guests(they don't have access to forum)..
here's my top list
top - 20:27:49 up 2:48, 1 user, load average: 7.41, 3.93, 2.00
Tasks: 164 total, 7 running, 157 sleeping, 0 stopped, 0 zombie
Cpu(s): 79.0%us, 3.8%sy, 0.0%ni, 16.6%id, 0.0%wa, 0.0%hi, 0.7%si, 0.0%st
Mem: 2059456k total, 1379400k used, 680056k free, 74100k buffers
Swap: 2031608k total, 0k used, 2031608k free, 578940k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
25037 apache 15 0 43488 20m 5168 S 25 1.0 0:05.08 httpd
25021 apache 15 0 45168 21m 4840 S 20 1.1 0:06.22 httpd
25033 apache 15 0 44072 20m 4900 S 15 1.0 0:04.18 httpd
25281 apache 16 0 41388 18m 4792 S 13 0.9 0:03.09 httpd
924 apache 15 0 47036 24m 6208 S 11 1.2 2:04.58 httpd
25000 apache 15 0 43036 19m 4884 S 9 1.0 0:04.27 httpd
25019 apache 15 0 44432 20m 4880 S 9 1.0 0:03.58 httpd
25793 apache 16 0 40228 16m 4656 R 8 0.8 0:00.25 httpd
24398 apache 16 0 42896 19m 5232 R 8 1.0 0:04.65 httpd
2516 apache 15 0 43868 21m 5412 S 7 1.0 1:42.88 httpd
916 apache 15 0 46212 23m 6268 S 7 1.2 2:01.07 httpd
25032 apache 15 0 42544 19m 4828 S 7 0.9 0:02.72 httpd
2674 mysql 15 0 180m 45m 4860 S 7 2.3 5:31.09 mysqld
23073 apache 15 0 44728 21m 5216 S 6 1.1 0:13.05 httpd
23062 apache 15 0 42992 19m 4916 S 5 1.0 0:16.05 httpd
25007 apache 15 0 47484 24m 5100 S 2 1.2 0:03.22 httpd
15795 apache 15 0 46944 23m 5544 S 1 1.2 0:47.47 httpd
16339 apache 15 0 46212 22m 5076 R 1 1.1 0:47.83 httpd
25038 apache 15 0 42336 18m 4788 S 1 0.9 0:02.92 httpd
16339 apache 15 0 46208 22m 5076 S 3 1.1 0:47.79 httpd
25020 apache 15 0 44860 21m 4864 S 2 1.1 0:04.71 httpd
25079 apache 17 0 45828 22m 4860 R 2 1.1 0:04.15 httpd
16361 apache 15 0 44872 21m 5392 S 1 1.1 0:50.04 httpd
22666 apache 15 0 43748 20m 5272 S 1 1.0 0:14.98 httpd
22671 apache 15 0 43320 20m 5244 S 1 1.0 0:16.42 httpd
25032 apache 15 0 42544 19m 4824 S 1 0.9 0:02.51 httpd
916 apache 15 0 46212 23m 6268 S 0 1.2 2:00.86 httpd
24247 root 15 0 2164 1104 816 R 0 0.1 0:00.64 top
25009 apache 15 0 43028 19m 4828 S 0 1.0 0:03.32 httpd
25034 apache 15 0 43492 20m 5128 S 0 1.0 0:02.63 httpd
25268 apache 15 0 40892 17m 4676 S 0 0.9 0:00.49 httpd
25282 apache 15 0 41168 17m 4700 S 0 0.9 0:01.37 httpd
View 5 Replies
View Related
