PHPBB MySQL error

apps

#1

I’m getitng this error currently on one of my forums:

Warning: mysql_connect(): Lost connection to MySQL server during query in /home/.kafka/rtfldgr/baseballboards.net/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/.kafka/rtfldgr/baseballboards.net/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/.kafka/rtfldgr/baseballboards.net/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database

I’ve got no clue what the problem is but I can’t find my way into MySQL. Was I hacked? :frowning:


#2

Soemthing is seriously wrong because I tried to change my password and I receieved this nice little error on dreamhost control panel:

NZA Fatal Error!
The developer says:
connect_admin failed for meow:wania

Handy stack trace:
Ndn::Common::Nza::Step::FatalError(‘connect_admin failed for meow:wania’) called at /usr/local/lib/site_perl/Ndn/Dhwebpanel/Goodies/Mysql.pm line 583
Ndn::Dhwebpanel::Goodies::Mysql::EditUserFinal::Do(‘Ndn::Dhwebpanel::Goodies::Mysql::EditUserFinal’) called at /usr/local/lib/site_perl/Ndn/Common/Nza.pm line 554
Ndn::Common::Nza::DoStep(‘Ndn::Dhwebpanel::Goodies::Mysql=HASH(0xc2824ec)’, ‘EditUserFinal’) called at /usr/local/lib/site_perl/Ndn/Common/Nza.pm line 174
Ndn::Common::Nza::fill(‘Ndn::Dhwebpanel::Goodies::Mysql=HASH(0xc2824ec)’, ‘Ndn::Common::Context=HASH(0xc186b84)’) called at /usr/local/lib/site_perl/Ndn/Common/TreeNav.pm line 375
eval {…} called at /usr/local/lib/site_perl/Ndn/Common/TreeNav.pm line 375
Ndn::Common::TreeNav::ANON(‘HASH(0xc282528)’, ‘ARRAY(0xc285680)’, ‘ARRAY(0xc1b33c4)’, ‘tree=goodies.mysql&’, 3, ‘panel_panel_’, ‘panel’) called at /usr/local/lib/site_perl/Ndn/Common/TreeNav.pm line 291
Ndn::Common::TreeNav::ANON(‘HASH(0xc283504)’, ‘ARRAY(0xc285680)’, ‘ARRAY(0xc287770)’, ‘tree=goodies&’, 2, ‘panel_panel_’, ‘panel’) called at /usr/local/lib/site_perl/Ndn/Common/TreeNav.pm line 291
Ndn::Common::TreeNav::ANON(‘HASH(0xc2855e4)’, ‘ARRAY(0xc285680)’, ‘ARRAY(0xc2877c4)’, ‘’, 1, ‘panel_panel_’, ‘panel’) called at /usr/local/lib/site_perl/Ndn/Common/TreeNav.pm line 398
Ndn::Common::TreeNav::Render(‘Ndn::Common::TreeNav=HASH(0xc285620)’, ‘Ndn::Common::Context=HASH(0xc0b159c)’) called at /usr/local/lib/site_perl/Ndn/Dhwebpanel.pm line 784
Ndn::Dhwebpanel::Main(‘Ndn::Common::Context=HASH(0xc0b159c)’) called at /usr/local/lib/site_perl/Ndn/Dhwebpanel.pm line 983
Ndn::Dhwebpanel::Display(‘Ndn::Common::Context=HASH(0xc0b159c)’) called at /usr/local/lib/site_perl/Ndn/Dhwebpanel.pm line 227
Ndn::Dhwebpanel::ProcQuery(‘Ndn::Common::Context=HASH(0xc0b159c)’) called at /usr/local/ndn/web/dhwebpanel/index.cgi line 27
Apache::ROOTpanel_2edreamhost_2ecom::index_2ecgi::handler(‘Apache=SCALAR(0x828962c)’) called at /usr/lib/perl/5.6.1/Apache/Registry.pm line 149
eval {…} called at /usr/lib/perl/5.6.1/Apache/Registry.pm line 149
Apache::Registry::handler(‘Apache=SCALAR(0x828962c)’) called at /dev/null line 0
eval {…} called at /dev/null line 0


#3

you probably should contact support. Looks like your database server may be down. And the error from DH webpanel is coming back from the meow server which died for a couple hours last night.

