| mehdi2 | apollo13: hi, are you around | 06:35 |
|---|---|---|
| mehdi2 | ? | 06:35 |
| mehdi2 | apollo13: zed, ping | 07:02 |
| TSA | Free pat downs for everybody! | 08:32 |
| mehdi2 | apollo13: ping | 12:59 |
| mehdi2 | zed: ping | 12:59 |
| mehdi2 | anybody can help us? | 13:00 |
| mehdi2 | I need some one look into our forum db | 13:00 |
| apollo13 | mehdi2: guess so, so I have no idea what to do… | 13:00 |
| mehdi2 | ... | 13:00 |
| apollo13 | don't do that, how should I know stupid php scripts | 13:00 |
| apollo13 | aside from that your db is fine | 13:00 |
| mehdi2 | apollo13: ok, thanks | 13:01 |
| mehdi2 | did you see the smf_messages table ? | 13:01 |
| apollo13 | I ran optimize on session and user tables though | 13:01 |
| apollo13 | there is one yes | 13:01 |
| mehdi2 | anything there ? | 13:01 |
| apollo13 | 125761 rows | 13:01 |
| mehdi2 | the last rows? anything that can help? | 13:02 |
| apollo13 | no idea, I can'T read iranian?! | 13:02 |
| mehdi2 | can you paste it somewhere for me ? | 13:03 |
| mehdi2 | any errors in db logs ? | 13:03 |
| apollo13 | doubt that, there is sensitive data in there, gimme a email addr | 13:03 |
| mehdi2 | mehdi@ubuntu.com | 13:03 |
| apollo13 | why are you looking in the db for a software problem? | 13:03 |
| mehdi2 | becaz I've seen same page before | 13:04 |
| mehdi2 | and was able to login repaire and fix from db | 13:04 |
| apollo13 | well I see no broken table, at least I don't know if mysql can tell me that without checking every table | 13:05 |
| mehdi2 | no idea | 13:05 |
| mehdi2 | zed could be useful if he had time... | 13:05 |
| apollo13 | well checking all the tables, though I don't think that's the problenm | 13:07 |
| apollo13 | status check on every table is okay | 13:08 |
| mehdi2 | ok, thanks. can I have a dump of our db to test it on a local setup ? | 13:08 |
| apollo13 | just sent you the last ten messages line | 13:09 |
| apollo13 | do you have access to the slave at eshu? | 13:09 |
| apollo13 | anyways I still suggest you check the code first before trying the db… | 13:09 |
| apollo13 | gotta go now, university is waiting | 13:10 |
| mehdi2 | I have access to checkout and yurugu | 13:10 |
| mehdi2 | ok, thanks for help :) | 13:10 |
| zed | pong mehdi2 | 13:13 |
| mehdi2 | zed: hi, sorry we have a strage problem with our forum | 13:13 |
| mehdi2 | I don't know what exactly it is and becaz I'm on a trip I can't connect to servers and check the db | 13:14 |
| zed | mh ok | 13:14 |
| mehdi2 | we've had it before and you helped resolving it | 13:14 |
| mehdi2 | I don't know maybe something useful in logs or... | 13:15 |
| zed | and what is the problem ? :) | 13:15 |
| mehdi2 | I says to everybody that your user is blocked | 13:15 |
| mehdi2 | I remember we had same when we blocked the balancer ip adress | 13:16 |
| mehdi2 | and then we had to repair and fix db from inside SMF | 13:16 |
| mehdi2 | but I've not blocked the load balancer ip this time... | 13:16 |
| zed | well, I can't remember what I did :) | 13:23 |
| mehdi2 | it's great :) | 13:23 |
| mehdi2 | but I'm not sure this is the same issue... | 13:23 |
| zed | what does the message exactly says on the homepage of the forum ? | 13:25 |
| mehdi2 | it says guest user is not allowed to login | 13:26 |
| mehdi2 | the guest user is disabled | 13:26 |
| zed | mmh ok | 13:28 |
| zed | +-------------------+-------+ | 13:33 |
| zed | | variable | value | | 13:33 |
| zed | +-------------------+-------+ | 13:33 |
| zed | | allow_guestAccess | 1 | | 13:33 |
| zed | +-------------------+-------+ | 13:33 |
| zed | too bad :( | 13:33 |
| mehdi2 | is there any administrator user or group ? | 13:34 |
| mehdi2 | smf_members id_group=1 | 13:35 |
| zed | mehdi2: yes there's "Administrator" | 13:42 |
| mehdi2 | what do you think is there any software crash ? | 13:49 |
| zed | everything else is running smoothly on the servers... :( | 14:02 |
| mehdi2 | zed: sorry is it possible to rollback the db to 19 november ? | 14:08 |
| mehdi2 | zed: can you please run REPAIR TABLE and OPTIMIZE TABLE on our forum tables | 19:35 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!