vb.org Archive
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   ipowerweb is teaching me a lesson.... and now i have hate (https://vborg.vbsupport.ru/showthread.php?t=94563)

b00k 12-21-2005 04:56 PM
Quote:
Originally Posted by SteveC
Why are you staying with them? This thread has convinced me to switch to someone new.

any new projects ive gone elsewhere. But with my current sites ive had fears of having to re-hack everything and or losing all the Db... thats basically it. :surprised:

But trust me, on my 'new' sites ive gone elsewhere. Im convinced i could run a better server from my basement :squareeyed:

tbradham 09-25-2006 07:58 PM
I have the exact same issue with iPower, and I will be moving as soon as my contract expires. My site goes down once a day if I don't "reset" it every day.

I remove the sql user's rights from the database. Log into phpmyadmin with that user. Go back and give the sql user rights to the database again. Open the database in phpmyadmin.

This also works to restore the site when it is down.

If I could only find a way to take the site offline on a schedule, I think I could live with it until December.

Marco van Herwaarden 09-26-2006 11:55 AM
How does it go down?

Do you get error messages?

tbradham 09-26-2006 12:37 PM
Fortunately it is up right now, so I can't give you the exact error message. It is the max resource questions exceeded 50,000 error message.

I do get emails to let me know it is down. Where does it get the email address from to send those error messages? I need to change it to go to my Blackberry so I can be more responsive to outages.

I changed it in the general VB settings, but they still go to the other address.

Chris M 09-26-2006 01:27 PM
If they are generated by vB you need to change the email in your config file ;)

Chris

COBRAws 09-26-2006 01:49 PM
I had the same problem with A Small Orange, they always told me it was my software running on their server the problem of everything. Then, they told me it was me (my pc lol, this was the last straw). I recently moved to another company and never got any errors agains. Ill never go back to A Small Orange ASO.

Zachariah 09-26-2006 07:08 PM
I was working on a rotation script.
- multi usernames 1 database
each user gets 50K in a given time frame. The script rotates what user VB uses.


- this needs some work or a new way of looking @ it.
- I am busy @ the moment

Old post I found
If you have a shared host for your website you may know what I mean. MySQL users get 50,000 Questions per hour. The account is banned then after the hour you get access again. :mad:

The hosts will allow you to create unlimited users per DB.

If I reindex the search index of my forums.
"" "" any part of my site that has a lot of data.

- 50,000 limit smashed and I get the no access "finger"

Quote:
Here is what I get:

Processing: 102279 ... Done
Processing: 102281 ... Querying first post of thread... Done
Processing: 102282 ... Done
Processing: 102283 ...

Invalid SQL:
INSERT IGNORE INTO word (title) VALUES ('annnnnnything');

MySQL Error : User 'root' has exceeded the 'max_questions' resource (current value: 50000)
Error Number : 1226

Idea: "user load balance" (this may be done somewere)
- I could use some ideas
- would make a nice "how-to" also :D

forums/config.php

Code:
EX: w/ vBulletin 3.5.4

//        ****** DATABASE NAME ******
        //        This is the name of the database where your vBulletin will be located.
        //        This must be created by your webhost.
$config['Database']['dbname'] = 'forums';

        //        ****** TABLE PREFIX ******
        //        Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

        //        ****** MASTER DATABASE USERNAME & PASSWORD ******
        //        This is the username and password you use to access MySQL.
        //        These must be obtained through your webhost.
$config['MasterServer']['username'] = 'root';
$config['MasterServer']['password'] = 'password';

        //        ****** MASTER DATABASE SERVER NAME AND PORT ******
        //        This is the hostname or IP address and port of the database server.
        //        If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;


// Database array for Random users
// ##########################################
$dblogins = array();
        //        ****** MASTER DATABASE USERNAME & PASSWORD ******
        //        This is the username and password you use to access MySQL.
        //        These must be obtained through your webhost.
$dblogins['1']['user'] = 'root2';
$dblogins['1']['pass'] = 'password';

        //        ****** MASTER DATABASE USERNAME & PASSWORD ******
        //        This is the username and password you use to access MySQL.
        //        These must be obtained through your webhost.
$dblogins['2']['user'] = 'root3';
$dblogins['2']['pass'] = 'password';

        //        ****** MASTER DATABASE USERNAME & PASSWORD ******
        //        This is the username and password you use to access MySQL.
        //        These must be obtained through your webhost.
$dblogins['3']['user'] = 'root4';
$dblogins['3']['pass'] = 'password';


// Place this below every thing.

// ********* The following does NOT need to be edited and is only used for multiple DB users ************
srand((float) microtime() * 10000000);
$dbloginid = array_rand($dblogins);
while ($dblogins[$dbloginid]['user'] == '')
{
        $dbloginid = array_rand($dblogins);
}       
$config['MasterServer']['username'] = $dblogins[$dbloginid]['user'];
$config['MasterServer']['password'] = $dblogins[$dbloginid]['pass'];

unset($dblogins, $dbloginid);
This will work but It still needs:
- counter in session memory per user and stop using account when close to 50k.

or

- IF mysql connect gives error ER_USER_LIMIT_REACHED (Error Number : 1226) THEN skip that user and use the next one.

tbradham 09-26-2006 07:39 PM
Quote:
Originally Posted by Chris M
If they are generated by vB you need to change the email in your config file ;)

Chris

Where is it? I know it should be in the root of my VB install, but it's not there?

da420 09-26-2006 07:42 PM
It's in your includes folder.

peeknpeak 06-20-2007 11:59 AM
They completely LOST my whole site for a week. 12 tech calls with no fix or site found. When I call Billing to ask for compensation, a Billing Supervisor found my site and restored it back to January. (It's now June) It's been a week of more Tech support with permissions errors everywhere.

I have three VB sites on iPower.:(:mad::down:

Daily e-mails:
User 'peekn' has exceeded the 'max_questions' resource (current value: 50000) Error Number : 1226


All times are GMT. The time now is 06:38 AM.
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

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.01137 seconds
  • Memory Usage 1,751KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete