After weeks of frustration with my SHARED server, I am relocating to a VPS. For the life of me, I can't find the post or instructions on the steps to follow.

-

Has anyone seen this? Please post link.

-

Thanks.

-

Lorren

Are you getting your VPS from the same server company?  If so, can they not transfer it for you together with the IP etc? If I am not mistaken, this should be a painless procedure. Please confirm whether I am correct.

Regards

Stuart

No, the shared server host does not offer VPS. I am going with a brand new (new to me) US based company.

-

Lorren

Lorren, I have not done this but: in my CPanel it gives me the option to copy the site as opposed to doing a 'backup' it states that this type of backup is for moving your site to a new server. Maybe this is an option?

Just my 2 cents, have you already paid for the new VPS? try to consider cyberxing they do full support and gives painless transfer.

Already paid...My shared host uses HSphere....New host is using CPanel but that is of no use in this particular situation.

-

Any other thoughts...

-

Thanks as always,

-

Lorren

Lorren,

1.  Backup your database using the Dolphin backup facility.

2.  Download everything to your local computer (using Filezilla, or whatever you use).

3.  Uploaded everything to your new server.

4.  copy the database backup file you made to the Dolphin backup directory on your new server ,

5.  Restore the backup file using Dolphin's restore facility.

6.  Change your DNS pointers

There might be more to it than this, but at least this procedure is in writing, and people here can shoot holes in it if I have said anything wrong.

Good luck

Rob

Hey Thanks a bunch, Rob...been struggling today.

-

Lorren

you can also ask your shared host to zip everything up for you so you can download the zipped file. this would help in time management as well as data loss possibilities when transferring via ftp.

good luck, if you need help gimme a shout, and i will see about helping you out.

regards,

DosDawg

Thanks DosDawg!

Would that be the case if you are moving from one domain to another, Sammie?

I've been setting up Dolphin on a spare domain of mine but it's intended to actually go 'live' on a different one. I'm almost ready to move it to the other domain and was going to ask how to do that.

Both domains are on the same server and same IP address, just are different TLD's.

That's what I was thinking also - her url will be exactly the same, though this is good to know if you change domains.

You shold also update each of your periodic/xxx.php files where you find the require once in each like:
require_once( '/home/youraccount/public_html/inc/header.inc.php' );

*I think this was mention but often overlooked.

Then you will also probably have to add the crons with your new host. If updating / transferring be sure to double check the crons and paths are set right.

You shouldn't need to do anything to ray/modules/global/js/integration.js with dolphin 6.1x, but you will with 6.0x

And finally if you are going from hsphere to cpanel...by the way cpanel is the $$ in my opinion, that's another story though.

But if they are just ftp'n files. You will want to check, double check and re-check file permissions.

If this is vps with full root privs and what not you are going to want to take some time when you get a chance to learn more linux, ssh commands, and how to add additional security you are used to having a shared host handle on there end. With vps generally it is all yours. They setup the basics but it's up to you to take care of this baby, and keep it on a leash.

Good Luck!!
gameutopia

Thanks guys. I haven't actually paid for any licence's yet, I figured there would be issues when transferring from one domain to another.

The intention is to transfer to the proper domain when everything is set-up as I want it on the test site and then purchase the appropriate licence's. I'm assuming, perhaps wrongly, that the RMS providers will be fine with me transferring from one .tld to another?

Thanks for your input Sammie...appreciate the outline of the files to be edited. I knew there were certain files to change but was unsure of them all.

-

gameutopia, do you have a tutorial on your site for these suggested security measures? Can you suggest a reference that would be helpful to me and others? Saw MScott's post.

-

Thanks all...this post will be a good reference!

-

Lorren

There is an option available in the WHM, which will enable you to transfer your account from another server. If you do so, you don't have to worry about anything.

Don't have to change paths, crons etc.

Ok, so the move didn't go so well...

-

I just reinstalled v6.1.4 on the new host. Then within dolphin admin, I went into Database Backup and restored the dump performed on old host and uploaded to new host.

-

I can access Admin now...but I get a database error. And this message keeps coming from cron:

-Unable to create lock file:  Permission denied
Failed to start up concurrent users module!

-

Lorren

-

Also I get database error when trying to see the site as a visitor even.

The permissions for the mysql database are 0644. Is this correct? The Backup Folder is 0777.

