Moving installation to new host, importing database and MySQL error

laptophobo · 2010-03-15 06:04:46

Hi Gocom. Thank’s for replying quickly.

Your first question regarding MySQL user rights, where would I find such a setting? (It’s not in Admin Preferences). Same thing with regards to “security modules”. I don’t think I’ve made any changes to what the default settings were when I installed TXP.

Regarding your last recommendation about not switching browsers, I use firefox and have publisher rights. But I’m still unable to delete users.

Hoping you’ll be able to figure this out with me. Thanks for your time.

Last edited by laptophobo (2010-03-15 06:10:47)

Gocom · 2010-03-15 07:58:50

laptophobo wrote:

Your first question regarding MySQL user rights, where would I find such a setting? (It’s not in Admin Preferences). Same thing with regards to “security modules”. I don’t think I’ve made any changes to what the default settings were when I installed TXP.

TXP won’t change or decide those, but server do. TXP is just PHP script that runs within the rules you and the server gave it to.

Do the users get added to the DB? Are they listed on the backend? If not, make sure that you don’t read the page from cache.
Do you use the main account to delete the users?
Can you modify, create and delete forms/articles?

laptophobo · 2010-03-15 08:28:29

I add users via the Admin Users panel.
I was logged in as Publisher when I tried to delete the user (so, yes).
I have no problems with creating or modifying anything else. I can even post comments (while I’m logged in.)

jsoo · 2010-03-15 12:11:34

laptophobo wrote:

File directory path is not writable: www.dotorgwebworks.org/example.dev/files
Temporary directory path is not writable: www.dotorgwebworks.org/example.dev/textpattern/tmp

I then changed it to the values I had set on my config.php form:
/var/www/html/example.dev/files (for File Directory) and /var/www/html/example.dev/textpattern/tmp (for Temporary Directory).

I went to the Textpattern folder on my web server and checked on all of the boxes (CHMD).

Went back to Diagnostics and got “All checks passed!” message.

As you’ve discovered, a file path is not a URL. You may not need such loose permissions (i.e., checking all the boxes); depends on your sever config.

laptophobo · 2010-03-16 02:20:09

Well, the “Textpattern Solutions” book stated I should use the 777 setting. My web service recommended 755. So, I tried 755 and that didn’t change a thing. (Diagnostics says all passed.) Still, I’m unable to login as a different user and when I create a new user account, my own password changes to that of the new account. I did learn, however, that if I delete a user and assign their assets (per the pop up option) to an existing user account, it deletes from the list.

So here’s the thing. All appears to be working except for the User management.

thanks for trying.

jsoo · 2010-03-16 02:37:04

Have you tried logging out, trashing the cookies for this site (both live and local), and logging in again? I don’t know if it’ll do anything, but it’s what I’d try.

Do you mean that simply creating a new user account causes your password to change? That is really strange.

laptophobo · 2010-03-16 02:45:03

I haven’t tried dumping my cookies (I’d rather do that only as a last resort), but have tried it on a browser that stores no data and the problem persists.

And, yes, simply creating a new user account cause my own password to change. It’s like the interface reads only 1 user even though it lists more than 1.

jsoo · 2010-03-16 12:36:31

laptophobo wrote:

I haven’t tried dumping my cookies (I’d rather do that only as a last resort),

You wouldn’t have to dump them all. Just the txp_login and txp_login_public cookies for this site.

but have tried it on a browser that stores no data and the problem persists.

Hmm, I didn’t think you could use the admin side with cookies disabled.

And, yes, simply creating a new user account cause my own password to change. It’s like the interface reads only 1 user even though it lists more than 1.

Post to Troubleshooting.

laptophobo · 2010-06-16 23:58:33

My Article paths are still seeing the old folder location.
I moved my site from a folder on my server to the root. I went into the Admin > Preferences and updated the paths. The config.php file was also updated (on all of these, all I had to do was remove the old folder location).
The site view as it should, but the links within the Articles are still going to the old folder. Also, my password protected Section (“design-questionnaire”) isn’t protecting (the Diagnostics show this message:“Old placeholder file is in the way: /var/www/html/design-questionnaire”).

