phpmyadmin + mysql

pgup · Post by **pgup** » Mon Nov 07, 2005 11:03 am

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

hkit · Post by **hkit** » Mon Nov 07, 2005 3:47 pm

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

pgup · Post by **pgup** » Mon Nov 07, 2005 4:42 pm

Hello!

Thanks the answer, it's very simple. But if you can see that LINK I don't have privileges. What's the problem?

Post by **garvinhicking** » Mon Nov 07, 2005 4:44 pm

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

Guest · Post by **Guest** » Mon Nov 07, 2005 5:03 pm

Oh, good. But how can I add a password for database 'alv'?

Post by **garvinhicking** » Mon Nov 07, 2005 5:07 pm

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

pgup · Post by **pgup** » Mon Nov 07, 2005 5:12 pm

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..

pgup · Post by **pgup** » Mon Nov 07, 2005 5:14 pm

No. It's good!

When I put 127.0.0.1 it's good. Thanks

pgup · Post by **pgup** » Mon Nov 07, 2005 5:49 pm

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?

Post by **garvinhicking** » Mon Nov 07, 2005 6:00 pm

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

pgup · Post by **pgup** » Mon Nov 07, 2005 7:27 pm

Where can I find the config file?

Post by **garvinhicking** » Mon Nov 07, 2005 7:51 pm

Open http://yourblog/serendipity_admin.php - there you can access the configuration.

Regards,
Garvin

pgup · Post by **pgup** » Mon Nov 07, 2005 9:57 pm

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

Post by **garvinhicking** » Tue Nov 08, 2005 11:26 am

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

pgup · Post by **pgup** » Tue Nov 08, 2005 1:36 pm

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 -