-Matttail


#4

Support got back to me - they moved some MYSQL users and DB’s becasue of usage and I was one of them and there was one corruption or another that caused this problem.

I’ve gotten access to my DB back now and I am trying to see if everything is all right. Need to re-import the DB into my forum.


#5

I’m really frustrated over this – my DB is there, I had to set up a new database in order to get the forum to show up again (AFTER I upgraded the software from 2.0.13 to 2.0.14)…

Now I can’t import my DB at all - I try through telnet and I don’t get error codes - I get a lot of text suggesting something didn’t take.


#6

I don’t know if they really screwwed up my DB or there is some other problems with their Mysql servers…

I try importing my DB - backup and the one that I could not access that started this entire problem - though telnet and I get this

[quote]
internal commands; see mysql> help . When enabled, the
test [expr
named commands can be used from any line of the query,
000038.html 000256.html
patch:
otherwise only from the first line, before an enter.
000067.html 000282
[harpo]$ patch --help
Disable with --disable-named-commands. This option is
000069.

Input options:
disabled by default.
-p NUM --strip=NUM Strip NUM leading
-i, --ignore-spaces Ignore space after function names.
000071.html 0002
–local-infile Enable/disable LOAD DATA LOCAL INFILE.F LINES --fuzz LINES Set the fuzz factor to LINES for inex
-b, --no-beep Turn off beep on error.

option deprecated; use --disable-tee insteadects to FILE.
-n, --unbuffered Flush buffer after each query.

-D NAME --ifdef=NAME Ma
–column-names Write column names in results.
-N, --skip-column-namestml 000803.
Don’t write column names in results. WARNING: -N ising style WORD.
deprecated, use long version of this options instead.
Valid WORDs are: literal, shell, shell-always, c, escape.814.
-O, --set-variable=name
Change the value of a variable. Please
-o, --one-database Only update the default database. This is useful for
| | _ | _| _ |
-Y PREFIX
skipping updates to other database in the update log.|
–pager[=name] Pager to use to display results. If you don’t supply anmes.336.html 000844.htmlltimedia.stonegauge.com
option the default pager is taken from your ENV variable

0001

Miscellaneous options:0846.html

-P, --port=# Port number to use for connection.

[harpo]$ patch p1 > phpBB
–prompt=name Set the mysql prompt to this value.

[harpo]$ patch -cl p1 > phpBB-2.0.8_to_2.0.1
–protocol=name The protocol of connection (tcp,socket,pipe,memory).it
logout
There are stopped jobs.
-q, --quick Don’t cache result, print it row by row. This may slow
[harpo]$ exit
logout
There are stopped jobs.
down the server if the output is suspended. Doesn’t usem
harpo login: rtfldgr
history file. Sat Apr 16 17:45:50 2005 from 6532
-r, --raw Write fields without conversion. Used with --batch.
s/1
Linux harpo 2.4.29-grsec+
–reconnect Reconnect if the connection is lost. Di
[harpo]$ mysql -hmysql.base
–ssl-cipher=name SSL cipher to use (implies --ssl).
-t, --table Output in table format. 14.7 Distrib 4.1.8, for pc-linux (i386)
-T, --debug-info Print some debug info at exit.ht © 2002 MySQL AB
This
–tee=name Append everything into outfile. See interactive help (\h)
and you are welcome
also. Does not work in batch mode.
-u, --user=name User for login if not curr

and reconnecting may take
-w, --wait Wait and retry if connection is down.

–connect_timeout=# Number of seconds before connection timeout.
-A, --no-auto-rehash

–max_allowed_packet=#shing. One has to use 'r
Max packet length to send to, or receive from server
table and field completion. This g
–net_buffer_length=#
–secure-auth Refuse client connecting to server if it uses old

(pre-4.1.1) protocoltml 000901.html

Default options are read from the following files in the given order:me
[harpo]$
000155.ht

/etc/mysql/my.cnf /var/lib/mysql/my.cnf ~/.my.cnfare.
The following groups are read: mysql
_notes
000156.html
auto-rehash TRUE

character-sets-dir (No default value)
default-character-set latin1 --disable-named-commands instead.
compress FALSE
000217.html 000563.htm
database (No default value)ommands0218.html 000570.html
delimiter ; Enable named commands. Name
vertical FALSEhe_life.ht
force FALSE
bas

named-commands FALSEble-named-commands. This option is
local-infile FALSE
Debian G
no-beep FALSE

host mysql.baseballboards.n
Password:

prompt mysql>
quick FALSE

raw FALSEoption instead.
reconnect TRUE

[harpo]$ patch -cl -d bas
socket /var/run/mysqld/mysqld.sock

ssl-capath (No default value)

ssl-cipher (No default value)ted; you can set variables directly with
table FALSE
function N
debug-info FALSE --variable-name=value. posting
user bbbnet1
safe-updates FALSEore Ignore SIGINT (CTRL-C)
i-am-a-dummy FALSE89.html 000503.html 20
select_limit 1000 updates to other database in the upda
max_join_size 1000000

secure-auth FALSE.php view
[harpo]$ mysqlimport l -hmysql.baseballboards.net -ubbbnet1 -pnumber9 bbbnetdb b results. If you don’t supply an
ackup414.sql
mysqlimport: Error: Access denied for user: 'bbbnet1@66.33.192.0/255.255.224.0’bleck_reply.php
to database 'l’
0001
[harpo]$ mysql -hmysql.baseballboards.net -ubbbnet1 -pnumber9 bbbnetdb backup414ode.o]$ up.html
bash: up: co
.sql
Copyright © 2002 MySQL ABver. If password is
This software comes with ABSOLUTELY NO WARRANTY. This is free software,000203.html 000541.html