There must be one other file that needs to be updated with the new file path, but I can’t think what it might be. Any ideas?

Thanks so much!

Last edited by laptophobo (2010-06-16 23:59:50)

laptophobo · 2010-10-05 23:27:08

I’m getting Pre-Flight Check errors after copying my live copy to local. All is well, but this is what I get in Diagnostics:

File directory path is not writable: C:\xampp\htdocs\files

Temporary directory path is not writable: C:\xampp\htdocs\textpattern\tmp

My notes say to make the files “writable” but I’m not offered CHMD on my local files.

Anyone? Thanks!

Gocom · 2010-10-06 00:33:30

laptophobo wrote:

My notes say to make the files “writable” but I’m not offered CHMD on my local files.

CHMOD itself is a command for UNIX like(ish) enviroments, not for Windows. But as you said, make sure the directory is actually writable. Even Windows has permission model and file attributes.

Make sure that the user that is used to run the Apache/PHP processes has write permissions to the directory (and parent directories) and that the directory isn’t set as Read-only. All that can be found from folder properties.

xampp

If you are using XAMPP, make sure that you have gone thru the securing steps provided in the Xampp’s FAQs/quides. Be aware; it’s a web server, and by default publicly accessable from outside. If you haven’t spent time to secure it (by blocking incoming access with firewall/router) and changed/set passwords, it’s highly insecure as the default settings are ment for local use.

Last edited by Gocom (2010-10-06 00:52:07)

laptophobo · 2010-10-06 16:56:23

Well, I’ve tried making the folder “writable” but no matter what i do the attributes remain “read only.” The file location is c:\xampp\htdocs\acme\files. I went through the apache security and put in passwords. As for trying to modify the folder properties (properties>security>advance>owners>edit) it does not take any changes that I make to the two users on there that don’t have full control already. But since I’m the only user to this computer and the administrator, I’m wondering why I can’t change file permissions.

els · 2010-10-06 18:18:52

You can try using an FTP client. It usually lets you change permissions more easily than windows itself does.

Gocom · 2010-10-06 18:44:51

laptophobo wrote:

c:\xampp\htdocs\acme\files

C:\xampp\htdocs\files

Which one is it? Earlier you said you used C:\xampp\htdocs\files as the file dir path, and you said it that was returned by the diagnostics. If the location is C:\xampp\htdocs\acme\files, then you should be using that in TXP’s preferences.

laptophobo · 2010-10-06 18:48:53

Hi Els. That was the first thing I had tried. Using my WS_FTP program, I tried to chmod the file, but since it sits in my computer and not on the Unix server, that option was not available to me.

Maybe you know a work-around?

Thanks.

Textpattern CMS

Textpattern CMS support forum

#31 2010-03-15 06:04:46

Re: Moving installation to new host, importing database and MySQL error

#32 2010-03-15 07:58:50

Re: Moving installation to new host, importing database and MySQL error

#33 2010-03-15 08:28:29

Re: Moving installation to new host, importing database and MySQL error

#34 2010-03-15 12:11:34

Re: Moving installation to new host, importing database and MySQL error

#35 2010-03-16 02:20:09

Re: Moving installation to new host, importing database and MySQL error

#36 2010-03-16 02:37:04

Re: Moving installation to new host, importing database and MySQL error

#37 2010-03-16 02:45:03

Re: Moving installation to new host, importing database and MySQL error

#38 2010-03-16 12:36:31

Re: Moving installation to new host, importing database and MySQL error

#39 2010-06-16 23:58:33

Re: Moving installation to new host, importing database and MySQL error

#40 2010-10-05 23:27:08

Re: Moving installation to new host, importing database and MySQL error

#41 2010-10-06 00:33:30

Re: Moving installation to new host, importing database and MySQL error

#42 2010-10-06 16:56:23

Re: Moving installation to new host, importing database and MySQL error

#43 2010-10-06 18:18:52

Re: Moving installation to new host, importing database and MySQL error

#44 2010-10-06 18:44:51

Re: Moving installation to new host, importing database and MySQL error

#45 2010-10-06 18:48:53

Re: Moving installation to new host, importing database and MySQL error

Board footer