Elxis CMS Forum

Support => General => Topic started by: ROUBOS on December 14, 2009, 01:34:42

Title: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 14, 2009, 01:34:42
Hi, I created a mySQL database in the plesk control panel, created a user for the database. Made the user the default, and then when I hit DB webAdmin, I get the following:

Create new database:
No Privileges

When I enter the url of  the website so the elxis installation can start, i get a blank page.

Ant thoughts ?
Title: Re: No privileges to create new database in phpMyAdmin
Post by: Ivan Trebješanin on December 14, 2009, 02:13:18
On panels such as cPanel you can create DB, but not via PhpMyAdmin. Maybe Plesk works the same way. You said you created DB, so it's OK.
Blank page however, means some PHP error, so there is some problem there. Ask you host admin.
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 14, 2009, 02:19:58
ok,

So could it be something wrong with the creation of the domain?
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 14, 2009, 02:35:54
re-created the domain, and i now can see the index.html
need to upload elxis.

but before the install i need to create the DB. that's where things go wrong I think

EDIT: Must be a php error. will need to contact the ISP. I created the Domain. It works with a normal index.html file, not with the index.php

Title: Re: No privileges to create new database in phpMyAdmin
Post by: CREATIVE Options on December 14, 2009, 11:32:52
In plesk you MUST create the DB from the plesk panel, look around the plesk panel, it has many hidden features.

1 PS: avoid PLESK if you can, install ISP (open source) or any other you like.
2 PS: Cpanel is far away good & secure from plesk.
3 PS: Apply this IF you have privilege:

Slightly modified version from the original post found at rackerhacker.com

Change the umask in ‘/etc/proftpd.conf’ from ‘022′ to ‘002′.

Then, update the directory permissions by running the following at the command line:
Code: [Select]
cd /var/www/vhosts/[domain.com]
chown -R [username]:psacln httpdocs
chmod -R g+w httpdocs
find httpdocs -type d -exec chmod g+s {} ;


Add the ‘apache’ user to the ‘psacln’ group by editing ‘/etc/group’.

Change
Code: [Select]
psacln:x:2524:

to
Code: [Select]
psacln:x:2524:apache

For my server I also had to add psaftp,psaadm:
Code: [Select]
psacln:x:2524:apache,psaftp,psaadm

About some PHP settings, sometimes including not being able to write to ‘/var/lib/php/session’. To fix the issues, make some adjustments to the ‘/var/www/vhosts/[domain]/conf/vhost.conf’ for the domain (you may have to create this file):
Code: [Select]
<Directory /var/www/vhosts/[domain]/httpdocs>
php_admin_flag magic_quotes_gpc on
php_admin_flag display_errors on
php_admin_value session.save_path /tmp
</Directory>


If the vhost.conf is brand new, then run:
Code: [Select]
/usr/local/psa/admin/bin/websrvmng -av

Make sure Apache runs with your new configuration:
Code: [Select]
# httpd -t (check your work)
# /etc/init.d/httpd reload (service httpd restart on my server)

Done! No more errors on the install screen and no more apache/ftpuser issues with uploading files.
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 15, 2009, 02:43:19
these can be done if I have my own server right?
The service provider (hosting space) has plesk.
Title: Re: No privileges to create new database in phpMyAdmin
Post by: CREATIVE Options on December 15, 2009, 10:07:00
Yes ONLY if you have VPS or Dedicate
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 15, 2009, 21:27:18
strange
I put up a simple php info file and it works.
It displays PHP info, but the Elxis install does not start up.

Any thoughts?
Title: Re: No privileges to create new database in phpMyAdmin
Post by: Ivan Trebješanin on December 15, 2009, 22:54:30
Which version of PHP do you have there?
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 16, 2009, 01:25:13
PHP Version 4.4.9
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ks-net on December 16, 2009, 01:47:19
http://wiki.elxis.org/wiki/Elxis_Requirements
http://wiki.elxis.org/wiki/Troubleshooting#I_can.27t_access_elxis_installer.2C_MySQL_or_PHP_errors
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 16, 2009, 02:41:42
yes I saw that... Need to find an older version of Elxis...
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ks-net on December 16, 2009, 02:54:20
might be the opposite?

as i can see you have many problems with your server.... almost every post of yours is about permissions-server setup- etc...
i think that worth to throw it away... leave it in it's fate.. go else where!



Quote
Need to find an older version of Elxis...
2008.0
Title: Re: No privileges to create new database in phpMyAdmin
Post by: Ivan Trebješanin on December 16, 2009, 03:16:58
yes I saw that... Need to find an older version of Elxis...

... or newer version of server ...

Imagine you are using hammer and the chisle to carve in stone, but everybody else use paper these days. So you say: "I must find paper which can stand carving.."
It is by far better to simply take a pen and write on paper!
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 16, 2009, 03:50:25
yes you are right. The thing is that I'm doing this for someone who has purchased hosting space on this server.

Do you have a hosting space to recommend   for my own web site soon ?

EDIT >>> : It's ok. Sending them an email to upgrade the version of PHP. It's says that they will do it.
Title: Re: No privileges to create new database in phpMyAdmin
Post by: Ivan Trebješanin on December 16, 2009, 04:00:48
Do you have a hosting space to recommend   for my own web site soon ?

I haven't used shared hosting for very long time, so I don't know. First thing that comes to my mind: https://www.isopensource.com/web-hosting/
Title: Re: No privileges to create new database in phpMyAdmin
Post by: ROUBOS on December 16, 2009, 04:12:25
From what I see the site I want to build is simple, and the rolling menu is compatible with elxis 2008.0

But it is good practice to use the latest elxis right?