Very strange migration problems

[Martz]

I've just migrated from a shared host to a dedicated server running Redhat 7.3, with apache 1.3.23, php 4.1.2, mysql 3.23.49 with php info here.



Everything went well, dumped the database, bz2'ed it, ftp'ed it over - decompressed on the new dedicated server. I also tarballed all the vB php stuff and moved it over. Edited admin/config.php to reflect the new setup with mysql being as localhost. Forums connected, and showed me the "BB inactive page" that I last saw when I closed the forums on my old host.

So I go to login to /admin/ and enter my existing username and password. All that happens is vB shows me the login windows again but in 2 seperate frames. I try and login to these and get nowhere, quickly. Just goes round in circles.

So, I thought I'd be clever, and edited the setting which contained the board active/inactive or not. I saved it, checked it had updated in the database, tried to login again.. and nothing. My index.php page still shows the forums as closed. So I started testing things.. I edited the copyright notice, and added "2003" to the end of it. Updated mysql, refreshed index.php. Nothing. No changes.

So I thought that I had maybe got 2 config.php files or something, I checked, and no. I also double/tripple/quad checked that my config.php was right. The values are all correct, localhost specified, correct user and pass. I changed these to user/pass's that I knew were wrong. Refreshed the index.php again and this generated a vB error, which i was for the first time quite happy to see - this to me proved that indeed the forums on the new host are indeed connecting to the right database.

I'm currently on vB 2.2.5 - i want to upgrade ASAP when I am on this new server - should I attempt this now? Would it maybe solve some problems?

Is my php version recent enough? I noticed on the php.net website they are up to 4.2.2 or something - however I have been warned that this has issues.

If anyone could help it would be appreciated, I will also be sending a copy of this post to vB support by the ticketing system. In the mean time I have deleted the mysql database, recreated all the permissions and reinserting the dump once again.

Thanks,

Martin







mySQL status:
Variable_name Value
Aborted_clients 0
Aborted_connects 0
Bytes_received 206073427
Bytes_sent 19076530
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 118
Com_change_master 0
Com_check 0
Com_commit 0
Com_create_db 1
Com_create_function 0
Com_create_index 0
Com_create_table 26
Com_delete 10
Com_drop_db 1
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 3
Com_grant 1
Com_insert 1836700
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 0
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 2
Com_rollback 0
Com_select 431
Com_set_option 0
Com_show_binlogs 0
Com_show_create 0
Com_show_databases 19
Com_show_fields 20
Com_show_grants 5
Com_show_keys 0
Com_show_logs 0
Com_show_master_stat 0
Com_show_open_tables 0
Com_show_processlist 0
Com_show_slave_stat 0
Com_show_status 5
Com_show_tables 31
Com_show_variables 43
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 0
Com_update 36
Connections 180
Created_tmp_disk_tables 0
Created_tmp_tables 5
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 4
Handler_read_first 18
Handler_read_key 694
Handler_read_next 1407
Handler_read_prev 0
Handler_read_rnd 3936
Handler_read_rnd_next 5422
Handler_update 20
Handler_write 1836710
Key_blocks_used 7793
Key_read_requests 12418981
Key_reads 14165
Key_write_requests 4255802
Key_writes 4255800
Max_used_connections 2
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 35
Open_files 67
Open_streams 0
Opened_tables 127
Questions 1837627
Select_full_join 0
Select_full_range_join 0
Select_range 73
Select_range_check 0
Select_scan 127
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 0
Variable_name Value
Sort_merge_passes 0
Sort_range 71
Sort_rows 3936
Sort_scan 16
Table_locks_immediate 1837491
Table_locks_waited 0
Threads_cached 0
Threads_created 179
Threads_connected 2
Threads_running 2
Uptime 2455

Variables
back_log 50
basedir /usr/
bdb_cache_size 8388600
bdb_log_buffer_size 32768
bdb_home /var/lib/mysql/
bdb_max_lock 10000
bdb_logdir
bdb_shared_data OFF
bdb_tmpdir /tmp/
bdb_version Sleepycat Software: Berkeley DB 3.2.9a: (February 14, 2002)
binlog_cache_size 32768
character_set latin1
character_sets latin1 big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7 win1250 win1251 win1251ukr ujis sjis tis620
concurrent_insert ON
connect_timeout 5
datadir /var/lib/mysql/
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0
have_bdb YES
have_gemini NO
have_innodb DISABLED
have_isam YES
have_raid NO
have_openssl NO
init_file
innodb_additional_mem_pool_size 1048576
innodb_buffer_pool_size 8388608
innodb_data_file_path
innodb_data_home_dir
innodb_file_io_threads 4
innodb_force_recovery 0
innodb_thread_concurrency 8
innodb_flush_log_at_trx_commit OFF
innodb_fast_shutdown OFF
innodb_flush_method
innodb_lock_wait_timeout 50
innodb_log_arch_dir
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir
innodb_mirrored_log_groups 1
interactive_timeout 28800
join_buffer_size 131072
key_buffer_size 8388600
language /usr/share/mysql/english/
large_files_support ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_long_queries OFF
long_query_time 10
low_priority_updates OFF
lower_case_table_names 0
max_allowed_packet 1048576
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 256
myisam_max_sort_file_size 2047
myisam_recover_options 0
myisam_sort_buffer_size 8388608
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
open_files_limit 0
pid_file /var/run/mysqld/mysqld.pid
port 3306
protocol_version 10
record_buffer 131072
record_rnd_buffer 131072
query_buffer_size 0
safe_show_database OFF
server_id 0
slave_net_timeout 3600
skip_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer 2097144
sql_mode 0
table_cache 64
table_type MYISAM
Variable_name Value
thread_cache_size 0
thread_stack 65536
transaction_isolation READ-COMMITTED
timezone CET
tmp_table_size 33554432
tmpdir /tmp/
version 3.23.49
wait_timeout 28800

[Martz]

Started from scratch, dropped the database and reinserted the dump with no problems. However, I still login or change rows with any effect on vB as described above.


Apache problem?
php problem?
mysql problem?

I dont even know where to start

[Scott MacVicar]

can you provide me with phpmyadmin access either via pm or support ticket

the settings are cached in the template table where the title of the templates is options also it sounds like you have a cookiedomain set which is causing the login problems.

[ZERO <ibis>]

I have the same exact problem! I can login but it just logs out instantly. If I delete my cookies I can login and view the index.php but if I click anything it logs me back out. Also it is impossible to log into the admin panel even if I delete my cookies. I have been dumping and creating hundreds of test databases with no success however a fresh install works.

Please HELP

[bigwater]

Are you still on VB2? This thread is almost seven years old. I doubt if it is relevant to your situation. Perhaps you'll get better results if you'll start a new thread in the appropriate location with your specific problems.