Database creation problem on hosted account

[elfracky]

hi all,

I have installed CMSMS locally and it's working just fine.

I am trying to do the same on my hosted account, however I can not create any database, only tables.
I have one already created name as "mydomain.com". I also can not set new privileges on this db.
I would need to modify the following connection parameters in the installation procedure :
- db : CMS changed for mydomain.com
- userID : cms_user@localhost for another_user_name
- pswd
how can I do this ?
Is there better solution ?

thx in advance
el.

[roman]

I don't uderstand why you have problem.... database must by created before installing CMSMS...with you, or your provider... and if you will put into installation procedure right parameters ...will create rights tables... Maybe problem is if you have "." in name o database...i newer used name with . for database...

[elfracky]

I don't uderstand why you have problem.... database must by created before installing CMSMS...with you, or your provider... and if you will put into installation procedure right parameters ...will create rights tables... Maybe problem is if you have "." in name o database...i newer used name with . for database...

On my hosted account I have only one predefined database named following this convention "mydomainname.com". That's it. Same for the privileges on this database. I can not create another one, which stop me from creating the "CMS" database and the userID/pswd as required in the install process.
This is why I need to have access to these parameters in order to modify them... so the install process can be completed. Right now... I block at step 2 and get :

"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, no.valid@email 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."

Because the db and userID/pswd is not set.

any idea on how to fix it ?

[elfracky]

On step 2, you must give the name of your database, and username (database user) and password. I understand those 3 are given to you by the provider, and those 3 are precisely what you must fill in those fields.

Are you sure you can use the database? or are you sure you got table creation privileges? what is mentioned in the hosting package and info? contact them!

I don't access to step 2.
Instead, I get the error message posted above.
I have access to phpmysql on my hosted account and have the necessary privileges to do whatever on the mydomainname.com database. I can't create another database though.
My package with my hoting Cie mentioned : only one database editable with 1 only userID/pswd... with as many tables as I want as long as it respects the space allocated with my hosting plan.

[Ted]

Umm.  I don't think that's the issue.  Step 2 just asks for a username and password for the admin.  Step 3 asks for the username, database name, etc.  It doesn't even try to contact the databse until after that.  Even if it did, it should give a sane error and not an Internal Error.

I think your issue is more configuration/PHP related.

[elfracky]

ohh... ok, let me check the files uploaded and the set up on the server and come back to you then. Thx a lot to all of you for your much apreciated help.
will give feed back soon.

[moire]

I have the same problem. I have a uploaded everything, I can create db, bet the name ends up to be something like 'ingus131_cms'. As well the usernames end up having theese prefixes.
This is what sucks about cmsmadesimple - there is no config file, everyone can easily enter whatever database and usernames they have. Hopefully this will be solved in future versions.

This is my first time trying to make a CMS + I am ' an-idiot-user' - never learned programming, cuz i'm a designer. For me (a foreign language speaking lame), instalation seems to be too complex and manual has too advanced terms (it took me a half an hour to figure out -u stands for username and p- for password).

My guestion would be - where in the code should I manually edit username, db and rest of stuff to adapt it to my preferences? (Hopefully I put it clearly)

chris

[sjg]

Actually, there is a config file once you've done an install.

Take a look in your install root at the file called config.php. You can update the values there.

It should be pretty straightforward to identify the username and database (this example is from one of my development boxes):

$config['dbms'] = 'mysqli';
$config['db_hostname'] = 'localhost';
$config['db_username'] = 'cms_user';
$config['db_password'] = '$ecret_password';
$config['db_name'] = 'cms';
$config['db_prefix'] = 'cms_';

You could change the db_name to be 'ingus131_cms', and put the 'ingus131_' prefix in front of any of the values you need it on.

Still, the error message you posted looks more like a Web Server configuration issue to me. You shouldn't be able to get a HTTP 500 from anything that CMS Made Simple does.

[moire]

Actually, there is a config file once you've done an install.

Take a look in your install root at the file called config.php. You can update the values there.

It should be pretty straightforward to identify the username and database (this example is from one of my development boxes):

$config['dbms'] = 'mysqli';
$config['db_hostname'] = 'localhost';
$config['db_username'] = 'cms_user';
$config['db_password'] = '$ecret_password';
$config['db_name'] = 'cms';
$config['db_prefix'] = 'cms_';

You could change the db_name to be 'ingus131_cms', and put the 'ingus131_' prefix in front of any of the values you need it on.

Still, the error message you posted looks more like a Web Server configuration issue to me. You shouldn't be able to get a HTTP 500 from anything that CMS Made Simple does.

Yea, I found that particular config section in root/lib/adodb/adodb.inc.php

I got CMS to work (kinda), but it did not happen the way it supposed - I enteredthe db info in root/lib/adodb/adodb.inc.php and run install/install.php. There I input the db name, host etc again. So I don't know what did play the main role. Btw there was not a config.php file in the site root by default (cmsmadesimple-0.10.1)

Now I seem to have a problem with nested image directories. I can make some, but it's impossible to upload files. =[
It says: File could not be uploaded. Permissions problem?
It also seems impossible to change CHMOD from 755

Code: Select all

[newImageSubdirectory]
COMMAND:> SITE CHMOD 777 newImageSubdirectory
550 galerija: Operation not permitted

[elfracky]

Umm.  I don't think that's the issue.  Step 2 just asks for a username and password for the admin.  Step 3 asks for the username, database name, etc.  It doesn't even try to contact the databse until after that.  Even if it did, it should give a sane error and not an Internal Error.

I think your issue is more configuration/PHP related.

ok... sorry for taking so much time to come back.
I have tried what Moire was suggested (ie modifying the root/lib/adodb/adodb.inc.php). No luck ... still the same error.
I have tried to create a config.php in the same way that it exists locally on my pc with amendments for the online server... still same error.

Code: Select all

<?php
$config['dbms'] = 'mysql';
$config['db_hostname'] = 'sql.domain.com';
$config['db_username'] = 'domain.com';
$config['db_password'] = '*********';
$config['db_name'] = 'databaseName';
$config['db_prefix'] = 'cms_';
$config['root_url'] = 'http://www.domain.com';
$config['root_path'] = '$DOCUMENT_ROOT';
$config['query_var'] = 'page';
$config['use_bb_code'] = false;
$config['use_smarty_php_tags'] = false;
$config['previews_path'] = '$DOCUMENT_ROOT/tmp/cache';
$config['uploads_path'] = '$DOCUMENT_ROOT/uploads';
$config['uploads_url'] = 'http://www.domain.com/uploads';
$config['max_upload_size'] = 1000000;
$config['debug'] = false;
$config['assume_mod_rewrite'] = false;
$config['auto_alias_content'] = true;
$config['image_manipulation_prog'] = 'GD';
$config['image_transform_lib_path'] = '/usr/bin/ImageMagick/';
$config['use_Indite'] = false;
$config['image_uploads_path'] = '$DOCUMENT_ROOT/uploads/images';
$config['image_uploads_url'] = 'http://www.domain.com/uploads/images';
$config['default_encoding'] = '';
$config['disable_htmlarea_translation'] = false;
$config['admin_dir'] = 'admin';
?>

I am a novice... and damn that I am getting some white hairs with this !!!!
the config of my php shared server is :
http://www.online.net/support/fr/doc/php4/phpinfo.html

I am now out of option... and idea.
any help would be greatly apreciated.

[kishman155]

maybe this could help

http://docs.cmsmadesimple.org/index.php?page=127

The perfect way is to begin from new.

kishman155

[badhoy]

I have several web sites on hosted accounts using CMSMS.  I've not had a single problem installing to the database available to me.  You have to get beyond the terminology. 

Give the install your existing database name, the user name to access it, and the databases password.  CMSMS will create the tables it needs in the existing database.  It does not need to create a new database

In my environment the database name and user name to access the database are the same as the main user name.  The password is different.  Check the FAQ's at you hosting provider if there's confusion around this.