phpCollab Community: General Support » PANIC! Error during connection on MySQL server

Home » Support » General Support » PANIC! Error during connection on MySQL server

Show: Today's Messages :: Show Polls :: Message Navigator

PANIC! Error during connection on MySQL server [message #8795]

Thu, 03 February 2011 03:44

ddoc
Messages: 6
Registered: February 2011

phpCollab guest

Dear, this is my first post. I started using phpcollab in 2005. Now, more experienced, I am having trouble.

When you install version 2.5, I received a strange message.

PANIC!
Error during connection on MySQL server

I consulted the forum here, but without result. Deletes the user, created another and tried again. Nothing. I have this server running at least 14 database, in mysql, and all work!

I tried to change the setting manually, but it appears only a white screen. I have no further attempt.

Can anyone help me without suggesting to delete user or rights?

Thanks

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8797 is a reply to message #8795]

Fri, 04 February 2011 15:30

LiviaCH
Messages: 3
Registered: February 2011

phpCollab guest

I do have the same problem...

In another thread (from 2003) I read something about the database needing to be empty at the time of installation. Is this true and still the case?

I have a limited number of databases in my provider's contract and I need to use one that already has other tables in it.... Is there a workaround for that??

Would be cool if someone could look into this.

Thanks a lot in advance!

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8798 is a reply to message #8797]

Fri, 04 February 2011 19:42

ddoc
Messages: 6
Registered: February 2011

phpCollab guest

Hello LiviaCH
Unfortunately, I tried various situations.
Deleted and created the directory.
I uploaded again.
I checked the code.
I complained to my hosting.
But nothing. And it seems that the forum moderator or is unsupported.
I chose to install phpcollab, for use since 2005.
anyway, thanks.

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8799 is a reply to message #8798]

Fri, 04 February 2011 20:22

LiviaCH
Messages: 3
Registered: February 2011

phpCollab guest

Have you tried to install into an empty database?
Not the file directory... the database itself.

As I mentioned, this (at least in 2003) caused some troubles to people.

I have the unfortunate situation that I CANNOT empty my database to give it a try and I can't make a new one, either. Crying or Very sad

I once had phpcollab installed, too.... years ago... then it worked... but now Sad

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8800 is a reply to message #8799]

Fri, 04 February 2011 21:32

ddoc
Messages: 6
Registered: February 2011

phpCollab guest

Yes. I tried empty DB. No work.

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8804 is a reply to message #8795]

Thu, 10 February 2011 23:18

mindblender
Messages: 610
Registered: July 2003
Location: AZ

phpCollab contributor

Does the database name have a dash or underscore in the name?

What type of system are you installing it on?

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8807 is a reply to message #8804]

Fri, 11 February 2011 01:26

ddoc
Messages: 6
Registered: February 2011

phpCollab guest

Does the database name have a dash or underscore in the name?

- Yes, my isp define this.

What type of system are you installing it on?

- CentOS 5, apache 2.2.15, PHP Version 5.2.13, Mysql 5.1.54

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8813 is a reply to message #8795]

Fri, 11 February 2011 07:04

mindblender
Messages: 610
Registered: July 2003
Location: AZ

phpCollab contributor

There is a known issue with MySQL that you can not have a dash in your database name.

That could be your problem if you have a dash in the database name. try asking your ISP to rename your database.

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8816 is a reply to message #8813]

Fri, 11 February 2011 13:27

LiviaCH
Messages: 3
Registered: February 2011

phpCollab guest

mindblender wrote on Fri, 11 February 2011 07:04

There is a known issue with MySQL that you can not have a dash in your database name.

That could be your problem if you have a dash in the database name. try asking your ISP to rename your database.

I too have a dash in the database name but:

1. My provider will not change that since it's a standard for all databases they have

2. I already had Phpcollab installed in exactly this database a few years ago... it worked flawlessly back then...

So why doesn't it work anymore? Question

[Updated on: Fri, 11 February 2011 13:27]

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8817 is a reply to message #8795]

Fri, 11 February 2011 17:49

mindblender
Messages: 610
Registered: July 2003
Location: AZ

phpCollab contributor

Not sure why it would work back then but not now. If you google MySQL dash in database name you will see that it is a bug that has been around for a long time.

The other thing you might check are your PHP error logs and see if there is anything else that might help point to the problem.

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8826 is a reply to message #8795]

Thu, 03 March 2011 03:23

southcot
Messages: 3
Registered: January 2008

phpCollab guest

I have had this problem today. It seems that as well as not working with, in my case, underscores in the DB username it also mangles password with non alphanumeric characters in it so:-

For DB user no underscore allowed
for DB name underscore allowed
For DB password only alphanumeric
For Admin password only alphanumeric

If you want to use non alphanumeric values in either password or underscores in the username then install using the values that will work and then changed the details in includes/settings.php

This is a very irritating problem that ought to be resolved as it is exclusively due to the setup interface and has absolutely nothing to do with MySQL.

[Updated on: Thu, 03 March 2011 03:24]

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8829 is a reply to message #8826]

Thu, 03 March 2011 19:11

ddoc
Messages: 6
Registered: February 2011

phpCollab guest

My dear Southcote

I'll leave the phpcollab and I will try another alternative. My host requires that the user name has an underscore. Type account_user and account_db. He has no choice.

And with the increased volume of hackers, allowing alphanumeric password is practically shoot in the foot.

With the projects that need to administer, does not. Obviously we want to make donations to the project. But without security, without practically giving.

And how do we install the Version 3 server rented? We do not have access to this host's to promote the necessary changes. I read the available documentation and saw that the update will be difficult.

thanks

Report message to a moderator

Re: PANIC! Error during connection on MySQL server [message #8830 is a reply to message #8795]

Fri, 04 March 2011 06:24

southcot
Messages: 3
Registered: January 2008

phpCollab guest

If you did want to use it then another option would be to temporarily install using another mysql where you could use a UN without and then move the db that was created back to your hosts mysql and edit settings.php to reflect the change. As I said it's only the setup that's the problem. If you want to do this and want access to a temporary db then message me and I'll "lend" you one.

Report message to a moderator

Previous Topic:	Not receiving notifications
Next Topic:	Can't login after logout

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed May 22 07:19:49 CEST 2013

Total time taken to generate the page: 0.82277 seconds