Here it the link that I was after...

-

I need to transfer my site to another folder/server. What do I need to do? ¶

1) First of all, you need to back up your folders and files and your database tables. It usually results in creation of two archives (.tgz or .zip) which you will have to unpack on your new server/folder; besides, the database tables will have to be imported in your new database.

2) Dolphin 6 has several files which must be changed after transferring to another folder or server:

• inc/header.inc.php change the values of the following variables according to your current settings:

$site['url'] and $dir['root']

and all the elements of $db array (it's not usually needed if you just move your site to another folder on the same server)

• cupid.php, notifies.php, cmd.php files in periodic folder. All of them have lines as follows:

  require_once( '[path_to]/inc/header.inc.php' );
  

where [path_to] must be changed according to the current path to Dolphin folder

Note: You also need to change the paths for each cron running for the above mentioned files.

• ray/modules/global/inc/header.inc.php

edit the line

include("[path_to]/inc/header.inc.php");

the same way as described above

Hi all,

I followed the instructions above in changing my domain name and host however everytime I login I get the following error

Warning: fopen(/home/izsocial/public_html/cache/user1.php)[function.fopen]: failed to open stream: Permission denied in /home/izsocial/public_html/inc/profiles.inc.php on line 659

Warning: cannot modify header information-header already sent by (output started at  /home/izsocial/public_html/inc/profiles.inc.php on line 659) in /home/izsocial/public_html/inc/design.inc.php on line 2041

any advice??

praveenky,
bud, the only way to use the transfer is to be leaving a cpanel hosted site, she said she didnt have cpanel, and had hsphere, therefore, a cpanel transfer from whm would not work. that is why that was not brought up. thanks for trying though.


regards,
DosDawg

Any one has any idea ?

empty cache folder //except htaccess

Ok, so tried it BOTH ways. Complete new reinstall using the database that I backed up AND uploading the site and changing all of the appropriate files as per Sammie. (game you were correct for v6.1 no need to edit integration.js)

-

Still getting the RED database error when trying to access.

-

Also notifies cron sending out this email error:

-

Unable to create lock file:  Permission denied
Failed to start up concurrent users module!

-

Help need please.

-

Thanks.

-

Lorren

Check /cache and /tmp permissions = 777  ..... 
.

oh man this is your thread L

hmm i get confused when people hijack threads....

somethings up...please post the mysql error..not all of it needed...just the part "Mysql error: you have ...."

DB values dont match files. with the info i can tell u right away...

That worked thanks RumpyBumpy

Sorry to be sooooo dense...but where do I find that error log? The only one I see is my Apache error log.

-

Should allow_url_include be ON or OFF?

Yes, I know this is not an error log. But with it being a new-to-me VPS...just want to make sure they did it right.

PHP Version 5.2.6

Only receiving the email errors:

-

Unable to create lock file:  Permission denied
Failed to start up concurrent users module!
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>
<title>Dolphin Smart Community Builder Installed</title>
<link href="install/general.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
</head>

<div id="main">
<div id="header">
<img src="install/images/boonex_logo.gif" alt="" /></div>
<div id="content">
<div class="installed_pic">
<img alt="Dolphin Installed" src="install/images/dolphin_installed.jpg" />
</div>

<div class="installed_text">
Please, remove INSTALL directory from your server and reload this page to activate your community site.
</div>

AND IT IS DELETED!

it should come to your email box the one thats in your inc/header.inc.php   bug line

This is what my Apache error log says:

-

client denied by server configuration: /home/coffee13/public_html/error_log
client denied by server configuration: /home/coffee13/public_html/.htaccess
client denied by server configuration: /home/coffee13/public_html/error_log
client denied by server configuration: /home/coffee13/public_html/.htaccess
client denied by server configuration: /home/coffee13/public_html/error_log
client denied by server configuration: /home/coffee13/public_html/.htacce

That is what I thought...but what I have posted from emails is all I am getting from notifies.php .

-

This is what all of them are saying:

-

Unable to create lock file:  Permission denied
Failed to start up concurrent users module!

Lorren,

Try adding
Options FollowSymLinks
to your root /.htaccess file  ..... 

Where should I add...exactly Rumpy...I haven't had my Wheaties tonite. I've opened .htaccess. Options at the top?

-

Above the
<IfModule mod_rewrite.c>
line should be fine  ..... 
.

Nothing is being sent...double checked that email.

-

New error after Rumpys edit

-

Options -MultiViews
Options -FollowSymLinks

<IfModule mod_rewrite.c>

-

Forbidden

You don't have permission to access /roundtable/index.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Ok if apache v2.0 change it to this and try ..... 
<Directory> Options FollowSymLinks AllowOverride None </Directory>

If apache v2.20 change it to this and try  ..... 
<Directory> Options FollowSymLinks AllowOverride None Order deny,allow Deny from all </Directory>

Remove obviously if that's not it  ..... 

ApcheV2.29

-

New error...didn't work.

-

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@coffeehousedigest.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

-

O well  ..... 

The "client denied by server configuration" suggests something is preventing access just can't point the finger  ..... 

This post is not the easiest to follow  ..... 
.

Has anyone ever seen this error?

-

Unable to create lock file:  Permission denied
Failed to start up concurrent users module!

-

Lorren  .....  remove your root /.htaccess file temporarily and test to see if any difference  .....  (back it up of course)

No, but here is the first reference on Google, which you have probably already looked at: http://forums.visualtour.com/showthread.php?t=315

-

update - poking around a bit on this, it might be a VPS thing - I'm betting your new host will know.

Just wondering when you are using your database from your other host did you import it with phpmyadmin maybe?

Or are you creating a brand new database using cpanels create database feature?

I am just wondering if you have also used cpanel mysql feature to create a database user and if so if you have given the database user the permissions to access the database such as lock tables and such? Not sure if this is what it might be referring to or not. There is lock table, but I'm not sure about the lock file part right off hand. If anything comes to me I'll reply back here.

Also not sure where you are at with this, but you are probably going to have a slightly different format than you are used to seeing with hsphere.

Cpanel database format
youraccount_databasename
youraccount_databasenameuser
databasepassword

So in header.inc.php it would look something like:
$db['host']                = 'localhost';
$db['sock']                = '';
$db['port']                = '';
$db['user']                = 'youraccount_databaseuser';
$db['passwd']              = 'databasepassword';
$db['db']                  = 'youraccount_databasename';

Usually the youraccount part would be your actual cpanel login.

Just a couple of thoughts. Maybe you've tried and done all this already.

gameutopia,

-

I created the database backup from inside the Dolphin admin panel on OLD host from prior working install.

-

Then, I created a database with cpanel on NEW host AND once Dolphin was migrated, imported the OLD host database backup from within the Dolphin admin panel on NEW host...make sense?

-

Yes, double-checked the header.inc.php file and all looks like you stated here.

-

Trying again from scratch to see if I can install without using database backup, but would still appreciate it if someone can tell me what to try or look for next. Ugh.

-

Lorren

-

Host will not help with Dolphin software. I have to know why the software is not working, then they can make appropriate changes to server for me OR I can do it. I think I'll let them do it...but I have to know what is happening. What script won't connect or what the database requires that it is not getting.

-

I am going to compare the php.ini file for this NEW host against OLD host, where the software was working.

-

Thanks for the tip.

-

Lorren

-

Then, I created a database with cpanel on NEW host AND once Dolphin was migrated, imported the OLD host database backup from within the Dolphin admin panel on NEW host...make sense?

Lorren,

As gameutopia asked; did you also create a user for the new database and add the user to the database and give the user privileges?

Review gameutopias last post again and feel free to ask questions  ..... 
.

Lorren,

You said you admin panel was working, is that correct?  Did the entire Dolphin ever work before you did the install?  If it did, I'm wondering it it would be better to backup to that version and then do a restore by individual tables.

Rob

Ok, brand new install on VPS. Still get database error when trying to access.

-

Database error in CoffeeHouse digest
Query:

SELECT
`ArticlesID`,
`Articles`.`CategoryID`,
`Date`,
UNIX_TIMESTAMP(`Date`) AS 'Date_UTS',
`Title`,
`Text`,
`CategoryName`,
`ownerID`
FROM `Articles`
INNER JOIN `ArticlesCategory` USING( `CategoryID` )
ORDER BY `Date` DESC
LIMIT 2


Mysql error:
Can't create/write to file '/tmp/#sql_17b9_0.MYI' (Errcode: 13)

Found error in file /home/coffee13/public_html/members/inc/classes/BxDolArticles.php
at line 694. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/coffee13/public_html/members/inc/classes/BxDolArticles.php
[line] => 694
[function] => db_res
[args] => Array
(
[0] =>
SELECT
`ArticlesID`,
`Articles`.`CategoryID`,
`Date`,
UNIX_TIMESTAMP(`Date`) AS 'Date_UTS',
`Title`,
`Text`,
`CategoryName`,
`ownerID`
FROM `Articles`
INNER JOIN `ArticlesCategory` USING( `CategoryID` )
ORDER BY `Date` DESC
LIMIT 2

)

The Dolphin admin panel you can get into on BOTH new install AND migration. But once you click out of that admin page to do anything...it kicks an error.

-

And yes Rumpy with the new install (I have completed fresh installs about 10 times now on old host and never had a database error) I created an entirely different database in CPanel with all privileges. Double-checked header.inc.php....but that sets up with NEW install anyway...you just have to make sure you input database name, username and password correctly, as you set it up.

-

This has to be related to the configuration on the new VPS.

-

 as you probably have already double checked the permissions on the files, also make sure the owner/group/public permissions are set properly too, if you are using the hosting control panel.

Since this VPS stuff is new to me...I checked the public.html folder for the owner/group/public permissions and they were set to 750, changed them to 754...still database error.

This is the error after changing permissions: This is on the Fresh install on new host.

-

Mysql error:
Can't create/write to file '/tmp/#sql_17b9_0.MYI' (Errcode: 13)

Found error in file /home/coffee13/public_html/members/inc/classes/BxDolArticles.php
at line 694. Called db_res function
with erroneous argument #0

what's the permissions on the tmp directory?

Error code 13 can be caused if:

- user/host permissions are wrong
- file permissions are wrong
- mysql not running

777 on both.

 did you check the file permissions on /tmp ? and does it have the .htaccess file in the /tmp folder?

The file permissions were double-checked for the fresh install.

-

user/host permissions should be what? New to this VPS environment, not sure what to check here and what it should be.

-

mysql not running? That is a new one to me. Can you explain?

-

Thanks...

-

Lorren

-

if user/host/file permissions are correct and it's still error 13, I know of (nor can find) any other reason for it..

To Start MySQL Server

login to the console via SSH with putty and type:

/sbin/service mysqld start

sorry, user should have full permissions, you've already said that you created a new user with full permissions so it can't be that, file permissions have been checked and rechecked etc.. that leaves only mysql not running (unless there is another reason for error code 13).

Permission Reversal ¶

Now you should set the post-installation permissions and after delete the install folder.

• Using FTP client.

Log into your FTP account using your favorite FTP client and navigate to the folder in which you have installed Dolphin script.

Notice the chmod commands for specified folders and files on the final installation screen and set the following permissions using right click on the corresponding files and folders:

755 for folders (755 means that the objects possessing these permissions will be readable and executable).
644 for files (644 means that such objects will be only readable).

• Using shell client.

Log into your shell account using your favorite shell client and change directory for that which contains your installed Dolphin script. Now run the following commands under your SSH prompt:

chmod 755 ./inc ./periodic
chmod 644  ./periodic/cmd.php ./periodic/notifies.php ./periodic/cupid.php ./ray/modules/global/inc/header.inc.php

Now you must delete the /install folder.

 

 

 

http://www.boonex.com/trac/dolphin/wiki/GenDolFAQs#Ineedtotransfermysitetoanotherfolderserver.WhatdoIneedtodo

ok, so I was wrong.. maybe ;)