and you are welcome to modify and redistribute it under the GPL licensec3+bu+at+gr0b+mc-v6.184m #1 SMPhtml 2004_06.html] [
Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
insecure as the
-I, --help Synonym for -?h
–auto-rehash Enable automatic rehashing. One doesn’t need to use /proc for a short time.
‘rehash’ to get table and field completion, but startupas separator,
–ssl Enable SSL for connection (aut
table and field completion. This gives a quicker start of emma1.jpgegauge.
mysql and disables rehashing on reconnect. WARNING:
other flags). Disable with --skip-s
options deprecated; use --disable-auto-rehash instead.name X509 key in PEM format (implies --ssl).po.dreamhost.comto harpo.dr
-B, --batch Don’t use history file. Disable interactiv

Password:
Directory where character sets are.ATE and DELETE that uses keys.login: Wed Nov 24 09:49:11
–default-character-set=name.rr.com
Set the default character set.
-C, --compress Use compression in server/client protocol.
Linu
-#, --debug[=#] This is a non-debug version. Catch this and exitverbose Write more. (-v -v -v gives the table output format).
-D, --database=name Database to use.
Wed
–delimiter=name Delimiter to be used.
-V, --version Output version inf
-e, --execute=name Execute command and quit. (Disables --force and history
| |–.—.-.----.-----.-----.

Named commands are disabled. Use * form only, or use
Max packet len
named commands only in the beginning of a line endingng.
with a semicolon (:wink: Since version 10.9 the client now
[harpo]$ pa
(pre-4.1.1) proto
starts with this option ENABLED by default! Disable with

Default options are read f
Disable with --disable-named-commands. This option ispbb=2.0.11.patch.tar.bz2
disabled by default.
vertical FA
-i, --ignore-spaces Ignore space after function names. FALSEtar.bz2
–local-infile Enable/disable LOAD DATA LOCAL INFILE.Epatch.tar.bz2: Cannot open: No such fil
-b, --no-beep Turn off beep on error.
local-infile
-h, --host=name Connect to host.
no-beep
-H, --html Produce HTML output.
-X, --xml Produce XML output mysql.baseballboard
–line-numbers Write line numbers for errors.
line-numbers
-L, --skip-line-numbers89.html 000307.html
sigint-ignore FALSE
–no-pager Disable pager and print to stdout. See interactive help
Welcome to h
prompt
(\h) also. WARNING: option deprecated; use

Any malicious
quick
–disable-pager instead.
raw
–no-tee Disable outfile. See interactive help (\h) also. WARNING:
reconnect TRUElogged by DreamHost We
option deprecated; use --disable-tee instead
socket /var/run/mysqld/my
-n, --unbuffered Flush buf
admin form.html me
–pager[=name] Pager to use to display results. If you don’t supply an
docs/INSTALL.html153.html 00
option the default pager is taken from your ENV variable
doc
PAGER. Valid pagers are less, more, cat [> filename],es posting.php viewforum1.php
etc. See interactive help (\h) also. This option does notld Jun 9 17:5
config.php
work in batch mode.
not given it’s asked from the tty. WARNING: This is
|__|
phpBB
insecure as the password is visible for anyone throughtor. Commands end with ; or \g.
/proc for a short time.BB-2
Your MySQL connection id is 1376
-P, --port=# Port number to use for connection.
–prompt=name Set the mysql prompt to this value. Type ‘\c’ to clear the buffer.
–protocol=name The protocol of connection (tcp,socket,pipe,memory).h

For the complete MySQL Manual online, visit:2.0.6_to_2.
-r, --raw Write fields without conversion. Used with --batch.) Edit command with $EDITOR.
ego
–reconnect Reconnect if the connection is lost. Disable with
exi
–disable-reconnect. This option is enabled by default.go (\g) Send command to mysql server.
-s, --silent Be more silent. Print results with a tab as separator,
nopager (\n) Disable pager, print to stdout.
ea
–ssl-cert=name X509 cert in PEM format (implies --ssl).e as an argument.
–ssl-ca=name CA file in PEM format (check OpenSSL docs, implies the server.
syste
–ssl).ll command.
–ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).pend everything into given outfile.
–tee=name Append everything into outfile. See interactive help (\h) Sat Apr 16 19:52:12 2005 from 6532249hfc69.tampabay.res.rr.com on pt
also. Does not work in batch mode.
s/1
Linux harpo 2.4.29-grsec+w+fhs6b+gr
-u, --user=name User for login if not current user.
-U, --safe-updates Only allow UPDATE and DELETE that uses keys.
__
| |–.—.-.----.-----.-----.
-U, --i-am-a-dummy Synonym for option --safe-updates, -U.
|||.|| | |__
Max packet length to send to, or receive from server© 2002 MySQL AB
This software comes with ABSO
–net_buffer_length=# is free software,
Buffer for TCP/IP and socket communication
and you are welcome to modify and redistribute it under the GP
–select_limit=# Automatic limit for SELECT when using --saf
Usage: mysql [OPTIONS] [d
–secure-auth Refuse client connecting to server if it uses old
’rehash’
(pre-4.1.1) protocoltup

Default options are read from the following files in the given order:ecting may take a longer time. Disable with
/etc/mysql/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf --disable-auto-rehash.
The following groups are read: mysql client, --no-auto-rehash

The following options may be given as the first argument: ‘rehash’ to get
–print-defaults Print the program argument list and exitnd field completion. This g
–defaults-extra-file=# Read this file after the global files are readractive behavior.abled.

Variables (–variable-name=value) (Enables --silent)

%[
and boolean options {FALSE|TRUE} Value (after reading options)
Directory wher


00
–default-character-set=nameies.html
auto-rehash TRUEthe default character set. bg [job_s
character-sets-dir (No default value)ress Use compression in server/client protocol.
default-character-set latin1

named-commands FALSEfg [job
file)for
local-infile FALSE Print the output of a query (rows
no-beep FALSE.html 00023
functio
host mysql.baseballboards.netor.me
html FALSEhtml 000602.ht
port 3306
prompt mysql>
quick FALSE
raw FALSE
reconnect TRUE
socket /var/run/mysqld/mysqld.sock
ssl FALSE
ssl-key (No default value)
ssl-cert (No default value)
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cipher (No default value)
table FALSE
debug-info FALSE
user bbbnet1
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
secure-auth FALSE
[harpo]$[/quote]
:frowning: I haven’t a clue…


#7

Your problem is your mysql command. The user and host need to have a space between the switch and the value I think. Password on the other hand needs to be next to the switch
Try
mysql -h dbhost.domain.com -u user -p dbname < backup.sql


#8

Edit - it just started working again dunno why thanks

Getting this too:


Warning: mysql_connect(): Can’t connect to MySQL server on ‘dbhost123.lolzing.com’ (4) in /home/.lanza/justinj12/lolzing.com/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/.lanza/justinj12/lolzing.com/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/.lanza/justinj12/lolzing.com/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database