chrometweaks.org

How to evaluate the QuickBooks iPage hosting service provider?

Click Here To View All Answers...


My 1st question is: How to evaluate the QuickBooks iPage hosting service provider? Many thanks for any response. Second question of mine... Have just managed to get my virtual local server part setup, in that I have managed to get past the phpmyadmin login screen on my local host to show this screen:.

However their is an error at the bottom that reads:.

The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!.

I found this in phpmyadmin>config.ink.php:.

$cfg['PmaAbsoluteUri'] = '';.

/**.

* Disable the default warning about $cfg['PmaAbsoluteUri'] not being set.

* You should use this if and ONLY if the PmaAbsoluteUri auto-detection.

* works perfectly..

*/.

But I don't know it's significance or what to do with it..

Any ideas?.

My second issue is the following message on the same screen:.

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole..

Again, I'm not sure what do about this..

Thanks.

Mark..

Comments (13)

Hmm... I need to find out myself. I don't know what is the answer to your question. I'll do some Googling and get back to you if I discover an answer. You should email the people at iPage as they probably could assist you..

Comment #1

This is for my own developement so that I can make upgrades without disrupting my customers..

Thanks.

Mark..

Comment #2

Ok then change the line.

$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;.

To.

$cfg['PmaAbsoluteUri_DisableWarning'] = TRUE;.

This is for the first message as for the second you can set a password or just ignore the message or disable the warning..

These will not stop things running and as there is no public access you have less worries..

This allows you to concentrate more on the work...

Comment #3

Thanks alot that was extremely helpful. I am trying to import my database that I have dumped from my live site. It is 15meg in size and when I try to do this it runs for about 10 minutes and times out..

It appears that the iPage site dump is too big for it too handle..

Any suggestions?.

Thanks.

Mark..

Comment #4

Change the execution time limit.

$cfg['ExecTimeLimit'].

Also in php.ini change the script memory sizes to something like 32M.

Max_execution_time = 300.

Max_input_time = 600.

Memory_limit = 32M.

You can also split the sql file in to more managable chunks..

This post has been edited by.

241.

: 19 July 2004, 18:40..

Comment #5

Thanks for your help Steve this sort of information is obviously buried deep in manuals, so you are saving me loads of time..

I got the first bit OK, but I don't know where to find php.ini..

Thanks.

Mark..

Comment #6

Sorry, and how do a split file into smaller chunks?..

Comment #7

Still don't have answers for the above 2 questions, but also - have adjusted the allowed download time at $cfg['ExecTimeLimit'] in the config.inc.php, but I am getting this message that I wasn't getting before:.

CGI Timeout.

The specified CGI application exceeded the allowed time for processing. The server has deleted the process..

I have tried this several times over trying to upload my iPage site dump as zipped or unzipped, but still not successful..

$cfg['ExecTimeLimit'] is set to 0 - which it says means unlimitted, but did also try putting in 12000 and it timed out well before reaching this..

Thanks.

Mark..

Comment #8

Is this an install of easyphp if not that is the easy option for local setup..

Php.ini will be found by using the search function and searching php.ini.

The file is normally located in the root or where apache is installed..

Comment #9

As for splitting the file open the file using something like notepad and highlight some complete sections of tables and cut and paste to a new file..

Obviously do this with a copy of the file in case of an oops..

Or send the file to me and I will send you back several files each of a much smaller size..

Changing the timeout and script memory size in php.ini will allow handeling of larger scripts..

Set the exectime in the phpMyAdmin config.inc.php to 300.

This post has been edited by.

241.

: 19 July 2004, 20:14..

Comment #10

I did do a search, but it didn't find this file. I have setup a virtual server via IIS on windows xp. I have phpmyadmin in the root directory and mysql version 4 on my c:\...

Comment #11

If this is your local system then you have total control over everything, uploading a 15 mb file you are better off using mysql from the command prompt, go to the dos prompt, then cd \mysql\bin.

Run mysql, ie mysql -u root -p databasename.

Then enter the root password.

Just to be on the safe side, use databasename;.

Then type in:.

Source databasename;..

Comment #12

OK it has now said that it has successfully uploaded the file, but it is nowhere to be seen...

Comment #13

Go back to your phpMyAdmin and open the database which should now be populated. When saying the file uploaded you do not see an actual file as you are loading the contents of the file into the database..

Not the best explanation in the world but should do the job..

Comment #14


This question was taken from a support group/message board and re-posted here so others can learn from it.