check here http://www.astahost.com/info.php/mysql-errors-error-13_t7854.html 

tmp dir is 777.

-

.htaccess is there in tmp folder. Here is what it says:

-

Options -Indexes
<FilesMatch "^.*\.php|.*\.html$">
ForceType application/x-httpd-php-source
</FilesMatch>

-

This was done AND I double checked each file and folder AGAIN just now.

-

• 
  
• 
  
• 
  
• 
  
• Using shell client.

Log into your shell account using your favorite shell client and change directory for that which contains your installed Dolphin script. Now run the following commands under your SSH prompt:

chmod 755 ./inc ./periodic
chmod 644  ./periodic/cmd.php ./periodic/notifies.php ./periodic/cupid.php ./ray/modules/global/inc/header.inc.php

Now you must delete the /install folder.

Do you still have access to the old hosting?

Ok kiddies...both databases on the now are throwing the same mySQL error.

-

Mysql error:
Can't create/write to file '/tmp/#sql_17b9_0.MYI' (Errcode: 13)

-

This is happening for the MIGRATED dolphin site AND the FRESH INSTALL dolphin site.

-

All permissions have been double checked, paths in files double-checked.

-

This has to be a server configuration on the VPS that needs to be addressed.

-

~ Lorren

Yes I do...Should I try to copy the php.ini file from old host/server to the new one?

