Page 1 of 1
phpmyadmin + mysql
Posted: Mon Nov 07, 2005 11:03 am
by pgup
Hello!
I have a serendipity blog + phpMyAdmin. How can I get to know how many field need serendipity?
And after what can I put in: Field/Type(VARCHAR,TEXT,DATE, etc)/VALUE/Null/etc.?
Thanks:
pgup
Posted: Mon Nov 07, 2005 3:47 pm
by hkit
Hi pgup,
is that, because you want to install serendipity? Actually you shouldn't need to change anything. You only need to create a new database, which is very easy using phpMyAdmin. Just go to phpMyAdmins start-page and under "create a new database" you type in the name you wish to have for the serendipity-database. That's it. You don't need to create tables by yourself. That will be done in the install process by the program.
cu
Stefan
Posted: Mon Nov 07, 2005 4:42 pm
by pgup
Hello!
Thanks the answer, it's very simple. But if you can see that
LINK I don't have privileges. What's the problem?
Posted: Mon Nov 07, 2005 4:44 pm
by garvinhicking
That means you only can create one database, and you need to tell serendipity to use the database "alv" to be installed in.
Regards,
garvin
Posted: Mon Nov 07, 2005 5:03 pm
by Guest
Oh, good. But how can I add a password for database 'alv'?
Posted: Mon Nov 07, 2005 5:07 pm
by garvinhicking
You already have a password, if you can log in with phpMyAdmin! You must use that exact same password to enter for serendipity.
Regards,
Garvin
Posted: Mon Nov 07, 2005 5:12 pm
by pgup
I tried it; when I put the username and pass on the form, serendipity:
Code: Select all
Could not connect to database; check your settings.
The mySQL error was: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I don't understand..
Posted: Mon Nov 07, 2005 5:14 pm
by pgup
No. It's good!
When I put 127.0.0.1 it's good. Thanks
Posted: Mon Nov 07, 2005 5:49 pm
by pgup
Well... I have successfully installed the blog. But it's funny.
http://alv.atw.hu/blog/serendipity/ --this is the blog now.. What's the problem now?
Posted: Mon Nov 07, 2005 6:00 pm
by garvinhicking
You've configured s9y to use URL Rewriting, but your hosts doesn't support it. Go to the s9y config and switch URL rewriting to "None", then it'll work.
Regards,
Garvin
Posted: Mon Nov 07, 2005 7:27 pm
by pgup
Where can I find the config file?
Posted: Mon Nov 07, 2005 7:51 pm
by garvinhicking
Open
http://yourblog/serendipity_admin.php - there you can access the configuration.
Regards,
Garvin
Posted: Mon Nov 07, 2005 9:57 pm
by pgup
I changed hosting to uw.hu. It's seems better, no problem during the installition.
Now, the problem is:
Click here
But now I have access the configuration
Code: Select all
Warning: realpath() has been disabled for security reasons in /mnt/ultraweb/a/al/alv/bundled-libs/Smarty/libs/internals/core.is_secure.php on line 25
Warning: realpath() has been disabled for security reasons in /mnt/ultraweb/a/al/alv/bundled-libs/Smarty/libs/internals/core.is_secure.php on line 28
Warning: realpath() has been disabled for security reasons in /mnt/ultraweb/a/al/alv/bundled-libs/Smarty/libs/internals/core.is_secure.php on line 28
Warning: realpath() has been disabled for security reasons in /mnt/ultraweb/a/al/alv/bundled-libs/Smarty/libs/internals/core.is_secure.php on line 37
Warning: Smarty error: (secure mode) accessing "/mnt/ultraweb/a/al/alv/templates/kubrick/index.tpl" is not allowed in /mnt/ultraweb/a/al/alv/bundled-libs/Smarty/libs/Smarty.class.php on line 1088
Posted: Tue Nov 08, 2005 11:26 am
by garvinhicking
Serendipity requires the Smarty temlating engine. Smarty relies on the realpath() function - when it's deactivated you sadly won't be able to use Smarty nor Serendipity...
Most free providers are blocking certain functions because of security - that's why paying for a good provider is often suggested.
Regards,
Garvin
Posted: Tue Nov 08, 2005 1:36 pm
by pgup
OK, good. Thanks the support!
I will subscribe to webhosting; than I will try again
I think this is the best blog!
Thank you:
- pgup -
