Problem with login to phpmyadmin

[yamahaERG121]

Hi all,

For the company where I work I installed Sugar CRM a couple of weeks ago, and everything is running smooth now. Altrought I have some questions about how to create and replace backups.

I used the bitrock installer (version 4.5.0h)

First problem I am facing is the fact that I cannot login to Phpmyadmin, when I try to login with the password I filled in before (during the installation), and hit the enter button nothing happens. I can fill in my login details 3 times, and still nothing happens, the fourth time i get the error message “authorization required.”.

Things I tried:
Deleted cookies
I’ve tried to change the config.php file with another password. Still no results

I really need this to work because I need to create back-ups of the database, as I want to migrate the whole database to another server soon.

For the backup of the application files of SugarCRM I have also a question: I found on this forum you have to create a back-up of the following directory:

*:\Program Files\sugarcrm-4.5.0h\htdocs\sugarcrm

In Sugar CRM is a build-in tool which you can make this backup with, but this tool isn’t working for me. I’ve searched this forum for a solution and tried several things (different users for example). But still I cannot create a backup with it. I get the error message that the directory is not writable or existing.

Can you also create a back-up manually? If you go to this directory and copy it to another one for example? And paste it back if needed?

I hope somebody can answer some of my questions,

[ridruejo]

Hi all,
First problem I am facing is the fact that I cannot login to Phpmyadmin, when I try to login with the password I filled in before (during the installation), and hit the enter button nothing happens. I can fill in my login details 3 times, and still nothing happens, the fourth time i get the error message “authorization required.”.

This login is set up at the Apache level (to prevent it from being accidentally accessible by unauthorized remote users). The specific configuration is at the end of the Apache2\conf\httpd.conf file and should look something like:

<Directory "c:/Program Files/sugg/htdocs/phpmyadmin">
AuthType Basic
AuthName phpMyAdmin
AuthUserFile "c:/Program Files/apache2/users"
Require valid-user
Order allow,deny
Allow from 127.0.0.1
Satisfy all
ErrorDocument 403 /pmaforbidden.html
</Directory>

You can remove the need for users to authenticate by removing or commenting the first 4 lines

Cheers

Daniel

[malcolmh]

Hi,

Which user name was you using to log into phpmyadmin? The default user with the Bitrock installer is administrator. Try that

[yamahaERG121]

Hi,

Sorry for the late reply but indeed administrator was the right username I'm logged on now and already made a back-up of the database. I also have another question about the back-up for the application files.

In sugarCRM is a build-in tool which you should be able to create back-ups with of the application files of SugarCRM.
But it doesn't work here, i checked the username and if it does have access to write in the directory where i want to place the back-up, but still i get the message the directory isn't writable or doesn't excist.

Do you have any idea why this error keeps coming? Is there anything i might forget?

And if i want to create a back-up manually of the application files, is the following directory the only one i have to make a copy of?

C:\Program Files\sugarcrm-4.5.0h\htdocs\sugarcrm

Thanks for you answer on my previous question

[Danielg42]

Yep, copy that dir and the database, and you should be set.

[yamahaERG121]

Thank you for your answer.

Next thing I am trying is migrating the whole database + application files to another server. Because in the future this maybe have to happen.

I migrated the whole database sucessfully to another server, but now I want to do the same with the application files. Because I changed a lot in the layouts and created many custom fields. So I took a copy of the directory with these files, and paste them over the new server but this doesn't work because it gives an error. Is there any way to migrate this sucessfully to another server? I did some research but didn't found any answer yet.

[malcolmh]

Hi,

If you copy the whole file directory and DB to another server, importing the DB files into the database, they the system should work.