-

Quoted:

 1) First of all, you need to back up your folders and files and your database tables. It usually results in creation of two archives (.tgz or .zip) which you will have to unpack on your new server/folder; besides, the database tables will have to be imported in your new database.

I would go into the old hosting phpmyadmin and do a database backup to a .sql or .zip file then remove your current database tables on the new host, keep the database intact just remove the tables. then run the old .sql or zip file in the new phpmyadmin panel.

I personally dont trust these backups from software because things can corrupt the file and if the previous database tables werent locked at the time of the backup. you can see if this helps to work around possible issues with the vps setup.

no on copying the previous php.ini

Lorren,

Did you follow the #2 in the detailed installation instructions and properly create the database user with privileges .....  ?

.

You mean this.....

-

Create a Database and a User ¶

Using CPanel

If your hosting provider has cPanel, you can follow these instructions to create your Dolphin database and user.

1. Log in to your cPanel.

1. Click MySQL Databases.

1. Create a database user:

1. Choose a username for Dolphin (for example "dolphin") and enter it in the Username field.

1. Choose a difficult-to-guess password (ideally containing a combination of upper- and lower-case letters, numbers, and symbols), and input it into the Password field.

1. Click Create user.

1. Create a Dolphin database and add the user to it:

1. Choose a name for your Dolphin database (for example "dolphin" or "community"), input it in the New Database field and click Create Database.

1. Under Add Users To Your Database, select your Dolphin username from the User dropdown list, then select your Dolphin database from the Database dropdown list. Make sure ALL is checked under Privileges, then click Add User To Database.

1. When you return to the main MySQL Account Maintenance screen, cPanel will list information about the database you just created. You should see the username you just added to the database (with ALL PRIVILEGES), as well as a few sample Connection Strings for you to use in Perl or PHP scripts to connect to the database. The PHP code will have the following format:

   $dbh = mysql_connect("hostname", "username", "<PASSWORD HERE>") or die ("message");
   mysql_select_db("databasename");
   
   

Write down the values of hostname, username, databasename, and the password you have chosen. (Note that hostname will usually be localhost.)

Absolutely yes.

This wouldn't explain the SAME 13 error that I am getting on the BRAND NEW install that I did this morning with a new database to see if this was a database error issue.

-

Lorren

-

There is something that need to be configured differently on the server...otherwise I won't be able to install Dolphin for any new sites here.

-

Damn I'm fed up!

-

L

 I agree your correct on the fact it shouldnt do this on a Complete new install, have you done a phpinfo to check the servers configs?

If you are getting the same errors on both the transfer and a fresh install, I would call your host and bitch - maybe ask for your money back.  People do installs on all sorts of hosts here- it shouldn't be this much of an issue.  There are other hosting alternatives.

-

Rob

Yes, some of it is posted above. What other config should I check.

-

 PHP 4.4.0/5.1.0 and higher (register_globals must be Off, safe_mode must be Off, exec() must be allowed and allow_url_fopen also must be On) with mbstring, domxml and xsl extensions (they are required to run Orca forum and support UTF-8)

Hey Rob,

-

They have a 90 day money back guarantee, no questions asked.

-

They do not trouble shoot third party software. This shouldn't be such an issue...but there needs to be MORE detail on certain configurations for the server available to double-check.

-

(sob)

-

L

-

Recently been attacked by

"Can't create/write to file '/tmp/#sql_28e2_0.MYI' (Errcode: 13)"?

Then its a simple fix, please DELETE (backup first) your SOURCE files that talk to the MySQL database, and re-upload them

This will purge them from the system and force them to recreate the temporary files.

Do NOT delete your database, just backup your files, delete them, re-upload them and youll be fine.

This is due to MySQL crash. Easily fixed and no data has been lost.


(I would assume that the temp file name would vary...)

Found everything as it should be except couldn't see or find exec() or xsl extensions. Can you give me specific area on my phpinfo file so that I can double check those two items?

-

Thanks.

PHP 4.4.0/5.1.0 and higher (register_globals must be Off, safe_mode must be Off, exec() must be allowed and allow_url_fopen also must be On) with mbstring, domxml and xsl extensions (they are required to run Orca forum and support UTF-8)

Thanks lazaru...but this shouldn't be the case for a FRESH INSTALL using a BRAND SPANKING NEW database.

-

L

BxDolArticles.php is the file named in the error email..

back-up that file, delete it, re-upload, and see what happens... (that's how I read that advice ^^^...)

Thanks. At this point anything is worth a try.

-

 The XSL and domxml should be located near the bottom of the page, the exec() I would have to assume since its not listed in the information that it means that file execution is allowed. As you notice I dont have domxml only xml which is because Im on a windows server and cant run both Domxml and standard xml at the same time.they conflict but your setup should use Domxml.

Found everything except exec(), which should be allowed. Talking with host now.

-

PHP 4.4.0/5.1.0 and higher (register_globals must be Off, safe_mode must be Off, exec() must be allowed and allow_url_fopen also must be On) with mbstring, domxml and xsl extensions (they are required to run Orca forum and support UTF-8)

I am making this host jump thru the hoops...he came back to tell me that all VPS are exec() allowed. Placed a file that I can call that checks this.

-

All the commands are there and correct.

-

Lorren

You know this is probably something very simple and has been overlooked. Funny cause I dont know how you are or others but I do it all the time , overlook stuff and then I find it and say what the heck was I thinking. Wish I could help more Ill still give it some more thought.

linksys7,

-

I have installed this Dolphin about 10 times on my old shared server...ne'er a problem. I also thought this would be a breeze to migrate, but when that was throwing errors...I decided we better do a complete fresh install. And that one is also throwing errors.

-

The part that also puzzles me is that weird error:

-

Unable to create lock file:  Permission denied
Failed to start up concurrent users module!

-

I have my old host with dolphin still in tact with license, AND then when I migrated to new host, I also entered the license over here. I wonder if Boonex pings that license and if it detects it in two places...it shoots out this error.

-

And yes, the DNS points to the new VPS. So it doesn't make sense to me either.

-

Thanks for you help....

-

Lorren

do you have shell access? if so do

shell> perror 13

to see what results you get for the Mysql

http://dev.mysql.com/doc/refman/5.0/en/cannot-create.html

I can have it...but if I mess it up...it will cost me for them to fix. So for now...I have placed a ticket asking them to check this for me. I looked at the explanation of not being able to write to temporary directory.

-

Is there a way that I can do this?:

-

One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option file. For example, to specify a directory of C:\temp, use these lines:

[mysqld]
tmpdir=C:/temp

[mysqld]
tmpdir=C:/temp

 To add an option to  mysqld has to be done through the my.ini config file , you have to have administrators right to access the Mysql server or config files. Im not real familar with VPS so i dont know how much access you have, but this might have to be done by your hosting.

Is this a windows server your on?

It is Linux. And I basically can have permission to go in and do whatever...currently I refused shell access so that I wouldn't mess anything up. I have all the options to re-boot server etc.

-

"To add an option to  mysqld has to be done through the my.ini config file , you have to have administrators right to access the Mysql server or config files. Im not real familar with VPS so i dont know how much access you have, but this might have to be done by your hosting.

Is this a windows server your on?"

Are table and field names changed to lowercase??

 Ok its linux, then you need to locate the my.ini file on Mysql and shut down the mysql server , add the

[mysqld]
tmpdir=path/to/your/tmp

to your my.ini file save it , then restart mysql..

But just as a note here, If you have a /tmp folder outside your public folder I would use this and reference it from the inc/header.inc.php instead. I dont know if there are any security issues in having a database tmp folder in public access area.

This also means that the mysql server has to reside on the same machine as your linux.

Hi okweb,

-

Haven't checked: With the fresh install I assume that Dolphin takes care of that for you and with the migration I followed the wiki docs and Sammie's directions to a T. Then for the migrated site I ftp'd the dump of the database to the backup dir of the migrated site. I then went into the Dolphin admin to re-upload that dump database.

-

Should I check and how do I check?

-

~~ Lorren

Open phpMyAdmin and you will se it

Some of them are and some are not...

-

Just went back to old host phpMyAdin...different Dolphin installation that is running on shared server and that table/field names are the same...some capitalized and some lowercase.

-

...

Ok, then I think linksys7 have found the answard for you
- MySQL cannot create a temporary file for the result set in the temporary directory
and reason can be directory used for storing data files is write protected

it would seem someone has their website somewhat working now? if so what was the cause of the issues?

LINKSYS7 THANK YOU!

Yes....this WAS the issue. Here was the answer by the host to my ticket:

-

Error 13 means permission denied, when MySQL tries to dump temp files and can't. I opened the directory that it was writing to so it should work now.

-

And they do!!!!!!!!

-

-

Both directory of sites appear operable now....it only took 100 posts to fathom this one out. It needs to be added somewhere for those on a dedicated or VPS, that the temporary directory for mySQL needs to be writable or open.

-

So I did my due diligence here and linksys7 deserves a HUGE THANK YOU because if I don't know what to tell them to do..they can't fix it. Note: they had the Technical Requirements from Boonex for setting up my VPS. Really, isn't this a standard for servers or is this just specific to Boonex?

-

I had called tech support and said I was getting a mySQL error 13 and they said they didn't know what that was.....shouldn't these people know this stuff and what it means?

-

Well this part of the puzzle is in place ....I'll keep you posted with any other issues regarding migration. Might help someone else.

-

Thanks to everyone who posted a suggestion!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! PROBLEM SOLVED.

-

Your welcome, and yes they should know that type of information if they plan on running hosting for clients but oh well, glad you got it all worked out, good luck with it all. 

Might I add that without team work problems like this couldnt be solved. This is why I like this community because everyone jumps right in and helps.

It's my turn to move my Dolphin install next. This thread caused me to wonder whether it was going to be a nightmare or not.. (I hope in my case it will be easier and smoother than Lorren's)

Just be on standby guys, I may need your help (next couple of days or so...)

Glad you got it sorted though Lorren :)

I know - what an ordeal, I hope my shared server holds up for a while so I don't have to go though this.   So Lorren, after this record breaking thread can you tell us- is your new VPS really fast?

Cron serving up error now....uh duh...the header.inc.php file is there... What's up with this?

-

Note to lazaru: Just make sure that you follow ALL of the steps perfectly as did I. Double and triple check everything. If you are using a different directory..make sure that any files you have edited you change those paths to pick up images and such. And of course make sure that your mySQL tmp directory is OPEN, can be written to.

-

Note to Rob: It is as quick as the Boonex forums here...that's the best that anyone can hope eh?

-

Ok, now back to the cron error below...ideas?

Warning: require_once(/home/coffee13/public.html/roundtable/inc/header.inc.php): failed to open stream: No such file or directory in /home/coffee13/public_html/roundtable/periodic/notifies.php on line 21

Fatal error: require_once(): Failed opening required '/home/coffee13/public.html/roundtable/inc/header.inc.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/coffee13/public_html/roundtable/periodic/notifies.php on line 21

Line 21 in notifies.php asks for this

require_once( '/home/coffee13/public.html/roundtable/inc/header.inc.php' );

Simple typo error here. (Just talking out loud.)

-

Should be:

require_once( '/home/coffee13/public_html/roundtable/inc/header.inc.php' );

The "headers already sent" error is usually caused by having white space before or after the opening and closing PHP tags (<?php . . . ?>)

In a PHP file there should not be a space(s) before the beginning <? or after the closing ?>  ....

Have you recently edited any PHP files or the file indicated?
.

Found the error....but thanks...If I get something like that again, it is just one more thing I can check.

-

require_once( '/home/coffee13/public.html/roundtable/inc/header.inc.php' );

require_once( '/home/coffee13/public_html/roundtable/inc/header.inc.php' );

Holy cow this one is 100+ replies I think.

when your done with this one loren you should be able to write the book on how to switch from hsphere shared to cpanel vps.

Hope you got it all sqauared away. Once you get the site working, then you can play around with tweaking that vps and setup. Should be fun...or maybe not, well yes it will be fun.

good luck!!

gameutopia

Yes I think I have the record here...

-

Site is up and running...but I am having issues with the Classifieds....the subDirectories are not there...ads are, but you can't edit or add any new ones.

-

See my other post on this...maybe it will be another record.

-

~~ Lorren

-

UPDATE: Moved my second Dolphin to the new VPS server.

-

I was literally holding my breath while refreshing the page ....

-

And it loaded PERFECTLY (hope I didn't speak too soon ) ...

-

Not an error to be seen so far!

-

It just goes to show that if the server is set up correctly...Dolphin will follow.

-

L

L,

i have been saying that from the beginning of some of these threads that were created about why they couldnt do one thing or the other, and when i would post that it was a server related issue, i would get criticized when i knew full well that it was a server problem, as i had personally experienced the same issues and had them resolved on the server i was working on. problem i have is when i start trouble shooting, i tend to change 5 or 6 things at one time, so never know what exactly the cause was that resulted in the problem, nor can i pinpoint the resolution. i.e. the ordeal with xml and xslt, when i kept stating it was a server problem, i would have posts from five or six, who would say there was nothing wrong with the server. i think killerhai suffered the longest with that issue, and finally there was some setting on the server that was changed by his tech support, and orca started working. why am i rambling you might ask, dont know might be bored, might be avoiding work, but i read your post, and wanted to see if you got it sorted, and you have Congrats on that.

as a second note to anybody who is hosting this script. i know its not a developers recommendation but i would personally recommend hosting on nothing but a server WITH WHM / CPANEL. that way you can do a server to server transfer with your complete site staying intact. there is still the need to go to cpanel file manager and compress your directory as well, you can then download that for your content backup, and backup the dbase, not from within the script, but from phpmysql, create a clean sql backup. now you have a physical backup, then do the whm/cpanel transfer. i have had this work for me 98% of the time.

well i am done rambling,

Regards,

DosDawg

WHM / Cpanel is by far the most popular host control panel out there. It is one of the easiest to use, and updated often. Sometimes even nightly. I agree with you Dog, I would take this one for the popularity in switching hosts alone. Transfers are fast and easy, and no need to update your file permissions. If you choose the same username/login for cpanel as the old host all databases will also work with without any modifications in most cases.

I say it all the time too, not all hosts are setup and configured to run dolphin and all the extras...ray, orca, etc. Many don't agree or don't realize it until they can't get something to work. On a host known to work I have absolutely no problem with the same thing they are trying to do. It just works. So to me there is a differnce in hosting by far.

Now I wont even attempt to install it on certain hosts, just because it's not worth the trouble.

Just wanted to let all know that the VPS is working beautifully!

i am looking into doing this now. what all steps that are listed in this thread are needed? what was helpful? and is there such a thing as seemless and painless transition? meaning 0 down time and 0 data loss. thanks in advance!

 0 downtime can be achieved, when moving from subdomain to TLD, 0 data loss should not even be a consideration, since you are only moving from one directory to another. so if you lose data, then something went wrong, and you might not shoulda tried it.

 when transferring from server to server, kinda sorta the same gig, no data should be lost. how do you avoid downtime, the most logical way, or the most logical way to suffer the least downtime, would be to lower the TTL on your current host, and on your registrar. 

use whm xml api to transfer the site, modify the zone file on the current host, point the records to the new vps or dedicated. so what does this DO, well whatever zone files are tracking your domain, will follow them to current host, current host will have a modified zone file which should follow to the new environment.

depending on your domain registrar, you could end up with immediate results or trickle results over 24 - 48 hours. the rule of thumb is 24 - 48 hours, though i only have experienced that with heart domains from the UK i think it was. there are some hideous registrars out there, hfw is a resellar and it can be tricky to manage the DNS there. 

GoDaddy, by far is the greatest domain registrar, i am not saying any of their other services are, but their domain registration and propogation, and management is TOP NOTCH against all. 

i own about 165 domains, and host a few :) , so i know a thing or two about domain propogation and management.

looking for 0 downtime, nobody can promise that, if they do you are being lied to.

data loss, should be fairly easy to achieve. moving sites large and small should be painless, but there are preparations required. 

if ya need help, hit me up, i can assist you in getting packed up and moved. 

we can be Two Men and a PuTTy Client

LOL